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

·   (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