Esquema Detallado del Curso
Module 1: Introduction to SQL Server 2014 Database Administration
- Database Administration Overview
- Introduction to the SQL Server Platform
- Database Management Tools and Techniques
Module 2: Installing and Configuring SQL Server 2014
- Planning SQL Server Installation
- Installing SQL Server 2014
- Post-Installation Configuration
Module 3: Working with Databases and Storage
- Introduction to Data Storage with SQL Server
- Managing Storage for System Databases
- Managing Storage for User Databases
- Moving Database Files
- Configuring the Buffer Pool Extension
Module 4: Planning and Implementing a Backup Strategy
- Understanding SQL Server Recovery Models
- Planning a Backup Strategy
- Backing up Databases and Transaction Logs
- Using Backup Options
- Ensuring Backup Reliability
Module 5: Restoring SQL Server 2014 Databases
- Understanding the Restore Process
- Restoring Databases
- Advanced Restore Scenarios
- Working with Point-in-Time Recovery
Module 6: Importing and Exporting Data
- Introduction to Transferring Data
- Importing and Exporting Table Data
- Copying or Moving a Database
Module 7: Monitoring SQL Server 2014
- Introduction to Monitoring SQL Server
- Dynamic Management Views and Functions
- Performance Monitor
Module 8: Tracing SQL Server Activity
- Tracing SQL Server Workload Activity
- Using Traces
Module 9: Managing SQL Server Security
- Introduction to SQL Server Security
- Managing Server-Level Security
- Managing Database-Level Principals
- Managing Database Permissions
Module 10: Auditing Data Access and Encrypting Data
- Auditing Data Access in SQL Server
- Implementing SQL Server Audit
- Encrypting Databases
Module 11: Performing Ongoing Database Maintenance
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
Module 12: Automating SQL Server 2014 Management
- Automating SQL Server Management
- Implementing SQL Server Agent Jobs
- Managing SQL Server Agent Jobs
- Managing Job Step Security Contexts
- Managing Jobs on Multiple Servers
Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications
- Monitoring SQL Server Errors
- Configuring Database Mail
- Configuring Operators, Alerts, and Notifications
Labs
- Using SQL Server Administrative Tools
- Installing SQL Server 2014
- Managing Database Storage
- Backing Up SQL Server Databases
- Restoring SQL Server Databases
- Importing and Exporting Data
- Monitoring SQL Server 2014
- Tracing SQL Server Workload Activity
- Managing SQL Server Security
- Auditing Data Access and Encrypting Data
- Performing Ongoing Database Maintenance
- Automating SQL Server Management
- Monitoring SQL Server by Using Alerts and Notifications