Skip to main Content

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

  • Kursuskode M-DP080
  • Varighed 2 dage
  • Sprog Engelsk

Leveringsmetoder

Åbent kursus (Virtuelt) Pris

DKR10,850.00

Ekskl. Moms

Anmod om gruppetræning Køb

Go to:

Leveringsmetoder

Kurset er tilgængeligt i følgende formater:

  • Firma kursus

    Et lukket firma kursus

  • Åbent kursus

    Traditionel klasserumsundervisning

  • Åbent kursus (Virtuelt)

    Live klasserumsundervisning du tilgår virtuelt

Anmod om dette kursus Med en anden leveringsløsning

Download fuld kursusbeskrivelse

Beskrivelse

Toppen

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.

Kursusdato

Toppen
    • Leveringsmetode: Åbent kursus (Virtuelt)
    • Dato: 01-02 april, 2026 | 10:00 AM to 6:00 PM
    • Kursussted: Virtual (W. Europe )
    • Sprog: engelsk

    DKR10,850.00

    • Leveringsmetode: Åbent kursus (Virtuelt)
    • Dato: 23-24 april, 2026 | 9:00 AM to 4:30 PM
    • Kursussted: Virtual (W. Europe )
    • Sprog: engelsk

    DKR10,850.00

    • Leveringsmetode: Åbent kursus (Virtuelt)
    • Dato: 02-03 juli, 2026 | 10:00 AM to 6:00 PM
    • Kursussted: Virtual (W. Europe )
    • Sprog: engelsk

    DKR10,850.00

    • Leveringsmetode: Åbent kursus (Virtuelt)
    • Dato: 09-10 juli, 2026 | 9:00 AM to 4:30 PM
    • Kursussted: Virtual (W. Europe )
    • Sprog: engelsk

    DKR10,850.00

    • Leveringsmetode: Åbent kursus (Virtuelt)
    • Dato: 01-02 oktober, 2026 | 10:00 AM to 6:00 PM
    • Kursussted: Virtual (W. Europe )
    • Sprog: engelsk

    DKR10,850.00

    • Leveringsmetode: Åbent kursus (Virtuelt)
    • Dato: 08-09 oktober, 2026 | 9:00 AM to 4:30 PM
    • Kursussted: Virtual (W. Europe )
    • Sprog: engelsk

    DKR10,850.00

Se alle kursusdatoer Datoer i andre lande

Målgruppe

Toppen

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.

mere…

Kursets formål

Toppen

Students will learn to,

  • Get Started Querying with Transact-SQL
mere…

Kursusindhold

Toppen

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
mere…