- Course
Query Data with T-SQL
Learn how to work with data stored in SQL Server using T-SQL. This course will teach you how to query data effectively by understanding language fundamentals, practicing using the right tools, and building a strong theoretical foundation.
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.
Table of contents
About the author
Ami is a senior instructor and mentor with over 25 years of experience in data tier architecture, data modeling, database design, and SQL development.