Microsoft SQL Server Database Administrator course, normally in the IT sector we called as SQL DBA (MS SQL DBA).
My course will cover all the below topics/modules. (Course is not completed, in progress. )
Module 1: Introduction to Database Administration
· Database Administration Roles and Responsibilities.
· Introduction to the SQL Server Platform
· Database Management Tools and Techniques
Module 2: Installing and Configuring SQL Server 2017 and 2019
· Installation of SQL Server 2019 using GUI
· Installation of SQL Server 2017 using Configuration file- kind of automation.
· Post-Installation Configuration
Module 3: Databases and Storage
· Introduction to Data Storage with SQL Server
· Managing Storage for System Databases
· Managing Storage for User Databases
· Moving Database Files
· Configuring the Buffer Pool Extension
Module 4: Backup
· SQL Server Recovery Models
· Planning a Backup Strategy
· Backing up Databases and Transaction Logs
Module 5: Restoring
· Restore Process
· Restoring Databases
· Advanced Restore Scenarios
· Working with Point-in-Time Recovery
Module 6: Importing and Exporting Data
· Introduction to Transferring Data
· Importing and Exporting Table Data
· Copying or Moving a Database
Module 7: Trace flags
· Tracing SQL Server Workload Activity
· Using Traces
Module 8: SQL Server Security
· Introduction to SQL Server Security
· Managing Server-Level Security
· Managing Database-Level Principals
· Managing Database Permissions
Module 9: Database Maintenance
· Ensuring Database Integrity
· Maintaining Indexes
· Automating Routine Database Maintenance
Module 10: Monitoring SQL
· Monitoring SQL Server Errors
· Configuring Database Mail
· Configuring Operators, Alerts, and Notifications
Module 11: SQL Server high availability and disaster recovery
Lessons:
· Log shipping
· Replication
· SQL Cluster
· AlwaysOn availability Group
Module 12: Azure SQL Database
Module 13: Interview