Training: Querying Data with Microsoft Transact-SQL

Ref. DP-080T00
Duration:
2
 days
Exam:
Not certifying
Level:
Fundamental

Description

This course teaches 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.

Participant profiles

  • Database Administrators
  • Database Developers
  • Business Intelligence professionals
  • SQL power users who aren’t necessarily database-focused such as report writers, business analysts and client application developers

Objectives

  • Use SQL Server query tools
  • Write SELECT statements to retrieve columns from one or more tables
  • Sort and filter selected data
  • Use built-in functions to returned data values
  • Create groups of data and aggregate the results
  • Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE

Prerequisites

  • No prerequisites

Course content

Module 1: Getting Started with Transact-SQL

  • Introduction to Transact-SQL
  • Using the SELECT statement

Module 2: Sorting and Filtering Query Results

  • Sorting query results
  • Filtering the data

Module 3: Using Joins and Subqueries

  • Using JOIN operations
  • Using subqueries

Module 4: Using Built-in Functions

  • Getting started with scalar functions
  • Grouping aggregated results

Module 5: Modifying Data

  • Inserting data into tables
  • Modifying and deleting data

Documentation

  • Access to Microsoft Learn (online learning content)

Lab / Exercises

Official Microsoft Labs

  • Get started with SQL Server query tools and writing queries in T-SQL
  • Sort and filter data returned by SELECT queries
  • Write queries with JOIN operations
  • Write SELECT statements using subqueries
  • Built-in functions
  • Modify data

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.
Prix de l'inscription
CHF 1'700.-
Inclus dans ce cours
  • Training provided by a certified trainer
  • 180 days of access to Official Microsoft Labs
  • Official documentation in digital format
  • Official Microsoft achievement badge

jeu11Avr(Avr 11)09:00ven12(Avr 12)17:00VirtuelVirtual Etiquettes de sessionDP-080T00

jeu11Avr(Avr 11)09:00ven12(Avr 12)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-080T00

jeu23Mai(Mai 23)09:00ven24(Mai 24)17:00VirtuelVirtual Etiquettes de sessionDP-080T00

jeu23Mai(Mai 23)09:00ven24(Mai 24)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-080T00

jeu04juil(juil 4)09:00ven05(juil 5)17:00VirtuelVirtual Etiquettes de sessionDP-080T00

jeu04juil(juil 4)09:00ven05(juil 5)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-080T00

jeu15Aoû(Aoû 15)09:00ven16(Aoû 16)17:00VirtuelVirtual Etiquettes de sessionDP-080T00

jeu15Aoû(Aoû 15)09:00ven16(Aoû 16)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-080T00

jeu26Sep(Sep 26)09:00ven27(Sep 27)17:00VirtuelVirtual Etiquettes de sessionDP-080T00

jeu26Sep(Sep 26)09:00ven27(Sep 27)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-080T00

jeu07Nov(Nov 7)09:00ven08(Nov 8)17:00VirtuelVirtual Etiquettes de sessionDP-080T00

jeu07Nov(Nov 7)09:00ven08(Nov 8)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-080T00

jeu19Déc(Déc 19)09:00ven20(Déc 20)17:00VirtuelVirtual Etiquettes de sessionDP-080T00

jeu19Déc(Déc 19)09:00ven20(Déc 20)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-080T00

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X