Training: Querying Data with Microsoft Transact-SQL

Ref. DP-080T00
Not certifying


This course teaches 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.

Participant profiles

  • Database Administrators
  • Database Developers
  • Business Intelligence professionals
  • SQL power users who aren’t necessarily database-focused such as report writers, business analysts and client application developers


  • 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


  • No prerequisites

Course content

Module 1: Getting Started with Transact-SQL

  • Introduction to Transact-SQL
  • Using the SELECT statement

Module 2: Sorting and Filtering Query Results

  • Sorting query results
  • Filtering the data

Module 3: Using Joins and Subqueries

  • Using JOIN operations
  • Using subqueries

Module 4: Using Built-in Functions

  • Getting started with scalar functions
  • Grouping aggregated results

Module 5: Modifying Data

  • Inserting data into tables
  • Modifying and deleting data


  • Access to Microsoft Learn (online learning content)

Lab / Exercises

Official Microsoft Labs

  • Get started with SQL Server query tools and writing queries in T-SQL
  • Sort and filter data returned by SELECT queries
  • Write queries with JOIN operations
  • Write SELECT statements using subqueries
  • Built-in functions
  • Modify data

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.
Prix de l'inscription
CHF 1'700.-
Inclus dans ce cours
  • Training provided by a certified trainer
  • 180 days of access to Official Microsoft Labs
  • Official documentation in digital format
  • Official Microsoft achievement badge

jeu26Oct(Oct 26)09:00ven27(Oct 27)17:00VirtuelVirtual Etiquettes de sessionDP-080T00

jeu26Oct(Oct 26)09:00ven27(Oct 27)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-080T00

jeu07Déc(Déc 7)09:00ven08(Déc 8)17:00VirtuelVirtual Etiquettes de sessionDP-080T00

jeu07Déc(Déc 7)09:00ven08(Déc 8)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-080T00

jeu18Jan(Jan 18)09:00ven19(Jan 19)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-080T00

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.


Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request