Session: How to Design a Relational Database

SPEAKER: Louis Davidson, Data Architect , drsql.org

Database design is a seemingly natural process, lending everyone to try to do it themselves, from an administrative assistant with a spreadsheet to a C# programmer with a copy of SQL Server Express. Unfortunately, the finer points of excellent database design are not intuitively obvious, and the difference between building a spreadsheet and a solid enterprise database is like the difference between building a doghouse and a two-story house, or even the Empire State Building.

This session looks at some of the concepts and practices that go into designing a great database, using a mix of light theory and practical examples to help to make it clear that building a relational database is neither simple nor difficult once you understand the fundamentals.

To access your 24 Hours of PASS session recording, please provide the following:

  •