
Explore the complete guide to xml for Microsoft developers, covering xpath, xslt, xquery, xsd, and json interoperability, plus practical C-sharp xml handling and sql xml workflows.
Learn why I use Total Commander, an orthodox file manager on Windows, to quickly locate, view, edit, rename, compare, and transfer XML files with Notepad++ integration.
Explore the course downloads bundle, featuring xml tutorials, xsd classes, xquery and xslt examples, sql integration for xml, PowerShell scripts, and ready-to-run demo assets.
Explain XML basics through flight data, showing a root element, nesting levels, and the empty element shorthand, and illustrate one-to-many relationships like reservations and legs.
Explore XML declarative statements and comments in sample01, including the XML declaration with version 1.0 and encoding, and how to use <!-- ... --> and ampersand entity codes like &.
Explore encoding of special characters in XML using sample two, covering ampersand, less than, greater than, quotes, CDATA, and decimal/hex character entities, with PowerShell data extraction examples.
Learn how to save XML as UTF-16 with a byte order mark, compare ANSI versus Unicode file sizes, and verify encoding using simple viewers and a PowerShell demo.
Demonstrates how json works naturally in javascript within VS Code using Code Runner, including creating objects, serializing with Json.stringify, and deserializing with Json.parse for web data.
Discover how to use Notepad++ XML tools and plugins for syntax checking, well-formedness validation, XPath, XSLT transformations, escaping, and quick XML navigation with a tree view.
Edit XML in Visual Studio 2019, format documents quickly, and use the create schema feature with IntelliSense to guide flight data elements and attributes.
Install and use the XPath tools extension in Visual Studio to copy XPath expressions and run them against XML files, using the XPath runner and context menu.
Learn to use Visual Studio Code with the XML Tools extension to format XML, view a tree, and navigate documents with the F1 command palette, XPath, and attributes.
Discover how Microsoft XML Notepad helps you edit XML with a tree view, manipulate elements and attributes, compare files, and use XPath for navigation.
Shows how browsers render an XML file like flights 01.xml, compares Chrome and Internet Explorer, and displays errors from malformed XML; demonstrates using a stylesheet (XSLT) to render HTML.
Explore simple to advanced XPath techniques, including subscripts and text(), and learn to test XML queries using XPath Tester, Notepad++, VS Code, and Visual Studio across practical examples.
Master using attributes in XPath and build simple where clauses to filter flights by sequence numbers using the @ syntax. Compare inner XML and text values across tools.
Explore using where clauses for elements in XPath, including flight number and arrival codes, with and without quotes. Learn to debug, combine conditions, and prepare for relative paths.
Learn XPath querying to find flight legs by flight number 1849 and extract arrival airport codes, using // and dot dot syntax, with where clauses and test examples.
Learn real-life xpaths and for-each patterns used in xslt, including predicates, nested brackets, and local-name with namespaces to query books by category and author.
Master XPath functions to query XML data, using count to tally elements and sum to total numeric fields. Explore contains, starts-with, and substring before to filter nodes and extract values.
Learn how C# handles XML with XMLDocument: load from file or string, save and pretty print, and view via outer XML while managing whitespace and exceptions, preparing for XPath later.
Discover how to convert an XML document to a formatted string in C#. Use an XML formatter with a pretty print extension method to produce XML with a string writer.
Explore XML document navigation with next-sibling, previous-sibling, and parent node methods. Demonstrates navigating a sample XML tree, retrieving node names, values, and attributes, including first child and get attribute.
Learn to validate an XML file against an XSD schema with a boolean method that accepts xml and schema paths and reports validation results for valid and invalid cases.
Practice extracting values from an xml config file using a C# helper class. Retrieve the smtp server, sender email, and branch code, and test with multiple branches.
Explore loading and creating XML in C# with LINQ, using XElement and XDocument, parse vs load, and build XML dynamically with C# constructors through flight file and Game of Thrones.
Learn to query XML using LINQ in C#, compare it with XPath, and extract character names, actors, and status attributes from a Game of Thrones XML sample.
Generate and validate an XML schema from a flight data sample using PowerShell, then explore XSD elements, complex and simple types, minOccurs and maxOccurs, and attributes with online validators.
Learn how xsd restrictions use simple types, enumerations, patterns, and length facets to validate xml data, including four-digit flight numbers and airline codes.
Explore complex XML element types, including elements only, empty elements, text only, and mixed content. See how attributes fit with elements and how a flight schema demonstrates these patterns.
Explore three XML strategies for representing missing data: empty strings, missing elements, and nil using a Z namespace, with nullable true in the schema and validation examples.
Learn how to validate xml schema syntax in C# using the validate xml file against the schema routine, identify errors like 'string not declared', fix the schema, and revalidate.
Explore available XML schema editors, compare free and paid tools, and demo BizTalk's Visual Studio schema editor, including editing XSDs, generating instances, validating data, and mapping schemas.
Explore industry standard xml schemas, including the open application group (ogis) schemas, their extensibility, annotations, and examples like purchase order, used across mortgage and health care sectors.
Run saxon XSLT 3.0 from PowerShell to transform sources into HTML and XML. Compare outputs, use two stylesheets, and consider upgrading from 1.0 to 3.0.
Convert an XML flights file into an HTML table using for each and apply templates in XSLT, demonstrating two approaches to transform XML to HTML for web display.
Explore conditional processing in XSLT and XML with if statements and the choose/when construct, including else via otherwise, plus debugging tips and formatting.
Learn conditional processing in XSLT with if and choose statements to color table rows by airline IATA codes, using booleans, XPath tests, and an otherwise fallback.
Learn to define and use XSLT variables, referencing them with dollars, combining literals with variables via concat, and using min/max for data in a flights example.
Learn to sort flight numbers in XML using an xsl:sort statement within an apply template, choosing text or number data types and ascending or descending order.
Learn how to perform airport code lookups in XSLT 3 using key and XPath to map codes to city and state names, with a DFW example.
Map the Macbeth xml data with xslt by structuring play, title, acts, scenes, and scene descriptions as attributes, including stage directions and the first speaker, plus a bonus list.
Illustrates solving an XML XSLT assignment by building a Shakespeare play-rooted output with nested for-each loops, extracting title attributes and first speakers via XPath.
Use the flight three XML file to build an HTML page that maps data from XML into a basic format, demonstrating one-to-many relationships; you may use provided icons and logos.
Transform a reservation XML into an HTML report with XSLT by looping over flights, computing first and last dates, and displaying origin and destination airports with a plane image.
Troubleshoot xslt output from the dos command line, fix html break issues and invalid amps; implement key lookups, variables, and substring-based date formatting with xpath, then render and save results.
Explore building an itinerary in XML using XSLT to loop over flights and legs, compute durations, format times, and present output with CSS, tables, and payment details.
Explore the XML query language Xquery, its declarative syntax, its differences from XSLT, and practical tools like Saxon, BaseX, and XML databases; learn core concepts and basic queries.
Learn to run xquery and xslt with saxon.exe on windows using saxonica tools, batch files, and command-line parameters to transform and query xml.
Learn how to run XQuery against a Shakespeare Hamlet xml file using Saxon, compare formats from Folger and ibiblio, fix dtd issues, and generate html with act and speaker lists.
Learn to run XQuery and XPath in SQL Server via the query command, using an XML variable loaded from disk to generate HTML output of the Shakespeare play.
Learn to run XPath queries in C# with the Saxonica API, including single and multiple evaluations and a 3.0 concatenation example on flight 03 XML.
Learn to call Saxon XSLT from C# using the Saxon .NET API, transforming XML with a test XSLT against the Flight zero three input and writing output to a file.
Run Saxonica XQuery from C#, set input and output files, compile and execute the query, and serialize results with pretty printing, using in-memory or disk-based inputs and the Saxon API.
This course is for Microsoft developers who want a well-rounded approach to XML on the entire Microsoft product-line. It is based on my 19 years of consulting and teaching XML and B2B/Integration. To be a well-rounded developer or architect, you need to be aware of all these features; and that's especially true for BizTalk and Integration Developers.
In addition to learning XML, you will learn XPath, XSLT (Extensible Stylesheet Language - used to map XML to another XML or HTML), and XQuery. The course shows what is possible with the Microsoft .NET libraries, and what additional features are available by using the third party Saxonica .NET libraries. You will learn how to create and understand XSD Schemas, and how to validate an XML file against a schema.
The programming languages covered as they relate to XML are C#, PowerShell, and T-SQL. You will learn how to read and write XML, and how to navigate and find elements and values in the XML, and how to modify the XML (for example, adding new elements or new attributes).
In Microsoft SQL Server, you will learn 1) how to use XML columns, 2) how to format relational data as XML using the "For XML" clause, and 3) how to take an XML file and query it in SQL, then store it into relational tables.
The course includes the most popular tools used on Windows platforms, including Visual Studio, NotePad++, VSCode, and XMLNotePad.