Module 1: Introduction to databases
This module introduces key database concepts in the context of SQL Server.
Lessons
- Introduction to Relational Databases
- Other Databases and Storage
- Data Analysis
- SQL Server Database Languages
Lab 1: Exploring SQL Server Databases and Tables
- Explore SQL Server
- Query Databases and Tables
After completing this module, students will be able to:
- Describe what a database is
- Understand basic relational aspects
- Describe database languages used in SQL Server
- Describe data analytics
Module 2: Data Modeling
This module describes data modelling techniques.
Lessons
- Data Modelling
- Designing a Database
- Relationship Modeling
Lab 1: Identify Components in Relationship Modeling
After completing this module, students will be able to:
- Understand the common data modeling techniques
- Describe the ANSI/SPARC database model
- Describe entity relationship modeling
Module 3: Normalization
This module describes normalization and denormalization techniques.
Lessons
- Fundamentals of Normalization
- Normal Form
- Denormalization
Lab 1: Normalizing Data
After completing this module, students will be able to:
- Describe normalization benefits and notation
- Describe important normalization terms
- Describe the normalization levels
- Describe the role of denormalization
Module 4: Relationships
This module describes relationship types and effects in database design.
Lessons
- Introduction to Relationships
- Planning Referential Integrity
Lab 1: Planning and Implementing Referential Integrity
- Implementing Referential Integrity
After completing this module, students will be able to:
- Describe relationship types
- Describe the use, types, and effects of referential integrity
Module 5: Performance
This module introduces the effects of database design on performance.
Lessons
- Indexing
- Query Performance
- Concurrency
Lab 1: Performance Issues
After completing this module, students will be able to:
- Discuss the performance effects of indexing
- Describe the performance effects of join and search types
- Describe the performance effects of concurrency
Module 6: Database Objects
This module introduces commonly used database objects.
Lessons
- Tables
- Views
- Stored Procedures, Triggers and Functions
Lab 1: Using SQL Server Objects
- Using Tables
- Using Views
- Using Stored Procedures
After completing this module, students will be able to:
- Describe the use of tables in SQL Server
- Describe the use of views in SQL Server
- Describe the use of stored procedures in SQL Server
- Describe other database objects commonly used in SQL Server
