Advanced T-SQL for Data Analysts (English)
- Tijdsduur
Advanced T-SQL for Data Analysts (English)
Opleiderscore:
Startdata en plaatsen
Wortell Learning biedt haar producten standaard aan in de volgende regio's: 's-Hertogenbosch, Alkmaar, Almere / Lelystad, Alphen aan den Rijn, Amersfoort, Amsterdam, Antwerpen, Apeldoorn, Arnhem, Assen, Breda, Brugge, Brussel, Delft, Den Haag, Deventer, Dordrecht, Drachten, Ede, Eindhoven, Emmen, Enschede, Gent, Gouda, Groningen, Haarlem, Haarlemmermeer, Heerenveen, Hilversum, Leeuwarden, Leiden, Luik, Maastricht, Middelburg, N.V.T. / Onbekend, Nijmegen, Roermond, Rotterdam, Terneuzen, Tilburg, Utrecht, Veenendaal, Venlo, Westland, Zaanstad, Zoetermeer, Zwolle
Beschrijving
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-d…Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
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".Audience
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.Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.