You need to extract, filter and manipulate data stored in SQL Server, but your queries lack structure and performance? Transact-SQL remains the fundamental skill for any professional working with Microsoft relational databases. Without a solid command of T-SQL, analyses remain approximate and data processing inefficient.
This official Microsoft DP-080 training allows you to master SELECT statements, joins, subqueries and built-in Transact-SQL functions in 2 days. Guided by MCT-certified trainers, you practice on cloud environments with official MOC course materials. You learn to write optimized queries to interrogate SQL Server and Azure SQL Database, group and aggregate results, and use table expressions to structure your analyses. This training is the ideal starting point for progressing toward Microsoft data certifications such as DP-300 or DP-600. Sessions are available in person in Geneva and Lausanne or via virtual classroom.
Module 1: Introduction to Transact-SQL
Module 2: Sort and filter results in T-SQL
Module 3: Combine multiple tables with JOINs in T-SQL
Module 4: Write Subqueries in T-SQL
Module 5: Use built-in functions and GROUP BY in Transact-SQL
Module 6: Modify data with T-SQL
Official Microsoft Labs
Transact-SQL, commonly known as T-SQL, is Microsoft’s proprietary extension to the standard SQL language. Used in SQL Server, Azure SQL Database and Azure Synapse Analytics, T-SQL goes beyond simple queries to include variables, control structures and advanced functions. For IT professionals in Switzerland, mastering T-SQL opens the door to numerous roles in database administration, data analysis and application development. This DP-080 training provides the solid foundation needed before pursuing more advanced certifications like DP-300 or DP-600.
The program covers all Transact-SQL fundamentals following the official Microsoft curriculum (MOC). You start by understanding the structure of relational databases and the basics of SQL syntax. You then progress through SELECT statements with various clauses, joins for combining data from multiple tables, aggregate functions and grouping, subqueries, common table expressions and built-in functions. Each module includes practical exercises on cloud environments so you can immediately apply what you learn. By the end of the training, you are able to write structured and optimized T-SQL queries for your daily professional needs.
No prior SQL knowledge is required. Basic familiarity with relational database concepts is helpful but not mandatory. This training is designed for beginners starting with Transact-SQL.
SQL is the standard language for managing relational databases. T-SQL is Microsoft’s extended version, adding variables, error handling, control structures and proprietary functions. This training covers T-SQL as used in SQL Server and Azure SQL.
DP-080 does not have a dedicated certification exam but provides the foundational T-SQL skills needed for DP-300 (Database Administrator) and DP-600 (Fabric Analytics Engineer) certifications.
Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00
ITTA
Route des jeunes 35
1227 Carouge, Suisse
Monday to Friday, from 8:30 am to 06:00 pm.
