.svg)
.svg)
.svg)
Machine Learning Engineer
The workshop consists of 85% practical SQL writing and requires minimal SQL knowledge. A virtual practice environment will be provided before the course so that you as a participant can test your skills and close any gaps (see course prerequisites).
Topics:
SQL-Basics : Review Basics from the SQL Standard Course
- SELECT, Column Alias, Calculated Columns
- WHERE
- FROM, JOINS , Table Alias
- GROUP BY, HAVING
- CASE Statement (SIMPLE and SEARCHED)
Using COMMON TABLE EXPRESSIONS
- WITH Keyword
SET Operators
- UNION
- INTERSECT
- EXCEPT
TOP n/LIMIT Queries (ANSI SQL-2008)
- OFFSET
- FETCH FIRST/NEXT
DATATYPES, FUNCTIONS and CONVERSIONS
- Overview/Awareness Datatypes
- Working with Character Data, String Functions
- Working with Date and Time Data, DateTime Functions
- Using Data Type Conversion Functions, CAST (and CONVERT)
- Working with Collations
SQL WINDOWING Functions
- OVER, PARTITION BY Clause
- Windowing Functions :
- RANK()
- DENSE_RANK()
- ROW_NUMBER()
- NTILE()
- LAG()
- LEAD()
- FIRST_VALUE()
- LAST_VALUE()
Optional modules:
SUBQUERIES
- Stand-alone subqueries
- Correlated subqueries
RECURSIVE COMMON TABLE EXPRESSIONS
System Versioned Temporal Tables
- PERIOD FOR SYSTEM_TIME
- FOR SYSTEM_TIME AS OF
Inserting New Values
- IDENTITY
- SEQUENCES
PIVOT and UNPIVOT
MERGE (ANSI SQL-2003)
- MERGE Statement
- WHEN MATCHED
- WHEN NOT MATCHED
Basic Indexing to improve Query Peformance
- CLUSTERED INDEX
- NONCLUSTERED INDEX
- COVERING INDEX
- Query Execution Plans
- IMPLICIT Conversions and Functions in Predicates
Variables & Basic Control-of-flow
- DECLARE variables
- Assign Values
- Escaping Single Quotes
Stored procedures
- Create Basic Stored Procedure
- Execute a Stored Procedure
- Stored Procedure OUT Parameters
Dynamic SQL
- EXEC()
- sp_executesql
APPLY Operator (MSSQL)
- CROSS Apply
- OUTER Apply
- Table-valued Functions
- Derived tables
Rolling Up Values
- Rolling up values from multiple rows into one
- FOR XML PATH
- STUFF Function
Requirements
Ability to create an SQL query based on a 'data question' to a relational database.
Practical application of: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY as well as INNER and OUTER JOINS (these topics are covered in the "Standard SQL-3" course).
As soon as the workshop is conducted safely, participants have access to a virtual practice environment. There you can test the required skills and close any gaps with specific exercises.
Additional info:
This course is designed to be vendor-independent. This means that it does not matter whether you work with Oracle, SQL Server, MySQL, DB2, PostgreSQL, MariaDB, TeraData or other relational database systems.
- Formulating complex SQL queries: Learn how to efficiently create sophisticated data queries.
- Immediate added value for everyday work: Benefit from practical exercises that teach directly applicable skills.
- Helpful practical tips: Use specially developed Digicomp course materials to deepen your knowledge and apply it in everyday life.
This course consists of training training and is led by a trainer who supervises the participants live. Theory and practice are taught with live demonstrations and practical exercises. The video conferencing software Zoom is used.
This course is aimed at reporting and specialists specialists and experts experts who work with relational databases and need to formulate advanced SQL queries. It is also suitable for developers who work with an SQL-capable database or want to create applications using the SQL possibilities of the database system.
.svg)
