SQL Admin2016

At ITBMS, we recognize that different customers have different training needs. ITBMS meets the specific customer requirements by offering tailored training courses.


A database administrator (DBA) has to focus on keeping the SQL server running and doing it fast. Configuration of the server and the software is the prime responsibility of database administrator An administrator may adopt an approach of setting the server and leaving it like that since SQL server can grow or reduce any database automatically. The role of the SQL administrator towards proper sizing and configuration of the hardware is also required to be determined

Microsoft SQL Administration 2016

Course 20764B Administering SQL Database Infrastructure

                                                                                                    Duration: 40 hours

       SQL Server Security
       Assigning Server and Database Roles
       Authorizing Users to Access Resources
       Protecting Data with Encryption and Auditing
       Recovery Models and Backup Strategies
       Backing Up SQL Server Databases
       Restoring SQL Server 2016 Databases
       Automating SQL Server Management
       Configuring Security for SQL Server Agent
       Monitoring SQL Server with Alerts and Notifications
       Introduction to Managing SQL Server by using Power Shell
       Tracing Access to SQL Server with Extended events
       Monitoring SQL Server
       Troubleshooting SQL Server
       Importing and Exporting Data

Course 20765A Provisioning SQL Databases

                                                                                                    Duration: 40 hours

       SQL Server 2016 Components
       Installing SQL Server 2016
       Upgrading SQL Server to SQL Server 2016
       Deploying SQL Server on Microsoft Azure
       Working with Databases
       Database Storage Options
       Performing Database Maintenance


       Exam 70-764 Administering SQL Database Infrastructure
       Exam 70765A Provisioning SQL Databases


Disclaimer: Course content, version and duration are subject to change without notice as a part of constant upgrade of the product by MICROSOFT TRAINING.