Oracle Database 19c: PL/SQL Workshop
The Oracle Database 19c: PL/SQL Workshop is a hands-on professional course designed to build practical proficiency in Oracle PL/SQL, Oracle's procedural extension to SQL used for developing robust, secure, and high-performance database applications. Oracle Database is developed by Oracle Corporation, and PL/SQL is a core skill for database developers, DBAs, application developers, and data engineers working in Oracle environments. This workshop-oriented course focuses on writing, debugging, optimizing, and securing PL/SQL code, including procedures, functions, packages, triggers, cursors, exception handling, and performance techniques. Emphasis is placed on real-world coding exercises aligned with Oracle Database 19c enterprise use cases. Course Objectives By the end of this course, participants will be able to: Understand PL/SQL architecture and execution model Write efficient PL/SQL blocks, procedures, and functions Use control structures, cursors, and exception handling Develop reusable packages and database programs Implement triggers for business logic enforcement Apply performance and security best practices Debug and optimize PL/SQL code
Course Curriculum
1
- Overview of PL/SQL
- Advantages of PL/SQL over SQL
- PL/SQL architecture and execution
- PL/SQL block structure
2
- Scalar data types
- Anchored data types (%TYPE, %ROWTYPE)
- Variable scope and visibility
- Constants and bind variables
3
- Conditional logic (IF, CASE)
- Looping structures (LOOP, WHILE, FOR)
- Nested control structures
- Best practices for readability
4
- Implicit and explicit cursors
- Cursor attributes
- Parameterized cursors
- Cursor FOR loops
5
- Predefined exceptions
- User-defined exceptions
- Exception propagation
- Logging and error-handling strategies
6
- Creating stored procedures
- Creating functions
- Parameter modes (IN, OUT, IN OUT)
- Using procedures and functions in SQL
7
- Package specification and body
- Encapsulation and modular design
- Public vs private components
- Package initialization
8
- Types of triggers (DML, DDL, system)
- Row-level vs statement-level triggers
- Trigger execution order
- Use cases and limitations
9
- Records and composite data types
- Associative arrays
- Nested tables and VARRAYs
- Using collections in PL/SQL programs
10
- BULK COLLECT and FORALL
- Reducing context switches
- Performance tuning techniques
- Common PL/SQL performance issues
11
- EXECUTE IMMEDIATE
- DBMS_SQL overview
- Dynamic query construction
- Security considerations
12
- Definer rights vs invoker rights
- Privileges and roles
- Secure coding practices
- Preventing SQL injection
13
- Using DBMS_OUTPUT
- Exception tracing
- Debugging techniques
- Code testing strategies
14
- PL/SQL performance improvements
- Compatibility considerations
- Best practices for long-term support environments
15
- Writing end-to-end PL/SQL programs
- Business logic implementation scenarios
- Debugging and optimization labs
- Code review and best practices
16
- Instructor-led classroom or virtual training
- Intensive hands-on lab sessions
- Guided workshops and exercises
17
- Database developers
- Oracle DBAs
- Application developers
- Data engineers
- IT professionals working with Oracle databases
18
- Knowledge of SQL
- Familiarity with Oracle Database fundamentals
- Completion of an Oracle SQL course is recommended
19
- Hands-on coding exercises
- Practical lab assessments
- Quizzes and knowledge checks
This course includes
- 19+ Activity Modules
- 40 hours + lessons
- Lifetime access
- Certificate of completion
- Available on desktop and mobile
Some of Our Partners
