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-462 Administering Microsoft SQL Server Databases
Course Curriculum
| Course 20462D Administering Microsoft® SQL Server 2014 Databases | |||
| Introduction to SQL Server 2014 Database Administration | 00:00:00 | ||
| Installing and Configuring SQL Server 2014 | 00:00:00 | ||
| Working with Databases and Storage | 00:00:00 | ||
| Planning and Implementing a Backup Strategy | 00:00:00 | ||
| Restoring SQL Server 2014 Databases | 00:00:00 | ||
| Importing and Exporting Data | 00:00:00 | ||
| Monitoring SQL Server 2014 | 00:00:00 | ||
| Tracing SQL Server Activity | 00:00:00 | ||
| Managing SQL Server Security | 00:00:00 | ||
| Auditing Data Access and Encrypting Data | 00:00:00 | ||
| Performing Ongoing Database Maintenance | 00:00:00 | ||
| Automating SQL Server 2014 Management | 00:00:00 | ||
| Monitoring SQL Server 2014 by Using Alerts and Notifications | 00:00:00 | ||
