Hours: 40
Short Description
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.
After completing this course, students will be able to:
- Install and configure SQL Server 2005
- Manage database files.
- Manage security.
- Perform administrative tasks.
- Backup databases.
- Restore databases
- Monitor SQL Server.
- Troubleshoot SQL Server
- Transfer data.
- Maintain high availability.
Course Outline
|
Lesson 1: Installing and Configuring SQL Server
2005Preparing to install SQL Server.
Installing SQL Server.
Managing a SQL Server 2005 Installation.
Lesson 2: Managing Databases and FilesPlanning databases.
Creating
databases.
Managing databases.
Lesson 3: Disaster
RecoveryPlanning a Backup Strategy.
Backing Up User Databases.
Restoring User Databases.
Recovering Data from Database
Snapshots.
System Database and Disaster Recovery.
Lesson
4: Managing SecurityOverview of SQL Server Security
Protecting
the Server Scope
Protecting the Database Scope
Managing Keys
and Certificates in SQL Server
Lesson 5: Monitoring SQL ServerViewing Current Activity.
Using System Monitor.
Using SQL Server Profiler.
Using
DDL Triggers.
Using Event Notifications.
|
Lesson 6: Transferring DataOverview of Data Transfer.
Introduction to
SQL Server Integration Services (SSIS).
Using SQL Server
Integration Services.
Features of SQL Server Integration Services
Lesson 7: Automating Administrative TasksAutomating
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: Implementing ReplicationOverview of
Replication.
Implementing Replication
Configuring Replication
in Some Common Scenarios
Lesson 9: Maintaining High
AvailabilityIntroduction to High Availability.
Implementing
Server Clustering.
Implementing Database Mirroring.
Implementing
Log Shipping.
Implementing Peer-to-Peer Replication
|
