Duration: 6 Months
• To introduce learners to relational database management systems (RDBMS) using Oracle
• To develop advanced skills in SQL for data retrieval and manipulation
• To equip learners with PL/SQL programming skills for server-side logic
• To provide an understanding of database security, triggers, and stored procedures
• To prepare learners for Oracle Database Developer certifications
Upon completion, learners will be able to:
- Design and implement complex relational database schemas.
- Execute advanced SQL queries including joins, subqueries, and analytic functions.
- Write efficient PL/SQL blocks, procedures, and functions.
- Implement database triggers and packages for business logic.
- Optimize query performance using indexing and execution plans.
Module 1: Oracle SQL Fundamentals
• Introduction to RDBMS and Oracle Architecture
• Data Definition Language (DDL) and Data Manipulation Language (DML)
• Restricting and sorting data; using single-row functions
• Grouping data and using aggregate functions
Module 2: Advanced SQL and Database Design
• Complex joins and subqueries (correlated and non-correlated)
• Set operators and hierarchical retrieval
• Data modeling: Entity-Relationship Diagrams (ERD) and Normalization
• Managing constraints and database objects (views, sequences, indexes)
Module 3: PL/SQL Programming Basics
• PL/SQL block structure and variable declarations
• Control structures in PL/SQL: Loops and conditional branches
• Working with Cursors: Implicit, explicit, and parameterized cursors
• Exception handling in PL/SQL blocks
Module 4: Composite Data Types and Subprograms
• PL/SQL Records and Collections (Nested tables, Varrays)
• Creating and managing Stored Procedures and Functions
• Building and using PL/SQL Packages
• Dependency management in Oracle
Module 5: Advanced PL/SQL and Performance
• Database Triggers: Statement vs. Row level
• Using Dynamic SQL and Execute Immediate
• Oracle architectural components for performance
• SQL Tuning Advisor and basic performance optimization