Exchanging and Transforming Data Using XML and XSLT
Program Outline
Module 1: Overview of XML and XSLT
The following topics are covered in this module:
Representing Data with XMLTransforming XML Documents with XSLTUsing XML and XSLT to Build SolutionsAfter completing this module students wll be able to:
Describe the syntax of XML documents.Describe the purpose of XSLT style sheetsDescribe typical problems that XSLT style sheets are used to solve.Module 2: Selecting and Navigating Nodes Using XPath
The following topics are covered in this module:
Introducing XPathAccessing Node InformationNavigating a Document Using Location PathsUsing Operators and Functions in Location PathsLab 2.1: Accessing Node InformationLab 2.2: Selecting and Navigating Nodes Using XPathAfter completing this module you will be able to use Xpath to traverse nodes in a tree. This includes:
Using XPath expressions within the Document Object Model (DOM) methods selectNodes() and selectSingleNode().Writing XPath location paths to select specific nodes from an XML document.Writing conditional expressions in XPath.Using XPath operators and functions to write more sophisticated expressions.Module 3: Introducing XSLT
The following topics are covered in this module:
Introducing XSLTTemplate RulesEnhancing Template RulesLab: Defining and Using Template RulesAfter completing this module you will be able to explain and implement the rules for using templates in XSLT. This includes:
Applying an XSLT style sheet to an XML document both statically and dynamically.Defining and instantiating template rules to make use of the transformation capabilities of XSLT.Module 4: Refining and Combining Style Sheets
The following topics are covered in this module:
Sorting Document ContentControlling Document OutputIncluding and Importing Style SheetsLab: Refining and Combining XSLT Style SheetsAfter completing this module you will be able to sort the contents of an XML document and use style sheets. This includes:
Specifying a sort order for the result document alphabetically or numerically in ascending or descending order.Specifing number formats for the result document.Specifing whether white space in the result document is stripped or preserved.Including one style sheet inside another.Importing one style sheet into another.Overriding imported template rules in the main style sheet.Module 5: Programming with XSLT
The following topics are covered in this module:
Named TemplatesVariables and ParametersPerforming Repetition and Conditional ProcessingUsing XSLT Extension Elements and FunctionsLab: Programming with XSLTAfter completing this module you will be able to write code to perform tasks in XSLT. This includes:
Defining and calling named templates.Using named templates to organize a style sheet effectively.Defining variables to represent complex expressions.Defining parameters for a template rule or a style sheet.Performing repetition and conditional logic within a template.Using extension elements and extension functions.Module 6: Defining XML Grammar and Data Types
The following topics are covered in this module:
Defining and Using XML SchemasDefining Elements in an XML SchemaDefining Attributes in an XML SchemaDefining Data Types in an XML SchemaXML Schemas and ADOLab: Defining XML Grammar and Data TypesAfter completing this module you will be able to create and use an XML Schema. This includes:
Creating an XML Schema definition.Applying an XML Schema to an XML document.Using an XML Schema to define the grammar of an XML document.Using an XML Schema to describe the content data types in an XML document.Module 7: Creating and Changing XML Structure with XSLT
The following topics are covered in this module:
Creating New Structure Using XSLTAfter completing this module you will be able to create a new XML structure by using XSLT. This includes:
Creating new elements in a result document.Defining attributes and namespaces for new elements.Inserting numbered text into a result document.Adding processing instructions and comments to a result document as necessary.Module 8: Cross-Referencing Documents Using XSLT
The following topics are covered in this module:
Accessing Multiple XML Documents in a Style SheetIntroducing Cross-ReferencesGenerating Cross-References in Result DocumentsLab: Cross-Referencing Documents Using XSLTAfter completing this module you will be able to cross-reference documents by using XSLT. This includes:
Writing XSLT style sheets that access and transform multiple XML documents.Defining keys to identify nodes in an XML document.Using keys to access nodes in the same XML document or a different XML document.Generating cross-references in the result document of an XSLT transformation.Module 9: Manipulating XML Documents Using SAX
The following topics are covered in this module:
Overview of SAXUsing SAX InterfacesLab: Manipulating XML Documents Using SaxAfter completing this module you will be able to use the SAX interfaces to manipulate XML documents. This includes:
Identifying situations where it is more useful to manipulate XML documents by using SAX than by using the DOM.Choosing the correct SAX COM interface and methods to handle typical programming tasks associated with manipulating an XML document.Creating an application with Visual Basic that uses SAX to manipulate an XML document.Module 10: Putting It All Together
The following topics are covered in this module:
Scope and Purpose of the Northwind Traders Web SiteLab: Northwind Traders Web SiteAfter completing this module you will be able to use all of the skills you learned in this course to transform and manage data by using XSLT. This includes:
Making appropriate use of XSLT and XML technical features.Creating XML documents from a database by using Microsoft ActiveX Data Objects (ADO) in an ASP page.Writing style sheets to transform XML into HTML or another XML grammar.Applying a style sheet dynamically at the Web browser or the Web server.Embedding XML documents and XSLT style sheets as data islands in HTML.Using the DOM to modify an XSLT style sheet dynamically.Using the DOM to create new XML content dynamically.Integrating ASP pages and XSLT style sheets with COM.Posting XML data from a Web browser to a Web server.Designing and using XML Schemas to validate XML structure and content.Related Exams
There is no Microsoft Certified Professional exam associated with this course.
Student Pre-Requisites
A moderate degree of Web development experience using HTML and XML.A moderate degree of experience scripting with Visual Basic for Applications VBScript or JavaScript.Some prior experience using COM objects Active Server Pages (ASP pages) and either Visual Basic or Microsoft Visual C++ .Taking one or more of the following courses will help the students meet the prerequisites and get more out of the course:Course 1905
Building XML-Based Web ApplicationsCourse 1013
Mastering Microsoft Visual Basic 6 DevelopmentCourse 1017
Mastering Web Application Development Using Microsoft Visual InterDev 6
Student Materials
The student kit includes a comprehensive workbook and other necessary materials for this class. This includes a student CD with supporting files for:
LabsPracticesDemonstrationsYou will be provided with the following software for use in the classroom:
Microsoft Windows 2000 ServerMicrosoft Internet Information ServerMicrosoft Windows 2000 Service Pack 1Microsoft SQL Server™ 2000 Standard EditionMicrosoft Visual Studio 6.0 Enterprise EditionMicrosoft Visual Basic 6.0Microsoft Visual Studio 6.0 Service Pack 4Microsoft Internet Explorer 5.5Microsoft XML Parser 3.0Internet Explorer Tools for Validating XML and Viewing XSLT Output
Program Goals
After completing this course students will be able to define XML Path Language (XPath) expressions to locate and filter the content of an XML document; define XSLT style sheets to transform XML documents at the Web browser and Web server; create and change XML structure by using XSLT; use XSLT to merge different XML documents and generate cross-references between them; and create a Visual Basic application that uses the Simple API for XML (SAX) to access large XML documents.
