Maintaining a Microsoft SQL Server 2005 Database

Hilton Computer Strategies
Houston, Texas, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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.

.

Audience

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

At Course Completion

At the end of the 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.




Microsoft Certified Professional Exams
There is no MCP exam associated with this course.

Student Materials
The student kit includes a comprehensive workbook and other necessary materials for this class.

Course Outline
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.

Lessons

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


After completing this module, students will be able to:

Explain how to prepare the hardware and other resources necessary to install SQL Server 2005.
Install SQL Server 2005.

Manage and configure a SQL Server 2005 installation.




Module 2: Managing Databases and Files

This module explains how to manage databases and files.

Lessons

Planning Databases

Creating Databases

Managing Databases


Lab 2: Managing Databases and Files

Creating a Database

Monitoring and Managing Filegroup Usage
Viewing Database Metadata


After completing this module, students will be able to:

Plan how to implement a database that meets an organization’s requirements.

Create a SQL Server database.

Manage a SQL Server database.




Module 3: Disaster Recovery

This module explains how to plan and implement a backup and restore strategy.

Lessons

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


After completing this module, students will be able to:

Plan a backup strategy for a database.

Back up user databases.

Restore user databases from backups.

Restore data in a user database while it is online.

Recover data for a user database from a database snapshot.

Restore and recover systems databases.




Module 4: Managing Security

This module explains how to manage principals, securables, and permissions, and how to implement cryptography in a SQL Server database.

Lessons

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


After completing this module, students will be able to:

Describe how SQL Server manages security.

Protect SQL Server at the server level.

Protect SQL Server databases.

Use keys and certificates to protect SQL Server objects.


Module 5: Monitoring SQL Server

This module explains how to monitor SQL Server performance and activity.

Lessons

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


After completing this module, students will be able to:

Examine the current activity in a SQL Server instance.

Use System Monitor to obtain performance data about your computer and the instances of SQL Server running on your computer.

Use SQL Server Profiler to trace server and database activity.

Implement DDL triggers that enable you to audit changes to the structure of database objects.

Use event notifications to capture and monitor significant events for a SQL Server instance.




Module 6: Transferring Data

This module explains how to transfer and transform data.

Lessons

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


After completing this module, students will be able to:

Describe the problems surrounding data transfer and the tools that SQL Server 2005 provides to perform data transfer.

Describe the purpose of SQL Server Integration Services.

Use SQL Server Integration Services to transfer data into a SQL Server database.

Describe the features of SQL Server Integration Services.




Module 7: Automating Administrative Tasks

This module explains how to use the SQL Server Agent to automate administrative tasks.

Lessons

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


After completing this module, students will be able to:

Define SQL Server 2005 administrative tasks and schedule these tasks to run automatically.

Configure SQL Server Agent to support automatic task scheduling.

Script tasks by using SQL Server jobs, and define operators for managing these jobs.

Define alerts to warn operators about events raised by SQL Server.

Define and manage administrative tasks that span multiple servers.

Configure SQL Server Agent security.




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.

Lessons

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

After completing this module, students will be able to: ...''

Phone:1-800-324-7415

School Address:

Hilton Computer Strategies, 6001 Savoy, Suite 207, Houston, TX 77036 USA

Jobs & Resumes: Houston
Houses & Roommates: Houston

Microsoft Internet Security and Acceleration Server 2004
Ethical Hacking and Countermeasures
Computer Hacking Forensic Investigator
CISSP Foundation
Service Oriented Architecture
Microsoft Office SharePoint Server 2007
Microsoft Office InfoPath 2007
Microsoft Office SharePoint Server 2007 Administration
Inside Microsoft SharePoint 2007 Products and Technology
Implementing a Microsoft SQL Server 2005 Database
Microsoft SQL Server 2005 Server-Side Solutions
Tuning and Optimizing Queries using Microsoft SQL Server 2005
Security for Microsoft SQL Server 2005
Administering and Automating Microsoft SQL Server 2005 Databases and Servers
Microsoft Server 2005 Analysis Services
Microsoft SQL Server 2005 Integration Services
Business Intelligence Solution for the Enterprise using Microsoft SQL Server 2005
ETL Solution Architecture using Microsoft SQL Server 2005 Integration Services
Microsoft SQL Server 2005 Reporting Services

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.