Querying Data with Microsoft Transact-SQL

Course DP-080T00

  • Duration:
    • 2 days

Dates:

  • Implementation planned - places still available
  • Implementation - probability high - still places available
  • There are no more seats available. For many courses, it may still be possible to participate online, via virtual classroom.
  • Course times: As a rule, our seminars are held from 10:00 am to 5:00 pm on day 1 and from 9:00 am to 4:00 pm on the following days. Changes are possible. The concrete seminar times you will find in the binding order confirmation.
14.01.2027 - 15.01.2027 Virtual Classroom
  • 1400 EUR / Person
 German
11.03.2027 - 12.03.2027 Virtual Classroom
  • 1400 EUR / Person
 German
10.06.2027 - 11.06.2027 Virtual Classroom
  • 1400 EUR / Person
 German
23.09.2027 - 24.09.2027 Virtual Classroom
  • 1400 EUR / Person
 German
25.11.2027 - 26.11.2027 Virtual Classroom
  • 1400 EUR / Person
 German
This course teaches the basics of Transact-SQL, the Microsoft dialect of the standard SQL language. Topics include querying and modifying data in relational databases hosted in Microsoft SQL Server-based database systems. These include Microsoft SQL Server, Azure SQL Database and Azure Synapse Analytics.

In this course, participants will gain the following skills:
  • Using SQL Server query tools.
  • Writing SELECT statements to retrieve columns from one or more tables
  • Sort and filter selected data
  • Using built-in functions to return data values
  • Create data groups and aggregate results
  • Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE
First steps with Transact-SQL:
  • Introduction to Transact-SQL
  • Using the SELECT statement
Sorting and filtering query results:
  • Sorting query results
  • Filtering data
Using JOIN and subqueries:
  • Using JOIN operations
  • Using sub-queries
Using built-in functions:
  • Getting started with scalar functions
  • Grouping aggregated results
Changing data:
  • Inserting data into tables
  • Changing and deleting data
Anyone who needs to write simple SQL or Transact-SQL queries can benefit from this course. This includes data analysts, technical and scientific data professionals, database administrators or database developers. It can also be useful for people who are marginally involved with data or simply want to learn more about data processing, such as solution architects, students and technology executives.
The course price includes:
- The original Microsoft training materials in English and digital form
- Break supply for face-to-face training: drinks, pastries, and lunch

We are also happy to conduct this training as an in-house seminar. Please request your individual offer.

The course is offered in German and English.

Please click here to go to our English course: DP-080T00_e - Querying Data with Microsoft Transact-SQL (English)

Contact us

SoftwareONE

IT CAMPUS
Customer Training Solutions

Blochstraße 1
D-04329 Leipzig
*The services of SoftwareONE Deutschland GmbH directly serving school and educational purposes are predominantly VAT-exempt according to § 4 No. 21 a) bb) UStG. Contact us - we are happy to help!