Generating and Consuming XML

Code: GCXML

Description

-

Audience

This course is designed for programmers that need to generate and consume XML with SQL

Prerequisites

It is assumed that participants have at least a basic knowledge of SQL. Participants should also be familiar with ACS-Run SQL Scripts.

Objectives

-

Topics

Generating XML Documents

  • XML Basics
  • Data Type: XML
  • SQL XML Publishing Functions
    • Scalar Functions for generating (nested) Elements
      • With/Without XML Attributes
      • With/Without Namespaces
    • Aggregate Functions for accumulating XML-Elements over multiple Rows
  • Generating (more) complex XML-Documents
  • Generating XML-Documents with embedded SQL

Consuming XML Documents

  • Annotated Schema Decomposition
  • XMLTABLE Table Function
    • XPath Syntax
    • Accessing XML Columns
    • Accessing IFS Files
    • Accessing Web-Services
  • Generating (more) complex XML-Documents
  • Generating XML-Documents with embedded SQL

Reading and Writing XML-Data into the IFS

Consuming XML-Data returned by Web-Services

Price (ex. VAT)

€ 1.640,00 per person

Duration

2 days

Schedule

Please send us a message with the form below

Delivery methods

  • Classroom
  • On-site (at your location)
  • Virtual (instructor online)

Questions?

Write us and we will contact you to discuss your requirements
contact us