SQL Server 2022 Database Administration Essential Training
Learn how to install, configure, and manage SQL Server on a server or in a Docker container. This comprehensive course covers topics such as security, backups, automation, troubleshooting, and migration to cloud platforms. Perfect for anyone looking to become an expert SQL Server Database Administrator. Ideal for developers, database administrators, IT professionals, and computer science graduates. Start your career in SQL database administration with this course.
What you’ll learn
- How to install and configure SQL Server on a server as well in a docker container
- How to manage instance level and database level security.
- How to perform backups and restores
- How to perform point-in-time restores
- How to automate repetitive task with SQL Server Agent
- How to perform vulnerability assessment
- Troubleshooting and monitoring using logs and DMVs
- How to migrate databases to cloud platforms
This course has been designed to give you the knowledge and skill to become an expert SQL Server Database Administrator.
If you want to become 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 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 Moniter
Indexes for performance tuning
Introduction to 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 & 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
Who this course is for:
- Developer
- Database Administrator
- I.T and Computer Science graduates
- Aspiring Database Administrators
