Get Started Querying with Transact-SQL

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Module 1: Introduction to Transact-SQL

After completing this module, you will be able to:

Understand what SQL is for
Identify database objects in schemas
Identify SQL statement types
Use the SELECT statement
Work with data types
Handle NULLs

Module 2: Sort and filter results in T-SQL

After completing this module, you will be able to:

Sort your results
Limit the sorted results
Return paged results
Remove duplicates
Filter data with predicates

Module 3: Combine multiple tables with JOINs in T-SQL

After completing this module, you will be able to:

Describe join concepts and syntax
Write queries that use inner and outer joins
Write queries that use cross joins
Write queries that use self joins

Module 4: Write Subqueries in T-SQL

After completing this module, you will be able to:

Understand what subqueries are
Use scalar or multi-valued subqueries
Use self-contained or correlated subqueries

Module 5: Use built-in functions and GROUP BY in Transact-SQL

After completing this module, you will be able to:

Categorize built-in functions
Use scalar functions
Use ranking and rowset functions
Use aggregate functions
Summarize data with GROUP BY
Filter groups with HAVING

Module 6: Modify data with T-SQL

After completing this module, you will be able to:

Insert data into a table
Generate automatic values
Update data in a table
Delete data from a table
Merge data based on multiple tables