Complete Guide to XML For Microsoft Developers

Course Curriculum

Chapter 1: Introduction

Lecture 1: Video Review of Course Outline

Lecture 2: Why I Use Total Commander In All the Course Videos

Lecture 3: XML – The Big Overview

Lecture 4: Course Downloads Video Preview (Actual download is in next lesson)

Lecture 5: Course Downloads (Zip File)

Chapter 2: Basics of XML

Lecture 1: XML Files with Elements and Nesting (Flight01/Flight02) and Empty Element

Lecture 2: XML Files with Attributes (Flight03-07)

Lecture 3: XML Files – Misc Features – Declarative, Comments (Sample01)

Lecture 4: XML Encoding Special Characters (Sample02) – Intro to PowerShell

Lecture 5: XML Unicode & Byte Order Mark (Sample03_Unicode.xml)

Lecture 6: XML to JSON (using PowerShell and NewtonSoft .Net Library)

Lecture 7: XML to JSON – PowerShell – formatting/indenting

Lecture 8: Bonus: Example of JSON use in JavaScript

Lecture 9: Finding Well-Formed Errors (The Divide and Conquer Method)

Chapter 3: XML Tools: Editors & Browsers

Lecture 1: Editing XML with NotePad++

Lecture 2: Editing XML with Visual Studio (2019)

Lecture 3: Adding Xpath Tools (Extension) to Visual Studio (From Marketplace)

Lecture 4: Editing XML with VS Code

Lecture 5: Microsoft XML Notepad

Lecture 6: Commerical Tools: Stylus Studio, XML Spy, Oxygen

Lecture 7: How Browsers handle XML (normal, with errors, with stylesheet)

Chapter 4: XPath

Lecture 1: XPath Intro – and How to Practice Answers for Quizes in this Module

Lecture 2: Simple element selection (including subscripts and text())

Lecture 3: Attributes and simple "where" clauses

Lecture 4: More where clauses (elements and/or)

Lecture 5: Relative paths

Lecture 6: XPath Axes – Documentation and Samples

Lecture 7: Namespaces – Part 1

Lecture 8: Namespaces – Part 2

Lecture 9: Real world, difficult XPath

Lecture 10: Functions: Count, Sum, Contains, Starts-With

Chapter 5: C# Programming – XmlDocument and XPath

Lecture 1: C# XML – XMLDocument – Load, LoadXML, Save, PrettyPrint

Lecture 2: XMLDocument, SelectNodes, SelectSingleNode, GetElementsByTagName

Lecture 3: XMLDocument – pretty print to a string

Lecture 4: XMLDocument – Navigation: NextSibling, PreviousSibling, ParentNode

Lecture 5: Validate XML data against a Schema

Lecture 6: Add a new attribute to existing element

Lecture 7: Add a new element to existing element

Lecture 8: Removing elements and attributes (XmlNode Properties/Methods)

Lecture 9: C# Assignment – – Getting values from an XML Config FileC

Lecture 10: C# Assignment Solution – Getting values from an XML Config FileC

Chapter 6: C# and LINQ/XML

Lecture 1: Loading and Creating XML using LINQ in C#

Lecture 2: Querying XML with LINQ in C#

Lecture 3: Using LINQ Query Expressions with XML Data in C#

Chapter 7: XSD Schemas

Lecture 1: XSD Schema Intro (also mention DTD, XDR Schemas, RelaxNG, Schematron)

Lecture 2: Generate Schema from Web – Validation in NotePad++

Lecture 3: PowerShell – using .Net Library – Schema Inference

Lecture 4: XSD Elements and Attributes

Lecture 5: XSD Restrictions

Lecture 6: XSD Empty, Elements Only, Text Only, Mixed

Lecture 7: XSD Indicators, All, Choice, Sequence, maxOccurs, MinOccurs, Groups

Lecture 8: Any Element and anyAttribute

Lecture 9: XSD Data Types

Lecture 10: Allowing Nulls with "Nillable"

Lecture 11: Validating the Schema Syntax in C#

Lecture 12: Discussion of Schema Editors (and Demo of BizTalk)

Lecture 13: Industry Standard Schemas – Example OAGIS

Lecture 14: Schema/Contract Development

Chapter 8: XSLT -Extensible Style Sheet Language

Lecture 1: How Mapping Fits into the Business Processes

Lecture 2: HelloWorld Example – Running .NET XSLT 1.0 in PowerShell

Lecture 3: HelloWorld Example – Running Saxon XSLT 3.0 in PowerShell

Lecture 4: ForEach and ApplyTemplates

Lecture 5: If/Test and Choose/When (Long Version with Errors/Debugging)

Lecture 6: If/Test and Choose/When (Short pre-canned version)

Lecture 7: Variables in XSLT

Lecture 8: Sort

Lecture 9: Key and Xpath Lookup

Lecture 10: Muenchian Grouping in 1.0 and new feature in 3.0

Lecture 11: XSLT – Assignment 1 – Map Shakespeare Play to New XML

Lecture 12: XSLT – Assignment 1 – Solution

Lecture 13: XSLT – Assignment 2 – Build HTML Web Page from Flight03

Lecture 14: XSLT – Assignment 2 – Solution – Part 1 of 3

Lecture 15: Assignment 2 – Solution – Part 2 of 3

Lecture 16: Assignment 2 – Solution – Part 3 of 3

Chapter 9: XQuery

Lecture 1: Introduction (Slide Presentation)

Lecture 2: Saxon.exe – Example Flight03.xml

Lecture 3: Saxon.exe – Example Shakespeare Hamlet.xml

Lecture 4: Saxon.exe – Example Videos.xml – join and multiple FLWOR

Lecture 5: XQuery in SQL Server Queries

Lecture 6: PowerShell Examples (Saxonica and SQL/XQuery)

Chapter 10: C# Programming with Saxonica API