Skip to main Content

Query and modify data with Transact-SQL (DP-080)

  • Code training M-DP080
  • Duur 2 dagen
  • Taal Engels

Andere trainingsmethoden

Virtueel leren Prijs

eur1,450.00

(excl. BTW)

Vraag een groepstraining aan Schrijf je in

Ga naar:

Methode

Deze training is in de volgende formats beschikbaar:

  • Klassikale training

    Klassikaal leren

  • Op locatie klant

    Op locatie klant

  • Virtueel leren

    Virtueel leren

Vraag deze training aan in een andere lesvorm.

Download de volledige beschrijving van de training

Trainingsbeschrijving

Naar boven

This course will teach 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.

Virtual Learning

This interactive training can be taken from any location, your office or home and is delivered by a trainer. This training does not have any delegates in the class with the instructor, since all delegates are virtually connected. Virtual delegates do not travel to this course, Global Knowledge will send you all the information needed before the start of the course and you can test the logins.

Data

Naar boven
    • Methode: Virtueel leren
    • Datum: 19-20 februari, 2026 | 09:00 to 16:30
    • Locatie: Virtueel-en-klassikaal (W. Europe )
    • Taal: Nederlands

    eur1,450.00

    • Methode: Virtueel leren
    • Datum: 01-02 april, 2026 | 10:00 to 18:00
    • Locatie: Virtueel-en-klassikaal (W. Europe )
    • Taal: Engels

    eur1,450.00

    • Methode: Virtueel leren
    • Datum: 23-24 april, 2026 | 09:00 to 16:30
    • Locatie: Virtueel-en-klassikaal (W. Europe )
    • Taal: Engels

    eur1,450.00

    • Methode: Virtueel leren
    • Datum: 21-22 mei, 2026 | 09:00 to 16:30
    • Locatie: Virtueel-en-klassikaal (W. Europe )
    • Taal: Nederlands

    eur1,450.00

    • Methode: Virtueel leren
    • Datum: 02-03 juli, 2026 | 10:00 to 18:00
    • Locatie: Virtueel-en-klassikaal (W. Europe )
    • Taal: Engels

    eur1,450.00

    • Methode: Virtueel leren
    • Datum: 09-10 juli, 2026 | 09:00 to 16:30
    • Locatie: Virtueel-en-klassikaal (W. Europe )
    • Taal: Engels

    eur1,450.00

Bekijk de volledige planning Meer data in andere landen

Doelgroep

Naar boven

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

Meer…

Trainingsdoelstellingen

Naar boven

Students will learn to,

  • Get Started Querying with Transact-SQL
Meer…

Inhoud training

Naar boven

Module 1:  Query and modify data with Transact-SQL

  • Introduction to Transact-SQL
  • Sort and filter results in T-SQL
  • Combine multiple tables with JOINs in T-SQL
  • Write Subqueries in T-SQL
  • Use built-in functions and GROUP BY in Transact-SQL
  • Modify data with T-SQL
Meer…