Introduction to Relational Database Management Systems (X-409.1)

Useful Links



Database Software


WinZip


Oracle Technology Network


MySQL


SQLite Browser


ERwin Data Modeler Community Edition (free 1 year license)



Database Design


A Simple Guide to Five Normal Forms in Relational Database Theory (William Kent)


Database Normalization Basics (Microsoft)


Normalization: Jose's Database Programming Corner


Basic Normalization (YouTube Video)



Star Schema Design


Another Look at Degenerated Dimensions (Kimball Group)


Conformed Dimensions (Kimball Group)



Slowly Changing Dimensions (Part 1), (Kimball Group)



Slowly Changing Dimensions (Part 2), (Kimball Group)



Creating and Managing Mini Dimensions (Kimball Group)




SQL


Online SQL Course2 (Intermediate/Advanced)


SQLZooo Interactive SQL Tutorial


Online SQL Course with SQL Interpreter


De-clutter Star Schemas With Junk Dimensions (Kimball Group)


Slowly Changing Dimensions (Part 1), (Kimball Group)


Slowly Changing Dimensions (Part 2), (Kimball Group)



Miscellaneous


Explanation of "Ambiguous Outer Joins" Error (MS Access)




Return to X409.1 Home Page