Querying Data with Transact-SQL

Course Description

This hands-on course provides participants with the knowledge and skills needed to query and manipulate data in Microsoft SQL Server using Transact-SQL (T-SQL). Participants will learn to write robust and efficient queries for data retrieval, transformation, filtering, aggregation, and joining. The course also introduces advanced querying techniques such as subqueries, common table expressions (CTEs), window functions, and data modification. Real-world case studies and guided labs will reinforce learning in a practical, business-driven context.

Durasi

5 Days

Course Objectives

By the end of this course, participants will be able to :

  • Understand the structure and components of T-SQL.
  • Write SELECT queries to retrieve and filter data from multiple tables.
  • Use JOINs, subqueries, and set operations to combine data.
  • Aggregate data using GROUP BY, HAVING, and window functions.
  • Write queries using CTEs, temporary tables, and table expressions.
  • Modify data using INSERT, UPDATE, DELETE statements.
  • Handle errors and transactions within T-SQL.
  • Apply best practices in writing clean, optimized, and secure SQL code.

Course Audience

  • Database Developers.
  • Business Intelligence Developers.
  • Data Analysts.
  • Database Administrators.
  • Application Developers working with SQL Server.

Course Prerequisites

  • Basic understanding of relational databases and data models.
  • Familiarity with Microsoft SQL Server environment is helpful but not required.
  • Some programming or scripting experience is beneficial.

Course Outline

  • Day 1 Introduction to Transact-SQL and Basic SELECT Queries

    1. Introduction to Microsoft SQL Server and SQL Server Management Studio (SSMS).
    2. Understanding database objects: tables, views, schemas.
    3. Writing basic SELECT statements.
    4. Filtering data using WHERE clause and logical operators.
    5. Sorting and formatting result sets.
    6. Using built-in scalar functions (string, date, math).

  • Day 2 Querying Multiple Tables and Set Operations

    1. Understanding and applying different types of JOINs (INNER, LEFT, RIGHT, FULL).
    2. Joining multiple tables in a single query.
    3. Using table aliases for readability.
    4. Using UNION, INTERSECT, and EXCEPT.
    5. Case scenario: Querying custom
Registration
Gallery
Contact