Oracle Database 12c: SQL II – Intermediate Course in United States
AT7716
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.
Training schedule for "Oracle Database 12c: SQL II – Intermediate Course"
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,160 $.
The total duration (day) of the One-to-One Oracle Database 12c: SQL II – Intermediate Course program is 2.
Note: If you prefer to take this course onsite, the total duration will be 3, as required by the training vendor’s delivery standards.
We can also deliver this Oracle Database 12c: SQL II – Intermediate Course in French, Arabic, and Spanish. If you require another language option, our Customer Success Managers will be happy to assist and guide you through availability and scheduling.
Yes, our certified and experienced trainers can deliver this program onsite at your location, and if required, in your preferred language. For customized delivery formats and pricing, please contact your Customer Success Manager.
If you prefer to take this course as a group (onsite), the total duration will be 3, as required by the training vendor’s delivery standards.
Official training materials (for Oracle Database 12c: SQL II – Intermediate Course), instructor support, hands-on labs and practical exercises, and 1-month post-training Q&A support.
Exam & Certification
Participation Certificate
All trainees who participate in training will have an AcademyTech participation certificate.
AcademyTech Training and Consulting Center