Maintaining a MSFT SQL Server 2008 Database (LX)

PROGRAMA

Installing and Configuring SQL Server
•Lesson 1: Preparing to Install SQL Server
•Lesson 2: Installing SQL Server
•Lesson 3: Configuring a SQL Server Installation

Managing Databases and Files
•Lesson 1: Planning Databases
•Lesson 2: Creating Databases
•Lesson 3: Using Policy-Based Management

Disaster Recovery
•Lesson 1: Planning a Backup Strategy
•Lesson 2: Backing Up User Databases
•Lesson 3: Restoring User Databases
•Lesson 4: Performing Online Restore Operations
•Lesson 5: Recovering Data from Database Snapshots
•Lesson 6: System Databases and Disaster Recovery

Managing Security
•Lesson 1: Overview of SQL Server Security
•Lesson 2: Protecting the Server Scope
•Lesson 3: Protecting the Database Scope
•Lesson 4: Protecting the Server Scope
•Lesson 5: Auditing Security

Transferring Data
•Lesson 1: Overview of Data Transfer
•Lesson 2: Introduction to SQL Server Integration Services

Automating Administrative Tasks
•Lesson 1: Automating Administrative Tasks in SQL Server
•Lesson 2: Using SQL Server Agent
•Lesson 3: Creating Maintenance Plans
•Lesson 4: Implementing Alerts
•Lesson 5: Managing Multiple Servers
•Lesson 6: Managing SQL Server Agent security

Implementing Replication  
•Lesson 1: Overview of Replication
•Lesson 2: Managing Publications and Subscriptions
•Lesson 3: Configuring Replication in Some Common Scenarios

Maintaining High Availability
•Lesson 1: Introduction to High Availability
•Lesson 2: Implementing Log Shipping
•Lesson 3: Implementing Database Mirroring
•Lesson 4: Implementing Server Clustering
•Lesson 5: Using Distributed High Availability Solutions

Monitoring SQL Server
•Lesson 1: Viewing Current Activity
•Lesson 2: Using SQL Server Profiler
•Lesson 3: Monitoring with DDL Triggers
•Lesson 4: Using Event Notifications

Troubleshooting and Performance Tuning
•Lesson 1: Troubleshooting SQL Server
•Lesson 2: Performance Tuning in SQL Server
•Lesson 3: Using Resource Governor
•Lesson 4: Using Data Collector