Home > Opleidingen > Querying Data with Microsoft Transact-SQL (DP-080) (English)

Querying Data with Microsoft Transact-SQL (DP-080) (English)

Duur
3 dagen
Prijs

€ 1795,-
Reviews
1000+ reviews
Locatie

Nieuwegeinvirtueel
Planning

Planning ophalen...
Lesvorm
Vijfhart-Flex

Schrijf je direct in Meer informatie Brochure downloaden

This course is guaranteed to start and therefore will always take place.

In this course you will learn how to use Transact-SQL to query and modify data in relational Microsoft SQL Server based database systems:

Microsoft SQL Server
Azure SQL database
Azure Synapse Analytics

While specific Transact-SQL statements supported by these different systems may differ, you can use most of the techniques covered in this course for anything. Because Transact-SQL is based on the SQL ANSI standard, you can apply the techniques taught in this course to other popular database systems.
This course focuses on the queries that are most commonly used. Transact-SQL is a comprehensive language with many advanced capabilities not covered in this course, with the topics covered in this course you will learn the most common scenarios including:

Use SELECT to retrieve columns from a table
Sort and filter search results
Use joins and subqueries to retrieve data from multiple tables
Use built-in functions, aggregations, and groupings
Insert, update and delete data

In order to be able to cover all the material properly, to be able to complete the exercises and based on feedback from previous students, we have adjusted the standard duration of the course from two to three days.

Doel

Using 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 return data values
Group data and aggregate the results
Change data using INSERT, UPDATE, DELETE and MERGE

Doelgroep

This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. For example, anyone who works with data as a data analyst, data engineer, data scientist, database administrator or database developer. The course can also be useful for anyone who is indirectly involved with data and wants to learn more about SQL.

Voorkennis

There are no specific pre-requisites for this course.

Bijzonderheden

This course is based on Personal Coaching. During the course you will receive access to our electronic learning environment (mijn.vijfhart.nl). Here you will find all the necessary course material. This training is also delivered complete with a Microsoft Technical Exam Voucher and a MeasureUp Practice Test Voucher. During the course you will receive access to our electronic learning environment Mijn.Vijfhart.nl. Here you will find all the necessary course material.

Dejan de Gooijer

accountmanager

Onderwerpen

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

Planning & Prijs

* *Een cursus met start gegarandeerd.
*Een cursus met valt onder de actie Summer Academy.

Alle prijzen zijn excl. BTW.

Wil je meer informatie ontvangen, een vrijblijvende offerte ontvangen of een brochure van deze cursus downloaden? Vul onderstaande gegevens in en je ontvangt de brochure of informatie binnen één werkdag.

Gerelateerde cursussen

Ervaringen

ervaringen verzameld via

"Training was prima, goede tips gekregen met af en toe een grap en grol. Locatie was prima, goed verzogd vwb koffie/thee, fruit en koekje. Mensen ook zeer vriendelijk. Lunch was perfect en zeer uitgebreid."

"De cursus was goed, en de verzorging ook!Ik heb er veel van opgestoken! De lokatie in Nieuwegein is goed te bereiken met het openbaar vervoer, dus dat is prettig. Tot een volgenden keer."

"Ik vond de training erg leerzaam. De inhoud was van een hoog niveau en de docent was goed thuis in de materie. Ik stel het vooral op prijs dat er diep op de concepten werd ingegaan."

Tags:

Categorieën

Onderwerpen

Leveranciers

Prijs