This article is perfect if you're just getting started. There's lore around design tricks to get the most out of a database, but it's often implementation or d

This article is perfect if you're just getting started. There's lore around design tricks to get the most out of a database, but it's often implementation or domain specific. You'll learn what rules to break, and why, as you solve real life production problems. FWIW - you can go a long, long, long way before de-normalising is actually necessary.