AGGREGATING DATA

WORKING WITH RANK -DENSE RANK-DUPLICATE ROWS

WORKING WITH TABLES

DATA MANIPULATION- ROLLBACK & COMMIT

WORKING WITH SUB QUERIES

WORKING WITH GROUP BY FUNCTIONS

SQL DAY 3 JOINS -EQUI JOIN - NON EQUI JOIN- INNER JOIN OUTER JOIN

WORKING WITH SQL FUNCTIONS - SINGLE ROW FUNCTIONS AND MULTI ROW FUNCTIONS

WORKING WITH DATA FILTER AND SORTING OF DATA

BASIC SQL STATEMENTS RETRIEVE DATA FROM THE DATABASE USING BASIC SELECT STATEMENTS