SQL with Birgitta Hauser


A two day event with Birgitta Hauser as the trainer could look like this:

 

Day 1

Do you know what you can do with a simple SELECT Statement

  • SELECT Statement

  • SQL Predicates

  • Scalar Functions

  • String Manipulation

  • Regular Expressions

  • Calculation with numeric Values

  • OLAP Ranking Functions

  • Date and Time Calculation

  • Case Clause

  • NULL Values

  • Joining Tables and Views

  • Inner, Left/Right Outer, Full, Left/Right Exception and Cross Join

  • Union / Intersect / Except

  • Aggregation

  • Group By / Having

  • Multi-dimensional Grouping

  • Common Table Expressions

  • Recursive Queries

  • Recursive Common Table Expressions

  • Hierarchical Query Clause

Day 2

  • Generating and Consumin JSON with SQL

  • JSON Basics

  • JSON Support in SQL

  • Generating JSON Documents

  • ·   (nested) JSON Objects

  • ·   JSON Arrays

  • By listing Values and Objects

  • Based on an Sub-Select

  • ·   Generating Arrays and Objects by aggregating multiple rows

  • Generating more complex JSON data

  • Generating Web-Services returning JSON data

  • Consuming JSON Data by using JSON_TABLE

  • ·   JSON Path Expression

  • ·    Data type conversion between JSON and SQL

  • ·   Regular Column Definition

  • ·   Column Nested Path Definition

  • ·   Ordinality Column Definition

  • Handling complex JSON Data

  • Consuming Web-Services returning JSON Data

© 2020 by IBMiCompetence.com