From: Subject: =?Windows-1252?Q?Course_2091=97Three_days=97Instructor-led?= Date: Sat, 4 Aug 2001 11:48:27 +0100 MIME-Version: 1.0 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Content-Location: file://D:\Website%20-%20Data\Outlines\ms\Course%202091.htm X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Course 2091=97Three = days=97Instructor-led

Course 2091=97Three days=97Instructor-led

Building XML-Enabled Applications Using Microsoft SQL Server = 2000


 

Introduction

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


 

Audience

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

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


 

At Course Completion

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


 

Prerequisites

Before attending this course, students must: =

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

Taking one or more of the = following courses=20 will help the students meet the prerequisites and get more out of = the=20 course:

  • Course=20 1905, Building XML-Based = Web=20 Applications=20
  • Course=20 2073, Programming a = Microsoft SQL=20 Server Database


 

Microsoft Certified Professional Exams

There is no MCP exam associated = with this=20 course.


 

Student Materials

The student kit includes a comprehensive = workbook and=20 other necessary materials for this class.

The following software is = provided in the=20 student kit:

  • Microsoft=20 Windows=AE 2000 Server=20
  • Microsoft=20 Internet Information Services (IIS)=20
  • Microsoft=20 Windows 2000, Service Pack 1=20
  • Microsoft=20 SQL Server 2000, Standard Edition=20
  • Microsoft=20 Internet Explorer 5.5=20
  • Microsoft=20 XML Parser 3.0=20
  • Internet=20 Explorer Tools for Validating XML and Viewing XSLT Output=20
  • Course=20 files:
    • Labs=20
    • Practices=20
    • Demonstrations=20


 

Course Outline

Module 1: Using XML and Microsoft SQL Server 2000

The following topics are covered = in this=20 module:

  • Building=20 Solutions with XML and SQL Server 2000=20
  • XML=20 Technology Review=20
  • XML=20 Support in SQL Server 2000=20
  • Lab:=20 Working with XML

After completing this module, = students will=20 be able to outline the native XML functionality that has been = built into=20 Microsoft SQ: Server 2000. This includes:

  • Representing=20 business data by using XML=20
  • Referencing=20 an existing XSL style sheet to format or transform an XML = document.=20
  • Using=20 XPath expressions in XSL programming.=20
  • Listing=20 the XML features in SQL Server 2000.=20
  • Describing=20 the SQL Server XML architecture.

Module 2: Retrieving XML Data

The following topics are covered = in this=20 module:

  • Using=20 the FOR XML Clause to Retrieve Data=20
  • Controlling=20 XML Output=20
  • Generating=20 Custom XML Formats=20
  • Lab=20 2.1: Retrieving XML Data=20
  • Lab=20 2.2: Explicit Queries

After completing this module, = students will=20 be able to retrieve data from an XML document. This includes:

  • Generating=20 Extensible Markup Language (XML) documents from Microsoft SQL = Server=20 data by using the RAW and AUTO modifiers.=20
  • Using=20 the Elements option to return an element-centric XML document.=20
  • Using=20 Table and Column aliases to name the returned elements and = attributes.=20
  • Creating=20 XML documents containing data from multiple tables by using JOIN = statements.=20
  • Generating=20 an XML document with a custom structure by using the EXPLICIT = modifier.=20

Module 3: Manipulating XSL Using Transact SQL

The following topics are covered = in this=20 module:

  • Creating=20 a Rowset from an XML Document=20
  • Processing=20 Nested Documents=20
  • Working=20 with Meta-Properties=20
  • Lab:=20 Using OpenXML

After completing this module, = students will=20 be able to manipulate data from an XML document by using = Transact-SQL.=20 This includes:

  • Using=20 OpenXML statements to create rowsets from single-level XML = documents.=20
  • Producing=20 rowsets from complex XML documents by using OpenXML.=20
  • Retrieving=20 elements, attributes, or both from an XML document by using the = Flags=20 parameter.=20
  • Using=20 XPath expressions to create rowsets from nested XML documents. =

Module 4: Using ADO to Access XML Data

The following topics are covered = in this=20 module:

  • Retrieving=20 XML Data with ADO=20
  • Using=20 ADO and XML on an ASP-Based Web Site=20
  • Lab=20 4.1: Creating an ADO Client Application=20
  • Lab=20 4.2: Using ADO on a Web Site

After completing this module, = students will=20 be able to access data by using ADO, and apply a stylesheet to the = data.=20 This includes:

  • Constructing=20 an XML query from Visual Basic.=20
  • Using=20 a Command object and Stream objects to submit an XML query.=20
  • Applying=20 a style sheet to the results of an XML query by using ADO.=20
  • Returning=20 XML query results to the ASP Response object=20
  • Specifying=20 the Content-Type and Output Encoding options for an XML query. =

Module 5: Using HTTP to Access XML Data

The following topics are covered = in this=20 module:

  • Enabling=20 HTTP Access to SQL Databases=20
  • Publishing=20 XML Templates on the Server=20
  • Posting=20 Query Templates from the Client=20
  • Publishing=20 a Database Object=20
  • Lab=20 5.1: Publishing a SQL Server Database=20
  • Lab=20 5.2: Using XML Templates

After completing this module, = students will=20 be able to access and manipulate data on a server from a remote = client.=20 This includes:

  • Creating=20 an IIS virtual directory that references a SQL Server 2000 = database.=20
  • Testing=20 the HTTP connectivity to a SQL Server 2000 database.=20
  • Creating=20 an XML template to retrieve XML data over HTTP.=20
  • Creating=20 a client that uses the POST method to publish templates to SQL = Server=20 2000.=20
  • Using=20 HTTP to gain access to database objects.

Module 6: Using Mapping Schemas

The following topics are covered = in this=20 module:

  • Using=20 Mapping Schemas=20
  • Using=20 Schemas to Retrieve Data=20
  • Mapping=20 Multiple Tables=20
  • Annotating=20 an Existing Schema=20
  • Lab=20 6.1: Using Mapping Schemas=20
  • Lab=20 6.2: Mapping Multiple Tables=20
  • Lab=20 6.3: Annotating an Existing Schema

After completing this module, = students will=20 be able to create and use annotated schemas. This includes:

  • Describing=20 the uses and structure of annotated schemas.=20
  • Creating=20 annotated schemas that map business documents to database = entities.=20
  • Using=20 XPath to access data through an annotated schema.=20
  • Using=20 ADO to request data by using an annotated schema.=20
  • Accessing=20 data by using a schema over HTTP.

Module 7: XML for SQL Tools

The following topics are covered = in this=20 module:

  • Modifying=20 Data with Updategrams=20
  • Inserting=20 Data with the Bulk Load Facility=20
  • Lab=20 7.1: Using Updategrams=20
  • Lab=20 7.2: Bulk Loading XML Data

After completing this module, = students will=20 be able to modify data by using Updategrams and load large amounts = of data=20 into SQL Server databases. This includes:

  • Inserting,=20 updating, and deleting data by using Updategrams=20
  • Loading=20 XML data into SQL Server tables by using the Bulk Load facility. =


 

Legal = Information=20

Last updated: 4/24/2001 2:34:35=20 PM

=A9 2001 = Microsoft=20 Corporation. All rights reserved. Terms of Use.