Get in Touch
 Duration 28 hours

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.
Investment

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)

Upcoming Courses

Related Categories