Administering Microsoft® SQL Server™ 2005 Databases for Oracle Database Professionals

Description:
In this online course, you extend your Oracle administrative skills to SQL Server 2005 through comparison of Oracle and SQL Server 2005 administrative tools and methods.

Objectives:
At the end of the course, students will be able to:
Describe the components of SQL Server and how they are configured.
Use the management tools provided in SQL Server 2005.
Configure SQL Server 2005 for high availability.
Secure a SQL Server database solution.
Manage transactions and locking in SQL Server.
Automate administration of SQL Server.

Modules & Lessons
Course Overview
Module Introduction
Navigation Overview
Lab Information

Administering SQL Server 2005 Databases for Oracle Database Professionals
Module Introduction

Exploring the SQL Server Architecture
Lesson Introduction
Editions of SQL Server 2005
SQL Server 2005 Services
What Are SQL Server Instances?
SQL Server 2005 Logical Database Architecture
SQL Server 2005 Physical Database Architecture
Components of the SQL Server 2005 Database Engine
Self Test

Examining the SQL Server 2005 Management Tools
Lesson Introduction
SQL Server 2005 Configuration Management Tools
SQL Server Management Studio
SQL Server Command Line Tools
SQL Server Business Intelligence Development Studio
SQL Server Performance Tools
Self Test

Configuring High Availability
Lesson Introduction
SQL Server 2005 Availability Options
SQL Server Failover Clusters
What Is Log Shipping?
What Is Database Mirroring?
Operation of Database Mirroring
Self Test

Securing a SQL Server Database Solution
Lesson Introduction
Overview of Security
SQL Server Authentication
What Are Fixed Server Roles?
What Are Database Principals?
SQL Server 2005 Permissions
SQL Server 2005 Cryptographic Functionality
Self Test

Managing Transactions and Locking
Lesson Introduction
Introduction to Transactions
How Does Snapshot Isolation Work?
Guidelines for Managing Locking
Self Test

Automating Administration
Lesson Introduction
Server Maintenance Tasks
What Is the SQL Server Agent?
What Are Maintenance Plans?
What Are Jobs?
What Are Operators, Events, Alerts, and Responses?
Self Test

Lab: Administering SQL Server 2005 Databases for Oracle Database Professionals
Lesson Introduction
Scenario
Exercise Information
Launch the Lab
Lab Review
Module Summary

Glossary
Module Introduction