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.

Who Should Attend

  • This course is designed for Intermediate Oracle PL/SQL developers and DBAs supporting development tasks DBAs who want to automate repetitive database management tasks

Course Content

  • 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 using 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

Frequently Asked Questions

"Oracle Database 12c: PL/SQL II – Intermediate: Develop Program Units Course" trainings are given in ("Group - One to one") two different  ways.
The one-to-one tuition fee is 2,180 $.

"Oracle Database 12c: PL/SQL II – Intermediate: Develop Program Units Course" trainings are given in two different ways.

The tuition fee as a group is 1,970 $. To create a group, you must be at least  3 people.
The one-to-one tuition fee is 2,180 $.

Our "Oracle Database 12c: PL/SQL II – Intermediate: Develop Program Units Course" trainings are one-to-one 3 days,

Our "Oracle Database 12c: PL/SQL II – Intermediate: Develop Program Units Course" trainings are group 2 days,
 

 

Exam & Certification

Participation Certificate

All trainees who participate in training will have an AcademyTech participation certificate.

Exam & Certification

Popular locations for Oracle Database 12c: PL/SQL II – Intermediate: Develop Program Units Course in United States

Request more information for
"Oracle Database 12c: PL/SQL II – Intermediate: Develop Program Units Course"

Prefered Mode of Contact