SQL:
  1. CTE
  2. Global Temp Tables
  3. Indexes
  4. Joins
  5. Types of Schema
SSIS:

  1. Types of Dimensions
  2. Types of Measure
  3. OLAP vs OLTP
  4. Multiple sheet Importing in SSIS flow with Logic
  5. Delay validation