DP-080T00 Querying Data with Microsoft Transact-SQL
- 2 Days Course
- Language: English
Introduction:
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 Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
Objectives:
Course Outline:
1 – Introduction to Transact-SQL
- Work with schemas
- Explore the structure of SQL statements
- Examine the SELECT statement
- Work with data types
- Handle NULLs
2 – Sort and filter results in T-SQL
- Sort your results
- Limit the sorted results
- Page results
- Remove duplicates
- Filter data with predicates
3 – Combine multiple tables with JOINs in T-SQL
- Understand joins concepts and syntax
- Use inner joins
- Use outer joins
- Use cross joins
- Use self joins
4 – Write Subqueries in T-SQL
- Understand subqueries
- Use scalar or multi-valued subqueries
- Use self-contained or correlated subqueries
5 – Use built-in functions and GROUP BY in Transact-SQL
- Categorize built-in functions
- Use scalar functions
- Use ranking and rowset functions
- Use aggregate functions
- Summarize data with GROUP BY
- Filter groups with HAVING
6 – Modify data with T-SQL
- Insert data
- Generate automatic values
- Update data
- Delete data
- Merge data based on multiple tables
Enroll in this course
$1,295.00