Introduction to SQL Databases Training 10985C Course Outline
Module 1: Introduction to Databases
- Introduction to Relational Databases
- Retrieve Data from a Relational Database by using SQL
Lab 1: Use the SELECT Statement to Retrieve Data from a Database
- Use the SELECT Statement to Retrieve Data from a Database
Module 2: Database Tables
- Identify and use Microsoft SQL Server Data Types
- Create Tables with SQL
- Altering and Dropping a Table
- Collect Information from Multiple Tables by using Joins and Views
Lab 1: Create and Alter a Table in Microsoft SQL Server
- Create and Alter a Table in Microsoft SQL Server
- Create and Retrieve a View that Uses the JOIN Statement in Microsoft SQL Server
Lab 2: Create and Alter a Table in Microsoft SQL Server
- Create and Alter a Table in Microsoft SQL Server
Lab 3: Create and Retrieve a View that Uses the JOIN Statement in Microsoft SQL Server
- Create and Retrieve a View that Uses the JOIN Statement in Microsoft SQL Server
Module 3: Add and Update Data
- Insert, Update, and Delete Information
Lab 1: Add and Change Data in SQL Server
- Add and Change Data in SQL Server
Lab 2: Create and use Stored Procedures in Microsoft SQL Server
- Create and use Stored Procedures in Microsoft SQL Server
Module 4: Entity Relationships
- Model Entity Relationships
- Design for Referential Integrity What is Referential Integrity?
Lab 1: Create an Entity Relationship Diagram in Microsoft SQL Server Management Studio
- Create an Entity Relationship Diagram in Microsoft SQL Server Management Studio
Module 5: Normalisation and Denormalisation
- Normalisation
- Denormalisation
Lab 1: Denormalise a Table by Adding a Redundant Column of Computed Data
- Denormalise a Table by Adding a Redundant Column of Computed Data
Module 6: Query Performance and Safety
- Indexes
- Write Performant SQL Code
- Concurrency
Lab 1: Create Indexes and Consult Execution Plans in Microsoft SQL Server Management Studio
- Create Indexes and Consult Execution Plans in Microsoft SQL Server Management Studio