Oracle SQL & PL/SQL - 5 days online classroom
3.450,00 EUR
- 5 days
Build a strong foundation in Oracle database development with this practical Oracle SQL and PL/SQL Fundamentals course. Designed for beginners and aspiring database professionals, the course teaches you how to retrieve, manage, and manipulate data using Oracle SQL while also introducing PL/SQL programming for creating procedures, functions, triggers, and database logic.
Key Features
Language
Course material in English
Level
Beginner - Intermediate level
5 days of live instructor-led
Virtual training (8 hours / day)
Access to Oracle SQL Developer
Course workbook and downloadable reference materials
60+ 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.
Working with Data Dictionaries
Learn how to query Oracle data dictionary views to understand database structures, relationships, indexes, and metadata for better database analysis and troubleshooting.
Dynamic SQL & Advanced Querying
Explore dynamic SQL, parameter binding, and secure query techniques while building advanced joins, correlated subqueries, inline views, and performance-optimized SQL queries.
Building PL/SQL Programs
Create modular PL/SQL programs using variables, loops, conditions, cursors, records, and exception handling to automate tasks and build reliable database-driven solutions.
Course timeline
Day 1
PL/SQL Fundamentals
- Introduction to PL/SQL
- Variables, constants, and data types
- Initialising variables and assigning values
- Using SQL within PL/SQL code
- Generating output in SQL Developer
Day 2
Program Logic
- IF, ELSE, and CASE statements
- Basic, WHILE, and FOR loops
- Nested and labelled loops
- GOTO and CONTINUE statements
Day 3
Using Cursors
- Implicit and explicit cursors
- Declaring, opening, and closing cursors
- Fetching rows and status checking
- Cursor FOR UPDATE and FOR loops
- Parameterised cursors
Day 4
Exceptions & Nested Blocks
- Exception handling in PL/SQL
- System and user-defined exceptions
- Application errors and WHEN OTHERS handling
- Nested and labelled blocks
- Scope of variables, cursors, and GOTO statements
- Exception propagation
Day 5
PL/SQL Records & Associative Arrays
- Declaring and using record types
- Working with nested records
- Associative arrays (index-by tables)
- Built-in PL/SQL table functions
- Managing PL/SQL collections
Who Should Enroll in this Program?
Aspiring Oracle database developers
Junior database administrators (DBAs)
Data analysts and reporting professionals
Software developers working with Oracle databases
IT professionals involved in database management
Anyone wanting to build SQL and PL/SQL programming skills
Prerequisites
- Basic computer and IT knowledge
- Familiarity with databases and data concepts is beneficial
- No prior Oracle SQL or PL/SQL experience required
- Basic programming knowledge is helpful but not mandatory
- Understanding of relational databases is recommended
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!