Module 2: Installing SQL Server 2005
This module explains how to
plan for a SQL Server 2005 installation, install SQL Server 2005 and
maintain a SQL Server 2005 installation.
Lessons
|
• |
Preparing to Install
SQL Server 2005 |
|
• |
Performing a SQL Server 2005 Installation |
|
• |
Maintaining a SQL Server 2005 Installation |
Lab 2: Installing SQL Server 2005
|
• |
Installing a SQL Server Instance. |
Module 3: SQL Server 2005 Administrative Tools
This module explains what
built-in administration tools and utilities are available in Microsoft
SQL Server™ 2005 and how they can be used to help database
administrators be successful in managing a SQL Server 2005 solution.
Lessons
|
• |
Using SQL Server
Management Studio |
|
• |
Using SQL Server
Computer Manager |
|
• |
Using the sqlcmd
Utility |
|
• |
Using the SQL
Management Objects |
Lab 3: Administering SQL Server 2005
|
• |
Creating the Personnel
database. |
|
• |
Populating the Personnel database. |
|
• |
Backing Up the
Personnel Database. |
Module 4: Monitoring SQL Server 2005
This module discusses the
various tools and techniques you can use to monitor Microsoft SQL
Server™ 2005.
Lessons
|
• |
Using SQL Profiler |
|
• |
Using DDL Triggers |
|
• |
Using Event
Notifications |
|
• |
Using Metadata Views |
Lab 4: Monitoring SQL Server 2005
|
• |
Creating DDL Triggers |
|
• |
Creating Event
Notifications |
Module 5: Maintaining Databases and Indexes
This module explains the tools
and utilities in Microsoft SQL Server™ 2005 that can help you implement
database maintenance plans, manage database indexes, and tune databases.
Lessons
|
• |
Managing Indexes |
|
• |
Using the Database
Tuning Advisor |
Lab 5: Maintaining a
Database
|
• |
Defining Indexes |
|
• |
Tuning a Database |
Module 6: Securing SQL Server 2005
This module explains the
changes and enhancements to the Microsoft SQL Server™ security model in
SQL Server 2005.
Lessons
|
• |
SQL Server 2005
Security Overview |
|
• |
Managing SQL Server
2005 Security |
|
• |
Managing Permissions |
|
• |
Managing Certificates |
Lab 6: Securing a SQL Server 2005 Database
|
• |
Managing securables |
|
• |
Managing principals |
|
• |
Managing Permissions |
|
• |
Dropping a User that
Created Objects. |
Module 7: Disaster Recovery
This module you will learn
about the enhanced backup and restore functionality in Microsoft SQL
Server™ 2005.
Lessons
|
• |
Disaster Recovery in
SQL Server 2005 |
|
• |
Using Database
Snapshots |
|
• |
Backup and Restore
Operations |
Lab 7: Managing Disaster Recovery
|
• |
Creating a Database
Snapshot |
|
• |
Backing up a Database |
Module 8: Data Availability in SQL Server 2005
This module teaches you how to
take advantage of the high availability features found in SQL Server
2005
Lessons
|
• |
Introduction to Data Availability |
|
• |
Introduction to Database Mirroring |
|
• |
Configuring Database Mirroring |
Lab 8: Maintaining Availability
|
• |
Preparing the Principal
and Mirror Server |
|
• |
Establishing a Mirroring Session |
|
• |
Establishing a Witness Server |
|
• |
Executing Transactions |
|
• |
Simulating Principal Server Failure |
|
• |
Restarting the Failed Server |
|
• |
Terminating the Mirror Session |
Module 9: SQL Server 2005 Replication
This module explains the new
and enhanced replication features in SQL Server 2005
Lessons
|
• |
Overview of Replication
Enhancements |
|
• |
New Types of
Replication |
|
• |
Configuring Replication |
This course may also available as an
online course.
Click here
to see our online courses.
