Lesson Six

• A list of some XML Application Standards
• Interaction of MySQL and XML
• A sample XML file (playlist)
• A sample XML file with CSS (playlist)
• The stylesheet for playlist.xml
• Application Users (from Wrox)
• Application Users with XSLT
• The XSL for Application Users
• Custom XML Entities (XML text)
• Custom XML Entities (XML file)
• Example of CDATA (Java sorting)
• Example of CDATA with XSLT
• The XSLT for the Java code
• Preserving white-space (Breakfast)
• The XSL for Breakfast
• An XML file with errors (from Wrox)
• The text version
• An XML text file ready for CSS styling

Lesson Seven (DTD)

• Case study: eCTD DTD for Drug Submissions
• The text of the internationally harmonized eCTD DTD
• Using Attribute Types ID / IDREF (Macbeth XML file)
• Using Attribute Types ID / IDREF (Macbeth XML text)
• Basic Book Catalog (XML file)
• Basic Book Catalog (XML text)
• Expanded Book Catalog (XML file)
• Expanded Book Catalog (XML text)

Lesson Seven (XML Schema)

• Product (XML file)
• Product (XML text)
• XML Schema for Product
• Order (XML file with reference)
• Order (XML text)
• XML Schema for Order
• Catalog (XML text with <any> against XHTML Schema)
• XML Schema for Catalog
• Using Multiple Schemas
• Useful references
  • XML Schema Best Practices (Burton Group). ** Excellent read!
  • XML Schema Best Practices (HP)
  • Security vulnerabilities with looser use of XML Schema (HP)
  • Examples from "Definitive XML Schema"

Lesson Eight

• XPath
• Tour Through XPath Expressions
• Football (XML file)
• Football (XML text)
• Sports (XML file)
• Sports (XML text)
• XSLT
• People(XML file)
• Transform People (XSL file)
• Landslide lyrics (XML file)
• Transform Landslide (XSL file)
• HTML result of transformation
• XSL to count unique words
• XML result of "WordCount" transformation
• Golf Country Club (XML file)
• Using avg() to calculate an average handicap (XSL file)
• HTML result of transformation
• Using replace() and number to count multiple things (XSL file)
• HTML result of transformation
• Job postings (XML file w/o namespaces)
• Using XSL for-each (XSL file)
• Output: qualifications (HTML file)
• lunch.xml
• Using XSL apply-templates and number (to produce lunch menu in table)
• Resulting lunch menu
• Using XSL choose, call-template and position() (mark premium and veg entrees)
• Marked up lunch menu
• Using XSL sort
• Sorted lunch menu
• An XML file to demo copy-of and value-of ("Dolly", XML file)
• XSL using copy-of and value-of (XSL file)
• Output from tranforming Dolly
• Famous People (XML file - note uppercase P in People)
• Months.xml (XML file to be stored in a variable)
• Using document(), variable and with-param (XSL file)
• Results of transformation
• Using for-each-group against sports.xml
• Transformed XML file (players by position)
• iTunes: songs by artist (using for-each-group and result-document)
• Useful references
  • XSLT functions
  • XSLT data types
• Assignments: for XSLT

Lesson Nine: Advanced Topics