+351 217 983 104

catálogo de formação

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

Print Friendly, PDF & Email

Em pré-inscrição. Entre em contacto para obter mais informações.

Nível Iniciado | 2 dias | 14 horas


This course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.


This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.


1- Introduction to Transact-SQL

2- Sort and Filter results in T-SQL

3- Combine multiple tables with JOINs in T-SQL

4- Write subqueries in T-SQL

5- Use built-in fuctions and GROUP BY in Transact-SQL

6- Modify data with T-SQL

Pedido de Informação