SQL Complete Roadmap – 2025
1. SQL and Database Introduction
2. Important keys
Primary , Foreign, Secondary
3. SQL Basic
- SELECT and FROM , Alias
- LIMIT
- WHERE
- COMPARISON Operators
- SQL Logical Operator
- LIKE
- IN
- BETWEEN
- IS NULL
- AND , OR , NOT
- ORDER BY
4. SQL Intermediate
- SQL Aggregate function
- COUNT
- SUM
- MIN , MAX
- AVG
- GROUP BY
- HAVING
- CASE
- DISTINCT
- JOINS – INNER , OUTER , LEFT, RIGHT
- SQL JOINS USING WHERE or ON
- FULL OUTER JOIN
- UNION
- SQL JOINS WITH COMPARISON OPERATORS
- SQL JOINS ON MULTIPLE KEYS
- SQL SELF JOIN
5. SQL Advance
- SQL Data Types – String , DateTime, Number, Boolean, Float
- Date Format
- String Functions to clean data
- LEFT, RIGHT, LENGTH
- TRIM
- POSITION and STRPOS
- SUBSTR
- CONCAT
- CHANGING CASE WITH UPPER AND LOWER
- TURNING STRINGS INTO DATES
- TURNING DATES INTO MORE USEFUL DATES
- SUBQUERIES
- PIVOTING DATA IN SQL
- Common Table Expression – CTE
6. Window Functions
- What are Window Functions
- Window Functions vs Aggregate Function
- Common Window Functions
- ROW_NUMBER()
- RANK()
- DENSE_RANK()
- Aggregate Functions – Sum, AVG, MIN, MAX, COUNT
- NTILE()
- LEAD and LAG
- FIRST_VALUE()
- LAST_VALUE()
- ROW and Range
7. SQL – Practice
In order to be a master in SQL you will have to practice different type of questions. Below are some if the resource which can help you in this
8. Analytics using SQL
- CASE STUDIES
- PRACTICAL QUESTIONS