Microsoft SQL Administration 2016 free videos and free material uploaded by ITBMS staff .
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 PowerShell
Tracing Access to SQL Server with Extended events
Monitoring SQL Server
Troubleshooting SQL Server
Importing&Exporting Data
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
- 0 Reviews
- 0 Students
- 35 Courses
Write a public review