Course Overview
This course will introduce students to SQL Server Core 2016, as well as teach them about
SSMS, data tools, installation, server configuration, using Management Studio, and
writing and executing queries.
Chapter 01 – Getting Started 1h 5m
Topic A: Introducing SQL Core 2016 – Part 1
Introducing SQL Core 2016 – Part 2
Introducing SQL Core 2016 – Part 3
Topic B: Using SSMS – Part 1
Using SSMS – Part 2
Using SSMS – Part 3
Topic C: Installing and Exploring the Sample Database – Part 1
Installing and Exploring the Sample Database – Part 2
Installing and Exploring the Sample Database – Part 3
Chapter 02 – SSMS and Data Tools 1h 22m
Topic A: Database Objects – Part 1
Database Objects – Part 2
Database Objects – Part 3
Topic B: SSMS Features and Help – Part 1
SSMS Features and Help – Part 2
SSMS Features and Help – Part 3
Topic C: SQL Server Data Tools – Part 1
SQL Server Data Tools – Part 2
SQL Server Data Tools – Part 3
Topic D: Working with Tables – Part 1
Working with Tables – Part 2
Working with Tables – Part 3
Topic E: Creating a View – Part 1
Creating a View – Part 2
Creating a View – Part 3
Chapter 03 – Installation 1h 25m
Topic A: Preparing to Install – Part 1
Preparing to Install – Part 2
Preparing to Install – Part 3
Topic B: Upgrading – Part 1
Upgrading – Part 2
Upgrading – Part 3
Topic C: Installation – Part 1
Installation – Part 2
Installation – Part 3
Topic D: Customizing Installation – Part 1
Customizing Installation – Part 2
Customizing Installation – Part 3
Topic E: Performing Installation – Part 1
Performing Installation – Part 2
Performing Installation – Part 3
Chapter 04 – Server Configuration 52m
Topic A: Install SSMS and SSDT – Part 1
Install SSMS and SSDT – Part 2
Install SSMS and SSDT – Part 3
Topic B: Configure the Server – Part 1
Configure the Server – Part 2
Configure the Server – Part 3
Topic C: More Server Config – Part 1
More Server Config – Part 2
More Server Config – Part 3
Chapter 05 – Using Management Studio 1h 18m
Topic A: SQL Server Management Studio – Part 1
SQL Server Management Studio – Part 2
SQL Server Management Studio – Part 3
Topic B: SSMS Options – Part 1
SSMS Options – Part 2
SSMS Options – Part 3
Topic C: Configure SSMS Windows – Part 1
Configure SSMS Windows – Part 2
Configure SSMS Windows – Part 3
Topic D: Object Explorer – Part 1
Object Explorer – Part 2
Object Explorer – Part 3
Topic E: Edit Objects in Designer – Part 1
Edit Objects in Designer – Part 2
Edit Objects in Designer – Part 3
Chapter 06 – Writing and Executing Queries 1h 10m
Topic A: Working with the Query Editor – Part 1
Working with the Query Editor – Part 2
Working with the Query Editor – Part 3
Topic B: Scripting with Management Studio – Part 1
Scripting with Management Studio – Part 2
Scripting with Management Studio – Part 3
Topic C: Debugging TSQL Code – Part 1
Debugging TSQL Code – Part 2
Debugging TSQL Code – Part 3
Topic D: Executing Queries – Part 1
Executing Queries – Part 2
Executing Queries – Part 3
Total Duration: 7h 12m