Type and hit enter to Search
×

Querying Data With Microsoft Transact-SQL DP080 - Saudi Arabia

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

Multiple Routes of Delivery to
Fit Your Timetable

We understand that flexibility is key to effective learning and development, especially in today’s dynamic work environment. That’s why we offer multiple delivery formats for our IT trainings in UAE. Whether you prefer the interaction of in-person classes, the convenience of live virtual training, or the independence of self-paced online learning, we have a solution tailored to your schedule. Our goal is to make professional growth accessible to everyone, allowing you to upskill without compromising your other commitments.

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

14 April 2025 - 15 April 2025
DP-080T00: Querying Data With Microsoft Transact-SQL
14 July 2025 - 15 July 2025
DP-080T00: Querying Data With Microsoft Transact-SQL
14 October 2025 - 15 October 2025
DP-080T00: Querying Data With Microsoft Transact-SQL
14 January 2026 - 15 January 2026
DP-080T00: Querying Data With Microsoft Transact-SQL

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
Open chat
Hello
How Can We Help You?