“We needed a partner who understood both the technical depth of Azure OpenAI and the governance requirements of an enterprise.”
Microsoft Official Curriculum
Role-Based Certification PrepTrack: DP-080T00Official Source: Microsoft Learn
MicrosoftBeginner
Query and modify data with Transact-SQL
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, Azure Synapse Analytics, and Microsoft Fabric.
Duration
2 days
Level
Beginner
Format
Virtual, On-site, or Hybrid
Language
English
Executive brief for stakeholdersDownload Program Brief (PDF)
Microsoft
DataIT
Query and modify data with Transact-SQL
Azure
Data
On this page
Ideal for
Database AdministratorDataCertification ReadinessTailored Team Delivery
Audience Profile
Built for these roles
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.
Overview
Executive overview
Official Microsoft Learn-aligned instructor-led program for Query and modify data with Transact-SQL.
Readiness
Prerequisites
- Relevant foundational experience in the target technology area.
- Comfort with hands-on labs in a cloud or GPU-accelerated environment.
Program Outcomes
Capabilities your teams will gain
Strengthen capability in data scenarios
Strengthen capability in azure scenarios
Strengthen capability in role-based scenarios
Curriculum
Curriculum roadmap
1
Data
2
Azure
3
Role-Based
1Module 1
Query and modify data with Transact-SQL
+
Module 1
Query and modify data with Transact-SQL
Learn how to use Transact-SQL (T-SQL) to interact with relational databases by querying and modifying data. This course covers essential operations such as inserting, updating, deleting, and merging data across tables. You'll also explore how to generate automatic values and apply changes efficiently using SQL Server or Azure SQL environments.
- 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
Delivery Models
Delivery models
Virtual ILTOnsiteHybridExecutive WorkshopBootcampWeekend
Engagement Fit
Engagement fit
Certification readinessImplementation-focused labsPrivate cohort deliveryBeginner practitioner depth
Enterprise Customization
Enterprise customization
Tailor this program to your organization's priorities: Builds current Microsoft credential readiness for Query and modify data with Transact-SQL using the official Microsoft Learn outline.
- •Align labs to your production environment and platform priorities
- •Add readiness reviews and instructor-led practice sessions
- •Extend into project-specific architecture or delivery coaching
Credentials
Certification & official source
- •DP-080T00
Aligned to the official Microsoft Learn course and learning path for this program.
View Official Microsoft Learn PageResources
Program resources
Yes. Most enterprise clients prefer private delivery scoped to role mix, timezone, and rollout timeline. We align lab environments and scenarios to your tenant context where applicable.
Enterprise Proof
Trusted delivery outcomes
Banking & Finance
Representative Enterprise Banking Team
The focus was not just on tooling knowledge, but on helping teams work from a shared operating model as they adopted a more modern data platform.
- Clearer platform operating model across teams
- Improved confidence in modern data stack adoption
Healthcare
Representative Healthcare Product Team
The engagement helped product and engineering stakeholders move from interest in AI to clearer implementation choices, security expectations, and prototyping discipline.
- Stronger alignment between product and engineering teams
- Improved clarity on prototype-to-production requirements
Delivery Capability
Enterprise-grade instruction
MCT-led delivery
Programs led by Microsoft Certified Trainer practitioners
Enterprise program oversight
Founder-led specialist delivery with structured rollout planning
Global delivery
APAC · EMEA · Americas · Virtual & Onsite
Implementation-focused
Hands-on labs aligned to production scenarios