Domain: SQL Server

SQL Server

T-SQL query reference across fundamentals, advanced patterns, and engineering — from schema exploration through partitioning strategies.

mindmap
  ((SQL Server))
    (fundamentals)
    (advanced patterns)
    (engineering)

SQL Fundamentals

• Schema exploration
• Aggregation and GROUP BY
• JOINs across medallion layers
• Window functions
• CTEs and subqueries
• Data quality checks

SQL Advanced

• Advanced window functions
• Recursive CTEs
• Pivot and unpivot
• MERGE upsert
• Grouping sets and rollup
• NULL handling patterns

SQL Engineering

• Views
• Stored procedures
• Indexes
• Slowly changing dimensions
• Execution plans and optimization
• Partitioning strategies