StationX
Start free

Browse › T-SQL Database Query

Can You Query Data by Using Transact-SQL?

Advanced

Part of T-SQL Database Query Topic: Data Science

Access

StationX Infrastructure Labs — 3 attempts per lab

🔒 Add StationX Infrastructure Labs — $149 / year · 3 attempts per lab

Already have access? Sign in.

New to this? Try a free practice lab — a scripted hacking challenge in your browser, no account needed.

What you'll do

In this challenge, you will write several Transact-SQL (T-SQL) queries for a database table.

  1. Launch Microsoft SQL Server Management Studio (SSMS)
  2. Develop a query that performs calculations by using expressions and column aliases
  3. Develop more specific queries that return filtered data from a table by using the SQL query WHERE clause
  4. Explore queries that sort and limit the results by using ORDER BY, OFFSET, and FETCH
  • ⏱ About 45 minutes