Generating and Consuming JSON Data
Code: GCJSONAudience
This course is designed for programmers that need to generate and consume JSON 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.
Topics
JSON versus XML
JSON Basics
JSON Support in SQL
Generating JSON-Documents
- Generating (nested) Objects
- Generating Arrays
- Listing Objects and Values
- Based on a SELECT Statement
- Generating Arrays over multiple Rows
JSON-Predicates
- Check valid JSON Data
Consumging JSON Data with JSON_TABLE
- JSON Path Expression
- Converting JSON Data Types into SQL-Data Types
- Column Defintions
- Regular Column Definition
- Column Nested Path Definition
- Ordinality Column Definition
- Return JSON formatted Data
- JSON - More complex Examples
Retrieve JSON Data
- JSON_VALUE and JSON_QUERY
Reading and writing JSON Data into the IFS
Consuming JSON-Daten returned by Web-Services
Price (ex. VAT)
€ 1.640,00 per person
Duration
2 days
Schedule
- virtual
- 16-12-2024 - 17-12-2024
- register
Delivery methods
- Classroom
- On-site (at your location)
- Virtual (instructor online)