This website discusses Normalization, Oracle Technology, Relational Database Design, and the Structured Query Language.
| Advanced Oracle Tuning Concepts |
| Abstract Data Types | Oracle Segment Internals |
| Advanced Structured Query Language |
| Characteristics of SQL | Group By Clause | Sub-Select Statements | Sub-Select Equals Clause |
| SQL Views | Create Subselect using IN |
| Basic Structured Query Language |
| DB Normalization - Exercise | Relational DB Analogy | Relational vs. Flatfile | Customer Table Example |
| SQL Approaches - Quiz | SQL-92 |
| Database Administration Features |
| Oracle Security Features |
| Database Creation Architecture |
| Oracle Describe Command | Oracle Spool Command | Oracle Exit Command | desc oracle command |
| Start Server Manager | Locating Oracle Home | Server Manager Executable | Server Manager HELP Command |
| Server Manager - Quiz | Oracle Initialization File | Oracle Redo Log - Quiz | Locating Executable Server Manager |
| Extended Database Features |
| Creating Oracle Cluster | Oracle Table Partitioning | Oracle Partitioned Tables | Oracle Hash Cluster |
| Managing Database Objects |
| Oracle Segment Role | Alter extent size table | Tablespace Fragmentation - Quiz | Operating system blocks |
| Oracle Extents | Free Diction - Quiz | Oracle Storage Concepts | Describing Columns View |
| Coalesce Tablespace | Oracle Tablespace Default Storage | Fragmented TableSpace | Oracle Extents Data Dictionary |
| Oracle Dictionary Extents | Storage Management Concepts | Oracle free space | Auction House Database |
| Oracle Space Management | Oracle Block Size | Data Dictionary Views | Schema Manager Table |
| Altering/Dropping Tables - Quiz |
| Oracle Network Administration |
| Network Administration - Quiz |
| Oracle Network Topology |
| Location Independence | Transparent Network Substrate | Distributed Databases | Searching Oracle Topology |
| Hardware Independence | Join Tables from remote sites | Replication Independence | Replication Independence |
| Oracle SQL Tuning |
| Heuristics Based Optimizer | Oracle Explain Plan Utility | SQL Tuning - Quiz | Decode ANSI Standard SQL |
| Oracle built-in functions for SQL | Oracle Query Override | Null versus Missing Value | SQL Tuning Utilities |
| DECODE with GROUPING/ROLLUP | Oracle Ranking Scheme |
| Oracle 8i PL/SQL Programming |
| Nested Tables and Varrays | Using Oracle Objects | Dangling Reference Oracle Trigger |
| Performance Tuning Oracle |
| Cost Based Optimizer |
| PL/SQL Stored Objects |
| Stored Function Advantages | PL/SQL Blocks Conclusion |
| PL/SQL Programming |
| dbms_out.put_line in sql | Petstore schema | pl sql dbms_output | Building Queries with PL/SQL |
| non pl/sql variables bind and host | (PGA) Program Global Area | Pet Store DataModel | Adding PL/SQL Comments |
| PL/SQL Block Conclusion | Oracle Naming Conventions | Binary Operators in PL/SQL | Implicit Data Type |
| Relational Database Analysis |
| Define Primary Key | Concatenated Keys | DB Normalization | First Normal Form - Exercise |
| DB Table Characteristics | Database Design Diagram | Second Normal Form - Exercise | Normalization Process - Quiz |
| Referential Integrity | Defining Foreign Keys | Functional Dependencies - Exercise | Database Normalization - Quiz |
| Relational Theory Notation | Achieving 2nd Normal Form | Limitations of 1st Normal Form | All-key relations |
| Purpose of Normalization | Relational Notation/Table Characteristics - Quiz | DB Primary Key - Quiz | 1st, 2nd, and 3rd Normal Forms |
| Relational Database Design |
| Design Stages in DBLC | ERD Modeling CaseStudy | Three Schema Architecture | 2 Different Design Strategies |
| Database Design - Quiz | Database Design Strategy | RDBMS Functions | Relational DB Design |
| Relational DB Design - Quiz | Post Database Design Stages | Top Down Design | Relational Database Course Project |
| ERD - Exercise | Bottom-Up Design |