Transact-SQL (T-SQL) enables you to query and manipulate data in SQL Server. You can use T-SQL in applications and reports but also for querying to get a quick answer from a database. It’s a versatile language, as it’s based on standards used by many database platforms vendors, so you can apply your T-SQL skills to the majority of database systems.
Join expert Kathi Kellenberger to learn how to use T-SQL in SQL Server. You’ll examine the underpinnings of the language before exploring the fundamental tasks you can perform with T-SQL, including writing a SELECT statement to pull data from a table, sorting and filtering data, and writing a query by joining two tables. You’ll also dive into a few advanced topics, such as aggregates and subqueries, as you build the knowledge and skills to become a T-SQL pro.
What you'll learn-and how you can apply it
By the end of this live online course, you’ll understand:
- The clauses of a SELECT statement
- How tables join together
- Why filtering results is important
And you’ll be able to:
- Write a SELECT statement to pull data from a table
- Sort and filter the data
- Write a query by joining two tables
This training course is for you because...
- You’re a developer.
- You run queries that others write for you.
- You want to become a database administrator.
Prerequisites
- A computer with a Remote Desktop Protocol client installed (If you’re using Windows, this client is built in. If you’re using macOS, please install an RDP client like Microsoft Remote Desktop or FreeRDP.)
- A Microsoft account (Free tier is fine. All exercises will be provided through Azure Lab Services, through a virtual machine that has Azure Data Studio and SQL Server Management Studio preinstalled and configured.)
Recommended follow-up:
- Read Beginning T-SQL, third edition (book)
About your instructor
-
Kathi Kellenberger is a Microsoft Data Platform MVP and the author of several SQL Server books. She has been working with SQL Server since 1998, and has taught or presented on SQL Server topics in the US, Canada, and Europe. Kathi is a longtime volunteer with the PASS and LaunchCode organizations and the co-leader of the PASS Women in Tech Virtual Group.Kathi Kellenberger is a Microsoft Data Platform MVP and the author of several SQL Server books. She has been working with SQL Server since 1998, and has taught or presented on SQL Server topics in the US, Canada, and Europe. Kathi is a longtime volunteer with the PASS and LaunchCode organizations and the co-leader of the PASS Women in Tech Virtual Group.
Schedule
The timeframes are only estimates and may vary according to how the class is progressing
Course overview (15 minutes)
- Presentation and demo: SSMS
The SELECT statement (40 minutes)
- Presentation and demos: Simple SELECT; ORDER BY
- Hands-on exercise: Write a simple query
- Q&A
Break (5 minutes)
Filtering (30 minutes)
- Presentation and demo: The WHERE clause
- Hands-on exercise: Write a query with a WHERE clause
- Q&A
Break (5 minutes)
Joining tables (50 minutes)
- Presentation and demo: INNER JOIN and OUTER JOIN
- Hands-one exercise: Write a query with an INNER JOIN
- Q&A
Break (5 minutes)
Advanced topics (30 minutes)
- Presentation and demos: Aggregates; subqueries
- Q&A