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

Prijs
vanaf € 950
Niveau
Hbo
Soort
Training
Thema
Automatisering en ICT

Meer informatie en aanmelden bij Fast Lane Benelux B.V.

Beschrijving

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

Startmomenten

Start Einde Plaats Prijs
1 maart 2027 2 maart 2027 Online € 950
30 maart 2027 31 maart 2027 Online € 950
1 juni 2027 2 juni 2027 Online € 950
4 oktober 2027 5 oktober 2027 Online € 950