Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
edupls_header
certification
Filter by Categories
Certifications
Data + Analytics
Design + UX
Dev + Engineer
Finance
HR + Recruiting
Marketing
Operations
Power Apps
Project
Project Management
Sales
SharePoint
software assurance
System Center
Technology
Training & Education
Virtual Training
Windows 10
Windows 7
Windows 8
Windows Server 2

DP-080T00 Querying Data with Microsoft Transact-SQL

On‑Demand: $595 | Instructor‑Led: $1,295 | Duration: 2 Days

Upgrade your tech skills with this training course from TechSherpas 365!

Select a Learning Method Below

Start Date End Date CLASS TIMES (EST) DELIVERY/LOCATION Status Price Enroll Now
1/26/2026 1/27/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run
$1,295
3/23/2026 3/24/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run
$1,295
5/28/2026 5/29/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run
$1,295
7/30/2026 7/31/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run
$1,295
START DATE : 1/26/2026
END DATE : 1/27/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run
PRICE : $1,295
START DATE : 3/23/2026
END DATE : 3/24/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run
PRICE : $1,295
START DATE : 5/28/2026
END DATE : 5/29/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run
PRICE : $1,295
START DATE : 7/30/2026
END DATE : 7/31/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run
PRICE : $1,295

Course Highlights
LEVEL: 
  • Intermediate
TOPICS & JOB ROLES: 
BRANDS/TECHNOLOGIES: 

DP-080T00 Querying Data with Microsoft Transact-SQL Course Outline

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.

Who Should Attend this Course?

This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.

1 – Introduction to Transact-SQL

  • Work with schemas
  • Explore the structure of SQL statements
  • Examine the SELECT statement
  • Work with data types
  • Handle NULLs

2 – Sort and filter results in T-SQL

  • Sort your results
  • Limit the sorted results
  • Page results
  • Remove duplicates
  • Filter data with predicates

3 – Combine multiple tables with JOINs in T-SQL

  • Understand joins concepts and syntax
  • Use inner joins
  • Use outer joins
  • Use cross joins
  • Use self joins

4 – Write Subqueries in T-SQL

  • Understand subqueries
  • Use scalar or multi-valued subqueries
  • Use self-contained or correlated subqueries

5 – Use built-in functions and GROUP BY in Transact-SQL

  • Categorize built-in functions
  • Use scalar functions
  • Use ranking and rowset functions
  • Use aggregate functions
  • Summarize data with GROUP BY
  • Filter groups with HAVING

6 – Modify data with T-SQL

  • Insert data
  • Generate automatic values
  • Update data
  • Delete data
  • Merge data based on multiple tables

Related Job Roles

This course builds skills and demonstrates qualifications for the job roles and average base salaries below. 

Computer Systems Analysts

Computer and Information Research Scientists

Database Architects

Data Warehousing Specialists

Actuaries

Mathematicians

Explore Related Training Courses

Related products

  • Data & Analytics

    PL-900T00 Microsoft Power Platform Fundamentals
    Microsoft Technical
    Beginner
    Learn the business value and product capabilities of Microsoft Power Platform. Create simple Power Apps, connect data with Dataverse, build a Power BI Dashboard, and automate processes with Power Automate.
    1 Day(s)
    $295 - $1,295
    Classroom Live
    On-Demand Learning (ODL)
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Business Intelligence

    Power BI for Data-driven Decision Makers
    Microsoft Technical
    Intermediate
    As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and…
    1 Day(s)
    $395
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Data & Analytics

    SQL Querying Fundamentals – Part 1
    Microsoft Technical
    Beginner
    In this course, students will compose SQL queries to retrieve desired information from a database.
    1 Day(s)
    $695
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Data & Analytics

    SQL Querying Fundamentals – Part 2
    Microsoft Technical
    Intermediate
    In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry…
    1 Day(s)
    $695
    Virtual Classroom
    Live, Instructor-Led (ILT)

What Our Students Are Saying

IT Certification Training Course Reviews