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.