I give series of classes and presentations on Data Design. I say “data” design instead of “database” design because we should consider more than just the database. Data might actually be stored in non-relational stores, such as Excel or XML files, and it might also be located in remote data stores like “cloud” technologies.

 

Here are the links I use in that presentation. Although this isn't a comprehensive list of Data Design topics, I’ll visit this topic from time to time so you may want to bookmark this page in your favorites:

 

Evidence and Comments:

http://tinyurl.com/ygvbadc

http://tinyurl.com/ydeh9ut

http://tinyurl.com/ycu9apq

http://tinyurl.com/ya7a9xc

http://tinyurl.com/ydlumyp

 

Importance:

Yes, it matters: http://tinyurl.com/yb5ucvn

Classic software development mistakes: http://tinyurl.com/y9x9vn8

Necessity of Good Design: http://tinyurl.com/yac3um3

Importance of Database Design Ranked high for BA/Dev interaction: http://tinyurl.com/yex4sjf

 

Structured Methods:

Test-Driven Development: http://tinyurl.com/maus78

From the BA’s Perspective: http://tinyurl.com/yea6pbe

Data-Map Examples: http://tinyurl.com/2d2nhr

Universal Patterns for Data Modelling: http://tinyurl.com/ybj7tb3

 

Tools:

EF Framework Design Example: http://tinyurl.com/yeuda49

Using EF and LINQ can cause divisions: http://tinyurl.com/yaljmhn