Verhoef Training, Inc.

P.O.Box 1515, West Caldwell, NJ 07006
Phone:(800)631-0410 Fax:(973)403-3468



Microsoft SQL Server 2005 New Features




SUMMARY:   Students attending this class will learn about the newest features of Microsoft SQL Server 2005.

AUDIENCE:   The course is recommended for application developers, database administrators, systems programmers, database designers, system analysts, and any personnel interested in Microsoft SQL Server 2005 performance and tuning facilities and those who are interested in learning about the newest features of Microsoft SQL Server 2005.

PREREQUISITES:   It is recommended that people attending this class have a working knowledge of Microsoft SQL Server 2000 and have worked with Microsoft SQL Server 2000 for a period of at least three months.

DURATION:   The class is presented as two days of lecture material.

OBJECTIVES:   Upon successful completion of this course, students will be able to describe the newest features in Microsoft SQL Server 2005, including the enhancements to:

    Database Architecture
    Security processing
    Database Tools
    System Availability
    Transact SQL programming facilities
    Notification services
    SQL Server Service Broker
    XML changes
    Reporting Services
    Data transformation facilities
    Analysis services
    Data Mining

COURSE CONTENT:   Database Architecture
    64 bit support
    Multiple instance support
    New datatypes
    Database Snapshots
    Mirroring
    Event and DDL Triggers
    Data Partitioning
    Enhancements to Indexes
    Multiple active results sets
    Bulk Loading
    Full Text search
    Query processor enhancements

Security Changes

Database Tools
    SQL Server Management Studio
    Business Intelligence Development Studio
    Database tuning advisor

Server Availability
    Failover clustering
    Early Restore Access
    Online Index commands
    Partial restore
    Page checksums
    Concurrent database and log backups

SQL Coding
    PIVOT and UNPIVOT
    Waitfor
    Transaction abort

Enhancements to Notification Services

SQL Server Service Broker
    Overview
    Usage

XML Integration
    XQuery
    XML indexes
    XML enhancements

Reporting services
    Report server and manager
    Authoring a report

Data Transformation Pipeline and Runtime
Analysis Services
    OLAP storage types

Data Mining Enhancements

MT/07

© 2007 Verhoef Training, Inc.