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.
Duration 28 hours
Course Outline
Introduction to Oracle Database 19c
- Comprehensive overview of Oracle Database 19c
- Installation procedures and configuration
- Understanding Oracle database architecture
- Essential tools for database administration
SQL Review and Advanced Concepts
- Refresher on Basic SQL
- Core DML operations: Select, Insert, Update, Delete
- Join strategies, subqueries, and set operations
- Exploring Advanced SQL
- Utilization of analytical functions
- Construction of hierarchical queries
- Complex grouping and aggregation techniques
Introduction to PL/SQL
- Overview of the PL/SQL language
- Structure and syntax of PL/SQL blocks
- Working with variables, constants, and data types
- Control flow structures: if, loop, and case statements
PL/SQL Program Units
- Designing procedures and functions
- Creating packages and package bodies
- Implementing and managing triggers
- Working with autonomous transactions
Advanced PL/SQL Features
- Managing collections: associative arrays, nested tables, and VARRAYs
- Optimizing bulk operations using BULK COLLECT and FORALL
- Executing dynamic SQL via EXECUTE IMMEDIATE
- Defining PL/SQL records and composite data types
Error Handling and Debugging
- Exception management: predefined and user-defined exceptions
- Applying effective PL/SQL debugging strategies
- Utilizing DBMS_OUTPUT and DBMS_DEBUG utilities
Performance Tuning and Optimization
- Techniques for optimizing SQL queries
- Interpreting execution plans
- Strategic indexing approaches
- Applying hints for targeted query optimization
PL/SQL Best Practices
- Authoring efficient and high-performance PL/SQL code
- Adhering to coding standards and conventions
- Addressing security considerations within PL/SQL
- Managing dependencies and implementing version control
Advanced SQL Topics
- Complex joins and nested subqueries
- Executing recursive queries
- Application of regular expressions in SQL
- Implementing full-text search capabilities
Summary and Next Steps
Requirements
- Foundational knowledge of SQL and relational database principles
- Working familiarity with the Oracle Database 19c environment
Target Audience
- Database administrators
- Database developers
- SQL programmers
- IT professionals
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.
