SQL Server 2022 Administration

Course details

Looking to get up to speed with the latest features of SQL Server 2022? In this course, join database analyst and trainer Eric Johnson as he covers the fundamental skills, techniques, and tools required to manage SQL Server 2022 in any development environment, regardless of your current level of experience. Learn about the new features available in the latest version of SQL Server as well as how to provision and secure Azure databases, design SQL Server tables, and tune and optimize SQL to meet your own unique needs. Throughout the course, Eric explains the relevant concepts and methodologies of managing and automating SQL Server databases, showing you how to apply what you’ve learned in a series of ongoing visual demonstrations designed to help you get hands-on practice and start building more advanced skills.

Concepts

0. Introduction

01 - Introduction

Lesson 1 - Installing and Using SQL Server Administration and Development Tools

02 - Module 1 introduction
03 - Learning objectives
04 - Understand the installation center
05 - Find the tools installed with the SQL Server
06 - Use the performance and reliability monitoring tools
07 - Understand SQL Server Management Studio

Lesson 2 - Introducing Database Server Components

08 - Learning objectives
09 - Configure server memory
10 - Setup database files
11 - Configure network settings
12 - Setup SQL Server security

Lesson 3 - Provisioning SQL Server SQL Databases

13 - Module 2 introduction
14 - Learning objectives
15 - Install a new instance
16 - Make post-installation server configuration changes
17 - Install and configure database features
18 - Create SQL Server databases

Lesson 4 - Provisioning Azure SQL Database

19 - Learning objectives
20 - Understand Microsoft Azure and database-as-a-service concepts
21 - Provision a logical SQL Server
22 - Provision a database
23 - Setup security in Azure SQL databases

Lesson 5 - Implementing and Managing SQL Server User Security and Permissions

24 - Module 3 introduction
25 - Learning objectives
26 - Understand logins and users
27 - Setup permissions in SQL Server
28 - Migrate SQL Server logins and permissions

Lesson 6 - Securing the Server and Data

29 - Learning objectives
30 - Handle encryption in SQL Server
31 - Setup row level security
32 - Understand data masking
33 - Configure SQL Server audits

Lesson 7 - Understanding and Designing SQL Server Tables

34 - Module 4 introduction
35 - Learning objectives
36 - Review table design
37 - Understand special table types
38 - Create views
39 - Use change tracking
40 - Understand change data capture

Lesson 8 - Performance Tuning and Optimizing SQL

41 - Learning objectives
42 - Understand isolation levels
43 - Use execution plans
44 - Configure clustered indexes
45 - Configure non-clustered indexes
46 - Use index statistics

Lesson 9 - Developing, Deploying, and Managing Data Recovery

47 - Module 5 introduction
48 - Learning objectives
49 - Understand data recovery fundamentals
50 - Understand backup devices
51 - Understand different types of backups
52 - Create and verify backups
53 - Restore a database
54 - Define a backup and recovery strategy

Lesson 10 - Implementing SQL Server High Availability and Disaster Recovery

55 - Learning objectives
56 - Review high availability and disaster recovery technologies
57 - Setup SQL Server Log shipping
58 - Replication for high availability
59 - Read secondary database copies

Lesson 11 - Managing and Monitoring SQL Server Databases

60 - Module 6 Introduction
61 - Learning objectives
62 - Schedule and monitor database backups
63 - Deal with database corruption
64 - Setup index maintenance
65 - Cleanup history
66 - Shrink databases
67 - Monitor database activity
68 - Use performance monitor
69 - Monitor database logs
70 - Use resource governor

Lesson 12 - Automating SQL Server Administration

71 - Learning objectives
72 - Understand the components of SQL Server automated administration
73 - Setup database maintenance plans
74 - Use PowerShell to automate SQL Server administration

Summary

75 - Summary