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

Fast Lane Benelux B.V.

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 Micro...

Price
from €950
Level
Higher professional education (hbo)
Kind
Training
Subject
Automation and IT

More information and registration at Fast Lane Benelux B.V.

Description

Introduction to Transact-SQL - Introduction - Work with schemas - Explore the structure of SQL statements - Examine the SELECT statement - Work with data types - Handle NULLs - Exercise - Work with SELECT statements - Module assessment - Summary Sort and filter results in T-SQL - Introduction - Sort your results - Limit the sorted results - Page results - Remove duplicates - Filter data with predicates - Exercise - Sort and filter query results - Module assessment - Summary Combine multiple tables with JOINs in T-SQL - Introduction - Understand joins concepts and syntax - Use inner joins - Use outer joins - Use cross joins - Use self joins - Exercise - Query multiple tables with joins - Module assessment - Summary Write Subqueries in T-SQL - Introduction - Understand subqueries - Use scalar or multi-valued subqueries - Use self-contained or correlated subqueries - Exercise - Use subqueries - Module assessment - Summary Use built-in functions and GROUP BY in Transact-SQL - Introduction - Categorize built-in functions - Use scalar functions - Use ranking and rowset functions - Use aggregate functions - Summarize data with GROUP BY - Filter groups with HAVING - Exerci...

Start dates

Start End Place Price
1 March 2027 2 March 2027 Online €950
30 March 2027 31 March 2027 Online €950
1 June 2027 2 June 2027 Online €950
4 October 2027 5 October 2027 Online €950