Poznámka
Přístup k této stránce vyžaduje autorizaci. Můžete se zkusit přihlásit nebo změnit adresáře.
Přístup k této stránce vyžaduje autorizaci. Můžete zkusit změnit adresáře.
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.