Course Description
This course is designed for Oracle professionals who want to deepen their expertise in PL/SQL programming. It covers advanced features of PL/SQL including performance tuning, bulk processing, advanced error handling, object types, collections, autonomous transactions, and PL/SQL security. Through a combination of concepts, hands-on practice, collaborative discussions, and real-world case studies, participants will gain the skills necessary to build efficient, scalable, and secure PL/SQL applications in an Oracle Database environment.
Durasi
4 Days
Course Objectives
By the end of this course, participants will be able to :
- Apply advanced PL/SQL programming techniques for enhanced performance and maintainability.
- Optimize PL/SQL code using collections, bulk operations, and efficient design patterns.
- Implement robust error handling, exception propagation, and logging strategies.
- Create and use PL/SQL object types and advanced collections.
- Use native dynamic SQL and autonomous transactions effectively.
- Manage PL/SQL code security, privileges, and dependency tracking.
- Develop and debug complex PL/SQL programs using best practices and tuning techniques.
Course Audience
- PL/SQL Developers.
- Oracle Database Developers.
- Application Developers working with Oracle databases.
- Technical Consultants.
- Advanced Database Administrators who need to support PL/SQL developmen.
Course Prerequisites
- A solid understanding of basic PL/SQL programming (equivalent to attending an Oracle PL/SQL Fundamentals course).
- Experience with Oracle SQL and basic database structures.
- Familiarity with Oracle development tools.