Querying Data with Microsoft Transact-SQL (DP-080) (English)

Lesmethode :

Persoonlijk begeleid

Algemeen :

This DP-080 training by Vijfhart teaches you how to work with Transact SQL to retrieve, filter and update data in a way that’s immediately useful in your daily work. Whether you use SQL Server, Azure SQL Database or Synapse Analytics, you’ll gain the skills to handle relational data with confidence.

Based on the official Microsoft content for the DP 080 exam (Querying Data with Microsoft Transact SQL), you’ll learn how to write SELECT statements, apply sorting and filtering, use built-in functions, group and summarize data, and modify records with INSERT, UPDATE, DELETE and MERGE.

Hands-on practice is at the heart of this course. You’ll build queries using joins, subqueries, grouping and logic that mirrors what you’ll do on the job. That way, you don’t just learn the syntax but you understand how to apply it effectively.

Je leert hoe je SELECT-statements schrijft, gegevens sorteert, filtert en groepeert, functies toepast en data aanpast met opdrachten zoals INSERT, UPDATE, DELETE en MERGE.

Alles wat je leert, oefen je meteen in opdrachten die lijken op jouw dagelijkse werk. Je werkt met echte datastructuren en bouwt queries die je direct in de praktijk kunt gebruiken. Zo maak je Transact SQL snel eigen, op een manier die voor jou werkt.

Doel :

After completing the course, you’ll be able to write and understand Transact SQL queries to retrieve, manage and analyze data. You’ll have the foundation you need to move into roles focused on business intelligence, data engineering or database administration.

Doelgroep :

This DP 080 training is ideal for data analysts, engineers, administrators or professionals who want to work with relational data using Transact SQL. No prior experience with SQL is required.

Voorkennis :

There are no specific pre-requisites for this course.

Onderwerpen :

- Introduction to Transact-SQL
- Sort and filter results in T-SQL
- Combine multiple tables with JOINs in T-SQL
- Write Subqueries in T-SQL
- Use built-in functions and GROUP BY in Transact-SQL
- Modify data with T-SQL