Implementing Data Models and Reports with Microsoft SQL Servers
| Start Date | End Date | Venue | Fees (US $) | ||
|---|---|---|---|---|---|
| Implementing Data Models and Reports with Microsoft SQL Servers | 14 Dec 2025 | 18 Dec 2025 | Dubai, UAE | $ 4,200 | Register |
| Implementing Data Models and Reports with Microsoft SQL Servers | 18 Jan 2026 | 22 Jan 2026 | Dubai, UAE | $ 3,900 | Register |
| Implementing Data Models and Reports with Microsoft SQL Servers | 14 Jun 2026 | 18 Jun 2026 | Istanbul, Turkey | $ 4,500 | Register |
| Implementing Data Models and Reports with Microsoft SQL Servers | 25 Oct 2026 | 29 Oct 2026 | Jeddah, KSA | $ 4,500 | Register |
Implementing Data Models and Reports with Microsoft SQL Servers
| Start Date | End Date | Venue | Fees (US $) | |
|---|---|---|---|---|
| Implementing Data Models and Reports with Microsoft SQL Servers | 14 Dec 2025 | 18 Dec 2025 | Dubai, UAE | $ 4,200 |
| Implementing Data Models and Reports with Microsoft SQL Servers | 18 Jan 2026 | 22 Jan 2026 | Dubai, UAE | $ 3,900 |
| Implementing Data Models and Reports with Microsoft SQL Servers | 14 Jun 2026 | 18 Jun 2026 | Istanbul, Turkey | $ 4,500 |
| Implementing Data Models and Reports with Microsoft SQL Servers | 25 Oct 2026 | 29 Oct 2026 | Jeddah, KSA | $ 4,500 |
Introduction
This Microsoft SQL Server training is a relational database management system (RDBMS) used to manage and store data. There are many different versions of Microsoft SQL Server, each with differing features, allowing SQL Servers to cater to the needs of professionals with various roles and responsibilities. Our Microsoft SQL Server Training provides valuable insights into efficiently using SQL Server, significantly enhancing productivity and an enterprise’s organisational capacity.
Objectives
Training Methodology
Different learning techniques will be used during the training course, starting from PowerPoint presentations, interactive practical exercises I PC labs, workshops, focused group discussions, related videos, and business case studies.
Who Should Attend?
This Training Course is designed for individuals who want to develop proficiency in querying and manipulating data using the Transact-SQL language within Microsoft SQL Server. This training course is especially beneficial for the following professionals:
- Database Developers
- Database Administrators
- Data Analysts
- Data Engineers
- IT Administrators
- DevOps Engineers
- Business Analysts
Course Outline
Module 1: Introduction to Transact-SQL
-
Introduction
-
Work with Schemas
-
Explore the Structure of SQL Statements
-
Examine the SELECT Statement
-
Work with Data Types
-
Handle NULLs
-
Exercise - Work with SELECT Statements
Module 2: Sort and Filter Results in T-SQL
-
Introduction
-
Sort Your Results
-
Limit the Sorted Results
-
Page Results
-
Remove Duplicates
-
Filter Data with Predicates
-
Exercise - Sort and Filter Query Results
Module 3: Combine Multiple Tables with JOINs in T-SQL
-
Introduction
-
Understand Joins Concepts and Syntax
-
Use Inner Joins
-
Use Outer Joins
-
Use Cross Joins
-
Use Self Joins
-
Exercise - Query Multiple Tables with Joins
Module 4: Write Subqueries in T-SQL
-
Introduction
-
Understand Subqueries
-
Use Scalar or Multi-Valued Subqueries
-
Use Self-Contained or Correlated Subqueries
-
Exercise - Use Subqueries
Module 5: Use Built-In Functions and GROUP BY in Transact-SQL
-
Introduction
-
Categorise Built-In Functions
-
Use Scalar Functions
-
Use Ranking and Rowset Functions
-
Use Aggregate Functions
-
Summarise Data with GROUP BY
-
Filter Groups with HAVING
-
Exercise - Use Built-In Functions
Module 6: Modify Data with T-SQL
-
Introduction
-
Insert Data
-
Generate Automatic Values
-
Update Data
-
Delete Data
-
Merge Data Based on Multiple Tables
-
Exercise - Modify Data

