This Oracle Database 12c: PL/SQL II - Intermediate: Develop Program Units students will apply the basics of the Oracle PL/SQL database programming language and its syntax, and employ the language in the development of database applications. In particular, the focus will be on the use of databaseresident 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.

Who Should Attend

  • Application designers and database developers
  • Database administrators
  • Web server administrators

Course Content

  • Introducing Database-Resident Program Units
  • Executing Stored Procedures & Functions
  • Maintaining Stored Program Units
  • Managing Dependencies
  • Creating & Maintaining Packages
  • Advanced Package Capabilities
  • Creating Stored Procedures & Functions
  • Advanced Cursor Techniques
  • Using System-Supplied Packages
  • Database Trigger Concepts
  • Creating Database Triggers
  • Maintaining Database Triggers
  • Implementing System Event Triggers

Frequently Asked Questions

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

"Oracle Database 12c: SQL II – Intermediate 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: SQL II – Intermediate Course" trainings are one-to-one 3 days,

Our "Oracle Database 12c: SQL II – Intermediate Course" trainings are group 2 days,
 

 

Exam & Certification

Participation Certificate

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

Exam & Certification

Request more information for
"Oracle Database 12c: SQL II – Intermediate Course"

Prefered Mode of Contact