SQL roadmap for beginners with resources

SQL is the bread and butter of the data field. Mastering this is very essential

A thread🧵👇

1. SQL basics:

SQL for Beginners by Udemy: This is a great course to start with, covering the basics of SQL syntax, queries, and database design.
SQLBolt: A website with interactive lessons on SQL basics and advanced topics.
Mode Analytics: This website has a tutorial section

2. Database design:
Database Design Fundamentals by Pluralsight: This course covers the principles of database design, including normalization and table relationships.Practical Database Design by Udemy: Another course that covers database design principles with real-world example

3. Data types and sample data:

SQL Data Types by W3Schools: This page has a comprehensive list of SQL data types and how to use them.
SQLZoo: This website has several sample databases you can use to practice SQL queries.

4. SELECT statement and filtering:

SQL SELECT Statement by W3Schools: A comprehensive tutorial on the SELECT statement and its various clauses.
Codecademy: This website has interactive lessons on the SELECT statement and filtering.

5. Grouping and aggregation:

SQL Aggregation Functions by Mode Analytics: A tutorial on using aggregation functions like SUM and COUNT.
SQL Tutorial by Mode Analytics: Covers grouping and aggregation with interactive exercises.

6. Joins:

SQL Joins Tutorial by Mode Analytics: A tutorial on joining tables together to combine data.
SQLZoo: This website has several exercises on joining and combining data from multiple tables.

7. Subqueries:

SQL Subqueries by W3Schools: A tutorial on using subqueries to retrieve data from one table based on data from another table.
SQLBolt: Has a few exercises on subqueries.

8. Real-world scenarios:

HackerRank: This website has a section on SQL with practice exercises on various topics.
SQL Exercises: A website with a variety of SQL exercises to practice.

9. Indexing and optimization:

SQL Performance Explained by Markus Winand: A book that covers SQL performance tuning in depth.
Use The Index, Luke!: A website that covers indexing and optimization techniques in SQL.

10. Practice:

LeetCode: This website has a SQL section with practice problems ranging from easy to hard.
SQL Fiddle: A website where you can write and run SQL queries on various databases.

Thank you so much for reading this, for more follow @nevrekaraishwa2