New Horizons Computer Learning Center
410-597-9722

2780: Maintaining a Microsoft SQL Server 2005 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 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

Prerequisites:
Writing Queries Using Microsoft SQL Server 2005 Transact-SQL
Course 2779: Implementing a Microsoft SQL Server 2005 Database
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 2005
• Manage database files
• Backup and restore databases
• Manage security
• Monitor SQL Server
• Transfer data into and out of SQL Server
• Automate administrative tasks
• Replicate data between SQL Server instances
• Maintain high availability

Course Content

Lesson 1: Installing and Configuring SQL Server 2005

• Preparing to Install SQL Server
• Installing SQL Server 2005
• Managing a SQL Server 2005 Installation
• Lab 1: Installing and Configuring SQL Server 2005
• Performing an Installation
• Managing SQL Server

Lesson 2: Managing Databases and Files

• Planning Databases
• Creating Databases
• Managing Databases
• Lab 2: Managing Databases and Files
• Creating a Database
• Monitoring and Managing Filegroup Usage
• Viewing Database Metadata

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 Database and Disaster Recovery
• Lab 3: Disaster Recovery
• Implementing a Backup Strategy
• Restoring and Recovering a Database
• Performing Piecemeal Backup and Restore Operations
• Restoring the master Database

Lesson 4: Managing Security

• Overview of SQL Server Security
• Protecting the Server Scope
• Protecting the Database Scope
• Managing Keys and Certificates in SQL Server
• Lab 4: Managing Security
• Creating Logins and Assigning Server-Scope Permissions
• Creating and Managing Users
• Using a Certificate to Protect Data

Lesson 5: Monitoring SQL Server

• Viewing Current Activity
• Using System Monitor
• Using SQL Server Profiler
• Using DDL Triggers
• Using Event Notifications
• Lab 5: Monitoring SQL Server
• Monitoring SQL Server Performance
• Tracing SQL Server Activity
• Implementing DDL Triggers

Lesson 6: Transferring Data

• Overview of Data Transfer
• Introduction to SQL Server Integration Services
• Using SQL Server Integration Services
• Features of SQL Server Integration Services
• Lab 6: Transferring Data
• Creating an SSIS Package
• Deploying an SSIS Package
• Using SSIS to Extract Data, Perform Lookups, Sort, and Split Data

Lesson 7: Automating Administrative Tasks

• Automating Administrative Tasks in SQL Server 2005
• Configuring the SQL Server Agent
• Creating Jobs and Operators
• Creating Alerts
• Managing Multiple Servers
• Managing SQL Server Agent Security
• Lab 7: Automating Administrative Tasks
• Configuring SQL Server Agent
• Creating Operators and Jobs
• Creating Alerts

Lesson 8: Implementing Replication

• Overview of Replication
• Implementing Replication
• Configuring Replication in Some Common Scenarios
• Lab 8: Implementing Replication
• Creating a Publication
• Creating a Subscription
• Implementing HTTP Merge Replication

Lesson 9: Maintaining High Availability

• Introduction to High Availability
• Implementing Server Clustering
• Implementing Database Mirroring
• Implementing Log Shipping
• Implementing Peer-to-Peer Replication
• Lab 9:
• Configuring Database Mirroring to Support Failover
• Implementing Distributed High Availability

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