This course introduces students to PL/SQL and explains 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 also learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. Students learn about declaring identifiers and trapping exceptions. Demonstrations and hands-on practice reinforce the fundamental concepts.
Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools.
After the basic PL/SQL and SQL language skills, students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage, PL/SQL subprograms and triggers. 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.
In this course, students use Oracle SQL Developer as the main tool and SQL*Plus is introduced as an optional tool.
This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement.
Learn to:
- Declaring PL/SQL Variables
- Working with Composite Data Types
- Conditionally control code flow (loops, control structures)
- Explicit cursors
- Handle runtime errors
- Describe stored procedures and functions
- Create, and execute stored procedures and functions.
- Design and use PL/SQL packages
- Create overloaded package subprograms for more flexibility.
- Utilize Oracle-Supplied Packages in Application Development
- Create triggers to solve business challenges.
- Build and execute SQL statements dynamically.