MS SQL Server 2022 - XML ​​Integration

Course Overview

ID 2101003
Duration 2.0 days
Methods Lecture with examples and exercises.
Prerequisites Basics of MS SQL Server
Target group Programmers, Web developers
Vorgängerkurs 2101001

Overview

For the exchange and storage of complex import/export data or structured content, MS SQL Server offers its own functionality and support for XML. This seminar will show you how XML is stored in the database, read, and used in application development. This includes generating XML from relational data using T-SQL queries and decomposing incoming XML streams back into relational database structures. For XML processing, you will learn how to use XQuery, XPath, and XSLT directly in the database.

Dates

OPEN
IN-HOUSE

Zurzeit stehen keine offenen Termine zur Verfügung. Nutzen Sie alternativ die Inhouse‑Option.

Learn with customized examples and content—precisely tailored to your requirements.

Your benefits at a glance

  • Flexible preferred date
  • Customized content
  • Intensive exchange
  • High practical relevance

Description

See how to use T-SQL in MS SQL Server to generate XML data from relational data and integrate and process XML data in the database.

Services

  • Lunch / catering
  • Help with hotel / travel
  • Comelio certificate
  • Flexible: free cancellation up to one day before
Service-Kaffeekanne

Comelio Media

Still looking for additional reading? Discover suitable specialist books in our catalog.

Go to book catalog

Content

Relational data in XML

Simple queries: Basics, automatic conversion, handling empty values ​​- Creating multi-level documents: Using PATH and EXPLICIT - Hierarchical documents

Saving, querying, and processing XML

Decomposing XML - Complex decomposition with XPath

Querying and processing XML

Overview of XPath and XQuery - Processing and querying with data type methods - Using XPath and XQuery

Using XML Schema

Overview and syntax of XML Schema - Creating, registering, and using XML Schema definitions – Validating XML data – Typing columns and variables with XML Schema

Using XSLT

Overview and syntax of XSLT - Creating an XSLT processor in .NET and using it in MS SQL Server – Using XSLT in T-SQL - Parameterized XSLT stylesheets

XML and Integration Services

Using XML as an input format for ETL processes – Using XML tasks in Integration Services packages – ETL and XSLT and XML Schema

Instructor

Marco Skulschus studied economics in Wuppertal and Paris with a focus on business informatics and has been working for over 10 years as a lecturer and developer for data warehouse and database solutions using MS SQL Server and the Microsoft BI Stack. He is also an author of specialist books and has participated in various research projects.

Publications

  • MS SQL Server - T-SQL Abfragen und Analysen (Comelio Medien )
    978-3-939701-93-4
  • MS SQL Server - Implementierung, Administration und Programmierung mit T-SQL (Comelio Medien )
    978-3-939701-71-2
  • MS SQL Server 2014 - XML-Integration mit T-SQL (Comelio Medien )
    978-3-939701-97-2
  • SQL und relationale Datenbanken (Comelio Medien )
    978-3-939701-52-1

Projects

As a developer, Mr. Skulschus designs business intelligence systems based on MS SQL Server and Azure SQL, including reporting components, statistical analyses, and data mining modules. His major projects include the development of a data warehouse for public administration using German tax data for analyses and forecasts of tax revenues, federal expenditures, and population development. He has participated in data warehouse projects for banks and insurance companies and has developed multi-tiered database solutions using 3NF, Data Vault, and the star schema.

Research

He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Certificates

Marco Skulschus is a Microsoft Certified: Power BI Data Analyst Associate, a Microsoft Certified: Fabric Analytics Engineer Associate, a Microsoft Certified Trainer, and has completed various other Microsoft certifications.