KnoxSQL: Louis Davidson - Database Design Fundamentals
Friday, May 10, 2013 from 11:30 AM to 1:00 PM (EDT)
*11:30 AM - Food(Provided by Premier Staffing Partners)/Networking*
*12:00 PM till about 1:00 PM - Speaker*
Database Design Fundamentals
In this session I will give an 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. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently).
Louis has been in the IT industry for 17 years as a corporate database developer and architect. He has been a Microsoft MVP for 9 years and has written 4 books on database design. Currently serves as the Data Architect for the Christian Broadcasting Network supporting offices in Virginia Beach, Virginia and Nashville, Tennessee. For more information please visit his website at drsql.org