PTR - People, Training ResultsPeople, Training, Results

Independent Technical IT Computer Training Courses

   
Scheduled Classroom based Training Courses

Updating Your Database Development Skills to Microsoft SQL Server 2005 Course

Course Description

This course is no longer scheduled to run. Please refer to schedule for current course titles.

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

This course is intended for experienced database developers and database administrators, who are responsible for the design, build, query, and develop enterprise SQL Server 2005 databases and servers.

Delegates will learn how to:
  • Use the Development Tools provided with SQL Server 2005
  • Use Transact-SQL enhancements to perform database development tasks
  • Develop XML-based Solutions using SQL Server 2005
  • Build Message-Based Services with the Service Broker
  • Implement Web Services using Native HTTP Endpoints
  • Build Notification Services Applications
  • Implement Database Functionality with Managed (.NET) Code
  • Build Client Applications with the .NET Framework
  • Build Administrative Applications with SQL Management Objects (SMO).
    		•  £

    3 day course

    Scheduled Dates:

    Course pre-requisites:

    Before attending this course, students must have:

  • MCDBA (Microsoft Certified Database Administrator) certification or equivalent knowledge.
  • Development experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.
  • Knowledge of SQL Server 2000/7.0:• Database and server architecture.
  • Database Security
  • Transact SQL
  • Query Engine
  • DDL
  • DML
  • Optimization
  • Schema and Objects
  • Programming Objects
  • UDDT
  • UDF
  • Triggers
  • Stored Procedures
  • Optimization
  • SQL XML
  • .NET Development (Visual Basic .NET or C# .NET)
  • ADO.NET


    • In addition, it is recommended, but not required, that students have completed the Programming a Microsoft SQL Server 2000 Database course.


    Topics covered on the 3 day Updating Your Database Development Skills to Microsoft SQL Server 2005 course

    SQL Server 2005 Overview

  • SQL Server 2005 Components and Architecture
  • SQL Server Developer Tools
  • SQL Server 2005 Security Implementation
  • Using SQL Server Management Studio
  • Using Schemas


    • Transact-SQL Enhancements in SQL Server 2005

  • Data Definition Language Enhancements
  • Data Manipulation Language Enhancements
  • Structured Exception Handling
  • Programming with Transact-SQL
  • Partitioning a Table
  • Using Common Table Expressions
  • Using Relational Operators


    • Using XML in SQL Server 2005

  • XML Enhancements in SQL Server 2005
  • The xml Data Type
  • Using XQuery
  • Working with XML
  • Retrieving XML from Relational Data
  • Storing XML Natively in the Databases
  • Using XQuery with xml Methods


    • Using Service Broker

  • Service Broker Architecture
  • Using the Service Broker
  • Using Service Broker
  • Creating Service Broker Objects
  • Implementing the Customer Service
  • Implementing the E-mail Service


    • Using Native HTTP Support

  • Native HTTP Support in SQL Server 2005
  • Configuring Native HTTP Support
  • Implementing a Web Service with HTTP Endpoints
  • Create an HTTP Endpoint
  • Test the HTTP Endpoint
  • Secure the HTTP Endpoint


    • Using Notification Services

  • Notification Services Architecture
  • Building Notification Services Solutions
  • Creating a Notification Services Application
  • Creating a Subscription Management Application
  • Creating an Event Provider


    • Using the .NET CLR in SQL Server 2005

  • SQL Server and the .NET CLR
  • Implementing Managed Code in SQL Server 2005
  • Creating a Managed Stored Procedure
  • Creating a Managed Function
  • Creating a Managed User-Defined Type


    • Developing Client Applications

  • Developing Client Applications with ADO.NET
  • Data Binding in the .NET Framework 2.0
  • Creating a Data Bound Windows Application
  • Creating a Data bound ASP.NET Application


    • Using SQL Management Objects

  • Introduction to SQL Management Objects
  • Replication Management Objects
  • Using SMO to Retrieve Server Information
  • Using SMO to Create Database Objects
  • Using SMO to Modify Database Objects

    • Course Classification: 

    Course Fee = £   (excl.VAT)



    Scheduled course dates



    Print / Download PDF Version of full course schedule

    If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite SQL Training and bespoke SQL courses