/T_SQL

Microsoft: DAT201x Querying with Transact-SQL from edx

Primary LanguageSQLPL

T_SQL

Microsoft: DAT201x Querying with Transact-SQL from edx

ID Verified certificate available at: https://s3.amazonaws.com/verify.edx.org/downloads/cb977a59e4b544bd954bf7313c76e934/Certificate.pdf

Course Outline

Introduction to Transact-SQL

Querying Tables with SELECT

Querying Multiple Tables with Joins

Using Set Operators

Using Functions and Aggregating Data

Using Subqueries and APPLY

Using Table Expressions

Grouping Sets and Pivoting Data

Modifying Data

Programming with Transact-SQL

Error Handling and Transactions