• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   Microsoft SQL Server Training Courses

M2734: Updating Your Database Development Skills to MS SQL Server 2005

View course dates

Course Duration: 3 days

Course Code: M2734

Course Description:

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.

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.

Prerequisite courses:

M2073: Microsoft SQL Server 2000 Database Programming

Prerequisite Certifications:

MCDBA: on Microsoft SQL Server 2000

This course includes the following modules:

SQL Server 2005 Overview

• SQL Server 2005 Components and Architecture
• SQL Server Developer Tools
• SQL Server 2005 Security Implementation

Transact-SQL Enhancements in SQL Server 2005

• Data Definition Language Enhancements
• Data Manipulation Language Enhancements
• Structured Exception Handling

Using XML in SQL Server 2005

• XML Enhancements in SQL Server 2005
• The xml Data Type
• Using XQuery

Using Service Broker

• Service Broker Architecture
• Using the Service Broker

Using Native HTTP Support

• Native HTTP Support in SQL Server 2005
• Configuring Native HTTP Support

Using Notification Services

• Notification Services Architecture
• Building Notification Services Solutions

Using the .NET CLR in SQL Server 2005

• SQL Server and the .NET CLR
• Implementing Managed Code in SQL Server 2005

Developing Client Applications

• Developing Client Applications with ADO.NET
• Data Binding in the .NET Framework 2.0

Using SQL Management Objects

• Introduction to SQL Management Objects
• Replication Management Objects

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course