Implementing Data Models and Reports with Microsoft SQL Servers

Start Date End Date Venue Fees (US $)
14 Dec 2025 Dubai, UAE $ 4,200 Register
18 Jan 2026 Dubai, UAE $ 3,900 Register
14 Jun 2026 Istanbul, Turkey $ 4,500 Register
25 Oct 2026 Jeddah, KSA $ 4,500 Register

Implementing Data Models and Reports with Microsoft SQL Servers

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

    At the end of this course you will be able to:

    • Describe the components, architecture, and nature of a BI solution
    • Create a multidimensional database with Analysis Services
    • Implement dimensions in a cube
    • Implement measures and measure groups in a cube
    • Use MDX Syntax
    • Customize a cube
    • Implement a Tabular Data Model in SQL Server Analysis Services
    • Use DAX to enhance a tabular model
    • Create reports with Reporting Services
    • Enhance reports with charts and parameters
    • Manage report execution and delivery
    • Implement a dashboard in SharePoint Server with PerformancePoint Services
    • Use Data Mining for Predictive Analysis

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

Accreditation

Related Courses

2026 Training Calendar (Excel)
Nationals Development Training Program
Laboratory Systems ISO17025 Consulting
Competency Frameworks Consulting
Talent & Succession Planning Solutions
Employee Assessment & Development Plans