Querying Data with TSQL

Sample scripts for each lectures of the edx course Microsoft: DAT201x - Querying Data with Transact-SQL
https://www.edx.org/course/querying-data-with-transact-sql-0

Course details -

• 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