SQL

Last reviewed: 2026-05-29

Purpose: SQL database querying and management — covering T-SQL stored procedures, table joins, string manipulation, and batch processing patterns.

Contents

• Overview
• Stored Procedures
• Joins & String Operations

Overview

SQL training material focused on Microsoft SQL Server (T-SQL) patterns, including paged stored procedures for large result sets, multi-table joins, and string splitting techniques.

Stored Procedures

• PagedStoredProcedure — Template pattern for implementing paginated stored procedures in T-SQL. Covers OFFSET/FETCH, dynamic row counts, and output parameter patterns for efficient paging through large datasets.

Related SQL Scripts (DOCKERS context)

The training content bundle includes additional SQL scripts:

• JointTables.sql — Multi-table JOIN examples demonstrating INNER, LEFT, and CROSS JOIN patterns with real event data.
• SplitString.sql — T-SQL string splitting function using STRING_SPLIT and recursive CTE approaches.
• CreateFMNEAEvents.sql — Table creation DDL for FMEA (Failure Mode and Effects Analysis) event schemas.
• CreateFMNEAEventsMAP.sql — Mapping table creation for FMEA event transformations.
• CreateJOBID.sql — Script for creating and seeding job ID tracking tables.

Key Skills Covered

• Paged stored procedures with OFFSET/FETCH
• Dynamic SQL for flexible filtering
• Multi-table JOIN strategies
• String splitting and manipulation
• Table creation with proper indexing patterns