KT-2091 Building XML-Enabled Applications Using SQL Server 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

Building XML-Enabled Applications Using SQL Server


The goal of this course is to provide students with the knowledge and skills they need to build applications that exchange data with Microsoft SQL Serverâ„¢ in Extensible Markup Language (XML) format.

This course is intended for developers of database client applications, including Internet and N-tiered application clients.

It is also intended for SQL Server database developers who need to query, insert, update, or delete data from a database by using XML, and for SQL Server database administrators who need to publish SQL data as XML.

At the end of the course, students will be able to describe the XML features provided by SQL Server 2000 and the SQL Server-XML architecture; generate and specify the structure of an XML document from SQL Server data by using Transact-SQL; insert XML data into SQL Server and use XML to modify existing data; use Microsoft ActiveX® Data Objects (ADO) to access SQL Server data and generate XML; publish a SQL Server database on the Internet/intranet over the Hypertext Transfer Protocol (HTTP) and query the data by using a Uniform Resource Locator (URL); create and use XML templates to query the database; create and use annotated schemas to query and transform SQL Server data; and describe how SQL Server and XML are used in real-world Internet applications.

Click here to view the Course Outline

Before attending this course, students must have:

  • Have written basic Transact-SQL statements to query, insert, update, and delete information from a database, and used joins to retrieve information from multiple tables.
  • Have knowledge of relational database design, including the use of primary and foreign keys. Students should know how to create databases, tables, and stored procedures. Students should also be familiar with the SQL Server Query Analyzer and SQL Profiler tools.
  • Have knowledge of basic XML formats and techniques, including attributes and elements, schemas, the Extensible Stylesheet Language (XSL) and Extensible Stylesheet Language Transformations (XSLT), and the XML Path Language (XPath).
  • Be able to access a data source by using ADO.
  • Be able to write Visual Basic Script (VBScript) code.
  • Be able to read standard Hypertext Markup Language (HTML) and build a form to gather and present data.
  • Be able to create Active Server Pages (ASP) by using the ASP Programming model. Skills include using the POST and GET methods, using the Response object, and using the Session object.
3 Days  

View Printer Friendly Page


To Inquire About Future Classes

Request a class date

if one is not scheduled.

Comments on the Course

I would recommend this class to my co-workers.