Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
Home
  
How it works
  
About the quality of your course
 
Managed services
  
Partner CourseMonster
  
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
  
 
Browse Microsoft Training Courses

SQL Server 2005: Updating your Development Skills to SQL Server 2005

Course Code: MS2734 (Also known as: M2734, MOC 2734)      Days: 3
Show all Microsoft Courses
Scheduled Dates (sort by: location | date)
Request availability or book by selecting a date:
03/12/08 London (Greater) (N20) £ 1,350
19/01/09 London (Greater) (N20) £ 1,350
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.

Course Overview

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.

Audience

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.

Skills Gained

  • 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).

Prerequisites

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:
  • Course 2073, Programming a Microsoft SQL Server 2000 Database.

Course Outline

  • Module 1: SQL Server 2005 Overview
  • Module 2: Transact-SQL Enhancements in SQL Server 2005
  • Module 3: Using XML in SQL Server 2005
  • Module 4: Using Service Broker
  • Module 5: Using Native HTTP Support
  • Module 6: Using Notification Services
  • Module 7: Using the .NET CLR in SQL Server 2005
  • Module 8: Developing Client Applications
  • Module 9: Using SQL Management Objects


How to make a booking for the MS2734 course
 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership