Thread by @AdarshChetan

SQL Roadmap with YouTube Resources

A Thread 🧵

1 Basic SQL Syntax:
SQL keywords
Data types
Operators
SQL statements (SELECT, INSERT, UPDATE, DELETE)



w3schools.com/sql/

2. Data Definition Language (DDL):
CREATE TABLE
ALTER TABLE
DROP TABLE
Truncate table



khanacademy.org/computing/comp…

3. Data Manipulation Language (DML):
SELECT statement (SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING, JOINs)
INSERT statement
UPDATE statement
DELETE statement

youtube.com/live/AA7i2GcTG…

sqlzoo.net/wiki/SQL_Tutor…

4. Aggregate Functions:
SUM, AVG, COUNT, MIN, MAX
GROUP BY clause
HAVING clause



learnsql.com

5. Data Constraints:
Primary Key
Foreign Key
Unique
NOT NULL
CHECK

6. Joins:
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL OUTER JOIN
Self Join
Cross Join

7. Subqueries:
Types of subqueries (scalar, column, row, table)
Nested subqueries
Correlated subqueries

8. Advanced SQL Functions:
String functions (CONCAT, LENGTH, SUBSTRING, REPLACE, UPPER, LOWER)
Date and time functions
Numeric functions



youtube.com/live/q_JsgpiuY…

9. Views:
Creating views
Modifying views
Dropping views

10. Indexes:
Creating indexes
Using indexes for query optimization

11. Transactions:
ACID properties
Transaction management (BEGIN, COMMIT, ROLLBACK, SAVEPOINT)
Transaction isolation levels

lnkd.in/dqXffY6N

12. Data Integrity and Security:
Data integrity constraints (referential integrity, entity integrity)
GRANT and REVOKE statements (granting and revoking permissions)
Database security best practices

13. Stored Procedures and Functions:
Creating stored procedures
Executing stored procedures
Creating functions
Using functions in queries

14. Performance Optimization:
Query optimization techniques (using indexes, optimizing joins, reducing subqueries)
Performance tuning best practices

15. Advanced SQL Concepts:

Recursive queries
Pivot and unpivot operations
Window functions (Row_number, rank, dense_rank, lead & lag)
CTEs (Common Table Expressions)
Dynamic SQL



interviewbit.com/sql-server-int…

PS: Remember, this is just a suggested plan feel free to adjust based on your own learning style and pace.

𝐉𝐨𝐢𝐧 𝐭𝐡𝐢𝐬 𝐭𝐞𝐥𝐞𝐠𝐫𝐚𝐦 𝐠𝐫𝐨𝐮𝐩 𝐟𝐨𝐫 𝐩𝐫𝐞𝐦𝐢𝐮𝐦 𝐉𝐨𝐛𝐬/Notes:t.me/AdarshChetan

That's a wrap-up for this one 🎁

If you liked this thread :

🔁 Retweet the first tweet

Do Follow @AdarshChetan for more such amazing stuff ❤️

#coder #SoftwareEngineer #adarshchetan