Database Design Fundamentals

Presenter: Louis Davidson, Christian Broadcasting Network

Session 23 (10:00 GMT on May 20)

Session Details

Data should be easy to work with in SQL Server if the database has been designed as close as possible to the proven standards of normalization. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured (e.g., not being able to use an index efficiently because you used the SUBSTRING function in a WHERE clause). You can avoid such problems by applying the basic normalization techniques covered in this session, which provides a practical overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases.

About the Speaker

Louis Davidson has been in the IT industry for 16 years as a corporate database developer and architect. A SQL Server MVP for 5 years, he has written four books on database design. Louis is currently the data architect and part-time DBA for the Christian Broadcasting Network, supporting offices in Virginia Beach, Virginia, and Nashville, Tennessee. He holds a bachelor's degree from the University of Tennessee at Chattanooga in computer science with a minor in mathematics. For more information, visit drsql.org.

Register now for 24 Hours of PASS!