RelationalDBDesign

Welcome to RelationalDBDesign!

This website discusses Normalization, Relational Database Design, SQL and Oracle Technology.

RelationalDBDesign

 
Oracle SQL Tuning
High Water Mark PCTFree Optimal Performance Monitoring Tuning  
Object Oriented Database 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
Coalesce Tablespace Operating System Blocks Describing Columns View Oracle Extents
Oracle free Space Oracle Segment Role Oracle Storage Concepts Fragmented TableSpace
Alter extent size Table Oracle Dictionary Extents Describing Table Columns Data Dictionary Constraints

 
Network Topology
Transparent Network Substrate Database Local Autonomy Location Independence Distributed Fragmentation
Oracle Networked Computers Searching Oracle Topology Evolution Network Protocols sqlnet.ora Location

 
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
Linking Tables Relational Database Model Relationally Complete Relational Database Quiz
RDBMS Functions Database LifeCycle Design Stages in DBLC Three Schema Architecture
Application Approach Design Post Database Design Stages Top Down Design Database Design Strategy
Business Rules Importance Purpose Requirements Analysis Define Business Objects Business Object Characteristics
Entities Attributes Conceptual Model Multi-valued Attribute Resolve Entity Identifier Attribute Attribute Domain Types
Three Relationship Types Many to Many to One-to-Many Optional Participation Relationship One-to-one Relationship

 
Database Analysis
DB Tables Characteristics Concatenated Keys Define Primary Key Defining Foreign Keys
Referential Integrity Relational Theory Notation Database Null Values Relational Notation
Normalization Defined Normalization Objective Identify Functional Dependencies Normalization Process - Quiz
Achieving 2nd Normal Form Functional Dependencies - Exercise Normalization Database - Quiz Reduce Data Redundancy
Third Normal Form 1st, 2nd, 3rd Normal Form Second NF Limitations Transitive Dependencies
Table Joins User Views Permissions Roles DB Permissions Requirements SQL Inner Join
Downside Horizontal Partitioning Downside Vertical Partitioning Horizontal Partitioning Database Partitioning
 
Oracle SQL Tuning
High Water Mark PCTFree Optimal Performance
Monitoring Tuning  
Object Oriented Database 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
Coalesce Tablespace Operating System Blocks
Describing Columns View Oracle Extents
Oracle free Space Oracle Segment Role
Oracle Storage Concepts Fragmented TableSpace
Alter extent size Table Oracle Dictionary Extents
Describing Table Columns Data Dictionary Constraints

 
Network Topology
Transparent Network Substrate Database Local Autonomy
Location Independence Distributed Fragmentation
Oracle Networked Computers Searching Oracle Topology
Evolution Network Protocols sqlnet.ora Location

 
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
Linking Tables Relational Database Model
Relationally Complete Relational Database Quiz
RDBMS Functions Database LifeCycle
Design Stages in DBLC Three Schema Architecture
Application Approach Design Post Database Design Stages
Top Down Design Database Design Strategy
Business Rules Importance Purpose Requirements Analysis
Define Business Objects Business Object Characteristics
Entities Attributes Conceptual Model Multi-valued Attribute Resolve
Entity Identifier Attribute Attribute Domain Types
Three Relationship Types Many to Many to One-to-Many
Optional Participation Relationship One-to-one Relationship

 
Database Analysis
DB Tables Characteristics Concatenated Keys
Define Primary Key Defining Foreign Keys
Referential Integrity Relational Theory Notation
Database Null Values Relational Notation
Normalization Defined Normalization Objective
Identify Functional Dependencies Normalization Process - Quiz
Achieving 2nd Normal Form Functional Dependencies - Exercise
Normalization Database - Quiz Reduce Data Redundancy
Third Normal Form 1st, 2nd, 3rd Normal Form
Second NF Limitations Transitive Dependencies
Table Joins User Views Permissions Roles DB
Permissions Requirements SQL Inner Join
Downside Horizontal Partitioning Downside Vertical Partitioning
Horizontal Partitioning Database Partitioning