Students learn to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. Students learn the basic functionality of how to debug functions and procedures using the SQL Developer Debugger. Students also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions.
Students are introduced to the utilization of some of the Oracle-supplied packages. Additionally students learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler, and manage dependencies. Oracle Database 11g: PL/SQL Fundamentals and Oracle Database 11g: Develop PL/SQL Program Units courses.
Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools. This is appropriate for a 10g audience too. There are few minor changes between 10g and 11g features.
Learn to:
Global I.T. is an authorized Oracle University WDP institution and provide the same curriculum and materials used by Oracle University. This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions.
Introduction
Introduction to PL/SQL
Declaring PL/SQL Identifiers
Writing Executable Statements
Interacting with the Oracle Server
Writing Control Structures
Working with Composite Data Types
Using Explicit Cursors
Handling Exceptions
Creating Stored Procedures
Creating Stored Functions and Debugging Subprograms
Creating Packages
Working With Packages
Using Oracle-Supplied Packages in Application Development
Using Dynamic SQL
Design Considerations for PL/SQL Code
Creating Triggers
Creating Compound, DDL, and Event Database Triggers
Using the PL/SQL Compiler
Managing PL/SQL Code
Managing Dependencies
Real testimonials from our Students!
I wish to thank GIobal Information Technology for helping me restart my career after taking a break of almost 8-9 years. During my career break, I had not kept my skills updated and before getting back into my career search, I decided to get re-trained. While researching the training institutions, in late 2009, I came [...] Read more
Nalini Sanku
9/30/2020 G.I.T, Global Information Technology, one the “stomping grounds”, for me to get a head-start in my career in IT was very foundational. Coming from where I did-nonetheless, how I did, this school was ‘almost’ like a sanctuary for me to tune in, stay focused, and connect with individuals from all walks of life pursuing [...] Read more
William Jones
I was hired into Global I.T. late May, coming from three separate jobs that I had been working simultaneously. Manish gave me the chance to start with Global IT to pursue Office Assistant and also suggested that I take the MS Office Suites class that they offered. I was constantly surrounded by people that encouraged [...] Read more
Mieh Khatib
I was in the legal field for over 20 years (Secretary promoted to Paralegal). After being laid off from my last position, I decided I needed a change. I had used databases as a front end user during my legal field and was really interested in learning more. My passion for computers and database interest [...] Read more
Donna Zarzycki
I began taking the Windows 2000 MCSE track in June of 2001. I decided to check out GIT after hearing an ad on the radio, and after viewing the facilities I signed up immediately. I attended classes on Tuesdays and Thursdays until the class ended in February 2002. I chose the MCSE course because I [...] Read more
David Warner