1. Introduction to Transact-SQL
This module provides an introduction to relational databases, the SQL language and Transact-SQL. You will learn what kinds of statements make up the SQL language and look at the SELECT statement in detail.
Click here to know more
2. Sort and filter results in T-SQL
Learn how to sort and filter query results
Click here to know more
3. Combine multiple tables with JOINs in T-SQL
Explore T-SQL queries accessing data from multiple tables with various kinds of JOIN operations.
Click here to know more
4. Write Subqueries in T-SQL
Learn how to use subqueries to combine multiple SELECT statements and compose nested queries.
Click here to know more
5. Use built-in functions and GROUP BY in Transact-SQL
Learn how to use functions in Transact-SQL, and how to group aggregated results.
Click here to know more
6. Modify data with T-SQL
Learn how to use Transact-SQL to insert, update, and delete data in a database.
Click here to know more