Querying Data with Transact-SQL
free to enroll, add certification for $99
6 weeks long @ 4-5 hours/week
Prerequisite: basic understanding of databases and IT systems
Content covered:
Create Transact-SQL SELECT queries
Work with data types and NULL
Query multiple tables with JOIN
Explore set operators
Use functions and aggregate data
Work with subqueries and APPLY
Use table expressions
Group sets and pivot data
Modify data
Program with Transact-SQL
Implement error handling and transactions