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 |