Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This page provides video content for learning about Transact-SQL (T-SQL).
In this video series, you learn the basics of Transact-SQL. You see how to add, edit, delete, and query data in a relational database. After completing the video series and the accompanying Microsoft Learn modules, you have the foundational knowledge to work with Transact-SQL in your applications.
RDBMS and setup
In this video, you learn why a relational database system and the Transact-SQL language can help you solve real-world business problems and how to set one up.
Introduction to Transact-SQL
In this video, you get an introduction to relational databases, the SQL language, and Transact-SQL. You learn what kinds of statements make up the SQL language and look at the SELECT
statement in detail.
Sort and filter results in Transact-SQL
In this video, you learn how to use Transact-SQL to sort and filter results.
Combining multiple tables with JOINS in Transact-SQL
In this video, you learn how to use Transact-SQL to join together multiple tables using various JOIN operations.
Write subqueries in Transact-SQL
In this video, you learn how to use Transact-SQL to use subqueries to combine multiple SELECT
statements and compose nested queries.
What are the SQL database functions?
Use functions and GROUP BY in Transact-SQL
In this video, you learn how to use Transact-SQL to use functions in Transact-SQL and how to group aggregated results.
Modify data with Transact-SQL
In this video, you learn how to use Transact-SQL to insert, update, and delete data in a database.
Next steps
To learn more, visit the Get Started Querying with Transact-SQL learning path on Microsoft Learn.