MS2091 - Building XML-Enabled Applications Using Microsoft SQL Server 2000
| Categories |
XML Training, SQL Training, Web Development Training, Microsoft Certification Training, Microsoft SQL Server Training |
| Duration |
3 days (21 hours) |
| Pre-requisites |
DMD - Database Modeling and Design, VBS1 - Mastering VBScript, TSQL1 - Transact-SQL Programming or MS2073 - Programming a Microsoft SQL Server 2000 Database and XML1 - XML: An Introduction or MS1905 - Building XML-Based Web Applications, or a basic understanding of database design, administration, and
implementation concepts and 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).
|
|
|
|
| Courseware |
MS2091-MS (200 pages) |
| Price |
$1185 |
| Notes |
|
This course will 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; Internet and N-tiered application clients; 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.
Module 1: Using XML and Microsoft SQL Server 2000
Building Solutions with XML and SQL Server 2000
XML Technology Review
XML Support in SQL Server 2000
Lab: Working with XML
Module 2: Retrieving XML Data
Using the FOR XML Clause to Retrieve Data
Controlling XML Output
Generating Custom XML Formats
Lab 2.1: Retrieving XML Data
Lab 2.2: Explicit Queries
Module 3: Manipulating XSL Using Transact SQL
Creating a Rowset from an XML Document
Processing Nested Documents
Working with Meta-Properties
Lab: Using OpenXML
Module 4: Using ADO to Access XML Data
Retrieving XML Data with ADO
Using ADO and XML on an ASP-Based Web Site
Lab 4.1: Creating an ADO Client Application
Lab 4.2: Using ADO on a Web Site
Module 5: Using HTTP to Access XML Data
Enabling HTTP Access to SQL Databases
Publishing XML Templates on the Server
Posting Query Templates from the Client
Publishing a Database Object
Lab 5.1: Publishing a SQL Server Database
Lab 5.2: Using XML Templates
Module 6: Using Mapping Schemas
Using Mapping Schemas
Using Schemas to Retrieve Data
Mapping Multiple Tables
Annotating an Existing Schema
Lab 6.1: Using Mapping Schemas
Lab 6.2: Mapping Multiple Tables
Lab 6.3: Annotating an Existing Schema
Module 7: XML for SQL Tools
Modifying Data with Updategrams
Inserting Data with the Bulk Load Facility
Lab 7.1: Using Updategrams
Lab 7.2: Bulk Loading XML Data