learn something new
FIND A CLASS
Virtual Training Schedule
Map : Bloomington, IL
Map : Springfield, IL
Find a Class
> Class Summary
MS2780 - Maintaining a Microsoft SQL Server 2005 Database
If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at
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.
Click here for a printer-friendly version of this page.
This course has not been scheduled yet. Please contact us by clicking the link below to learn about availability.
Contact us for additional availability.
Before attending this course, students must have: • 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. In addition, it is recommended, but not required, that students have completed: • Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL. • Course 2779: Implementing a Microsoft SQL Server 2005 Database.
Detailed Class Syllabus
Module 1: Installing and Configuring SQL Server 2005
This module explains how to plan for and install SQL Server 2005, how to manage a SQL Server 2005 installation, and how to use the SQL Server 2005 administrative tools.
Preparing to Install SQL Server
Installing SQL Server 2005
Managing a SQL Server 2005 Installation
Lab 1: Installing and Configuring SQL Server 2005
Module 2: Managing Databases and Files
This module explains how to manage databases and files.
Lab 2: Managing Databases and Files
Module 3: Disaster Recovery
This module explains how to plan and implement a backup and restore strategy.
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
Module 4: Managing Security
This module explains how to manage principals, securables, and permissions, and how to implement cryptography in a SQL Server database.
Overview of SQL Server Security
Protecting the Server Scope
Protecting the Database Scope
Managing Keys and Certificates in SQL Server
Lab 4: Managing Security
Module 5: Monitoring SQL Server
This module explains how to monitor SQL Server performance and activity.
Viewing Current Activity
Using System Monitor
Using SQL Server Profiler
Using DDL Triggers
Using Event Notifications
Lab 5: Monitoring SQL Server
Module 6: Transferring Data
This module explains how to transfer and transform data.
Overview of Data Transfer
Introduction to SQL Server Integration Services
Features of SQL Server Integration Services
Lab 6: Transferring Data
Module 7: Automating Administrative Tasks
This module explains how to use the SQL Server Agent to automate administrative tasks.
Automating Administrative Tasks in SQL Server 2005
Configuring the SQL Server Agent
Creating Jobs and Operators
Managing Multiple Servers
Managing SQL Server Agent Security
Lab 7: Automating Administrative Tasks
Module 8: Implementing Replication
This module explains the purpose of replication, introduces the concepts underpinning replication, and describes how to implement replication in several common scenarios.
Overview of Replication
Configuring Replication in Some Common Scenarios
Lab 8: Implementing Replication
Module 9: Maintaining High Availability
This module explains how to implement high availability technologies with SQL Server 2005.
Introduction to High Availability
Implementing Server Clustering
Implementing Database Mirroring
Implementing Log Shipping
Implementing Peer-to-Peer Replication
Copyright © 1996 - 2013 Levi, Ray & Shoup, Inc. All rights reserved. |
Trademark Information and Legal Disclaimers