Oracle PL/SQL - 2 days online classroom
1.650,00 EUR
- 2 days
Build advanced Oracle database programming skills with this hands-on Oracle PL/SQL course. Designed for developers, DBAs, and technical professionals working with Oracle environments, the course teaches you how to create efficient, scalable, and maintainable PL/SQL applications using procedures, functions, triggers, packages, and advanced programming techniques.
Key Features
Language
Course material in English
Level
Beginner - Intermediate level
2 days of live instructor-led
Virtual training (8 hours / day)
Interactive hands-on live labs
All relevant course materials
30+ recommended study hours
Program completion certification included
Learning Outcomes
At the end of this program, you will be able to:
Oracle SQL & PL/SQL Fundamentals
Develop practical skills in Oracle SQL for data retrieval, manipulation, and database management before progressing into PL/SQL programming for automation and procedural logic.
Managing Dependencies in PL/SQL
Learn how Oracle handles object dependencies, invalidation, and recompilation to reduce errors, prevent cascading failures, and maintain stable applications.
Performance Optimization & Native Compilation
Improve PL/SQL performance using native compilation, compiler warnings, and the DBMS_WARNING package to create faster and more efficient applications.
PL/SQL Best Practices & Dynamic SQL
Apply PL/SQL design best practices, including secure coding, exception handling, compiler hints, and dynamic SQL techniques to build maintainable and adaptable Oracle applications.
Course timeline
Day 1
Session 1: PL/SQL Fundamentals
- Introduction to PL/SQL
- Basic syntax and elements
- Variables, constants, and data types
- Assigning values and using SQL in code
- Output in SQL Developer
Session 2: Program Logic
- IF, ELSIF, ELSE statements
- CASE expressions
- Loops: basic, WHILE, and FOR
- Nested and labelled loops
- GOTO and CONTINUE statements
Session 3: Using Cursors
- Cursor concepts
- Implicit and explicit cursors
- Declaring, opening, and closing cursors
- Fetching and checking data
- Cursor FOR UPDATE and FOR loops
- Parameterised cursors
Day 2
Session 4: Exceptions & Nested Blocks
- Exception handling in PL/SQL
- Types of exceptions and error handling
- System and user-defined exceptions
- Nested and labelled blocks
- Exception propagation and scope rules
- Managing variables, cursors, and GOTO scope
Session 5: PL/SQL Records & Index-by Tables
- Record types in PL/SQL
- Working with PL/SQL records and nested records
- Index-by tables (associative arrays)
- Built-in table functions
- Manipulating PL/SQL collections
Who Should Enroll in this Program?
Oracle database developers
Database administrators (DBAs)
SQL developers and backend developers
Technical support and application support professionals
Anyone looking to strengthen Oracle programming skills
IT professionals working with Oracle databases
Prerequisites
- Basic understanding of relational database concepts
- Working knowledge of Oracle SQL and query writing
- Prior exposure to Oracle databases is recommended
- Basic programming knowledge is beneficial
- Completion of an Oracle SQL Fundamentals course or equivalent experience is advised
Statements
Licensing and accreditation
The course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Question
Need corporate solutions or LMS integration?
Didn't find the course or program which would work for your business? Need LMS integration? Write us, we will solve everything!