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:
- What tables to build and how to link them
- How to design for different scales (small client APP to a huge distributed website)
- How to write effective / efficient / elegant SQL queries