SQL: Analytic Function

Spark: Transformation and Action

Spark setup on windows local machine

Introduction to Spark

Agenda to spark tutorial

3 ways to find second / Nth Highest salary in SQL server

SQL Constraint Index

SQL Constraint FOREIGN KEY

SQL Constraint PRIMARY KEY

SQL Constraint Unique

SQL Constraint Check

SQL Constraints Default

SQL Constraint: NOT NULL

SQL: View

SQL: Sub Query

SQL: Analytic Function RANK and DENSE_RANK

SQL: Analytic Function ROW NUMBER

SQL: Analytic Function LAG and LEAD

SQL: Analytic Function

SQL: Aggregate Function (min, max, sum, count and avg)

SQL: Full Join

SQL: Right Outer Join

SQL: Left Outer Join

SQL: Inner Join

SQL: DQL Commands