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
Description
This course has been designed to give the Knowlege 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)
- Using database console commands (DBCC)
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
