Querying Data with Microsoft Transact-SQL (DP-080T00-A [Coming Soon in April])

This new course will be replacing 20761 Querying Data with Transact-SQL which will go EOL in December 2021

részletek megjelenítése

The course will be 1-day in duration, and cover:

  • Module 1: Getting Started with Transact-SQL
  • Module 2: Sorting and Filtering Query Results
  • Module 3: Using Joins and Subqueries
  • Module 4: Using Built-in Functions
  • Module 5: Modifying Data

 

Description:

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
  • Azure Synapse Analytics

While the specific Transact-SQL statements supported by these different systems can vary, the majority of techniques described in this course can be used across all of them. Additionally, because Transact-SQL is based on the ANSI standard SQL language, the techniques learned on this course can often be used, with minimal adaptation, on other popular database systems.


The ability to query relational data sources is a fundamental skill for anyone working professionally with data; whether it be as a database administrator, a data analyst, or a software engineer building applications that store and consume data.


This course has been designed to focus on the kinds of queries that are used most commonly. Transact-SQL is a comprehensive language, that includes many advanced capabilities not covered in this course; but you should learn enough to create the queries you need for the most common scenarios, including:

  • Using SELECT to retrieve columns from a table
  • Sorting and filtering query results
  • Using joins and subqueries to retrieve data from multiple tables
  • Using built-in functions, aggregations, and groupings
  • Inserting, updating, and deleting data