New Horizons Computer Learning Center
410-597-9722

6231A: Maintaining a Microsoft SQL Server 2008 Database

Course Length: 5 Days

Overview:
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

Prerequisites:
Basic knowledge of the Microsoft Windows operating system and its core functionality
Working knowledge of Transact-SQL
Working knowledge of relational databases
Some experience with database design

Course Objectives:
Upon successful completion of this course, students will be able to:

• Install and configure SQL Server 2008
• Manage database files
• Backup 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 Content

Lesson 1: Installing and Configuring SQL Server

• Preparing to Install SQL Server
• Installing SQL Server
• Configuring a SQL Server Installation
• Lab: Installing and Configuring SQL Server
• Lab Exercise 1: Installing SQL Server
• Lab Exercise 2: Configuring SQL Server

Lesson 2: Managing Databases and Files

• Planning Databases
• Creating Databases
• Using Policy-Based Management
• Lab: Managing Databases and Files
• Lab Exercise 1: Creating a Database
• Lab Exercise 2: Monitoring and Managing Filegroup Usage
• Lab Exercise 3: Creating a Policy

Lesson 3: Disaster Recovery

• 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
• Lab Exercise 1: Designing a Backup Strategy
• Lab Exercise 2: Implementing a Backup Strategy
• Lab Exercise 3: Restoring and Recovering a Database
• Lab Exercise 4: Performing Piecemeal Backup and Restore Operations
• Lab Exercise 5: Restoring the master Database

Lesson 4: Managing Security

• Overview of SQL Server Security
• Protecting the Server Scope
• Protecting the Database Scope
• Protecting the Server Scope
• Auditing Security
• Lab: Managing Security
• Lab Exercise 1: Creating Logins and Assigning Server-Scope Permissions
• Lab Exercise 2: Creating and Managing Users
• Lab Exercise 3: Using a Certificate to Protect Data
• Lab Exercise 4: Implementing SQL Server Audit

Lesson 5: Transferring Data

• Overview of Data Transfer
• Introduction to SQL Server Integration Services
• Lab: Transferring Data
• Lab Exercise 1: Using the Import/Export Wizard
• Lab Exercise 2: Performing a Bulk Load
• Lab Exercise 3: Creating an SSIS Solution

Lesson 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
• Lab: Automating Administrative Tasks
• Lab Exercise 1: Configuring SQL Server Agent
• Lab Exercise 2: Creating Operators and Jobs
• Lab Exercise 3: Creating Alerts

Lesson 7: Implementing Replication

• Overview of Replication
• Managing Publications and Subscriptions
• Configuring Replication in Some Common Scenarios
• Lab: Implementing Replication
• Lab Exercise 1: Implementing Snapshot Replication
• Lab Exercise 2: Implementing Peer-to-Peer Transactional Replication
• Lab Exercise 3: Implementing HTTP Merge Replication

Lesson 8: Maintaining High Availability

• Introduction to High Availability
• Implementing Log Shipping
• Implementing Database Mirroring
• Implementing Server Clustering
• Using Distributed High Availability Solutions
• Lab: Maintaining High Availability
• Lab Exercise 1: Configuring Log Shipping
• Lab Exercise 2: Configuring Database Mirroring
• Lab Exercise 3: Implementing SQL Server Clustering

Lesson 9: Monitoring SQL Server

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

Lesson 10: Troubleshooting and Performance Tuning

• Troubleshooting SQL Server
• Performance Tuning in SQL Server
• Using Resource Governor
• Using Data Collector
• Lab: Troubleshooting and Performance Tuning
• Lab Exercise 1: Troubleshooting Connectivity Problems
• Lab Exercise 2: Troubleshooting Concurrency Problems
• Lab Exercise 3: Using the Database Engine Tuning Advisor
• Lab Exercise 4: Implementing Resource Governor
• Lab Exercise 5: Implementing Data Collector

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com