What You'll Learn

• Install and configure SQL Server 2008
• Manage database files
• Back up and restore databases
• Manage security
• Transfer data into and out of SQL Server
• Automate administrative tasks
• Replicate data between SQL Server instances
• Maintain high availability
• Monitor SQL Server

Course Outline

1. Installing and Configuring SQL Server

• Preparing to Install SQL Server
• Installing SQL Server
• Configuring a SQL Server Installation

2. Managing Databases and Files

• Planning Databases
• Creating Databases
• Using Policy-Based Management

3. Disaster Recovery

• Planning a Database Backup Strategy
• Backing Up a User Database
• Restoring User Databases
• Performing Online Restore Operations
• Recovering Data from Database Snapshots
• System Databases and Disaster Recovery

4. Managing Security

• Overview of SQL Server Security
• Protecting the Server Scope
• Protecting the Database Scope
• Managing Keys and Certificates
• Auditing Security

5. Transferring Data

• Overview of Data Transfer
• Introduction to SQL Server Integration Services

6. Automating Administrative Tasks

• Automating Administrative Tasks in SQL Server
• Using SQL Server Agent
• Creating Maintenance Plans
• Implementing Alerts
• Managing Multiple Servers
• Managing SQL Server Agent Security

7. Implementing Replication

• Overview of Replication
• Managing Publications and Subscriptions
• Configuring Replication in Some Common Scenarios

8. Maintaining High Availability

• Introduction to High Availability
• Implementing Log Shipping
• Implementing Database Mirroring
• Implementing Server Clustering
• Using Distributed High Availability Solutions

9. Monitoring SQL Server

• Viewing Current Activity
• Using SQL Server Profiler
• Monitoring with DDL Triggers
• Using Event Notifications

10. Troubleshooting and Performance Tuning

• Troubleshooting SQL Server
• Performance Tuning in SQL Server
• Using Resource Governor
• Using Data Collector

Labs

Lab 1: Installing and Configuring SQL Server

• Installing SQL Server
• Configuring SQL Server

Lab 2: Managing Databases and Files

• Creating a Database
• Monitoring and Managing Filegroup Usage
• Creating a Policy

Lab 3: Disaster Recovery

• Implementing a Backup Strategy
• Restoring and Recovering a Database
• Performing Piecemeal Backup and Restore Operations
• Restoring the Master Database

Lab 4: Managing Security

• Creating Logins and Assigning Server-Scope Permissions
• Creating Database Users and Assigning Database-Scope and Schema-Scope Permissions
• Encrypting Data Using Certificates and Keys
• Implementing SQL Server Audit

Lab 5: Transferring Data

• Using the Import/Export Wizard
• Performing a Bulk Load
• Creating an SSIS Solution

Lab 6: Automating Administrative Tasks

• Configuring SQL Server Agent
• Creating Operators and Jobs
• Creating Alerts

Lab 7: Implementing Replication

• Implementing Snapshot Replication
• Implementing Peer-to-Peer Transactional Replication
• Implementing HTTP Merge Replication

Lab 8: Maintaining High Availability

• Configuring Log Shipping
• Configuring Database Mirroring

Lab 9: Monitoring SQL Server

• Monitoring SQL Server Activity
• Tracing SQL Server Activity
• Using DDL Triggers
• Using Event Notifications

Lab 10: Troubleshooting and Performance Tuning

• Troubleshooting Connectivity Problems
• Troubleshooting Concurrency Problems
• Using the Database Engine Tuning Advisor
• Implementing Resource Governor
• Implementing Data Collector

Classroom Dates and Locations

Date	Location
Sep 13 - 17, 2010	St. John's, NL	Register
Sep 13 - 17, 2010	Victoria, BC	Register
Sep 13 - 17, 2010	Toronto, ON	Register
Sep 20 - 24, 2010	Vancouver, BC	Register
Sep 27 - Oct 1, 2010	Halifax, NS	Register
Oct 4 - 8, 2010	Calgary, AB	Register
Oct 4 - 8, 2010	Edmonton, AB	Register
Nov 1 - 5, 2010	Winnipeg, MB	Register
Nov 1 - 5, 2010	Mississauga, ON	Register
Nov 1 - 5, 2010	Kitchener, ON	Register
Jan 24 - 28, 2011	Toronto, ON	Register
Jan 24 - 28, 2011	Ottawa, ON	Register
Jan 24 - 28, 2011	Montreal, QC	Register
Jan 24 - 28, 2011	Halifax, NS	Register
Feb 7 - 11, 2011	Edmonton, AB	Register
Feb 7 - 11, 2011	Calgary, AB	Register
Feb 7 - 11, 2011	Victoria, BC	Register
Feb 7 - 11, 2011	Vancouver, BC	Register
Mar 7 - 11, 2011	Winnipeg, MB	Register
Mar 7 - 11, 2011	Mississauga, ON	Register
Mar 7 - 11, 2011	Kitchener, ON	Register
May 9 - 13, 2011	Halifax, NS	Register
May 9 - 13, 2011	Toronto, ON	Register
May 9 - 13, 2011	Ottawa, ON	Register
May 9 - 13, 2011	Montreal, QC	Register

Don’t see the location or date you need? No problem – just use our By Request service.