|
|
|
|
Title: |
2780 Maintaining a Microsoft SQL Server 2005 Database - ML |
|
Delivery Method: |
Mentored Learning |
|
Duration: |
10 Sessions |
|
Overview: |
This course provides students with product knowledge and skills needed 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. |
| 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. |
| Pre-requisite(s): |
2779 Implementing a Microsoft SQL Server 2005 Database
2778 Writing Queries Using Microsoft SQL Server 2005 Transact-SQL |
| CPE
Information: |
CPE Credits:
0
hours
Course Level: Basic
Instructional Method: Group-live
Additional CPE Information |
|
Outline: |
Lesson 1: Installing and Configuring SQL Server 2005
Preparing to install SQL Server.
Installing SQL Server.
Managing a SQL Server 2005 Installation.
Lesson 2: Managing Databases and Files
Planning databases.
Creating databases.
Managing databases.
Lesson 3: Managing Security
Overview of SQL Server Security.
Securing the Server Scope.
Securing the Database Scope.
Implementing Cryptography in SQL Server.
Lesson 4: Disaster Recovery
Planning a Backup Strategy.
Backing Up User Databases.
Restoring User Databases.
Recovering Data from Database Snapshots.
System Database and Disaster Recovery.
Lesson 5: Monitoring SQL Server
Viewing Current Activity.
Using System Monitor.
Using SQL Server Profiler.
Using DDL Triggers.
Using Event Notifications.
Lesson 6: Transferring Data
Overview of Data Transfer.
Introduction to SQL Server Integration Services (SSIS).
Using SQL Server Integration Services.
Lesson 7: Automating Administrative Tasks
Automating Administrative Tasks in SQL Server 2005.
Configuring the SQL Server Agent.
Creating Jobs and Operators.
Create Alerts.
Managing Multiple Servers.
Managing SQL Server Agent Security
Lesson 8: Maintaining High Availability
Introduction to High Availability.
Implementing Server Clustering.
Implementing Database Mirroring.
Implementing Log Shipping.
Lesson 9: Introduction to Replication
Overview of Replication. |
|
