Oracle Database 12c: PL/SQL II – Intermediate: Develop Program Units Course in United States
AT7718
"Deepen your expertise in PL/SQL programming with our 'Oracle Database 12c: PL/SQL II' course. Tailored for database developers and administrators, this program offers an advanced exploration of PL/SQL, a powerful procedural language used for database development in Oracle Database 12c. Learn to design and implement complex PL/SQL programs, optimize database performance, and handle exceptions effectively. Our expert instructors, well-versed in Oracle Database technologies, will guide you through hands-on exercises and real-world scenarios, ensuring you acquire the advanced skills necessary to excel in database development and administration with PL/SQL in Oracle Database 12c. Elevate your proficiency in PL/SQL programming and empower yourself to build efficient and robust database solutions with our 'Oracle Database 12c: PL/SQL II' course."
Training schedule for "Oracle Database 12c: PL/SQL II – Intermediate: Develop Program Units Course"
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,160 $.
"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 2,180 $. To create a group, you must be at least 3 people.
The one-to-one tuition fee is 2,160 $.
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.
AcademyTech Training and Consulting Center