Intro to Data Modeling & Database Design for Developers Part 1


Many programmers struggle when accessing data in relational databases. Either the database doesn’t provide fast performance, doesn’t meet the needs, is filled with illogical data, or is far more complicated that the problem it was intended to solve.  But why? As it turns out, the classic standards of database design and normalization really are a “gold standard” that many struggle with, either because they don’t know what the standards are, don’t want to apply them to their designs because they seem old-fashioned, or are handed an application that has an already completed but inadequate design.

In Part 1 of this 2 part series, we provide an overview of how to design a relational database, allowing your data structures to ease your job instead of make it harder. You’ll be able to use SQL naturally so that the query engine can better optimize your SQL code without you needing to spend a lot of time thinking about it.

By attending this session, you’ll spend less time fiddling with messy SQL code, like SUBSTRING(column,3,1) = 'A', that is killing your performance, and more time solving high-value customer problems. Join us! 

Interested in additional SentryOne webinars?  Check our webinar library.

Available On Demand

Kevin Kline

Kevin Kline

Principal Program Manager, SentryOne

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at blogs.sentryone.com/author/kevinkline. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.

Louis Davidson

Louis Davidson

Data Architect, CBN

Louis has been in the IT industry for over 20 years as a corporate database developer and data architect. Currently he is the Data Architect for CBN in Virginia Beach. Louis has been a Microsoft MVP since 2004, and is an active volunteer for the PASS locally and globally. He is the author of a series of SQL Server Database Design books, most recently Pro SQL Server Relational Database Design and Implementation.

Companies with the highest demands for database performance choose SentryOne