SQL Server 2022 Administration

Introduction

• Introduction

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

• Module 1 introduction
• Learning objectives
• Understand the installation center
• Find the tools installed with the SQL Server
• Use the performance and reliability monitoring tools
• Understand SQL Server Management Studio

Lesson 2: Introducing Database Server Components

• Learning objectives
• Configure server memory
• Setup database files
• Configure network settings
• Setup SQL Server security

Lesson 3: Provisioning SQL Server SQL Databases

• Module 2 introduction
• Learning objectives
• Install a new instance
• Make post-installation server configuration changes
• Install and configure database features
• Create SQL Server databases

Lesson 4: Provisioning Azure SQL Database

• Learning objectives
• Understand Microsoft Azure and database-as-a-service concepts
• Provision a logical SQL Server
• Provision a database
• Setup security in Azure SQL databases

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

• Module 3 introduction
• Learning objectives
• Understand logins and users
• Setup permissions in SQL Server
• Migrate SQL Server logins and permissions

Lesson 6: Securing the Server and Data

• Learning objectives
• Handle encryption in SQL Server
• Setup row level security
• Understand data masking
• Configure SQL Server audits

Lesson 7: Understanding and Designing SQL Server Tables

• Module 4 introduction
• Learning objectives
• Review table design
• Understand special table types
• Create views
• Use change tracking
• Understand change data capture

Lesson 8: Performance Tuning and Optimizing SQL

• Learning objectives
• Understand isolation levels
• Use execution plans
• Configure clustered indexes
• Configure non-clustered indexes
• Use index statistics

Lesson 9: Developing, Deploying, and Managing Data Recovery

• Module 5 introduction
• Learning objectives
• Understand data recovery fundamentals
• Understand backup devices
• Understand different types of backups
• Create and verify backups
• Restore a database
• Define a backup and recovery strategy

Lesson 10: Implementing SQL Server High Availability and Disaster Recovery

• Learning objectives
• Review high availability and disaster recovery technologies
• Setup SQL Server Log shipping
• Replication for high availability
• Read secondary database copies

Lesson 11: Managing and Monitoring SQL Server Databases

• Module 6 Introduction
• Learning objectives
• Schedule and monitor database backups
• Deal with database corruption
• Setup index maintenance
• Cleanup history
• Shrink databases
• Monitor database activity
• Use performance monitor
• Monitor database logs
• Use resource governor

Lesson 12: Automating SQL Server Administration

• Learning objectives
• Understand the components of SQL Server automated administration
• Setup database maintenance plans
• Use PowerShell to automate SQL Server administration

Summary

• Summary