Take advantage of spring savings with up to 50% off ILT training.

MyGK
Support
USA USA - English
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Subtotal

$

Checkout

or Continue Shopping

Contact Sales
Course  
Contact Sales
Support
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Subtotal

$

Checkout

or Continue Shopping

Request Group Training

Querying Data with Microsoft Transact-SQL (DP-080T00)

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

LEARN MORE

Elite Total Access Collection for Microsoft
Access this course and over 50 other instructor-led training courses for only $2,999.

 

WATCH NOW

Microsoft Azure Certification Video

GK# 821360 Vendor# MDP-080T00
Vendor Credits:
  • Global Knowledge Delivered Course
  • Training Exclusives
No matching courses available.
Start learning as soon as today! Click Add To Cart to continue shopping or Buy Now to check out immediately.
Access Period:
Scheduling a custom training event for your team is fast and easy! Click here to get started.
$
Your Selections:
Location:
Access Period:
No available dates
Add To Cart

BUY NOW

Request a quote

Who Should Attend?

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.

What You'll Learn

Students will learn to,

  • Get Started Querying with Transact-SQL

Course Outline

Module 1: Get Started Querying with Transact-SQL

  • Introduction to Transact-SQL
  • Introduction to Transact-SQL
  • Combine multiple tables with JOINs in T-SQL
  • Write Subqueries in T-SQL
  • Write Subqueries in T-SQL
  • Modify data with T-SQL
BUY NOW