DP080T00: Querying Data with Microsoft Transact-SQL

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Apr 17, 202409:0005:00EDTLive Virtual Class2$1,190 USDPurchase
May 29, 202409:0005:00EDTLive Virtual Class2$1,190 USDPurchase


DP-080T00

Querying Data with Microsoft Transact-SQL

This course will teach you how to use Transact-SQL to query and modify 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.

Duration: 2 Days

Audience

  • Individuals who need to write basic SQL or Transact-SQL queries: Data Analysts, Data Engineers, Data Scientists, Database Administrators and Database Developers
  • Individuals peripherally involved with data, or wanting to learn more about working with data such as Solution Architects, students, and Technology Managers

Learning Objectives

  • 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 return data values
  • Create groups of data and aggregate the results
  • Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE

Topics

  • Getting Started with Transact-SQL
  • Sorting and Filtering Query Results
  • Using Joins and Subqueries
  • Using Built-in Functions
  • Modifying Data
Right Menu IconMENU