DP-080: Querying Data with Microsoft T-SQL – 10+ Tests

Learn Microsoft T-SQL fundamentals for querying data, filtering results, and working with SQL Server databases

This course provides a clear and structured introduction to Microsoft Transact-SQL (T-SQL), designed to help learners build a strong foundation in querying and managing data using SQL Server. It is aligned with the DP-080: Querying Data with Microsoft Transact-SQL learning objectives and focuses on practical, real-world database querying skills.

You will begin by learning how to create databases and tables, including using T-SQL statements to create, alter, and drop database objects. The course then introduces data types, helping you understand how data is stored and managed in SQL Server.

As the course progresses, you will work with basic Data Manipulation Language (DML) commands to insert, update, delete, and retrieve data. You will learn how to organize database objects using schemas and synonyms, followed by a deep dive into SELECT queries, which form the core of data querying in T-SQL.

The course covers essential querying techniques such as sorting data, filtering records using predicates, and limiting result sets using TOP, OFFSET, and FETCH. You will also learn how SQL Server handles NULL and unknown values, how to use CASE expressions for conditional logic, and how to combine result sets using set operations.

Each topic is explained through focused video lessons, making complex SQL concepts easy to understand. Practice tests are included to help you assess your understanding and reinforce key concepts. By the end of this course, you will be confident in writing T-SQL queries to retrieve and analyze data effectively.