The workshop is 85% practical and has a minimal skill level requirement. There will be a pre-course virtual lab environment in which participants can test their skills and fill any missing gaps (see Requirements).
Topics:
SQL-Basics : Review Basics from the SQL Standard Course
Using COMMON TABLE EXPRESSIONS
SET Operators
TOP n/LIMIT Queries (ANSI SQL-2008)
DATATYPES, FUNCTIONS and CONVERSIONS
SQL WINDOWING Functions
Optional modules:
SUBQUERIES
RECURSIVE COMMON TABLE EXPRESSIONS
System Versioned Temporal Tables
Inserting New Values
PIVOT und UNPIVOT
MERGE (ANSI SQL-2003)
Basic Indexing to improve Query Peformance
Variables & Basic Control-of-flow
Stored Procedures
Dynamic SQL
APPLY Operator (MSSQL)
Rolling Up Values
Reporting and SQL specialists as well as data experts who work with relational databases and need to formulate advanced SQL queries. Developers who want to work with an SQL-enabled database or build applications using the SQL capabilities of the database system.
Practical ability to write SQL Queries using the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses as well as INNER and OUTER JOINS when given a 'data question' in a relational database (covered in the «Standard SQL-3» course).
Once the workshop is guaranteed to take place, participants will get access to a virtual lab environment in which they can test their prerequisite SQL skills and have an opportunity to fill any gaps using specific exercises.
This course is manufacturer-independent. So it does not matter if you work with Oracle, SQL Server, MySQL, DB2, PostgreSQL, MariaDB, TeraData or other relational database systems.