DP-080: Querying Data with Microsoft Transact-SQL

Course Summary

Duration4 full days
Delivery methodVirtual Instructor-led Training
List price890 Euro VAT Excl.

Click Tabs for Detailed info

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.

Important notice:
This course is originally a 2 day official course from Microsoft. SQL Master Academy has added 2 days extra with content and one extra module, to meet the needs of students that require a full-fledged training on Transact-SQL.

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.

  • Use SQL Server query tools
  • Write SELECT statements to retrieve columns from one or more tables
  • Sort and filter selected data
  • Use built-in functions to returned data values
  • Create groups of data and aggregate the results
  • Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE
  • Using programming modules to enclose data modifications in a programming object

Module 1: Getting Started with Transact-SQL

Module 2: Sorting and Filtering Query Results

Module 3: Using Joins and Subqueries

Module 4: Using Built-in Functions

Module 5: Modifying Data

Module 6 (extra): Basics of T-SQL Programming Objects – Views, Stored Procedures, Triggers, Functions

Next planned dates:

Trainer: Magi Naumova



You have a question or you want to book now? Feel free to contact us!

Vili Koleva-Training Manager

E: vili.koleva@inspirit.bg

M: +359 (885) 113 442