Course curriculum

  • 1

    T-SQL Subquery

    • 01 Data Source Installation

    • 02 Subqueries single value

    • 03 Subqueries multiple value

    • 04 Cross Joins with Where

    • 05 Calculated Fields Subquery

    • 06 Min values filter subquery

    • 07 Table filter Checking for Existence

    • 08 subqueries versus inner joins
  • 2

    T-SQL Apply Operator

    • 09 APPLY operator vs Power Query

    • 10 Cross APPLY and Outer APPLY