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

Agenda

Duration
2 Days

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