Oracle SQL Tuning |
Advanced Oracle Tuning - Glossary | |||
PCTFree Optimal Performance | Monitoring Tuning | ||
Abstract Data Type | |||
Concatenated Indexes | STAR Transformation Queries | B-Tree Bitmapped Indexes | Function Based Indexed |
Advanced SQL |
Characteristics of SQL | PUBS Database explained | Group By Clause | Subquery Equals Clause |
GETDATE, SYSDATE, TODAY |
Backup Recovery Methods |
Backup Recovery Methods - Glossary | |||
Physical Archiving | Physical vs Logical | OS Backup Options | Closed DB Backup |
Backup Recovery Concepts |
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 Admin |
Database Admin-Glossary | |||
DBA | Tablespace Resource MGT | Large DB Features | Security Features |
DBA Admin -Tasks |
DBA Admin Tasks-Glossary | |||
DB Monitoring | Alert Log Info | Alert Log Contents | License Compliance |
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 |
Extended DB Features |
Database Features - Glossary | |||
Partitioned Tables | Partitioning Tables | Partitioning Advantages | Table Range Partitioning |
Managing Objects |
Managing Users |
Managing Users - Glossary | |||
Configuring Oracle | Configuring listener.ora | Stop Restart Listener | |
Admin Privileges | Oracle Connect Database | Remote Login Password | Oracle DBA Roles |
Config Management |
Internet Directory | Directory Naming | Oracle Names | Local Filesystem |
Oracle Backup Recovery |
Oracle Backup Recovery - Glossary | |||
Database Backup | Recovery Manager Features | Backup Strategies | Enterprise Manager |
Database Backup |
Database Backup Recovery - Glossary | |||
Import Export Utilities | Export/Import Overview | Running Export | Complete Backup |
Network Admin |
Network Administration - Glossary | |||
Network Services | Scalability Features | Partitioned Tables | Security Features |
Network Topology |
SQL Extensions |
Oracle SQL - Glossary | |||
Union, Intersect, Minus | Hierarchical Retrieval via Connect | Advanced Group Operators | Oracle Pseudo Columns |
Decode NVL Functions | Character, String Functions | to_char, round, trunc |
SQL Tuning |
SQL Tuning - Glossary | |||
Decode ANSI SQL | Heuristics Based Optimizer | SQL Tuning Quiz | |
SQL Optimizer Modes | Analyze Explain Plan | SQL Optimizer Modes |
Oracle PL/SQL |
Oracle PL/SQL - Glossary | |||
Querying Object Tables | Oracle Objects | Two Types Object Tables | Collections | varrays |
Performance Tuning |
Performance Tuning - Glossary | |||
Optimizer/Query Improvements | Optimizer Functions | Stored Outlines Behavior | dbms_stats package |
Tuning Basics |
OCP Exam Preparation | |||
Oracle Performance Tuning |
Stored Objects |
PL/SQL Objects - Glossary | |||
User Defined Objects | Function Syntax | Function Return Values | Function Boolean Value |
PL/SQL Programming |
Database Analysis |
Database Design |
DB2 Interview Questions |
Outer Joins, Subselect Questions | |||
DB2 Lock Contention Questions |
Tuning Oracle Instance |
Tuning Instance - Glossary | |||
Instance Tuning | SGA Components | Shared Pool | Library Cache |
Tuning External Environment |
DB Monitoring | Tune OS Components | Architecture Related Performance | Disk I/O DB Performance |
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 |
Queries Cursors Views - Glossary | |||
SQL Basic Conclusion | |||
Using Subqueries - Exercise | Selecting Data Conclusion | ||
Using SubQuery Statements | SQL Statement-Punctuation |
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 |
PCTFree Optimal Performance | |
Monitoring Tuning | |
Abstract Data Type | |
Concatenated Indexes | STAR Transformation Queries |
B-Tree Bitmapped Indexes | Function Based Indexed |
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 |
Transparent Network Substrate | Database Local Autonomy |
Location Independence | Distributed Fragmentation |
Oracle Networked Computers | |
Evolution Network Protocols | sqlnet.ora Location |
SQL Extensions |
Union, Intersect, Minus | Hierarchical Retrieval via Connect |
Advanced Group Operators | Oracle Pseudo Columns |
Decode NVL Functions | |
Character, String Functions | to_char, round, trunc |
SQL Tuning |
Decode ANSI SQL | |
Heuristics Based Optimizer | SQL Tuning Quiz |
SQL Optimizer Modes | |
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 |