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

The DP-080 course teaches you how to query and modify data in Microsoft-based database systems like Microsoft SQL Server and Azure Synapse Analytics. It is designed for individuals familiar with Transact-SQL, including data engineers, data scientists, and data administrators.
Course Details

Price:

$1,295.00

Days:

1

Location:

Virtual

Course Overview

The DP-080 course teaches you how to query and modify data in Microsoft-based database systems like Microsoft SQL Server and Azure Synapse Analytics. It is designed for individuals familiar with Transact-SQL, including data engineers, data scientists, and data administrators.

– • 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 return data values
– • Create groups of data and aggregate the results
– • Modify data with Transact-SQL using INSERT, UPDATE, DELETE, and MERGE

No specific prerequisites are required for this course. Basic computer literacy and familiarity with fundamental concepts in the subject area are recommended for the best learning experience.

• LAB Outline
• LAB Outline
• LAB Outline
• Get Started Querying with Transact-SQL
• Get Started Querying with Transact-SQL
• Get Started Querying with Transact-SQL
• Modify data with T-SQL
• Modify data with T-SQL
• Modify data with T-SQL
• Introduction to Transact-SQL
• Introduction to Transact-SQL
• Introduction to Transact-SQL
• Sort and filter results in T-SQL
• Sort and filter results in T-SQL
• Sort and filter results in T-SQL
• Combine multiple tables with JOINs in T-SQL
• Combine multiple tables with JOINs in T-SQL
• Combine multiple tables with JOINs in T-SQL
• Write Subqueries in T-SQL
• Write Subqueries in T-SQL
• Write Subqueries in T-SQL
• Use built-in functions and GROUP BY in Transact-SQL
• Use built-in functions and GROUP BY in Transact-SQL
• Use built-in functions and GROUP BY in Transact-SQL

Class Dates & Times
Filters Sort results
Reset Apply
5/19/2025
Virtual
09:00:00-17:00:00 CST
Enroll Now
$1,295.00
7/28/2025
Virtual
09:00:00-17:00:00 CST
Enroll Now
$1,295.00
9/22/2025
Virtual
09:00:00-17:00:00 CST
Enroll Now
$1,295.00
11/24/2025
Virtual
09:00:00-17:00:00 CST
Enroll Now
$1,295.00
— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.