T-SQL for data analysts (DP-080) (English)
- Tijdsduur
T-SQL for data analysts (DP-080) (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 basic training "T-SQL for data analysts" we cover T-SQL, the query and design language for Microsoft SQL Server, Azure SQL Database and Azure Synapse Analytics. We focus on making analyzes in SQL, and preparing, linking and enriching datasets for use within other analysis tools. From the broad experience of data analysis, the trainer shares examples, and has numerous "puzzles" ready that help to really understand SQL better.
With these two days, this training is particularly suitable to master T-SQL with a focus on data analysis.
Audience
This course is suitable for anyone who wants to learn how to write basic SQL or T-SQL queries. No special prior knowledge is required. B…
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 basic training "T-SQL for data analysts" we cover T-SQL, the query and design language for Microsoft SQL Server, Azure SQL Database and Azure Synapse Analytics. We focus on making analyzes in SQL, and preparing, linking and enriching datasets for use within other analysis tools. From the broad experience of data analysis, the trainer shares examples, and has numerous "puzzles" ready that help to really understand SQL better.
With these two days, this training is particularly suitable to master T-SQL with a focus on data analysis.
Audience
This course is suitable for anyone who wants to learn how to write basic SQL or T-SQL queries. No special prior knowledge is required. Both people who have to process data from their primary role (Data Analysts, Data Engineers, Data Scientists, Database Administrators) and people who have to deal with SQL adjacent to their role (solution architects, technical management) can participate in this training.
Skills gained
After this two-day training you will be able to:
- Use SQL Server query tools (Azure Data Studio, SQL Server Management Studio)
- Write SELECT statements to retrieve columns from one or more tables
- Join tables using JOIN statements (and really understand what's happening)
- Sort and filter data
- Use built-in SQL functions to analyze data
- Grouping and aggregating (summarizing) datasets
- Modify data with T-SQL, using INSERT, UPDATE, DELETE and MERGE
Prerequisites
No specific prior knowledge is required for the training "T-SQL for data analysts (DP-080)". Do you doubt your prior knowledge? Then please contact us!
Course outline
In the course we will work with the following topics. This gives you a solid basis for extracting and adjusting data from databases yourself.
- Introducing TSQL
- Using the SELECT statement
- Sort, Filter with WHERE, unique values and the TOP clause
- Really understand JOIN: INNER, OUTER and CROSS
- Sub queries
- Advanced subqueries
- Functions
- Aggregate (SUM, MIN, MAX) and GROUP BY
- Filter with HAVING
- Adjustments with INSERT, UPDATE and DELETE
- Adjustments with MERGE
- Automatic values with IDENTITY and SEQUENCE
Course material
In the training "T-SQL for data analysts" we use the official DP-080 (DP-080T00-A) Microsoft material. We expand this with material, exercises and puzzles that we have developed ourselves at Wortell Smart Learning. 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.