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

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

Duration
3 dagen
Price

€ 1975,-
Reviews
1000+ reviews
Location

Nieuwegeinvirtueel
Schedule

Planning ophalen...
Classroom
Vijfhart-Flex

Enroll More information Download brochure

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.

Objectives

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

Target audience

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.

Requirements

There are no specific pre-requisites for this course.

Particularities

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.

Lucas Ditvoorst

senior accountmanager

Topics

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

Schedule & Price

* * This course event is guaranteed to run.
*Een cursus met valt onder de actie Summer Academy.

All prices are exclusive of VAT.

We are happy to help you. Please fill in the request form below and you will receive the requested information as soon as possible.

Related courses

Er zijn geen gerelateerde cursussen.

Tags:

Categorieën

Onderwerpen

Leveranciers

Prijs