microsoft partner logo color
8293  Reviews star_rate star_rate star_rate star_rate star_half

Querying Data with Microsoft Transact-SQL

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...

Read More
$1,190 USD GSA  $899.24
Duration 2 days
Course Code DP-080T00
Available Formats Classroom, Virtual

Overview

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.

Audience Profile

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.

Skills Gained

After completing this course, students will be able to:

  • Use SQL Server query tools
  • Write SELECT statements to retrieve columns from one or more tables
  • Sort and filter selected data
  • Use built-in functions to returned data values
  • Create groups of data and aggregate the results
  • Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE

Course Details

Outline

  • Introduction to Transact-SQL
    • Work with schemas
    • Explore the structure of SQL statements
    • Examine the SELECT statement
    • Work with data types
    • Handle NULLs
    • Exercise - Work with SELECT statements
    • Knowledge check
  • Sort and filter results in T-SQL
    • Sort your results
    • Limit the sorted results
    • Page results
    • Remove duplicates
    • Filter data with predicates
    • Exercise - Sort and filter query results
    • Knowledge check
  • 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
    • Exercise - Query multiple tables with joins
    • Knowledge check
  • Write Subqueries in T-SQL
    • Understand subqueries
    • Use scalar or multi-valued subqueries
    • Use self-contained or correlated subqueries
    • Exercise - Use subqueries
    • Knowledge check
  • 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
    • Exercise - Use built-in functions
    • Knowledge check
  • Modify data with T-SQL
    • Insert data
    • Generate automatic values
    • Update data
    • Delete data
    • Merge data based on multiple tables
    • Exercise - Modify data
    • Knowledge check
|
View Full Schedule

Schedule

1 options available

  • Guaranteed to Run
    May 29, 2025 - May 30, 2025 (2 days)
    Live Virtual | 9:00AM 5:00PM EDT
    Language English
    Select from 1 options below
    Live Virtual |9:00AM 5:00PM EDT
    Live Virtual | 9:00AM 5:00PM EDT
    Enroll
    Enroll Add to quote

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

The course was informative, and I learnt a new skill. The instructor was up to the point.

The platform is very intuitive and easy to navigate. Great tool for learning

I didn't have any problem navigating Exitcertified website or lab material at all.

had a good time with the course, however some topics were left out due to the compact amount of time for training.

This was effective way to provide a ton of information in a short time period.