RelationalDBDesign   Tweet
RedhatLinuxSysAdmin SeoMining


Welcome to RelationalDBDesign!
This website discusses Normalization, Oracle Technology, Relational Database Design, and the Structured Query Language.

Access Databases Linux/Network Administration Enterprise Java Design Patterns
Java Certification Object Programming System Modeling Redhat Linux Certification
Website Development ebusiness Solutions Internet Technologies SQL Configuration


Advanced Oracle Tuning Concepts
Abstract Data Types Oracle Segment Internals Pctfree Optimal Performance Monitoring tuning indexes
Advanced Structured Query Language
Characteristics of SQL Group By Clause Sub-Select Statements Sub-Select Equals Clause
SQL Views Create Subselect using IN   
Backup Recovery Options
Read Only Tablespace Backups Database Backup Concepts Complete Recovery Operation Identifying Instance Failure Implications
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 Large Database Features Intro Tablespace Management  
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
Pros/Cons of index-organized Tables    
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    
Managing Users Connectivity
Database Administrator Privileges Creating Password File Stop Restart Listener  
Network Configuration Management
Configuring Oracle Dispatchers Mts Configuration Conclusion   
Oracle Backup Recovery Features
Implement Faststart Parallel Rollback Oracle Recovery Catalog   
Oracle DB Backup Recovery
Import Recover Database Objects Running Oracle Export   
Oracle Network Administration
Network Administration - Quiz Distributed Database Tools - 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 Extensions
CONCAT, SUBSTR, LENGTH, INSTR Oracle character string functions Upper, initcap, rtrim, soundex Functions Union Intersect Minus
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 Dbms Stats Package   
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   
Tuning Oracle Instance
Viewing Library Cache Statistics Pin Packages Shared Pool