DP080T00: Querying Data with Microsoft Transact-SQL

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Dec 1, 202209:0005:00ESTIn Class or by Video Conference2$1,350 USDPurchase
Jan 25, 202309:0005:00ESTIn Class or by Video Conference2$1,350 USDPurchase
Apr 3, 202309:0005:00EDTIn Class or by Video Conference2$1,350 USDPurchase
May 17, 202309:0005:00EDTIn Class or by Video Conference2$1,350 USDPurchase
Jul 10, 202309:0005:00EDTIn Class or by Video Conference2$1,350 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