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

Vijfhart IT-Opleidingen

This course includes a free exam voucher. The DP-080 course covers the use of Transact-SQL for queries and data manipulation in SQL Server, Azure SQL and Synapse.

Price
from €1,975
Level
Not specified
Kind
Training
Subject
Automation and IT

More information and registration at Vijfhart IT-Opleidingen

Description

In this Microsoft DP-080 course from Vijfhart, you will learn how to use Transact-SQL to query and modify data in relational, Microsoft SQL Server-based database systems such as Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics. We cover writing SELECT statements to retrieve columns from one or more tables, after which you will discover how to sort and filter query results. You will not only work with simple queries, but also learn how to use joins and subqueries to combine data from multiple tables. In addition, you will be introduced to built-in functions to manipulate or calculate values, and learn how to group data and aggregate results. For example, you will be able to calculate totals and averages and directly apply them in analyses relevant to your daily work. You will also practice modifying data with INSERT, UPDATE, DELETE, and MERGE, so you gain experience not only in retrieving data but also in maintaining and updating the database. During the course, you will work in a training environment with real data structures and use the SQL Server query tools, so you directly experience how these techniques function in practice.

Start dates

Start End Place Price
18 November 2026 20 November 2026 Online €1,975
24 November 2026 26 November 2026 Online €1,975
2 December 2026 4 December 2026 Online €1,975
8 December 2026 10 December 2026 Online €1,975
16 December 2026 18 December 2026 Online €1,975
22 December 2026 24 December 2026 Online €1,975
30 December 2026 4 January 2027 Online €1,975
6 January 2027 8 January 2027 Online €1,975
12 January 2027 14 January 2027 Online €1,975
20 January 2027 22 January 2027 Online €1,975
26 January 2027 28 January 2027 Online €1,975
3 February 2027 5 February 2027 Online €1,975
9 February 2027 11 February 2027 Online €1,975
17 February 2027 19 February 2027 Online €1,975
23 February 2027 25 February 2027 Online €1,975
3 March 2027 5 March 2027 Online €1,975
9 March 2027 11 March 2027 Online €1,975
17 March 2027 19 March 2027 Online €1,975
23 March 2027 25 March 2027 Online €1,975
31 March 2027 2 April 2027 Online €1,975
6 April 2027 8 April 2027 Online €1,975
14 April 2027 16 April 2027 Online €1,975
20 April 2027 22 April 2027 Online €1,975
28 April 2027 30 April 2027 Online €1,975
4 May 2027 10 May 2027 Online €1,975
12 May 2027 14 May 2027 Online €1,975
18 May 2027 20 May 2027 Online €1,975
26 May 2027 28 May 2027 Online €1,975
1 June 2027 3 June 2027 Online €1,975
9 June 2027 11 June 2027 Online €1,975
15 June 2027 17 June 2027 Online €1,975
23 June 2027 25 June 2027 Online €1,975
29 June 2027 1 July 2027 Online €1,975
7 July 2027 9 July 2027 Online €1,975
13 July 2027 15 July 2027 Online €1,975
21 July 2027 23 July 2027 Online €1,975
27 July 2027 29 July 2027 Online €1,975
4 August 2027 6 August 2027 Online €1,975
10 August 2027 12 August 2027 Online €1,975