Maintaining a Microsoft SQL Server 2005 Database (MS2780)

Revision: TE4601_20070117

(6.19 KB) View, Download, or Print Catalog as a PDF.

Course Length:

4 Days

Course Description:

This instructor-led course provides students with product knowledge and skills needed to maintain a Microsoft SQL ServerT 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

Who Should Attend:

This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.

Benefits of Attendance:

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

• Install and configure SQL Server 2005
• Manage database files
• Manage security
• Perform administrative tasks
• Back up databases
• Restore databases
• Monitor SQL Server
• Troubleshoot SQL Server
• Transfer data
• Maintain high availability.

Prerequisites:

Before attending this course, students must have basic knowledge of the Microsoft Windows operating system and its core functionality as well as working knowledge of Transact-SQL and relational databases. Some experience with database design is also required. In addition, it is recommended, but not required, that students have completed courses in Writing Queries Using Microsoft SQL Server 2005 Transact-SQL and Implementing a Microsoft SQL Server 2005 Database.

Course Outline:

• Installing and Condiguring SQL Server 2005
  1. Preparing to install SQL Server
  2. Installing SQL Server.
  3. Managing a SQL Server 2005 Installation
  4. Lab 1: Installing SQL Server 2005
  5. Performing an Installation
  6. Managing SQL Server
• Managing Databases and Files
  1. Planning databases
  2. Creating databases
  3. Managing databases
  4. Lab 2: Creating and Managing Databases
  5. Creating a Database
  6. Managing Filegroups
  7. Viewing Metadata
• Disaster Recovery
  1. Planning a Backup Strategy
  2. Backing Up User Databases
  3. Restoring User Databases
  4. Recovering Data from Database Snapshots
  5. System Database and Disaster Recovery
  6. Lab 4: Implementing a Disaster Recovery Strategy
  7. Implementing a Backup Strategy
  8. Restoring Databases
  9. Rebuild The Master Database
• Managing Security
  1. Overview of SQL Server Security
  2. Securing the Server Scope
  3. Securing the Database Scope
  4. Managing Keys and Certificates in SQL Server
  5. Lab 3: Securing SQL Server
  6. Creating Logins
  7. Creating and Managing Users
  8. Using a Certificate to Encrypt Data
• Monitoring SQL Server
  1. Viewing Current Activity
  2. Using System Monitor
  3. Using SQL Server Profiler
  4. Using DDL Triggers
  5. Using Event Notifications.
  6. Lab 5: Monitoring SQL Server
  7. Monitoring SQL Server Performance
  8. Tracing SQL Server Activity
  9. Implementing DDL Trigger
• Transferring Data
  1. Overview of Data Transfer
  2. Introduction to SQL Server Integration Services
  3. Using SQL Server Integration Services
  4. Lab 6: Transferring Data with SQL Server Integration Services (SSIS)
  5. Create an SSIS Package
  6. Deploying an SSIS Package
• Automating Administrative Tasks
  1. Automating Administrative Tasks in SQL Server 2005
  2. Configuring the SQL Server Agent.
  3. Creating Jobs and Operators
  4. Creating Alerts
  5. Managing Multiple Servers
  6. Managing SQL Server Agent Security
  7. Lab 7: Automating Database Administration
  8. Configuring the SQL Server Agent
  9. Creating Operators and Jobs
  10. Creating Alerts
• Maintaining High Availability
  1. Introduction to High Availability
  2. Implementing Server Clustering
  3. Implementing Database Mirroring
  4. Implementing Log Shipping
  5. Lab 8: Configuring Database Mirroring
  6. Setting the Recovery Model
  7. Backing Up and Restoring the Database
  8. Starting Database Mirroring
  9. Performing an Automatic and Manual Failover
• Introduction to Replication
  1. Overview of Replication
  2. Replication Scenarios
  3. Lab 9: Implementing Replication
  4. Creating a Publication
  5. Creating a Subscription