Introduction

What you should know

Download the Study Guide

User permissions and authentication

Log in with Management Studio

Connect Docker SQL Server to Management Studio

Enable the System Administrator account

Create the first database

Database configuration options

Table structures

Create a simple table

Edit a table's structure

Enter data into a table using the GUI

Import data from CSV files

Create tables from flat files

Install a sample database

Choose appropriate data types

SQL Server data type options

Automatically assign record identities

Primary key fields

Establish a default value

Check constraints

Unique constraints

Foreign keys

Create a foreign key column

Create relationships between tables

Understand the role of T-SQL

Use the T-SQL editor

Create a table with T-SQL

Add data to a table

Retrieve records with SELECT

Filter returned results with WHERE

Sort records

Delete records from a table

Update records in a table

Join related tables

LEFT JOIN and RIGHT JOIN

Remove a table from the database

Create a view of the data

Data table indexes

Create additional indexes on a table

Columnstore indexes

View execution plans

SQL Server's Query Store

Rebuild indexes

Create a full backup of the database

Create a differential backup

Restore a backup

Automate backups

Business continuity solutions

User roles and permissions

Database schemas

Dynamic data masking

Always On data encryption

Explore the role of system databases

Prevent excessive tempdb autogrowth

Review the SQL Server error log

Dynamic management views

Database Console Commands (DBCC)

Next steps