Module 1: Introduction to databases
This module introduces key database concepts in the context of SQL Server 2016.
Lessons
- Introduction to relational databases
- Other types of database
- Data analysis
- Database languages in SQL Server
Lab : Exploring and querying SQL Server databases
Module 2: Data Modelling
This module describes data modelling techniques.
Lessons
- Data modelling
- ANSI/SPARC database model
- Entity relationship modelling
Lab : Identify components in entity relationship modelling
Module 3: Normalization
This module describes normalization and denormalization techniques.
Lessons
- Fundamentals of Normalization
- Normal form
- Denormalization
Lab : Normalizing data
Module 4: Relationships
This module describes relationship types and effects in database design.
Lessons
- Introduction to relationships
- Planning referential integrity
Lab : Planning and implementing referential integrity
Module 5: Performance
This module introduces the effects of database design on performance.
Lessons
- Indexing
- Query performance
- Concurrency
Lab : Performance issues
Module 6: Database Objects
This module introduces commonly used database objects.
Lessons
- Tables
- Views
- Stored procedures, triggers and functions
Lab : Using SQL server