Microsoft DP-080T00 - Querying Data with Microsoft Transact-SQL

Course Overview

This two-day course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Covering both querying and modifying data in relational databases hosted in Microsoft SQL Server-based systems, including Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics, this course is designed to provide a strong foundation in Transact-SQL.

Enrol in the Introduction to Transact-SQL course to gain essential skills in querying and modifying data within Microsoft SQL Server-based systems. This comprehensive two-day course covers fundamental topics such as writing SELECT statements, sorting and filtering data, using built-in functions, creating data groups, and modifying data with Transact-SQL commands. Ideal for data analysts, engineers, scientists, and database professionals, this course will enhance your ability to work with data effectively.

What will you learn? 

• Use SQL Server query tools effectively
• Write SELECT statements to retrieve columns from one or more tables
• Sort and filter selected data
• Use built-in functions to return data values
• Create groups of data and aggregate the results
• Modify data with Transact-SQL using INSERT, UPDATE, DELETE, and MERGE commands

Who is this course for?

• Data analysts, data engineers, data scientists, database administrators, and database developers
• Solution architects, students, and technology managers involved with data
• Anyone needing to write basic SQL or Transact-SQL queries
• Individuals seeking to improve their data management skills

What you need to know

The Microsoft DP-080T00 - Querying Data with Microsoft Transact-SQL course is designed to provide learners with essential skills in querying and modifying data using Transact-SQL. This hands-on course covers SQL Server query tools, writing SELECT statements, sorting and filtering data, using built-in functions, and modifying data, ensuring participants can manage data efficiently.

Instructional Formats:

• Virtual Instructor-Led: Participate in live, instructor-led sessions from the comfort of your home or office.
• In-person Instructor-Led: Join us in person at one of our training centres for a hands-on learning experience.

Course Structure

This course will delve into the following key topics:

• Introduction to Transact-SQL

• Sort and filter results in T-SQL

• Combine multiple tables with JOINs in T-SQL

• Write Subqueries in T-SQL

• Use built-in functions and GROUP BY in Transact-SQL

• Modify data with T-SQL