Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Oracle Database 19c
- Overview of Oracle Database 19c
- Installation and configuration
- Oracle database architecture
- Tools for database management
SQL Review and Advanced Concepts
- Basic SQL review
- Select, insert, update, delete
- Joins, subqueries, and set operations
- Advanced SQL concepts
- Analytical functions
- Hierarchical queries
- Advanced grouping and aggregation
Introduction to PL/SQL
- Overview of PL/SQL
- PL/SQL block structure
- Variables, constants, and data types
- Control structures: if, loop, case
PL/SQL Program Units
- Procedures and functions
- Packages and package bodies
- Triggers and trigger management
- Autonomous transactions
Advanced PL/SQL Features
- Collections: associative arrays, nested tables, VARRAYs
- Bulk processing with BULK COLLECT and FORALL
- dynamic SQL with EXECUTE IMMEDIATE
- PL/SQL records and composite data types
Error Handling and Debugging
- Exception handling: Predefined and user-defined exceptions
- PL/SQL debugging techniques
- Using DBMS_OUTPUT and DBMS_DEBUG
Performance Tuning and Optimization
- SQL query optimization techniques
- Understanding execution plans
- Indexing strategies
- Using hints for query optimization
PL/SQL Best Practices
- Writing efficient PL/SQL code
- Coding standards and conventions
- Security considerations in PL/SQL
- Managing dependencies and version control
Advanced SQL Topics
- Advanced joins and subqueries
- Recursive queries
- Using regular expressions in SQL
- Implementing full-text search
Summary and Next Steps
Requirements
- Basic knowledge of SQL and relational database concepts
- Familiarity with Oracle Database 19c environment
Audience
- Database administrators
- Database developers
- SQL programmers
- IT professionals
28 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €9120 online delivery, based on a group of 2 delegates, €2880 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (3)
he explained very well, and gave guidance on the exercises.
Stoyan - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
I like everything.
Angel - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
I liked very much the format of the training, hands on, directly in sql developer.
