Microsoft SQL Server 2005 Administration Course Overview:

An Overview of SQL Server 2005

        New Features

        Database Roles

        Client Tools           

Installing SQL Server 2005

        Preparing For Installation

        Setup User Interface

        Installing Express Edition

        Configuring an New Instance    
 

SQL Server Database Engine

        Managing Services

        Managing Servers

        Database Projects

        Database Objects          

SQL Server Integration Services (SSIS)

        What Happened To DTS?

        What is ETL?

        Integration Services Projects

        SSIS Objects

        Expressions    

SQL Server Analysis Services (SSAS)

        OLAP vs. OLTP

        Data Warehousing

        Data Mining

        Architecture

        Analysis Services Projects

        Analysis Services Scripting Language (ASSL)

        XML for Analysis (XMLA)

        Predictive Mining Model Language (PMML)

        Data Mining Extensions (DMX)

        Multidimensional Expression Language (MDX)     

 SQL Server Replication

        Overview

        Replication Types

        Agents

        Implementing

        Administering

        Enhancements   

SQL Server Reporting Services (SSRS)

        Overview

       Creating, Managing, and Delivering

        Administering          

SQL Server Full-Text Search (SSFTS)

        Overview

        Architecture

        Writing Queries

        Administering  
 

SQL Server Notification Services (SSNS)

        Overview

        Subscription Management

        Event Collection

        Subscription Processing

        Formatting and Delivery      

SQL Server Service Broker

        Overview

       Conversations

        Message Ordering and Coordination

        Transactional Asynchronous Programming

        Loosely Coupled Applications

        Components

        Administering  
 

Security

        Overview

        Catalog Views

        Security Functions

        Cryptographic Functions

        CLR Integration

        Native XML Web Services

        Integration Services

        Analysis Services

        Replication

        Reports

        Notifications

        Service Broker         

International Databases

        Unicode Data

        Date and Time Issues

        Collations

        International SQL

        Integration Services

        Analysis Services

        Reports

        Notifications

        Service Broker

        Full-Text Searches     

Working with XML

        Data Type

        Indexes

        Schema Collections

        For XML

        OpenXML

        Native XML Web Services       

Data Availability

        Disaster Recovery

       High Availability

        Backup

        Restore        

Monitoring and Performance

        Windows Performance Monitor

       SQL Server Profiler

        Database Engine Tuning Advisor (DTA)

        Federated Database Servers

        Partitioned Tables

        Partitioned Indexes

        Query Performance Issues

        Transactions and Locks

        Best Practices for Native XML Web Services         

Programming SQL Server 2005

        Transact-SQL

       CLR Integration Overview

        Stored Procedures

        User-Defined Functions

        User-Defined Types

        DML Triggers

        DDL Triggers

        SQL Management Objects (SMO)

        Integration Services

        Replication Management Objects (RMO)

        Reports

        Notifications