Sql – A beginner’s guide to SQL database design

databasedatabase-designscalabilitysql

Do you know a good source to learn how to design SQL solutions?

Beyond the basic language syntax, I'm looking for something to help me understand:

  1. What tables to build and how to link them
  2. How to design for different scales (small client APP to a huge distributed website)
  3. How to write effective / efficient / elegant SQL queries

Best Solution

I started with this book: Relational Database Design Clearly Explained (The Morgan Kaufmann Series in Data Management Systems) (Paperback) by Jan L. Harrington and found it very clear and helpful

and as you get up to speed this one was good too Database Systems: A Practical Approach to Design, Implementation and Management (International Computer Science Series) (Paperback)

I think SQL and database design are different (but complementary) skills.