Model Online / On-Site
Duration
Modules 7 modules

About the Course

By the end of this training, participants will have mastered comprehensive data querying techniques in SQL Server and will be able to create and manage database objects effectively.

Curriculum

SQL Server Fundamentals and Environment Overview

  • SQL Server Architectural Structure

  • SQL Server Edition Family

  • Inspecting System Databases

  • Getting to Know the SSMS (SQL Server Management Studio) Interface

  • SSMS Usage Principles

  • Using Object Explorer

  • Script and Project Organization

  • Query Execution Techniques

  • Core Table Design Principles
Core Concepts of the T-SQL Language

  • Categories of T-SQL Statements

  • Core Components of T-SQL

  • Understanding ResultSets

  • Using Predicate Structures

  • Overview of the SELECT Statement

  • Clauses of the SELECT Statement

  • Logical Query Processing Flow of SELECT

  • Query Processing Architecture
Retrieving Data with the SELECT Statement

  • Writing Basic SELECT Queries

  • Returning Unique Rows with DISTINCT

  • Using Column and Table Aliases
Querying Data Across Multiple Tables

  • Relational Database Concepts

  • Normalization and Data Consistency

  • Introduction to JOINs

  • In-Depth Examination of JOIN Logic

  • Cartesian Product

  • Comparing JOIN Types

  • INNER JOIN Applications

  • Using OUTER JOINs (LEFT, RIGHT, FULL)

  • CROSS JOIN Scenarios

  • Using SELF JOINs
Sorting and Filtering Data Techniques

  • Sorting Results with ORDER BY

  • Conditional Filtering with WHERE

  • Pagination Applications

  • Using the TOP Clause

  • Pagination with OFFSET–FETCH

  • Handling NULL Values
SQL Server Data Types and Usage

  • Overview of Data Types

  • Numeric Data Types

  • Binary and String Data Types

  • Data Type Precedence Rules

  • Declaring and Managing Variables

  • Character-Based Data Types

  • Collation Structure

  • String Concatenation Techniques

  • Using String Functions

  • Date and Time Operations
Using Built-in Functions

  • Function-Based Queries

  • Scalar Functions

  • Using Aggregate Functions

  • Introduction to Window Functions

  • Rowset Functions

  • Data Conversion Functions (CAST, CONVERT, TRY_CAST)

  • Logical Functions (IIF, CHOOSE, CASE)

Other Courses in This Category

  • Big Data Querying and Analytics with Apache Spark SQL

    Apache Spark SQL and the DataFrame API, Catalyst Optimizer and Adaptive Query Execution (AQE), Parquet/Delta Lake/Iceberg table formats, join strategies and fixing data skew — for teams building big-data analytics.

    Databases Corporate
    Live Course
    5 modules
    View
  • PostgreSQL for Developers: From Fundamentals to Advanced SQL

    PostgreSQL data types, advanced SQL (CTEs, window functions, LATERAL), JSONB document modelling, full-text search, B-Tree/GIN/GiST/BRIN indexes, PL/pgSQL, MVCC/locking and partitioning — for application developers.

    Databases Corporate
    Live Course
    5 modules
    View
  • PostgreSQL Database Administration, High Availability and Operations

    PostgreSQL architecture, memory and WAL tuning, MVCC/Autovacuum and bloat control, PgBouncer connection pooling, PITR backups with pgBackRest, Streaming/Logical Replication and Patroni high availability.

    Databases Corporate
    Live Course
    5 modules
    View
  • MySQL and MariaDB Development, Tuning and Administration

    InnoDB storage engine and clustered index architecture, query and index optimisation, transaction and lock analysis, backups, GTID replication and high availability — for developer and DBA teams running MySQL and MariaDB.

    Databases Corporate
    Live Course
    5 modules
    View
  • Oracle Database Architecture, SQL Tuning and Administration

    Oracle Multitenant (CDB/PDB) architecture, SGA/PGA memory and background processes, tablespace/segment management, B-Tree/Bitmap indexes, partitioning, AWR/ASH tuning, RMAN backups and Data Guard essentials.

    Databases Corporate
    Live Course
    5 modules
    View
  • MongoDB Document Data Modelling, Aggregation and Operations

    BSON and document schema design patterns (embedding vs referencing), the Aggregation Pipeline, compound/multikey indexes and the ESR rule, multi-document ACID transactions, Change Streams, Replica Sets and Sharding.

    Databases Corporate
    Live Course
    5 modules
    View

Get in touch