[go: up one dir, main page]
Scribd
Upload
35 views2 pages

SQL Beginner Learning Roadmap

The document outlines a beginner SQL learning roadmap spanning eight weeks, focusing on fundamental concepts such as basic querying, joins, aggregation, and subqueries. It includes specific goals, topics to cover, and resources for each two-week segment, culminating in practical projects for real-world application. Additionally, it suggests extra topics to explore for further skill development in SQL.

Uploaded by

suman.kumari.iitm
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
35 views2 pages

SQL Beginner Learning Roadmap

The document outlines a beginner SQL learning roadmap spanning eight weeks, focusing on fundamental concepts such as basic querying, joins, aggregation, and subqueries. It includes specific goals, topics to cover, and resources for each two-week segment, culminating in practical projects for real-world application. Additionally, it suggests extra topics to explore for further skill development in SQL.

Uploaded by

suman.kumari.iitm
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Beginner SQL Learning Roadmap

Week 1–2: Basics of SQL


 Goals: Understand what SQL is, basic querying
 Topics:

 - SELECT, FROM, WHERE


 - Filtering with AND, OR, IN, BETWEEN
 - ORDER BY, LIMIT

 Resources:

 - SQLBolt: https://sqlbolt.com
 - Video: freeCodeCamp SQL Full Course (https://www.youtube.com/watch?
v=HXV3zeQKqGY)
 - Book: Learning SQL by Alan Beaulieu

Week 3–4: Joins, Aggregation & Grouping


 Goals: Combine data across tables, basic analysis
 Topics:

 - INNER JOIN, LEFT JOIN, RIGHT JOIN


 - GROUP BY, HAVING
 - COUNT(), SUM(), AVG(), MAX(), MIN()

 Resources:

 - LeetCode SQL: https://leetcode.com/problemset/database/


 - Mode SQL Tutorial: https://mode.com/sql-tutorial/
 - YouTube: SQL joins visual explanation

Week 5–6: Subqueries & CTEs


 Goals: Handle complex questions, clean your queries
 Topics:

 - Subqueries (SELECT inside WHERE, etc.)


 - CTEs (WITH clause)
 - Nested queries

 Resources:

 - StrataScratch: https://www.stratascratch.com/
 - YouTube: Subqueries and CTEs in SQL

Week 7–8: Projects & Real-World Practice


 Goals: Build confidence by applying what you've learned
 Topics:

 - Movie database queries


 - Sales dashboard query system
 - Build a small employee database

 Resources:

 - Kaggle Datasets: https://www.kaggle.com/datasets


 - Data.gov: https://www.data.gov/
 - DB Fiddle: https://www.db-fiddle.com/
 - SQLite Online: https://sqliteonline.com/

Extras to Explore Later


 Goals: Broaden your SQL skillset
 Topics:

 - Database Design & Normalization


 - Window Functions (ROW_NUMBER, RANK, etc.)
 - SQL for Data Analysis (PostgreSQL or MySQL)

You might also like