Microsoft AI Foundry track — available for enterprise team delivery

VNode ITeSBook

Microsoft Official Curriculum

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.

Role-Based Certification PrepTrack: DP-080T00Official Source: Microsoft LearnMicrosoftBeginner
Plan Private DeliveryConsult a Solutions Architect
Download Program Brief (PDF)

Program Snapshot

Engagement scoped to cohort

Duration2 days
FormatVirtual, On-site, or Hybrid
LevelBeginner
Course CodeDP-080T00
Certification TrackDP-080T00
SubjectData
  • MCT-led delivery
  • Private cohort / virtual ILT
  • Typical response: 1 business day
Scoping call typically scheduled within one business day

VNode ITeS delivers Query and modify data with Transact-SQL as an MCT-led Microsoft program for Database Administrator. Typical duration is 2 days (Virtual, On-site, or Hybrid). Labs follow production-shaped scenarios rather than slide-only walkthroughs. Certification prep maps to DP-080T00 without turning the week into a dump of Learn modules. Private cohorts can shift emphasis by role mix, workspace or repo constraints, and rollout timing.

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.

  • Database Administrator
  • Data
  • Certification Readiness
  • Tailored Team Delivery

Overview

Executive overview

Official Microsoft Learn-aligned instructor-led program for Query and modify data with Transact-SQL.

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 database administrator scenarios
  • Strengthen capability in azure scenarios

Enterprise Delivery

Official learning & delivery options

Review the vendor learning resource, then book a consultation or request a private cohort for your team.

View Official LearningBook a ConsultationRequest Private CohortOpen in learning platformProgram brief (PDF)

Curriculum

Curriculum roadmap

  • Database Administrator
  • Azure
1

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 readiness
  • Implementation-focused labs
  • Private cohort delivery
  • Beginner 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 Page

Resources

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.

Program brief (PDF)View Official Microsoft Learn Page

Delivery Capability

Enterprise-grade instruction

View delivery capability profile

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

Plan delivery
Kriya AI