Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business E-Commerce XML

Complete Guide to XML For Microsoft Developers

XML, XPATH, XSLT, XQuery, XSD, XML in SQLServer, C#, LINQ, and PowerShell, Saxonica
Bestseller
Rating: 4.4 out of 54.4 (30 ratings)
277 students
Created by Neal Walters
Last updated 6/2020
English
English [Auto]
30-Day Money-Back Guarantee

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++

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

Course content

15 sections • 125 lectures • 16h 37m total length

  • Preview08:23
  • Preview06:50
  • Preview26:05
  • Preview02:36
  • Course Downloads (Zip File)
    00:07

  • XML Files with Elements and Nesting (Flight01/Flight02) and Empty Element
    07:24
  • Preview06:04
  • 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

  • Preview15:52
  • 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 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
  • XPath Practice Quiz 1
    5 questions
  • More where clauses (elements and/or)
    06:30
  • Relative paths
    07:38
  • XPath Practice Quiz 2
    4 questions
  • XPath Axes - Documentation and Samples
    09:56
  • Namespaces - Part 1
    11:23
  • Namespaces - Part 2
    12:16
  • XPath Practice Quiz 3
    5 questions
  • Real world, difficult XPath
    06:09
  • Functions: Count, Sum, Contains, Starts-With
    09:40
  • XPath - Practice Quiz with Functions
    3 questions

  • Preview08:25
  • 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

  • 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 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

  • How Mapping Fits into the Business Processes
    04:35
  • Preview10:00
  • 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

  • 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

  • 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

Instructor

Neal Walters
BizTalk Consultant
Neal Walters
  • 4.5 Instructor Rating
  • 285 Reviews
  • 1,511 Students
  • 5 Courses

I’m a former Microsoft Certified Trainer and went to the Train-The-Trainer Bootcamp held by Microsoft in Redmond back in about 2004.

After that I was a stand-up instructor travelling around the US and Canada teaching BizTalk for a year or so,

THEN I went into BizTalk Consulting and have been doing it ever since.


  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.