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
