Dp-080t00: Querying Data With Microsoft Transact-Sql

The DP-080T00: Querying Data with Microsoft Transact-SQL course teaches the fundamentals of Transact-SQL (T-SQL) for querying Microsoft SQL Server and Azure SQL databases. This 16-hour course covers SELECT statements, filtering, sorting, joins, subqueries, set operators, built-in functions, and data modification. Esamatic srl, a Microsoft Learning Partner in Milan, delivers this course with Microsoft Certified Trainers.

• T-SQL Fundamentals: SELECT, WHERE, ORDER BY, GROUP BY, and HAVING clauses
• Joins: INNER JOIN, LEFT/RIGHT JOIN, CROSS JOIN, and self-joins
• Subqueries and CTEs: scalar subqueries, correlated subqueries, and Common Table Expressions
• Built-in Functions: string, numeric, date/time, and aggregate functions
• Data Modification: INSERT, UPDATE, DELETE, and MERGE statements

Course Overview: DP-080T00

Transact-SQL is the query language for Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics. The DP-080T00 course builds practical querying skills essential for database administrators, data analysts, developers, and anyone working with Microsoft data platforms.

Learning Objectives

1. Write SELECT queries — retrieve data, filter rows, sort results, and work with NULL values
2. Query multiple tables — use INNER, OUTER, and CROSS joins to combine data from related tables
3. Use built-in functions — apply string, numeric, date, and aggregate functions for data transformation
4. Use subqueries and set operators — write subqueries, CTEs, and use UNION, INTERSECT, EXCEPT
5. Modify data — insert, update, and delete data using DML statements

Who Should Attend

The DP-080T00 is for database beginners, data analysts, business analysts, and developers learning to query SQL Server and Azure SQL databases.

Prerequisites

No prior SQL experience required. Basic understanding of relational database concepts is helpful.

Frequently Asked Questions

What is Transact-SQL?

Transact-SQL (T-SQL) is Microsoft's extension of SQL for querying and managing data in SQL Server, Azure SQL Database, and Azure Synapse Analytics. It adds procedural programming, error handling, and additional functions to standard SQL.