Oracle Database 12c: PL/SQL II - Intermediate

PT9695
Training Summary
This course is intended for those who have already learned the basics of the Oracle PL/SQL database programming language and its syntax, and who are now ready to employ the language in the development of database applications. In particular, the focus of this course 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.
Prerequisites
Either of the courses Oracle Database 12c: SQL Fundamentals (Levels I & II) or Oracle Database 12c: SQL Complete Library (Levels I, II, & III) are recommended.
Duration
3 Days?/Lecture & Lab
Audience
Application designers and database developersDatabase administratorsWeb server administrators
Course Topics
  • 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

Related Scheduled Courses