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 am writing this letter to express my sincere gratitude for the expertise shared throughout my studies in Global Information Technology, a superior training institute. I am thankful to all of the hardworking individuals at Global Information Technology especially to my instructors and career advisor. I had Oracle 10g Database Administrator and ASP .Net courses [...] Read more
Jawahar Babu
Having stagnated as an IT professional, as well as finding the demands in the market are for later technologies, it became evident that I had to re-tool to remain, indeed become, marketable. I needed a training venue that offered a breadth of curriculums, that was affordable, that was convenient and that was geared to the [...] Read more
Ray Hodge
I worked 17 yrs in manufacturing as a Hilo driver, a material processor and 9 yrs as a Quality assurance technician and was let go due to the economy in February 2007. During that time I’d always had a passion for the computing arena so after weighing my options and overcoming the fear that can [...] Read more
Ralph Cook
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
I am writing you this letting in praise of GIT, its wonderful staff and the learning experience I had in my time there. I have been an IT professional for 10+ years but never took the time to obtain any credentials or certifications along the way. When I finally decided it was time to do [...] Read more
De McCadney