DP-080T00 : Querying Data with Microsoft Transact-SQL

About Course

This course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

Course Prerequisites

There are no formal prerequisites for this course, though participants should have basic familiarity with database concepts and the SQL language. Recommended skills include:

Basic understanding of relational databases and how data is structured
General computer proficiency, including the ability to use query tools and navigate databases
No prior experience with T-SQL is required, as the course covers foundational topics

Target Audience

This course is valuable for:

Data analysts, data engineers, data scientists, and database administrators who need to query or manipulate data in Microsoft SQL Server-based systems
Database developers looking to enhance their T-SQL skills for writing complex queries
Solution architects, students, and technology managers seeking foundational knowledge of T-SQL for working with data
Professionals or anyone involved with data management tasks in environments that use SQL Server, Azure SQL Database, or Azure Synapse Analytics

Why Choose us

⭢ Live Online Training (Duration : 16 Hours)

⭢ Guaranteed to run classes

⭢ Experienced & certified trainers

⭢ Query Handling session

Enquire About This Course

Learning Objectives

The DP-080T00 course equips students with essential skills to write, modify, and understand SQL queries in a Microsoft SQL Server environment, helping them efficiently manage and manipulate data for business or analytical needs.

Understand the key concepts of Transact-SQL (T-SQL) and the structure of data within SQL Server databases
Use the SELECT statement to query and retrieve data from SQL Server databases
Master SQL Server query tools for writing and executing T-SQL queries effectively
Apply sorting techniques to organize query results for better readability and analysis
Implement filtering techniques to extract specific data from large datasets based on defined criteria
Use JOIN operations to retrieve and combine data from multiple tables within the same query
Write advanced queries with subqueries to retrieve complex data from relational tables
Learn and apply scalar and aggregate functions for data calculations and summarization
Effectively insert, update, and delete records from SQL Server tables
Learn how to group data and understand the impact of grouping on aggregated query results

Benefits of the course

Master Data Querying with Transact-SQL:
Gain essential skills in writing queries and manipulating data using Microsoft Transact-SQL, the foundational language for data professionals working with SQL Server and Azure SQL.
Industry-Relevant Skills:
Learn to retrieve, filter, join, and modify data efficiently, work with stored procedures and functions, and understand query optimization techniques.
Real-World Skills:
Build confidence in writing T-SQL queries to support business intelligence, reporting, and data analysis tasks across modern database environments.
Hands-On Experience:
Engage in practical labs focused on writing queries against real-world datasets, exploring subqueries, aggregations, and data transformations.
Career Boost:
Prepares you for roles such as Database Analyst, Data Engineer, or SQL Developer, and supports foundational knowledge for more advanced Azure data certifications.