Advanced T-SQL for Data Analysts (English)
€ 699,- (excl. VAT)
1 day
Online, Utrecht, Utrecht (Open Leercentrum)
Description
In the training "Advanced T-SQL for data analysts" you will learn the very powerful concepts of windowing , ranking , subqueries and CTEs in one day. As a data analyst you can efficiently perform and solve all kinds of analyzes with this. In the course of the afternoon, work on the "challenge", in which all knowledge comes together. These are a number of larger SQL commands, where you have to decide for yourself which technique you can use best to find the solution. In this way, the training is really a whole, and you as a student are challenged to constantly apply the entire "toolset" learned. This training can be followed separately, but it is also the next step after the two-day basic training "T-SQL for data analysts".
The "Advanced T-SQL for data
analysts" training is aimed at data analysts, data engineers and data scientists who want to support their work by
leveraging the power of SQL for advanced data
analytics.
Skills gained
After this day you can:- Structure complex SQL queries with Common Table Expressions
- Use Windowing and Ranking functions
- Transform datasets using Pivot and Unpivot
Prerequisites to follow the training "Advanced T-SQL for data analysts".
You as a participant are
expected to have a solid foundation in SQL: sorting, filtering, JOINs, grouping and aggregating are expected as prior
knowledge. Would you rather polish up? Have a look at our two-day training "T-SQL for data
analysts"
Course outline
- Table Expressions
- Sub queries
- Common Table Expressions (CTEs)
- ranking functions
- Window functions
- Pivot and Unpivot
Course material
In the "Advanced T-SQL for Data Analysts" training, we use material that we have developed ourselves at Wortell Smart Learning. There are a lot of fun SQL puzzles at the center, which we work through hands-on. This helps you to really understand the language. We make sure that you receive all the necessary material on time.Available dates
Starts at
Ends at
Location
Price (ex. VAT)
Price (inc. VAT)
Enroll
Actions
Title | Date |
---|---|
Advanced T-SQL for Data Analysts (Open Leercentrum / Trainer-led self-study) |
Starts at:
Ends at:
Location: Utrecht (Open Leercentrum)
Price (ex. VAT): € 699,-
Price (inc. VAT): € 845,79
Title | Date |
---|---|
Advanced T-SQL for Data Analysts (Open Leercentrum / Trainer-led self-study) |
Starts at:
Ends at:
Location: Utrecht (Open Leercentrum)
Price (ex. VAT): € 699,-
Price (inc. VAT): € 845,79
Title | Date |
---|---|
Advanced T-SQL for Data Analysts (Open Leercentrum / Trainer-led self-study) |
Title | Date |
---|---|
Advanced T-SQL voor Data-analisten |
Title | Date |
---|---|
Advanced T-SQL for Data Analysts (English + Online) |
Title | Date |
---|---|
Advanced T-SQL voor Data-analisten |
Unlimited learning for a fixed price with Unlimited Learning.
Unlimited learning for a fixed monthly price. Whether you go solo or as a team, we are ready to meet your knowledge goals.
More about Unlimited Learning.
€ 300,- per month