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 BasicsJSON Support in SQLGenerating 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