Introduction

What you should know

Download the Study Guide

What is a SQL Server

SQL Server Installations

SQL Server Instances

Structured Query Language

Interfacing With SQL Server

Choose a SQL Server 2022 edition

Install SQL Server on your PC

Install Management Studio

Enable features with Configuration Manager

Work with SQL Server in Docker

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

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