/Querying-Data-with-TSQL

Sample scripts for each lectures of the edx course Microsoft: DAT201x - Querying Data with Transact-SQL

Primary LanguageTSQL

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