2020-06-23 14:02:42
Complete Guide to XML For Microsoft Developers
43 students enrolled
Complete Guide to XML For Microsoft Developers
XML, XPATH, XSLT, XQuery, XSD, XML in SQLServer, C#, LINQ, and PowerShell, Saxonica
New
43 students enrolled
Current price: $104.99
Original price: $149.99
Discount:
30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
- 16.5 hours on-demand video
- 1 article
- 1 downloadable resource
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Training 5 or more people?
Get your team access to 4,000+ top Udemy courses anytime, anywhere.
Try Udemy for Business
What you'll learn
- Uses and History of XML and Basics of Well-Formed XML
- Mapping XML using XSLT (1.0 and 3.0, including Saxon Library)
- XPath (used in XSLT, XQuery, and programming)
- SQL XML, reading XML into SQL, processing XML Columns
- Using C# to Process XML, XPath, XSLT, and XQuery
- Using PowerShell to Process XML
- Creating HTML from XML (using XSLT)
- Extracting and Formatting XML from SQL databases
- Serialization and Deserialization (to and from XML)
- Use of the XSD utility to generate schemas from classes and classes from schemas
- Converting XML to JSON using Newtonsoft Json library
- Using PlugsIns to making working with XML easier in Visual Studio, VSCode, and NotePad++
Course content
Expand all
125 lectures
16:37:28
+
–
Introduction
5 lectures
44:01
Course Downloads (Zip File)
00:07
+
–
Basics of XML
9 lectures
47:18
XML Files with Elements and Nesting (Flight01/Flight02) and Empty Element
07:24
XML Files - Misc Features - Declarative, Comments (Sample01)
01:24
XML Encoding Special Characters (Sample02) - Intro to PowerShell
08:56
XML Unicode & Byte Order Mark (Sample03_Unicode.xml)
07:15
XML to JSON (using PowerShell and NewtonSoft .Net Library)
04:46
XML to JSON - PowerShell - formatting/indenting
01:06
Bonus: Example of JSON use in JavaScript
06:56
Finding Well-Formed Errors (The Divide and Conquer Method)
03:27
Intro To XML - Quiz
10 questions
+
–
XML Tools: Editors & Browsers
7 lectures
54:33
Editing XML with Visual Studio (2019)
05:54
Adding Xpath Tools (Extension) to Visual Studio (From Marketplace)
05:26
Editing XML with VS Code
07:18
Microsoft XML Notepad
08:45
Commerical Tools: Stylus Studio, XML Spy, Oxygen
03:58
How Browsers handle XML (normal, with errors, with stylesheet)
07:20
XML Tools - Quiz
6 questions
+
–
XPath
10 lectures
01:27:17
XPath Intro - and How to Practice Answers for Quizes in this Module
02:36
Simple element selection (including subscripts and text())
11:20
Attributes and simple "where" clauses
09:49
5 questions
More where clauses (elements and/or)
06:30
Relative paths
07:38
4 questions
XPath Axes - Documentation and Samples
09:56
Namespaces - Part 1
11:23
Namespaces - Part 2
12:16
5 questions
Real world, difficult XPath
06:09
Functions: Count, Sum, Contains, Starts-With
09:40
XPath - Practice Quiz with Functions
3 questions
+
–
C# Programming - XmlDocument and XPath
10 lectures
01:31:39
XMLDocument, SelectNodes, SelectSingleNode, GetElementsByTagName
18:41
XMLDocument - pretty print to a string
06:39
XMLDocument - Navigation: NextSibling, PreviousSibling, ParentNode
14:21
Validate XML data against a Schema
08:05
Add a new attribute to existing element
10:55
Add a new element to existing element
05:55
Removing elements and attributes (XmlNode Properties/Methods)
03:02
C# Assignment - - Getting values from an XML Config FileC
01:55
C# Assignment Solution - Getting values from an XML Config FileC
13:41
C# XMLDocument Quiz
5 questions
+
–
C# and LINQ/XML
3 lectures
17:22
Loading and Creating XML using LINQ in C#
03:11
Querying XML with LINQ in C#
08:31
Using LINQ Query Expressions with XML Data in C#
05:40
+
–
XSD Schemas
14 lectures
01:37:56
XSD Schema Intro (also mention DTD, XDR Schemas, RelaxNG, Schematron)
02:47
Generate Schema from Web - Validation in NotePad++
06:40
PowerShell - using .Net Library - Schema Inference
04:26
XSD Elements and Attributes
12:46
XSD Restrictions
23:01
XSD Empty, Elements Only, Text Only, Mixed
05:17
XSD Indicators, All, Choice, Sequence, maxOccurs, MinOccurs, Groups
05:01
Any Element and anyAttribute
05:53
XSD Data Types
03:59
Allowing Nulls with "Nillable"
04:03
Validating the Schema Syntax in C#
02:21
Discussion of Schema Editors (and Demo of BizTalk)
10:22
Industry Standard Schemas - Example OAGIS
06:07
Schema/Contract Development
05:13
XSD Schema Quiz
1 question
+
–
XSLT -Extensible Style Sheet Language
16 lectures
02:48:22
How Mapping Fits into the Business Processes
04:35
HelloWorld Example - Running Saxon XSLT 3.0 in PowerShell
07:13
ForEach and ApplyTemplates
06:39
If/Test and Choose/When (Long Version with Errors/Debugging)
24:07
If/Test and Choose/When (Short pre-canned version)
06:27
Variables in XSLT
12:47
Sort
03:06
Key and Xpath Lookup
03:44
Muenchian Grouping in 1.0 and new feature in 3.0
09:25
XSLT Quiz
1 question
XSLT - Assignment 1 - Map Shakespeare Play to New XML
02:20
XSLT - Assignment 1 - Solution
27:23
XSLT - Assignment 2 - Build HTML Web Page from Flight03
01:07
XSLT - Assignment 2 - Solution - Part 1 of 3
12:03
Assignment 2 - Solution - Part 2 of 3
16:59
Assignment 2 - Solution - Part 3 of 3
20:27
+
–
XQuery
6 lectures
47:05
Introduction (Slide Presentation)
15:43
Saxon.exe - Example Flight03.xml
08:58
Saxon.exe - Example Shakespeare Hamlet.xml
05:36
Saxon.exe - Example Videos.xml - join and multiple FLWOR
05:07
XQuery in SQL Server Queries
03:17
PowerShell Examples (Saxonica and SQL/XQuery)
08:24
XQuery Quiz
7 questions
+
–
C# Programming with Saxonica API
4 lectures
20:48
Saxonica .NET API = Downloading and Documentation
02:34
Saxonica XPath in C#
06:24
Saxonica XSLT in C#
04:49
Saxonica XQuery in C#
07:01
C# Programming with Saxonica API
4 questions
Requirements
- While not required, general knowledge of C# and Visual Studio would be useful
- While not required, experience in some programming language would be useful
- While not required, knowledge of HTML would be useful for one of the exericses
Description
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.
Who this course is for:
- C# developers who want to use XML, XPath, XSLT, and XQuery
- PowerShell developers who want to use XML, XPath, XSLT, and XQuery
- SQL developers who want to use use XML, XPath, XSLT, and XQuery
- BizTalk Integration (Middleware) Developers who want a well-rounded background in XML and the surrounding technologies