DP-080T00: Querying Data With Microsoft Transact-SQL

  • 4.8(45,987 Rating)

Course Overview

This two-day 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.

Target Audiance

  • 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.

Schedule Dates

DP-080T00: Querying Data With Microsoft Transact-SQL
10 April 2024 - 11 April 2024
DP-080T00: Querying Data With Microsoft Transact-SQL
10 July 2024 - 11 July 2024
DP-080T00: Querying Data With Microsoft Transact-SQL
10 October 2024 - 11 October 2024
DP-080T00: Querying Data With Microsoft Transact-SQL
13 January 2025 - 14 January 2025

Course Content

  • Introduction to Transact-SQL
  • Using the SELECT statement
  • Get started with SQL Server query tools and writing queries in T-SQL

  • Sorting query results
  • Filtering the data
  • Sort and filter data returned by SELECT queries

  • Using JOIN operations
  • Using subqueries
  • Write queries with JOIN operations
  • Write SELECT statements using subqueries

  • Getting started with scalar functions
  • Grouping aggregated results
  • Built-in functions

  • Inserting data into tables
  • Modifying and deleting data

FAQs

No FAQs Found
Start learning with 15.8k students around the world.
  • 3.3k
    Courses
  • 100+
    Certified Instructors
  • 99.9%
    Success Rate
Open chat
Hello
How Can We Help You?