4.8Course 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.
Learning Options
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 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
DP-080T00: Querying Data With Microsoft Transact-SQL
14 April 2025 - 15 April 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
Duration
Language
Batch Options
Upcoming Batch
Soft copy of Courseware
Certificate of Course Complition
Experienced and Professional Trainer
Lab and Exercises During Training 
Sample Questions for Exam Prepration
Mock Test on the Last Day of Training 
Exam Registration Guidance 
5-Star Training Environmment 
