SQL & PL/SQL Tutorial
Creating and maintaining relational databases requires SQL. This is a 5th generation, declarative, domain specific programming language. It stands for Structured Query Language. You can use SQL with a CLI app or you can embed SQL in application development. PL/SQL adds full procedural power on top of SQL.
Scope: Study the lessons in order, practice each query in your database, and revisit the index for targeted reference.
SQL & PL/SQL Study Progress
| # | PL/SQL | Topic | Description |
|---|---|---|---|
| PHASE 1: DATABASE LIFE CYCLE | |||
| 01 | Overview | SQL and relational database concepts. | |
| 02 | Build | Schema design tables and database creation. | |
| 03 | Operate | Querying and operating a live database. | |
| 04 | Maintain | Database maintenance and administration. | |
| 05 | Optimize | Query plans, indexes, and performance tuning. | |
| PHASE 2: PL/SQL LANGUAGE | |||
| 06 | Syntax | PL/SQL syntax and embedded SQL rules. | |
| 07 | Structure | Program blocks and execution structure. | |
| 08 | Flow Control | Conditionals, loops, and procedural flow. | |
| 09 | Cursors | Implicit/explicit cursors, %ROWTYPE, REF CURSOR. | |
| 10 | Exceptions | Predefined and user-defined exception handling. | |
| PHASE 3: PL/SQL DATA & MODULES | |||
| 11 | Data Types | PL/SQL data types and variable binding. | |
| 12 | Collections | Associative arrays, nested tables, and VARRAYs. | |
| 13 | Packages | Packages, procedures, and stored code organization. | |
| 14 | Transform | JOIN, GROUP BY, CTEs, views, and MERGE. | |
| 15 | Triggers | BEFORE/AFTER triggers, :NEW and :OLD. | |
| PHASE 4: PRACTICE & REFERENCE | |||
| 16 | Lab Examples | Single-file practice scripts. | |
| 17 | References & Tools | Playgrounds, docs, courses, samples. | |