What you'll learn

Retrieving the right data quickly is essential—but without a strong grasp of query languages, it can be difficult to get what you need. In this course, Query Data with T-SQL, you’ll gain the ability to use Transact-SQL (T-SQL) and client tools to query and retrieve data from SQL Server. First, you’ll explore what T-SQL is and how it compares to other SQL dialects. Next, you’ll discover how to connect to SQL Server using both Microsoft and third-party client tools, and how to use SELECT statements to shape your results. Finally, you’ll learn how to filter data with WHERE clauses and refine your output with sorting and limiting techniques. When you’re finished with this course, you’ll have the skills and confidence to query data using T-SQL and the right tools to support your analysis tasks.