Thread by @swapnakpanda

Be an SQL Expert in just 6 months.

A roadmap for Absolute Beginners:

Beginner
⭣ Learn fundamentals ➊
⭣ Working with table ➋
⭣ Working with data ➌
⭣ Querying the data ➍
⭣ Operators ➎
⭣ Functions ➏
⭣ Database objects ➐
⭣ Programming in SQL ➑
⭣ Users and Roles ➒
⭣ Advanced Concepts ➓
Pro

➊ Fundamentals

Effort: 1 to 2 hours per day
Time: 2 weeks

➀ What is a database and DBMS?
➁ What is a relational database?
➂ What are the different vendors for RDBMS?
➃ What is normalization?
➄ Different normalization forms (NFs).
➅ What is SQL?
➆ Different components of SQL.
➇ What is ERD?

➋ Working with database/table

Effort: 1 to 2 hours per day (Study + Practice)
Time: 2 weeks

❯ Create a database
❯ Create a table
❯ Alter a table
❯ Add a column
❯ Remove a column
❯ Modify a column
❯ Rename a table
❯ Drop a table
❯ Various Datatypes
❯ Constraints
❯ Primary Key
❯ Foreign Key
❯ NOT NULL data
❯ UNIQUE data

➌ Working with data

Effort: 1 to 2 hours per day (Study + Practice)
Time: 2 weeks

❯ Insert records
❯ Modify a record
❯ Merge data
❯ Delete a record
❯ Truncate a table

* Once done, try to insert/modify huge data into multiple tables at one shot.

➍ Querying the data

Effort: 1 to 2 hours per day (Study + Practice)
Time: 4 weeks

❯ SELECT
❯ WHERE clause
❯ Projection
❯ Aggregation
❯ Join
❯ Union, Intersection
❯ Subquerying
❯ Sorting

* Once done, learn about query optimization.

➎ Operators

Effort: 1 to 2 hours per day (Study + Practice)
Time: 2 weeks

❯ Arithmetic
❯ Logical
❯ Comparison
❯ String
❯ Bitwise
❯ Compound

➏ Functions

Effort: 1 to 2 hours per day (Study + Practice)
Time: 3 weeks

❯ String-based
❯ Numeric
❯ Date-based
❯ Comparison

✧ Functions vary from vendor to vendor.

➐ Database objects

Effort: 1 to 2 hours per day (Study + Practice)
Time: 4 weeks

❯ View
❯ Materialized View
❯ Index
❯ Sequence
❯ Synonym
❯ Trigger

➑ Programming

Effort: 1 to 2 hours per day (Study + Practice)
Time: 4 weeks

❯ Stored Procedure
❯ User-defined Functions

➒ Users and Roles

Effort: 1 to 2 hours per day (Study + Practice)
Time: 2 weeks

❯ Create user
❯ Create role
❯ Grant access to a user
❯ Grant access to a role
❯ Revoke access from a user
❯ Revoke access from a role
❯ Drop a role
❯ Drop a user

➓ Advanced Concepts

Effort: 1 to 2 hours per day (Study + Practice)
Time: 4 to 6 weeks

❯ Binding variables
❯ Temporary tables
❯ Common Table Expressions (CTE)
❯ Regular Expressions
❯ Pivot data
❯ Import data
❯ External tables

📚 Learning Resources

1. Book: SQL Professional Notes
books.goalkicker.com/SQLBook/

2. YouTube Course
❯ SQL Full Course (Data with Baraa)
youtube.com/watch?v=SSKVgr…

❯ SQL Crash Course (techTFQ)
youtube.com/watch?v=S86phs…

3. Free Online Course
openclassrooms.com/en/courses/603…

4. SQL Bootcamp (Free)
youtube.com/playlist?list=…

5. Practice Sites
❯ hackerrank.com/domains/sql
❯ sqlzoo.net/wiki/SQL_Tutor…
❯ sqlpad.io

If you are looking for a course on Product Management + AI,

This course from BITS Pilani may help you a lot.

https://x.com/swapnakpanda/status/1946516802030452741

🏁 Final Words

⬙ Choose one database (e.g., MySQL/PostgreSQL).

⬘ Spend at least 1 to 2 hrs/day learning and practicing.

⬙ Overall it should take 6 to 9 months.

⬘ Also learn a programming language in addition to SQL if you want to be an application developer.

All the best.