A database administrator (DBA) has to focus on keeping the SQL server running and doing it fast. The 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
CERTIFICATION:
Exam 70-764 Administering SQL Database Infrastructure
Exam 70765A Provisioning SQL Databases
Course Curriculum
| Course 20764B Administering SQL Database Infrastructure | |||
| SQL Server Security | 00:00:00 | ||
| Assigning Server and Database Roles | 00:00:00 | ||
| Authorizing Users to Access Resources | 00:00:00 | ||
| Protecting Data with Encryption and Auditing | 00:00:00 | ||
| Recovery Models and Backup Strategies | 00:00:00 | ||
| Backing Up SQL Server Databases | 00:00:00 | ||
| Restoring SQL Server 2016 Databases | 00:00:00 | ||
| Automating SQL Server Management | 00:00:00 | ||
| Configuring Security for SQL Server Agent | 00:00:00 | ||
| Monitoring SQL Server with Alerts and Notifications | 00:00:00 | ||
| Introduction to Managing SQL Server by using PowerShell | 00:00:00 | ||
| Tracing Access to SQL Server with Extended events | 00:00:00 | ||
| Monitoring SQL Server | 00:00:00 | ||
| Troubleshooting SQL Server | 00:00:00 | ||
| Importing&Exporting Data | 00:00:00 | ||
