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

Einführung in Transact-SQL
- Grundlagen
- Eigenschaften und Terminologie relationaler Datenbanken
- Verwenden des SELECT-Statements
Sortieren und Filtern von Abfrageergebnissen
- Sortieren von Daten mit ORDER BY
- Filtern der ausgegebenen Zeilen mit WHERE
- Entfernen von Duplikaten mit DISTINCT
Verwenden von Joins und Unterabfragen
- Zugriff auf Daten aus mehreren Tabellen mit JOIN
- Schreiben von Unterabfragen
Verwenden von eingebauten Funktionen
- Einführung in skalare Funktionen
- Gruppieren von aggregierten Ergebnissen
Modifizieren von Daten
- Einfügen von Daten in eine bestehende Tabelle
- Automatisches Befüllen einer Spalte mit einem IDENTITY- oder SEQUENCE-Wert
- Modifizieren von Daten mithilfe des UPDATE-Statements
- Entfernen von Daten mithilfe des DELETE-Statements
- Modifizieren von Daten mithilfe von MERGE, um zwei Tabellen zu synchronisieren

Goal

In diesem Seminar erlernen Sie die Grundlagen von Microsofts Dialekt der Standard-SQL-Sprache: Transact-SQL. Zu den Themen gehören Abfrage und Modifizieren von Daten in relationalen Datenbanken, die in Microsoft-SQL-Server-basierten Datenbanksystemen gehostet sind, einschließlich Microsoft SQL Server, Azure SQL Database und Azure Synapse Analytics.

Requirement

Praktische Erfahrung mit relationalen Datenbanken
Grundkenntnisse über das Windows-Betriebssystem und seine Kernfunktionalität

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:

29. June 2026, 09:00

timer End:

30. June 2026, 17:00

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:

29. June 2026, 09:00

timer End:

30. June 2026, 17:00

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!