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