Topic 14 – Introduction to Database Design

Why do I need to learn about database design?

Database is the heart of your application, especially enterprise applications. Designing a database incorrectly will cause your application eventually fail.

What can I do after finishing learning about database design?

You will know how to design a relational database and write SQL code PROPERLY. You will know how to build a data warehouse. You will know WHY you should use a relational database system and how it actually works.

That sounds useful! What should I do now?

Please read this "Stephane Faroult and Peter Robson (2006). The Art of SQL" book first.
Then please read
- this "W. H. Inmon (2005). Building the Data Warehouse" book and
- this "Ralph Kimball and Margy Ross (2013). The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling" book and
- this "Vincent Rainardi (2007). Building a Data Warehouse: With Examples in SQL Server" book.
Finally, please read
- this "C. J. Date (2012). Database Design and Relational Theory: Normal Forms and All That Jazz" book and
- this "C.J. Date (2011). SQL and Relational Theory: How to Write Accurate SQL Code" book.
After finishing the books please click Topic 15 - Advanced Software Design to continue.