Scribd
Upload
5 views2 pages

SQL RoadMap + Data Visualization Projects

The document outlines a 30-day SQL roadmap designed to help individuals master SQL for data analyst and business intelligence roles, covering essential concepts and advanced queries. It includes a structured daily plan with specific topics, practice sets, and resources for each phase of learning. Additionally, it provides links to Tableau projects and courses for further skill development in data visualization.

Uploaded by

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

SQL RoadMap + Data Visualization Projects

The document outlines a 30-day SQL roadmap designed to help individuals master SQL for data analyst and business intelligence roles, covering essential concepts and advanced queries. It includes a structured daily plan with specific topics, practice sets, and resources for each phase of learning. Additionally, it provides links to Tableau projects and courses for further skill development in data visualization.

Uploaded by

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

SQL RoadMap + Data Visualization Projects

Author- vee_daily19

Sometimes the most important thing you need is a small victory to push you forward. When I
was looking for an internship, I had to be strategic about my job search especially with limited
time. At this time, I prioritized learning SQL because not only was it the easiest to do but also
made me eligible for data analyst roles and business intelligence engineer roles.

SQL RoadMap to Master in 30 days :

When I say master, it means that by this time, you could ask me any advance queries and I
could solve them. I practiced over 300 problems to ensure I knew how to use each and every
sql function including advance concepts like rank, window, partition.

Day 1 - 2 : Select , from , where. And , or , not Learn the basic fundamentals -
Day 3 - 6 : group by, order by , distinct, and, aggregate , update , delete , select top
Day 7 - 10 : joins , inner join, outer join, lef join , right join,

Days SQL Resources

Day 1- 2 Select , from , where. And , or Practice SET 1 , Leetcode 50


,not Learn the basic , w3schools
fundamentals

Day 3 - 6 group by, order by , distinct, Practice Set 5 , Leetcode 50


and, aggregate , update , section 3 , w3schools for
delete , select top practice

Day 7 - 10 Joins : inner join, left join, Practice Set 6 , Leetcode 50


right join, outer join. Basic Joins , hackerrank

Day 11 - 14 Advanced Select and Joins, Practice Set 7 , Leetcode 50


Multiple Joins, , Hackerrank

Day 15 - 22 Subqueries and aggregate Leetcode 50 , Hackerrank


functions like window, rank, aggregation
partition

Day 23 - Day 30 Advanced String and Regex I left advanced string


+ Revision functions and didn’t
necessarily practice too much
except few key functions.
This is because they are not
just highly specific but rarely
asked.

Key concepts for SQL :

1.​ JOINS
2.​ SUBQUERIES
3.​ AGGREGATE FUNCTIONS
4.​ RANK, WINDOW, PARTITION - these are really useful and life savers. Learn how to use
them.

Tableau Projects

1.​ Use community projects to learn Tableau :


https://www.tableau.com/community/community-projects

2.​ Full 6 hour tableau course : https://www.youtube.com/watch?v=aHaOIvR00So

3.​ Tableau 21 hour course for beginners :


https://www.youtube.com/watch?v=K3pXnbniUcM

4.​ Learn Tableau Series :


https://www.youtube.com/watch?v=SSq5NwsUNGI&list=PLEiEAq2VkUUJEvrsey26P-Bj4
Vk6BLBVC

You might also like