Course Overview
This course introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This trainng will also lay the foundation for the Oracle PL/SQL programming language, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The focus of the second part of this training will be on the use of database-resident stored program units such as procedures, functions, packages and database triggers. New features introduced with the Oracle 12c release of the database are also explained and demonstrated.
PL/SQL may be considered as one of the basic skill sets required for any Oracle professional, nearly as important as the SQL language itself.
Who should attend
The target audience is all Oracle professionals. Among the specific groups for whom this course will be helpful are:
- Application designers and database developers
- Database administrators
- Web server administrators
Course Objectives
This trainng begins with an explanation of the intent and usage of the PL/SQL programming language for database applications. Important reasons why one should incorporate PL/SQL modules within the application architecture right from the initial design and planning phase are presented. Next one learns how to begin building executable PL/SQL program units. One learns about each of the major segments of a working program and how these interact with each other during program execution, including the important error or exception handling capabilities of the language.
In a production environment most PL/SQL program units should be packaged, and these advanced database programming capabilities along with the benefits of using these are discussed. It concludes with extensive demonstrations on how a particular type of database-resident program unit known as a database trigger can be used as part of an advanced database application design.
Course Content
- Selection & Setup Of The Database Interface
- About BIND & SUBSTITUTION Variables
- Choosing A Database Programming Language
- PL/SQL Language Fundamentals
- DECLARE Section
- BEGIN Section
- Exception Section
- Beyond The Basics: Explicit Cursors
- Beyond The Basics: Nested Blocks
- Beyond The Basics: DECLARED Subprograms
- Introducing Database-Resident Program Units
- Creating Stored Procedures & Functions
- Executing Stored Procedures & Functions
- Maintaining Stored Program Units
- Managing Dependencies
- Creating & Maintaining Packages
- Advanced Package Capabilities
- Advanced Cursor Techniques
- Using System-Supplied Packages
- Database Trigger Concepts
- Creating Database Triggers
- Maintaining Database Triggers
- Implementing System Event Triggers