KT-2734 Updating Your Database Development Skills to Microsoft SQL Server 2005 Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University


Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training



 Course Search
Course #

 Training Delivery
Training Delivery
Custom Curriculum
Course List
 Main Menu
View Courses
Site Index

Updating Your Database Development Skills to Microsoft SQL Server 2005


This three-day instructor-led 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. 

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.

At Course Completion

After completing this course, students will be able 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)






Click here to view the Course Outline

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
  • UDF
  • Triggers
  • Stored Procedures
  • Optimization
  • .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.

3 Days  

View Printer Friendly Page


To Inquire About Future Classes

Request a class date

if one is not scheduled.