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 |