SQL Server 2022 Database Administration Essential Training

This course has been designed to give you the knowledge and skills to become an expert SQL Server Database Administrator.

If you want to become a SQL database administrator, then this is the course for you.

Here is the course outline:

Section 1 – Introduction

• Introduction

• What is SQL Server

Section 2 – Setting Up Your Environment

• SQL Server Editions

• Installing SQL Server 2022

• Install Management Studio

• SQL Server Configuration Manager

• Working With SQL Server in Docker

Section 3 – Database Creation & Configuration

• SQL Server System Databases

• Database Storage Strategies

• Capacity and growth considerations

• Configuring Model Database

• Creating a Database

• SQL Server contained database

Section 4 – Securing Your SQL Server

• Managing Users & Login

• Managing Contained Users

• Implementing Instance-Level Security

• Implementing Database-Level Security

• SQL Server Audit Specifications

• Configuring Server and Database Audit

• Data Discovery & Classification

• SQL Vulnerability Assessment

Section 5: Backup & Restore

• Introduction to Backup and Restore

• Understanding Recovery Models

• How to Perform Full Backups

• How to Perform a Differential Backup

• Transaction log backups

• Performing Recovery

• Backup Strategies

Section 6: Automating Maintenance Routines

• What is SQL Server Job Agent

• Automating Processes with SQL Server Agent

• Configuring and Sending Database Mail

• Automating database backups

Section 7: Performance & Monitoring

• Reviewing server logs

• Exposing Dynamic Management Views (DMVs)

• Database Console Commands for SQL Server

• SQL Server Activity Monitor

• Indexes for performance tuning

• Introduction to the SQL Server Query Store

Section 7: Migrate & Import Data

• Introduction

• Migrating Databases to Amazon Web Services (AWS)

• Detaching and Attaching Databases to an Instance

• Migrating to Azure and Docker using bacpac archive

• Importing and exporting data

Who this course is for:

• Anyone who wants to start a career in SQL database administration.

• Anyone who wants to have complete SQL database training to get a job in IT

• Anyone who wants to advance his/her career

• College students looking to pursue database administration.

• IT Infrastructure Professionals