microsoft partner logo color
7854  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
View Full Schedule Train Your Team
$1,190 USD GSA  $899.24
Course Code DP-080T00
Duration 2 days
Available Formats Classroom, Virtual

Upcoming Course Dates

  • May 29, 2024 - May 30, 2024 (2 days)
    Live Virtual
    Language Time
    English 9:00AM – 5:00PM EDT
    Select delivery method/location  (1 options)
    Live Virtual | 9:00AM – 5:00PM EDT
    Live Virtual | 9:00AM – 5:00PM EDT
    Enroll
    Enroll
    SAVE on this course -  Promo Code:  MSKILL500
  • GTR
    Jun 10, 2024 - Jun 11, 2024 (2 days)
    Virtual
    Language Time
    English 09:00 AM – 05:00 PM EDT
    Select delivery method/location  (1 options)
    Virtual | 09:00 AM – 05:00 PM EDT
    Virtual | 09:00 AM – 05:00 PM EDT
    Enroll
    Enroll
  • Aug 12, 2024 - Aug 13, 2024 (2 days)
    Live Virtual
    Language Time
    English 9:00AM – 5:00PM EDT
    Select delivery method/location  (2 options)
    Live Virtual | 9:00AM – 5:00PM EDT
    Live Virtual | 9:00AM – 5:00PM EDT Virtual | 09:00 AM – 05:00 PM EDT
    Enroll
    Enroll
    SAVE on this course -  Promo Code:  MSKILL500
Ask a Question Request Other Date Request On-site Course

Overview

Schedule

FAQ

Reviews

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
  • Sort and filter results in T-SQL
  • Combine multiple tables with JOINs in T-SQL
  • Write Subqueries in T-SQL
  • Use built-in functions and GROUP BY in Transact-SQL
  • Modify data with T-SQL
Read Less
|
View Full Schedule
View Full Schedule