![]() |
Oracle SQL Tuning |
Advanced SQL |
Characteristics of SQL | PUBS Database explained | Group By Clause | Subquery Equals Clause |
GETDATE, SYSDATE, TODAY |
Basic SQL |
SQL Approaches - Quiz | SQL-92 | Relational DB Analogy | Three Normalization Levels |
Customer Table Example | Flatfile Database | Relational vs Flatfile | Normalization Example Table |
Database Architecture |
Oracle Describe Command | Oracle Spool Command | desc Oracle command | Archive Log List Command |
Checkpoint process (CKPT) | (DBW0) Database Writer | Instance vs. Database | Oracle Large Pool |
Managing Objects |
Network Topology |
SQL Extensions |
Union, Intersect, Minus | Hierarchical Retrieval via Connect | Advanced Group Operators | Oracle Pseudo Columns |
Decode NVL Functions | Concat substr, length | Character, String Functions | to_char, round, trunc |
SQL Tuning |
Oracle Explain Plan Utility | Decode ANSI SQL | Heuristics Based Optimizer | SQL Tuning Quiz |
SQL Optimizer Modes | Non-correlated Subquery | Analyze Explain Plan | SQL Optimizer Modes |
PL/SQL Programming |
Petstore DB Schema | Creating Naming Conventions | non-PL/SQL VAR bind host | DBMS_OUTPUT.PUT_LINE |
PL/SQL Block Conclusion | Adding PL/SQL Comments | Explicit/Implicit Data Conversions | Variables Nested Blocks |
Database Design |
Database Analysis |