Updating Your Database Administration Skills to Microsoft SQL Server™ 2005
Introduction
This course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers.
Audience
This course is intended for experienced database administrators and database developers who are responsible for the supporting, configuring, and maintaining enterprise SQL Server 2005 databases and servers.
At Course Completion
After completing this course, students will be able to:
• Describe the architecture of SQL Server 2005.
• Install SQL Server 2005.
• Use SQL Server 2005 administrative tools and utilities.
• Maintain SQL Server 2005 servers and databases.
• Secure a SQL Server 2005 server and database.
• Monitor SQL Server 2005.
• Implement a Backup and Restore solution for SQL Server 2005.
• Implement a data availability solution with database mirroring or clustering.
• Use enhanced SQL Server 2005 replication features.
Prerequisites
• MCDBA certification or equivalent knowledge.
• Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.
• Knowledge of SQL Server 2000/7.0:• Database and server architecture.
• Installation and configuration.
• Database security.
• Database recovery (backup and restore).
• SQL Server technologies used for database availability such as log shipping and clustering.
• Job automation.
• Database and server monitoring.
• Troubleshooting.
• Replication.
Course Outline
Module 1: Overview of SQL Server 2005 Architecture
This module introduces students to the various components and services that comprise SQL Server. Database administrators are often required to manage multiple aspects of the database server – not just the relational database engine, so an awareness of the components and functionality available in SQL Server 2005 is essential in order to prepare database administrators for SQL Server 2005 deployments and management.
Lessons
• Overview of the components of SQL Server 2005.
• System Enhancements for Administrators
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
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
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
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
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
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
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
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
Return to Database Development and Administration Training Courses
|
