Microsoft SQL Server DB Admin Online Training Course

Course Content

1. Introduction to Microsoft SQL Server

   • Overview of SQL Server Architecture

   • SQL Server Editions and Options

   • SQL Server Objects

   • SQL Server Tools and Utilities

2. SQL Server Administration

   • SQL Server Installation and Configuration

   • SQL Server Backup and Recovery

   • SQL Server Performance Tuning

   • SQL Server Security and Auditing

3. SQL Server Development

   • SQL Server Transact-SQL (T-SQL)

   • SQL Server Data Types and Operators

   • SQL Server Functions and Procedures

   • SQL Server Triggers and Views

4. Advanced SQL Server Features

   • SQL Server Integration Services (SSIS)

   • SQL Server Reporting Services (SSRS)

   • SQL Server Analysis Services (SSAS)

   • SQL Server Always On Availability Groups

5. SQL Server Tuning and Troubleshooting

   • SQL Server Performance Tuning

   • SQL Server Monitoring and Diagnostics

   • SQL Server Troubleshooting and Tuning Techniques

6. SQL Server Security and Auditing

   • SQL Server Security

   • SQL Server Auditing

   • SQL Server Encryption and Advanced Security Features

7. SQL Server Backup and Recovery

   • SQL Server Backup and Recovery Concepts

   • SQL Server Backup and Recovery Tools and Techniques

   • SQL Server Disaster Recovery