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
Getting Started with Oracle Database 19c
- Comprehensive overview of Oracle Database 19c
- Setup, installation, and configuration procedures
- In-depth look at Oracle database architecture
- Essential tools for database administration
SQL Refresher and Advanced Paradigms
- Foundational SQL recap
- DML operations: Select, insert, update, delete
- Complex joins, subqueries, and set operations
- Sophisticated SQL methodologies
- Advanced analytical functions
- Handling hierarchical data structures
- Complex grouping and aggregation strategies
Introduction to PL/SQL Programming
- Overview of the PL/SQL language
- Anatomy of PL/SQL blocks
- Managing variables, constants, and data types
- Control flow mechanisms: if, loop, and case structures
Developing PL/SQL Program Units
- Creating procedures and functions
- Designing packages and package bodies
- Implementing and managing triggers
- Utilizing autonomous transactions
Advanced PL/SQL Capabilities
- Working with collections: associative arrays, nested tables, and VARRAYs
- Optimizing bulk processing using BULK COLLECT and FORALL
- Executing dynamic SQL via EXECUTE IMMEDIATE
- Defining PL/SQL records and composite data structures
Error Management and Debugging Strategies
- Exception handling: leveraging predefined and custom exceptions
- Techniques for effective PL/SQL debugging
- Utilizing DBMS_OUTPUT and DBMS_DEBUG utilities
Performance Enhancement and Tuning
- Strategies for SQL query optimization
- Interpreting execution plans for performance insights
- Developing effective indexing strategies
- Applying hints to fine-tune query performance
PL/SQL Best Practices
- Writing high-efficiency PL/SQL code
- Adhering to coding standards and conventions
- Addressing security considerations in PL/SQL development
- Managing code dependencies and version control
Advanced SQL Subject Matter
- Complex joins and nested subqueries
- Implementing recursive queries
- Utilizing regular expressions within SQL
- Implementing full-text search capabilities
Conclusion and Future Pathways
Requirements
- Foundational knowledge of SQL and relational database architectures
- Proficiency with the Oracle Database 19c environment
Target Audience
- Database Administrators
- Database Developers
- SQL Programmers
- IT Specialists
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.