How to Design and Normalize a Database


Length: 1 hour, 15 minutes

Designing a relational database isn’t hard work. But investing the time and effort early to create a normalized database design will yield big benefits by providing a database that’s self-documenting, easy to maintain and change, and quickly delivers high-quality data to its users.

This session uses extensive examples and a real-world use case to teach you:

  • How to approach a new database design project
  • How to normalize a relational database up to Third Normal Form (3NF)
  • How to read an Entity-Relationship Diagram (ERD) or create your own

This is a great session for developers who’ve never undertaken a database design project themselves, administrators who focus on operations, and other IT professionals who are interested in relational databases. 

Prerequisites: General experience with the ANSI/ISO SQL statements

Goal 1: Understand the benefits of the relational database design method.

Goal 2: Learn how to take an unnormalized table to third normal form.

Goal 3: How to read and create Entity-Relationship Diagrams.



Interested in additional SentryOne webinars? Check our webinar library.

Watch now

Kevin Kline

Kevin Kline

Head Geek

Kline is a noted database expert and software industry veteran. At previous companies, his product designs won multiple "Best of" and "Readers' Choice" awards.

Kline was a founding board member and former president of the Professional Association for SQL Server (PASS), is an avid blogger and database columnist, author of the best-selling book, SQL in a Nutshell, and co-author of SQL Server 2012 Management and Administration, Professional SQL Server 2008 Database Design and Optimization, and Database Benchmarking: Practical Methods for Oracle & SQL Server. He is a frequent webinar host and speaker at various industry conferences and user groups and has traveled the world as part of his multi-continent roadshows.

A Microsoft SQL Server MVP since 2003, Kline is passionate about improving the quality of life for Microsoft database professionals and their customers. As a SolarWinds Head Geek, he focuses on helping customers with troubleshooting and adopting best practices for optimal database performance monitoring, on-premises and in the cloud.

Companies with the highest demands for database performance choose SentryOne