DP-080 | Querying Data with Microsoft Transact-SQL

Name: DP-080 | Querying Data with Microsoft Transact-SQL
Start: 1970-01-01T00:00:00+00:00
End: 1970-01-01T00:00:00+00:00
Location: Bensheim

What awaits you

Introduction to Transact-SQL
- Basics
- Properties and terminology of relational databases
- Using the SELECT statement
Sorting and filtering query results
- Sorting data using ORDER BY
- Filtering the output lines with WHERE
- Removing duplicates with DISTINCT
Using joins and subqueries
- Accessing data from multiple tables using JOIN
- Writing subqueries
Using built-in functions
- Introduction to scalar functions
- Grouping aggregated results
Modifying data
- Inserting data into an existing table
- Automatically populating a column with an IDENTITY or SEQUENCE value
- Modifying data using the UPDATE statement
- Removing data using the DELETE statement
- Modifying data using MERGE to synchronize two tables

Goal

This seminar teaches you the fundamentals of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include querying and modifying data in relational databases hosted on Microsoft SQL Server-based database systems, including Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics.

Requirement

Practical experience with relational databases
Basic knowledge of the Windows operating system and its core functionality

Miscellaneous

Services already included in the seminar price:

Conference catering
Digital Microsoft training materials

Possible expenses:

Overnight stays
Additional catering
Examination fee

All details at a glance

today Start:

September 14, 2026, 09:00

timer End:

September 15, 2026, 5:00 PM

place Location:

Bensheim

category Category:

payments Net price:

€790

hearing Language:

German

Book now

Your data has been successfully transmitted

check Thank you for your booking!
Your data has been successfully submitted. You will receive a confirmation email from us shortly.

Make another booking

Fill out the booking form and register!

Step 1: Fill in the participant data

partner number

company

first name*

last name*

e-mail address*

telephone number

Step 2: Add this participant

You can only complete the booking after you have added at least one participant

I consent to the PROVIDER sharing my email address with the sponsors of the event I have booked for the purpose of contacting them. I may revoke this consent at any time without giving reasons, effective for the future (email to EMAIL ADDRESS).

I agree that iTeam may share my email address with the sponsors of the event I have booked for the purpose of contacting them. I may revoke this consent at any time without giving reasons, effective for the future (email to partner@synaxon.de).

All seminars, downloads, workshops, etc. are exclusive to our SYNAXON partners. Are you working in the IT industry but not yet a SYNAXON partner? Then join us. here Contact us.

This event is an exclusive offer for our iTeam partners. Not yet an iTeam partner and want to take advantage of this offer? You can find further information here.

Step 3: Complete booking

Book bindingly For 0.00 €

* Mandatory fields

Please note: This is a binding booking for this event. Cancellation fees may apply. For further information, please refer to the general booking conditions or cancellation information. Prices are exclusive of VAT.

General booking conditions of the SYNAXON Academy

The general booking conditions of the SYNAXON Academy apply to the iTeam.

Summary

expand_less

today Start:

September 14, 2026, 09:00

timer End:

September 15, 2026, 5:00 PM

place Location:

Bensheim

info Price information:

hearing Language:

German

payments Total price:

0.00 €

You might also be interested in:

AI in Focus: The exchange and expert roundtable on AI in the system house

How can I use AI in a systems house effectively and to increase profits? This is just one of the questions we will address in the exchange and expert panel.

Learn more

Expert panel for system administrators

The daily challenges posed by new technologies and complex software solutions for IT technicians, support staff, and administrators are significant. This makes continuous training and exchange all the more important.

Learn more

Focus group: Optimizing tools, processes and billing in the system house

The challenges facing IT service providers are significant. New technologies, such as AI and complex software solutions, are an essential part of this.

Learn more

AI in Focus: The exchange and expert roundtable on AI in the system house

How can I use AI in a systems house effectively and to increase profits? This is just one of the questions we will address in the exchange and expert panel.

Learn more

Expert panel for system administrators

The daily challenges posed by new technologies and complex software solutions for IT technicians, support staff, and administrators are significant. This makes continuous training and exchange all the more important.

Learn more

Focus group: Optimizing tools, processes and billing in the system house

The challenges facing IT service providers are significant. New technologies, such as AI and complex software solutions, are an essential part of this.

Learn more

DP-080 | Querying Data with Microsoft Transact-SQL

What awaits you

Contents

Goal

Requirement

Miscellaneous

All details at a glance

Your data has been successfully transmitted

Fill out the booking form and register!

Step 1: Fill in the participant data

Step 2: Add this participant

Step 3: Complete booking

Summary

You might also be interested in:

AI in Focus: The exchange and expert roundtable on AI in the system house

Expert panel for system administrators

Focus group: Optimizing tools, processes and billing in the system house

AI in Focus: The exchange and expert roundtable on AI in the system house

Expert panel for system administrators

Focus group: Optimizing tools, processes and billing in the system house

Get in touch with us!

Your message has been successfully sent

We are happy to answer any questions you may have about the SYNAXON Academy!