O'Reilly logo
live online training icon Live Online training

T-SQL First Steps

Learn how to query SQL Server

Topic: Data
Kathi Kellenberger

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:

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