Practical Data Modeling With C# and SQL Server
By Jason Sauer
A good data model can be the difference between a successful, manageable application and one that breaks with every change request.
Course info
Level
Beginner
Updated
Jun 21, 2014
Duration
2h 34m
Table of contents
Practical Data Modeling With C# and SQL Server
Origin Story! Birth of a Data Model
Introduction
1m
Components of a Data Model
1m
Determining the Components for Your Data Model
2m
Our Data Model: Comic Book Catalog
1m
Components of Our Data Model
1m
C# Data Model
6m
SQL Server Data Model
13m
Summary
1m
Clones! Replicants! The Importance of Normalization
Introduction
1m
What is Normalization?
4m
Components of a Data Model, Revisited
3m
Our Data Model: Comic Book Catalog, I
2m
Our Data Model: Comic Book Catalog, II
6m
Zero, One or More Than One
2m
Relationships
2m
Our Data Model: Comic Book Catalog, III
6m
Summary
1m
Coding the Data Model
Erased From Existence! Maintaining Data Integrity Over Time
Introduction
1m
What's the Problem?
2m
Components of a Data Model
3m
Our Data Model: Comic Book Catalog
3m
C# Data Model
3m
SQL Server Data Model
20m
Summary
1m
Everything's Connected: Removing Unnecessary Dependencies
Introduction
1m
What's the Problem?
5m
Our Data Model: Comic Book Catalog
3m
C# Data Model
3m
SQL Server Data Model
14m
Summary
2m
Final Issue!
Description
Course info
Level
Beginner
Updated
Jun 21, 2014
Duration
2h 34m
Description
A good data model can be the difference between a successful, manageable application and one that breaks with every change request. This course will walk through the design of a practical data model that is refined through each module, using a fun example application for its inspiration.
About the author
About the author
Jason is the founder of Bam! Pow! Software Solutions, LLC. He has over 20 years experience as a business analyst, project manager and software developer. Jason has written numerous applications for the financial industry ranging from portfolio management and accounting systems to contact relationship management systems to trading systems.