Microsoft SQL Server 2022 Essential Training

Course details

This course with database expert Adam Wilbert introduces you to creating relational databases with SQL Server and the graphical interface, SQL Server Management Studio. Adam walks you through your first steps in the newest edition of Microsoft's database management system. He takes a detailed look at creating efficient tables and adding rows of data, importing existing tabular data from spreadsheets, and writing queries to view and process that data. Adam also covers important database management tasks such as creating backups, securing access to sensitive information, and leveraging the capabilities of Microsoft’s Azure cloud infrastructure.

Concepts

0. Introduction

01 - Create databases with SQL Server 2022
02 - What you should know
03 - Exploring the code challenge environment

1. Getting Started

04 - Core concepts
05 - Choose a SQL Server 2022 edition
06 - Install SQL Server on your PC
07 - Install Management Studio
08 - Enable features with Configuration Manager
09 - Deploy SQL Server 2022 in the Azure cloud
10 - Work with SQL Server in Docker

2. Logging in to the Server

11 - User permissions and authentication
12 - Log in with Management Studio
13 - Enable the System Administrator account
14 - Connect to Azure and Docker servers

3. Creating Databases

15 - Create the first database
16 - Database configuration options
17 - Table structures
18 - Create a simple table
19 - Edit a table's structure
20 - Enter data into a table using the GUI
21 - Import data from CSV files
22 - Create tables from flat files
23 - Install a sample database

4. Table Design for Healthy Databases

24 - Choose appropriate data types
25 - SQL Server data type options
26 - Automatically assign record identities
27 - Primary key fields
28 - Establish a default value
29 - Check constraints
30 - Unique constraints
31 - Foreign keys
32 - Create a foreign key column
33 - Create relationships between tables

5. Structured Query Language

34 - Understand the role of T-SQL
35 - Use the T-SQL editor
36 - Create a table with T-SQL
37 - Solution - Create tables with T-SQL commands
38 - Add data to a table
39 - Solution - Add data with T-SQL commands
40 - Retrieve records with SELECT
41 - Solution - Query data in a database
42 - Filter returned results with WHERE
43 - Sort records
44 - Solution - Filter and sort data with a query
45 - Delete records from a table
46 - Update records in a table
47 - Solution - Remove and update records in a table
48 - Joining related tables
49 - Solution - Query information from related tables
50 - Remove a table from the database

6. Writing Efficient Queries

51 - Create a view of the data
52 - Data table indexes
53 - Create additional indexes on a table
54 - Aggregate functions
55 - Use built-in functions
56 - Leverage user-defined scalar functions
57 - Introduction to stored procedures
58 - Create stored procedures
59 - Parameterized stored procedures

7. Backup and Restore

60 - Create a full backup of the database
61 - Create a differential backup
62 - Restore a backup
63 - Business continuity solutions
64 - Continuously replicate data to the cloud

8. Security

65 - Create a new user account
66 - User roles and permissions
67 - Database schemas
68 - Dynamic data masking
69 - Always On data encryption

9. Monitoring and Management

70 - Explore the role of system databases
71 - Prevent excessive TempDB autogrowth
72 - Review the SQL Server error log
73 - Dynamic management views
74 - Database Console Commands (DBCC)

Conclusion

75 - Next steps