Data Platform MOC

DP-080: Querying Data with Microsoft Transact-SQL

0.0

(0)

14 Labs

This track consists of 14 labs, each provided as a separate lab instance, and has to be completed in one uninterrupted session. Once you launch a lab, your session time begins. The estimated duration to complete each lab is around 1.5 Hours. This track and all associated labs will be available for 30 days once you redeem the voucher code. After 30 days, all labs and related data will be automatically deleted from the CloudLabs portal.

About Course

DP-080 is a beginner-level course titled “Querying Data with Microsoft Transact-SQL.”

It teaches the basics of writing T-SQL queries to retrieve and modify data in SQL Server databases.

The course covers SELECT statements, filtering, joins, built-in functions, and data modification.

Ideal for data analysts, developers, and beginners with no prior SQL experience.

Get Started with Transact-SQL
Sort and Filter Query Results
Query Multiple Tables with Joins
Use Subqueries
Use Built-in Functions
Modify Data
Create queries with table expressions
Combine query results with set operators
Use window functions
Use pivoting and grouping sets
Introduction to programming with Transact-SQL
Create stored procedures and functions in Transact-SQL
Implement error handling with Transact-SQL
Implement transactions with Transact SQL

No Review Yet

No Review Yet

Level Beginner
Lab Duration 21 hours
Last Updated August 25, 2025
Lab Type Self Paced

01

Create an Account & Purchase

Sign up on CloudLabs and complete your lab purchase.

02

Get Confirmation

You'll receive a confirmation email once your purchase is successful.

03

Access Instructions Sent

Our support team will reach out with your credentials and steps to access the lab.

Need Assistance? Contact Us