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 .NETlibraries, and what additional features are available by using the third party Saxonica .NETlibraries. You will learn how to create and understand XSDSchemas, and how to validate an XMLfile against a schema. The programming languages covered as they relate to XMLareC#, 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 SQLServer, you will learn 1) how to use XMLcolumns, 2)how to format relational data as XML using the “For XML” clause, and 3) how to take an XMLfile and query it inSQL, then store it into relational tables. The course includes the most popular tools used on Windows platforms, including Visual Studio, NotePad++, VSCode, and XMLNotePad.
