SQL Interview Preparation

What ever may be position on the interview SQL is must and we must be aware of:

Here are some SQL Concepts which we should know before an interview.

1. Joins
2. Aggregate Functions
3. Window Functions - Row_number() , Rank() , Dense_Rank() , lead() , lag()
4. Analytic Function's - Range() between Window Functions and Row() Between Window Functions.
5. To Find Running Total , Moving Average , Moving Sum etc..
6. Stored procedures
7. Function's etc..