Главная
Study mode:
on
1
Intro
2
PASS SUMMIT 2015
3
What is Good Design?
4
Example: Types of Tables
5
Data Types
6
Naming Objects
7
The ERD: Entity Relationship Diagram
8
NULL vs. NOT NULL
9
Constraints
10
Tips & Reminders
11
Example: Normalization
12
Database Design: Conclusion
Description:
Discover essential database design principles in this 59-minute conference talk from PASS Data Community Summit. Learn to anticipate future organizational needs and make smart decisions to avoid common pitfalls. Explore topics such as choosing appropriate data types, normalization, and effective column naming to facilitate easier database development and future modifications. Through live demonstrations, examine potential disasters caused by poor design choices and learn how to correct them. Gain insights into creating entity relationship diagrams, understanding NULL vs. NOT NULL, implementing constraints, and mastering normalization techniques. Equip yourself with the knowledge to create beautiful database designs that positively impact your entire team and enhance the quality of your TSQL code.

Database Design - Solving Problems Before They Start

PASS Data Community Summit
Add to list
0:00 / 0:00