SQL103

So last time we were discussing the difference between normalized and de-normalized database design.  We also discussed our case study, the CRM company.  We decided to begin our database design by designing normalized tables to track customers and contacts with those customers. Let’s continue with that case today.  We want to build tables to store…

Read More SQL 103 – Normalized Table Design

I’m starting a new blog series to accompany the session I’m presenting at SQL Saturday #87 in Louisville! This session will cover the basics of designing a database from a developer’s point of view. During the class I’ll only have an hour, but in these blog posts I’ll be able to dig in a bit…

Read More SQL 103 – Introduction to Database Design and Architecture

When you begin designing a database, you start with the tables. You can’t very well start with views or stored procedures, right? What tables would they reference? When you begin designing tables, one of the first calls you’ll have to make is are you going to build a set of normalized tables or denormalized tables?…

Read More SQL103 – Normalized or Denormalized Design