Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
DP-080: Querying Data with Microsoft T-SQL – 10+ Tests
Rating: 4.5 out of 5(33 ratings)
624 students

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
Created byVandana Soni
Last updated 12/2025
English
English [Auto],

What you'll learn

  • Create databases using SQL Server and T-SQL
  • Create, alter, and drop tables using T-SQL
  • Understand and use SQL Server data types
  • Perform basic DML operations (INSERT, UPDATE, DELETE)
  • Write SELECT queries to retrieve data
  • Sort query results using ORDER BY
  • Filter data using WHERE predicates
  • Limit result sets using TOP, OFFSET, and FETCH
  • Work with NULL and unknown values
  • Use CASE expressions for conditional logic
  • Combine result sets using set operations
  • Apply T-SQL concepts to real-world querying scenarios

Course content

15 sections • 15 lectures • 5h 1m total length

  • Create Database43:24

    Explore how to create databases using a user interface and transact-SQL, and organize data with data and log files, file groups, and auto growth considerations.

  • Quiz 1

Requirements

  • Basic understanding of databases is helpful but not required
  • No prior SQL or T-SQL experience is required
  • Familiarity with computers and basic programming concepts is an advantage

Description

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.

Who this course is for:

  • Beginners who want to learn SQL and T-SQL from scratch
  • Students preparing for the DP-080 Microsoft learning path
  • Developers who need to query data from SQL Server
  • Data analysts starting with Microsoft SQL technologies
  • IT professionals working with relational databases
  • Anyone who wants a strong foundation in Transact-SQL

Report abuse