Course Overview

This DP-080T00: Query and Modify Data with Transact-SQL 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.

What are the skills covered

After completing this module, students will be able to:

  •  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

Who should attend this course

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.

Course Curriculum

What are the Prerequisites

Note: There is no exam directly associated with this course. However, Microsoft offers an extensive portfolio of industry-recognized certifications that can help you stand out as a tech professional in 2025 and beyond. Achieving Microsoft certification is one of the most effective ways to validate your skills and accelerate your career.

With our expert-led training, you’ll be prepared to:

  • Master in-demand capabilities across Cloud, Data & AI, and Cybersecurity — areas driving global digital transformation.
  • Prove your expertise with a globally respected credential recognized by employers worldwide.
  • Advance your career by enhancing your credibility, increasing your earning potential, and opening doors to new opportunities.

Explore our full range of Microsoft certifications and start building the skills that matter today.

Download Syllabus

Course Modules

Request More Information

Training Options

Intake: 3-4 Sep 2025
Duration: 2 Days
Guaranteed: TBC
Modality: ILT
Price:

RM2,100.00Enroll Now

Exam:
Intake: 3-4 Sep 2025
Duration: 2 Days
Guaranteed: TBC
Modality: VILT
Price:

RM2,100.00Enroll Now

Exam:
Intake: 8-9 Dec 2025
Duration: 2 Days
Guaranteed: TBC
Modality: ILT
Price:

RM2,100.00Enroll Now

Exam:
Intake: 8-9 Dec 2025
Duration: 2 Days
Guaranteed: TBC
Modality: VILT
Price:

RM2,100.00Enroll Now

Exam:

Exam & Certification

This course is not associated with any Certification. If you’d like to learn more about Azure certification roadmap, do check out our Microsoft Azure Training Certifications blog post.

Training & Certification Guide

Frequently Asked Questions