Course 6-SQL-Takmili-Query Level 2
Video Files
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
Presentation Files (pdf)
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
Scripts & Samples
- 24-AggregationFunctions
- 25-Null AggregationFunctions
- 26-Where AggregationFunctions
- 27-Distinct AggregationFunctions
- 28-GroupBy
- 29-GroupBy2
- 30-GroupBy MultipleColumn
- 31-GroupBy All
- 32-GroupBy Having
- 33-GroupBy Rollup
- 34-GroupBy Cube
- 35-GroupBy Pivot
- 36-GroupingSet
- 37-Join
- 38-Cross-Join
- 39-Inner-Join
- 40-Inner-Join-MultipleKey
- 41-Inner-Join-MultipleTable
- 42-Self-Join
- 43-GroupBy-Join
- 45-RightOuterJoin
- 46-LeftOuterJoin
- 47-FullOuterJoin