SQL Server 2005 > MOC 2734: SQL Server 2005 Developers Update

MOC 2734: SQL Server 2005 Developers Update


MOC 2734: SQL Server 2005 Developers Update

PACKAGE INCLUDES

  • 8 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable courseware
  • Step-by-step hands-on-labs
  • Comprehensive, understandable, and reusable as reference material
  • Focused on practical solutions to real-world development problems


    • Single User CD Course
    £ 298
    Single User Online Course
    £ 238
    Multi User CD Course
    £ 596

    COURSE INTRODUCTION

    Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the best SQL Trainers in the industry to help us develop the ultimate training & certification program.

    This course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers.

    Course Outline


    Module 1

    What's New In SQL Server 2005 for Developers
    SQL Server 2005 Developer Tools
    SQL Server Management Studio
    Demo - SQL Server Management Studio
    SQL Server Security
    Business Intell Development Studio
    Demo - Extra Features
    Transact-SQL Enhancements
    Reporting Services Enhancements
    SQL Server Integration Services
    SQL CLR Support
    Notification Services
    Service Broker
    Native HTTP Support
    ADO.NET 2.0
    SQL Management Objects
    Lab - Disconnected Query
    Module 1 Wrap-up

    Module 2

    Enhancements to T-SQL in SQL Server 2005
    New Data Definition Language Features
    New Data Types
    New Large Value Types
    XML Data Type
    Table Partitioning
    Demo - Table Partitioning
    Indexing Enhancements
    Common Table Expressions
    Demo - Common Table Expressions
    Recursive Common Table Expressions
    The OUTPUT Keyword
    PIVOT and UNPIVOT Operators
    Demo - Pivoting
    The APPLY Operator
    Demp - APPLY
    Ranking Functions
    Demo - Ranking Functions
    Structured Exception Handling
    Lab - Partitioning a Table
    Module 2 Wrap-up

    Module 3

    New XML Features in SQL Server 2005
    FOR XML Enhancements
    Demo - FOR XML Enhancements
    OPENXML Enhancements
    The XML Data Type
    Using Untyped XML
    Demo - Untyped XML
    XML Schema Collections
    Strongly Typed XML
    Demo - Strongly Typed XML
    XML Indexes
    Creating XML Indexes
    Using XQuery
    Demo - XQuery Expressions
    XQuery: Modifying Data
    XQuery: Shredding
    Demo - XQuery Nodes and Modify
    Lab - Returning XML from Relational Data
    Module 3 Wrap-up

         		 

    Module 4

    SQL Server 2005 Service Broker
    Service Broker Architecture
    Service Broker Security
    Enabling Service Broker
    Implementing Services
    Creating Message Types
    Demo - Creating Message Types
    Creating Contracts
    Demo - Creating a Simple Contract
    Creating Queues
    Demo - Creating Queues
    Creating Services
    Demo - Creating Services
    Sending & Receiving Messages
    Demo - Sending & Receiving Messages
    Lab - Creating Service Broker Objects
    Module 4 Wrap-up

    Module 5

    SQL Server 2005 Native HTTP Support
    Web Services
    Native HTTP Support
    Native HTTP Usage Scenarios
    Native HTTP Architecture
    Creating an HTTP Endpoint
    Demo - Creating an HTTP Endpoint
    Securing an HTTP Endpoint
    Calling HTTP Endpoints from Client Apps
    Demo - Securing an HTTP Endpoint
    Lab - Creating an HTTP Endpoint
    Module 5 Wrap-up

    Module 6

    SQL Server 2005 Notification Services
    Notification Services Architecture
    Subscription Management
    Event Providers
    Notification Generation
    Notification Formatting
    Building Notifications
    Design Considerations
    The Configuration File
    Demo - The Configuration File
    The Application Definition File
    Demo - The Application Definition File
    Managing Notification Services
    Demo - Notification Services
    Subscription Management Applications
    Demo - Subscription Management
    Using Event Providers
    Demo - Event Providers
    Best Practices
    Lab - Creating an Event Provider
    Module 6 Wrap-up

         		 

    Module 7

    .NET CLR Integration in SQL Server 2005
    The .NET Common Language Runtime
    Features of Managed Code
    SQL Server 2005 Hosting the CLR
    When to Use Managed Code
    Intro to Managed Code in SQL Server
    Demo - Managed Code
    .NET CLR Security
    SQL Projects in Visual Studio 2005
    Demo - SQL Server Project
    Microsoft.SqlServer.Server Namespace
    Creating Managed Stored Procedures
    Managed User Defined Functions
    Creating Managed Triggers
    Creating Managed Aggregates
    Creating Managed Data Types
    Deploying Managed Database Objects
    Demo - SQL ClR
    Lab - Creating a Managed Stored Procedure
    Module 7 Wrap-up

    Module 8

    Developing Client Applications for SQL Server 2005
    ADO.NET Overview
    ADO.NET 2.0 Enhancements
    Demo - Async
    MARS
    Demo - MARS
    Managed Bulk Copy
    Demo - Bulk Copy
    Batch Update
    Demo - Batch Update
    Lab - Creating a MARS Application
    Module 8 Wrap-up
    Course Closure
    Page Execution time is 5.219 seconds.