Oracle 12c PL/SQL Program Units

PT10507
Training Summary
One of the most powerful features of the Oracle RDBMS product is the ability to create named 'blocks' of PL/SQL code that are stored within the database. This allows for robust solutions to be developed that can be shared and re-used.This intermediate class provides the technical expertise necessary to expand the powerful capabilities of PL/SQL by creating program units: stored procedures, functions, packages and triggers that are stored within the database. Working in Oracle's SQL Developer tool participants will learn how to develop, debug and manage all these types of programs.The four types of these program units: procedures, functions, packages and triggers are each covered in depth. Students will learn to write, debug and manage each.Students use the Oracle PL/SQL IDE, SQL Developer, throughout the course as the presentation tool and as their development environment. Features of this tool that enhance productivity along with its integral source level debugger are presented.The content of this course is applicable to Oracle 12c with relevance to versions back to 10g.This class provides preparation for the OCP 1Z0-147 Program with PL/SQL test. Additional skills with basic PL/SQL will also be required for success. These topics are covered in the Oracle Introduction to PL/SQL Program Units course. Oracle Corporation suggests that candidates also have six months of hands-on experience before testing.
Prerequisites
Prior to taking this course, students should have the following skills:Skill with GUI interfacesData processing backgroundBasic SQL and PL/SQL skill (3 to 6 months of development effort)A basic understanding of SQL is required to succeed in this class. The SQL used in this class is as simple as possible, but persons with absolutely no SQL experience will likely experience difficulty. An introductory understanding of PL/SQL is required to succeed in this class. The "Oracle 12c PL/SQL Introduction" class contains this content.
Duration
3 Days/Lecture & Lab
Audience
This course is designed for Intermediate Oracle PL/SQL developers and DBAs supporting development tasks and DBAs who want to automate repetitive database management tasks.
Course Topics
  • The Petsaver database
  • Creating stored procedures
  • Writing stored procedures using SQL Developer
  • Creating stored functions
  • Advanced features of procedures and functions
  • 12c PL/SQL new features
  • Debugging PL/SQL with SQL Developer
  • Creating packages
  • Writing packages with SQL Developer
  • Advanced features of packages
  • Creating database triggers
  • Advanced features of triggers
  • Maintaining program units
  • Dynamic SQL in PL/SQL

Related Scheduled Courses