Skip to content

Latest commit

 

History

History
80 lines (47 loc) · 3.68 KB

videos-transact-sql.md

File metadata and controls

80 lines (47 loc) · 3.68 KB
titledescriptionauthorms.authorms.datems.servicems.subservicems.topicms.custommonikerRange
Programming databases with T-SQL videos
This page lists video content relevant for learning Transact-SQL (T-SQL).
markingmyname
maghan
05/24/2023
sql
t-sql
reference
ignite-2024
>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric

Programming databases with T-SQL videos

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.

 

[!VIDEO https://learn-video.azurefd.net/vod/player?show=programming-databases-with-t-sql-for-beginners&ep=rdbms-and-setup-1-of-7-programming-databases-with-t-sql-for-beginners]

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.

 

[!VIDEO https://learn-video.azurefd.net/vod/player?show=programming-databases-with-t-sql-for-beginners&ep=introduction-to-transact-sql-2-of-7-programming-databases-with-t-sql-for-beginners]

Sort and filter results in Transact-SQL

In this video, you learn how to use Transact-SQL to sort and filter results.

 

[!VIDEO https://learn-video.azurefd.net/vod/player?show=programming-databases-with-t-sql-for-beginners&ep=sort-and-filter-results-in-transact-sql-3-of-7-programming-databases-with-t-sql-for-beginners]

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.

 

[!VIDEO https://learn-video.azurefd.net/vod/player?show=programming-databases-with-t-sql-for-beginners&ep=combining-multiple-tables-with-joins-in-transact-sql-4-of-7-programming-databases-with-t-sql-for-beginners]

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.

 

[!VIDEO https://learn-video.azurefd.net/vod/player?show=programming-databases-with-t-sql-for-beginners&ep=write-subqueries-in-transact-sql-5-of-7-programming-databases-with-t-sql-for-beginners] 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.

 

[!VIDEO https://learn-video.azurefd.net/vod/player?show=programming-databases-with-t-sql-for-beginners&ep=use-functions-and-group-by-in-transact-sql-6-of-7-programming-databases-with-t-sql-for-beginners]

Modify data with Transact-SQL

In this video, you learn how to use Transact-SQL to insert, update, and delete data in a database.

 

[!VIDEO https://learn-video.azurefd.net/vod/player?show=programming-databases-with-t-sql-for-beginners&ep=modify-data-with-transact-sql-7-of-7-programming-databases-with-t-sql-for-beginners]

Next steps

To learn more, visit the Get Started Querying with Transact-SQL learning path on Microsoft Learn.

close