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 |
Managing Users |
Configuring Oracle | SID List Listener | Configuring listener.ora | Stop Restart Listener |
Admin Privileges | Oracle Connect Database | Remote Login Password | Oracle DBA Roles |
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 |
Building Access Database |
Building Access Database - Glossary | |||
MS Access Window | Access Help Systems | ||
How Data Is Stored | Database Concepts - Quiz | Design Tables Conclusion | Create Access Database |
Access Data Manipulation |
Tables Queries |
Access Features |
Cascade Update Delete | Different Table Relationship Types | Many-to-many Relationship | Database Relationships - Quiz |
Access Web | |||
Access Macros | Create Macros | Macro Builder | Running Macro Queries |
Database Web Apps |
Database Web - Glossary | |||
Database Web Applications | |||
Database Concepts Conclusion | Table-Structures Databases | ODBC Middleware Solutions | Database Concepts - Quiz |
Enterprise Business Rules |
Queries Cursors Views |
SQL Monitoring |
SQL Monitoring - Glossary | |||
Trace Flags | DTS Limitations | DTS Package Designer | |
SQL-Database Creation |
SQL Server Database Creation - Glossary | |||
What is Relational Database | SQL-Client/Server-Architecture | SQL Server Services | Administer SQL Servers |
Database DeNormalization | Data Normalization - Exercise | ||
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 |