pds-it
['Product detail page','no']
Databases / Microsoft SQL
The illustrations were created in cooperation between humans and artificial intelligence. They show a future in which technology is omnipresent, but people remain at the center.
AI-generated illustration

Database queries with Microsoft Transact-SQL

Online
2 days
German
Download PDF
€ 1.290,-
plus VAT.
€ 1.535,10
incl. VAT.
Booking number
36164
Venue
Online
1 appointment
€ 1.290,-
plus VAT.
€ 1.535,10
incl. VAT.
Booking number
36164
Venue
Online
1 appointment
Become a certified
Machine Learning Engineer
This course is part of the certified Master Class "Machine Learning Engineer". If you book the entire Master Class, you save over 15 percent compared to booking this individual module.
To the Master Class
In-house training
In-house training for your Employees only - exclusive and effective.
Inquiries
In cooperation with
Use Transact-SQL to query and modify data in relational databases hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and Azure Synapse Analytics.
Contents

Module 1: First steps with Transact-SQL

In this module, you will learn the basics of the Transact-SQL (T-SQL) language as well as general properties and terms of relational databases. This module also introduces the basic SELECT statement for retrieving data from a table.

 

Lessons:

  • Introduction to Transact-SQL
  • Using the SELECT statement

Exercise: First steps with the SQL Server query tools and writing queries in T-SQL

 

Module 2: Sorting and filtering query results

In this module, you will learn how to control which data is returned in which order. You will use the ORDER BY clause, with and without paging. You will learn about different types of filters that can be used in the WHERE clause to control which rows of data are returned. You will also learn how to manage the results by removing duplicates with DISTINCT.

 

Lessons:

  • Sorting query results
  • Filtering the data

Exercise: Sorting and filtering data returned by SELECT queries

 

Module 3: Using joins and subqueries

In this module, you will learn about T-SQL queries that access data from multiple tables using different types of JOIN operations and simple subqueries.

 

Lessons:

  • Using JOIN operations
  • Using subqueries

Exercise: 

  • Writing queries with JOIN operations
  • Writing SELECT statements with subqueries

 

Module 4: Using built-in functions

In this module, you will learn how to use built-in functions to return calculated or special values in the SELECT list or in the WHERE clause. Functions include math functions, string functions and system functions. There are other types of functions that are mentioned but not discussed in detail. You will also learn how to group rows of data together and provide summary information for the group such as SUM, MIN or MAX.

 

Lessons:

  • First steps with scalar functions
  • Grouping aggregated results

Exercise: Built-in functions

 

Module 5: Changing data

In this module you will learn the T-SQL statements for changing table data including UPDATE, DELETE and MERGE as well as various options for INSERT including creating a new table with data from an existing table. You will also see how the system can automatically provide values for columns when inserting data.

 

Lessons:

  • Inserting data into tables
  • Changing and deleting data

Exercise: Modify data

Your benefit
  • Using SQL Server query tools
  • Writing SELECT statements to retrieve columns from one or more tables
  • Sorting and filtering selected data
  • Use built-in functions to return data values
  • Creating data groups and aggregating the results
  • Changing data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE
trainer
Philippe Moser
Methods

This course consists of training training and is led by a trainer who supervises the participants live. Theory and practice are taught with live demonstrations and practical exercises. The video conferencing software Zoom is used.

Final examination
Recommended for

This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes every who works with data as a data analyst, data engineer, data scientist, database administrator, or database developer.
It can also be useful for others who are peripherally involved with data or want to learn more about working with data, such as solution architects, students, and technology managers.

Start dates and details

Form of learning

Learning form

18.8.2025
Online
Few places available
Implementation secured
Online
Few places available
Implementation secured

The training is carried out in cooperation with an authorized training partner.

The latter collects and processes data under its own responsibility. Please take note of the corresponding privacy policy

Do you have questions about training?
Call us on +49 761 595 33900 or write to us at service@haufe-akademie.de or use the contact form.