Skip to main Content

Query and modify data with Transact-SQL (DP-080)

  • Course Code M-DP080
  • Duration 2 days

Course Delivery

Public Classroom Price

Please call

Request Group Training Add to Cart

Jump to:

Course Delivery

This course is available in the following formats:

  • Company Event

    Event at company

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

Request this course in a different delivery format.

Download Course Details

Course Overview

Top

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 Schedule

Top

Contact us for dates

Request Group Training Dates in Other Countries

Target Audience

Top

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.

Show me more

Course Objectives

Top

Students will learn to,

  • Get Started Querying with Transact-SQL
Show me more

Course Content

Top

Module 1:  Query and modify data with Transact-SQL

  • 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
Show me more