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 just want to say “Thank You” to Global Information Technology for getting me to where I am now. My place of work, Raytech, was permanently closed and all employees including myself were laid off in the beginning of 2005. I was introduced to Global Information Technology by the Southfield Unemployment office to take e-commerce [...] Read more
Ebenezer Aniapam
My name is Cedric Porties, and I am currently employed as a systems administrator for Electronic data Systems. I was made aware of Global Information Technology from a local computer magazine. After much speculation due to a situation from another private school I previously attended, I decided to go in and speak with a representative. [...] Read more
Cedric Porties
I would like to take this opportunity to show my heart-felt appreciation and my learning experience at Global Information Technology (Global IT). I had recently left the military and was floundering with no real valid prospects and not sure what my next steps would be. I met with a knowledgeable Global IT Career Advisor who [...] Read more
Timothy Taylor
I was faced with a layoff from my previous employer. Being in the auto industry really made me stop and think about my future. I have always enjoyed working with computers, so I started exploring my options. I was browsing the internet one evening and found Global Information Technology. My biggest concern was going back [...] Read more
Michael Kurtser
First I would like to thank GIT staff for all their support. Before I started at Global Information Technology (GIT). I had no IT experience and I was searching for a career that I enjoyed as well as one that would allow me to raise my two children as a single parent. At the time [...] Read more
Nicole Walker