course | Querying Data with Transact-SQL
We turn your development needs and aspirations into powerful digital solutions that drive growth
IT-1329 | Querying Data with Transact-SQL
Course Sector : Information Technology
| Duration | Date from | Date to | Course Venue | Course fees | Book a course |
|---|---|---|---|---|---|
| 5 Days | 2025-06-30 | 2025-07-04 | Dubai | $4,250 | Book now |
| 5 Days | 2025-07-21 | 2025-07-25 | Madrid | $4,950 | Book now |
| 5 Days | 2025-10-06 | 2025-10-10 | Abu Dhabi | $4,250 | Book now |
Course Introduction
This training course is designed to provide participants with the fundamental concepts related to Transact-SQL. This will cover topics such as introduction to SQL Server, the versions of SQL Server, including cloud versions, how to connect to SQL Server using SQL Server Management Studio, writing SELECT queries, grouping and aggregating data, and programming with T-SQL.
Course objective
- Gain a comprehensive understanding of the key capabilities and components of SQL Server.
- Learn T-SQL, sets, and predicate logic.
- Write a single table and multi-table SELECT statement.
- Write SELECT statements with filtering and sorting.
- Understand how SQL Server uses data types.
- Write DML statements, queries that use built-in functions, queries that aggregate data and subqueries.
- Create and implement views and table-valued functions.
- Use set operators to combine query results.
- Write queries that use window ranking, offset, and aggregate functions.
- Transform data by implementing pivot, unpivot, rollup and cube.
- Create and implement stored procedures.
- Add programming constructs such as variables, conditions, and loops to T-SQL code.
Course Outline | Day 01
Module 1: Introduction to Microsoft SQL Server
- Module 2: Introduction to T-SQL Querying
- Module 3: Writing SELECT Queries
- Module 4: Querying Multiple Tables
Course Outline | Day 02
Module 5: Sorting and Filtering Data
- Module 6: Working with SQL Server Data Types
- Module 7: Using DML to Modify Data
- Module 8: Using Built-In Functions
Course Outline | Day 03
Module 9: Grouping and Aggregating Data
- Module 10: Using Subqueries
- Module 11: Using Table Expressions
- Module 12: Using Set Operators
Course Outline | Day 04
Module 13: Using Windows Ranking, Offset, and Aggregate Functions
- Module 14: Pivoting and Grouping Sets
- Module 15: Executing Stored Procedures
Course Outline | Day 05
Module 16: Programming with T-SQL
- Module 17: Implementing Error Handling
- Module 18: Implementing Transactions
BOOST’s Professional Attendance Certificate “BPAC”
BPAC is always given to the delegates after completing the training course,and depends on their attendance of the program at a rate of no less than 80%,besides their active participation and engagement during the program sessions.
Upcoming Courses In This Sector
Since 2001, we have been pioneering the training field in the Middle East, helping individuals, teams, and organizations reach their full potential with integrated solutions.
🔗 Quick Links
Sister Companies to Boost Consulting and Training
most trending
And Recommended Training Courses
We believe in progress for everyone.
We helped more than 10,000 clients over 20 countries on 4 continents in boosting their knowledge, skills, and careers.
Boost Training And Consulting All Copyrights Reserved 2025