Kurs Süresi
· Instructor-led training: 5 days in the classroom with hands-on lab practice
· Virtual instructor-led training: 5 days of web-based classes with hands-on lab practice
· E-learning: Equivalent of 5 days of content with videos, practice, and challenges
Ders İçeriği
1. Introduction to SQL Server 2014 Database Administration
- Database Administration Overview
- Introduction to the SQL Server Platform
- Database Management Tools and Techniques
2. Installing and Configuring SQL Server 2014
- Plan SQL Server Installation
- Install SQL Server 2014 and Post-Installation Configuration
3. Work with Databases and Storage
- Introduction to Data Storage with SQL Server
- Manage Storage for System Databases and User Databases
- Move Database Files
- Configure the Buffer Pool Extension
4. Plan and Implement a Backup Strategy
- SQL Server Recovery Models
- Plan a Backup Strategy
- Backup Databases and Transaction Logs
- Backup Options and Backup Reliability
5. Restore SQL Server 2014 Databases
- Restore Process and Databases Restoration
- Advanced Restore Scenarios
- Point-in-Tim Recovery
6. Import and Export Data
- Transferring Data
- Import and Export Table Data
- Copy or Move a Database
7. Monitor SQL Server 2014
- Introduction to Monitoring SQL Server
- Dynamic Management Views and Functions
- Performance Monitor
8. Tracing SQL Server Activity
- Trace SQL Server Workload Activity and Use Traces
9. Manage SQL Server Security
- Introduction to SQL Server Security
- Manage Server-Level Security and Database-Level Principals
- Manage Database Permissions
10. Audit Data Access and Encrypt Data
- Audit Data Access in SQL Server
- Implement SQL Server Audit
- Encrypt Databases
11. Perform Ongoing Database Maintenance
- Ensure Database Integrity
- Maintain Indexes
- Automate Routine Database Maintenance
12. Automate SQL Server 2014 Management
- Implement and Manage SQL Server Agent Jobs
- Manage Job Step Security Contexts
- Manage Job on Multiple Servers
13. Monitor SQL Server 2014 Using Alerts and Notifications
- Monitor SQL Server Errors
- Configure Database Mail
- Configure Operators, Alerts, and Notifications
