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