What you’ll learn
- Learn Best Practices for Relational Database Design
- Understand Relational Theory
- Learn the data normalization process
- Understand the First, Second, Third and Fourth Normal Forms
- Understand Boyce-Codd normal form
- Identify relationship types between entities
- How to enforce database relationships including one-to-one, one-to-many, and many-to-many
- Learn functional dependencies
- Learn multivalued dependencies
- Learn what Update, Insert and Delete anomalies are
- Surrogate keys vs Natural keys
- Learn the difference Candidate keys and Super Keys
- Learn how to implement physical design using SQL Server
- Create database tables and alter existing tables
- Create SQL Queries and Views
-
Introduction
-
Database Basics
-
Introduction to SQL Server
-
Data Constraints and Integrity
-
Relationships
-
Data Normalization
- Introduction to Normalization
- Insert, Update and Delete Anomalies
- Introduction to the Normal Forms
- Functional Dependencies
- Trivial Functional Dependencies
- Functional Dependencies Exercise
- Candidate Keys
- Candidate keys vs Super Keys
- Key and Non-key Attributes
- First Normal Form
- Second Normal Form
- Second Normal Form (demo)
- Transitive Dependencies
- Third Normal Form
- Boyce-Codd Normal Form
- ourth Normal Form and Multivalued Dependencies
-
Indexing
0.0
0 total
5
4
3
2
1
