Course Outline
Introduction to Oracle Database 19c
- General overview of Oracle Database 19c
- Setup and configuration processes
- Architecture of the Oracle database
- Management tools
SQL Recap and Advanced Topics
- Review of fundamental SQL
- Select, insert, update, and delete statements
- Joins, subqueries, and set operations
- Advanced SQL principles
- Analytical functions
- Hierarchical queries
- Complex grouping and aggregation
Getting Started with PL/SQL
- Introduction to PL/SQL
- Structure of PL/SQL blocks
- Variables, constants, and data types
- Control structures: if, loop, and case
PL/SQL Program Units
- Procedures and functions
- Packages and package bodies
- Triggers and their administration
- Autonomous transactions
Advanced PL/SQL Capabilities
- Collections: associative arrays, nested tables, and VARRAYs
- Bulk processing using BULK COLLECT and FORALL
- Dynamic SQL via EXECUTE IMMEDIATE
- PL/SQL records and composite data types
Error Management and Debugging
- Exception handling: predefined and custom exceptions
- Techniques for PL/SQL debugging
- Utilization of DBMS_OUTPUT and DBMS_DEBUG
Performance Tuning and Optimization
- Methods for SQL query optimization
- Analysis of execution plans
- Indexing strategies
- Application of hints for query tuning
PL/SQL Best Practices
- Creating efficient PL/SQL code
- Coding standards and conventions
- Security aspects in PL/SQL
- Dependency management and version control
Advanced SQL Subjects
- Complex joins and subqueries
- Recursive queries
- Application of regular expressions in SQL
- Implementation of full-text search
Conclusion and Future Pathways
Requirements
- Fundamental understanding of SQL and relational database concepts
- Acquaintance with the Oracle Database 19c environment
Target Audience
- Database administrators
- Database developers
- SQL programmers
- IT professionals
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 5800 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (4)
To understand and better comprehensive with routine SQL
Faizal KAHAR - Soitec Microelectronics Singapore Pte Ltd
Course - Oracle Database 19c PL and Advanced SQL
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.