Module 1: Installing and Configuring SQL Server
Lessons:
- Preparing to Install SQL Server
- Installing SQL Server
- Configuring a SQL Server Installation
Lab: Installing and Configuring SQL Server
- (Level 200) Installing SQL Server
- (Level 200) Configuring SQL Server
Module 2: Managing Databases and Files
Lessons:
- Planning Databases
- Creating Databases
- Using Policy-Based Management
Lab: Managing Databases and Files
- (Level 200): Creating a Database
- (Level 200): Monitoring and Managing Filegroup Usage
- (Level 200) Creating a Policy
Module 3: Disaster Recovery
Lessons:
- Planning a Backup Strategy
- Backing Up User Databases
- Restoring User Databases
- Performing Online Restore Operations
- Recovering Data from Database Snapshots
- System Databases and Disaster Recovery
Lab: Disaster Recovery
- (Level 200) Designing a Backup Strategy
- (Level 200) Implementing a Backup Strategy
- (Level 200) Restoring and Recovering a Database
- (Level 300) Performing Piecemeal Backup and Restore Operations
- (Level 200) Restoring the master Database
Module 4: Managing Security
Lessons:
- Overview of SQL Server Security
- Protecting the Server Scope
- Protecting the Database Scope
- Protecting the Server Scope
- Auditing Security
Lab: Managing Security
- (Level 200) Creating Logins and Assigning Server-Scope Permissions
- (Level 200) Creating and Managing Users
- (Level 300) Using a Certificate to Protect Data
- (Level 200) Implementing SQL Server Audit
Module 5: Transferring Data
Lessons:
- Overview of Data Transfer
- Introduction to SQL Server Integration Services
Lab: Transferring Data
- (Level 200) Using the Import/Export Wizard
- (Level 200) Performing a Bulk Load
- (Level 200) Creating an SSIS Solution
Module 6: Automating Administrative Tasks
Lessons:
- Automating Administrative Tasks in SQL Server
- Using SQL Server Agent
- Creating Maintenance Plans
- Implementing Alerts
- Managing Multiple Servers
- Managing SQL Server Agent security
Lab: Automating Administrative Tasks
- (Level 200) Configuring SQL Server Agent
- (Level 200) Creating Operators and Jobs
- (Level 200) Creating Alerts
Module 7: Implementing Replication
Lessons:
- Overview of Replication
- Managing Publications and Subscriptions
- Configuring Replication in Some Common Scenarios
Lab: Implementing Replication
- (Level 300) Implementing Snapshot Replication
- (Level 300) Implementing Peer-to-Peer Transactional Replication
- (Level 300) Implementing HTTP Merge Replication
Module 8: Maintaining High Availability
Lessons:
- Introduction to High Availability
- Implementing Log Shipping
- Implementing Database Mirroring
- Implementing Server Clustering
- Using Distributed High Availability Solutions
Lab: Maintaining High Availability
- (Level 300) Configuring Log Shipping
- (Level 300) Configuring Database Mirroring
- (Level 300) Implementing SQL Server Clustering
Module 9: Monitoring SQL Server
Lessons:
- Viewing Current Activity
- Using SQL Server Profiler
- Monitoring with DDL Triggers
- Using Event Notifications
Lab: Monitoring SQL Server
- (Level 200) Monitoring SQL Server Activity
- (Level 300) Tracing SQL Server Activity
- (Level 200) Using DDL Triggers
- (Level 200) Using Event Notifications
Module 10: Troubleshooting and Performance Tuning
Lessons:
- Lesson 1: Troubleshooting SQL Server
- Lesson 2: Performance Tuning in SQL Server
- Lesson 3: Using Resource Governor
- Lesson 4: Using Data Collector
Lab: Troubleshooting and Performance Tuning
- (Level 300) Troubleshooting Connectivity Problems
- (Level 300) Troubleshooting Concurrency Problems
- (Level 300) Using the Database Engine Tuning Advisor
- (Level 300) Implementing Resource Governor
- (Level 300) Implementing Data Collector
|
Printable version
