Scribd
Upload
12 views3 pages

Python and SQL Roadmap for Data Analysts

The document outlines a comprehensive roadmap for learning Python and SQL for data analysis roles. It includes recommended courses, practice exercises, and resources for mastering Python basics, data analysis with libraries, and SQL concepts over a structured timeline. Optional projects and interview preparation resources are also provided to enhance practical skills.

Uploaded by

vamshi
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
12 views3 pages

Python and SQL Roadmap for Data Analysts

The document outlines a comprehensive roadmap for learning Python and SQL for data analysis roles. It includes recommended courses, practice exercises, and resources for mastering Python basics, data analysis with libraries, and SQL concepts over a structured timeline. Optional projects and interview preparation resources are also provided to enhance practical skills.

Uploaded by

vamshi
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

Python Roadmap -

First complete Python Basics from below mentioned course

[Link]

Practice 150 Python Basic question from below link to get aware about syntax -

[Link]

Complete below course of python data analysis using pandas, numpy, matplotlib and seaborn -

[Link]

Complete atleast 3-4 case study from below playlists -

[Link]

Practice Python interview questions for data scientist role (only try upto medium level) -

[Link]

Python Project (Optional) -

[Link]

—---------------------++++------++++++---------------

SQL Roadmap -

SQL week wise RoadMap With Free resources for Data Analyst role - #sql #dataanalyst

𝐖𝐞𝐞𝐤 𝟏 🗓️
- Work through the first 12 free interactive lessons on SQL Bolt.

This will teach you


○ SELECT
○ WHERE
○ JOINS
○ Aggregate Functions

Don’t worry about the Update/Create/Alter table lessons - skip these!

👉 [Link]
𝐖𝐞𝐞𝐤 𝟐 🗓️
- Work through the 38 short SQL tutorials on W3Schools.

This will cover similar material as SQL Bolt BUUUT

It’s absolutely worth repeating these SQL concepts so that they’ll sink into your brain!

👉 [Link]
𝐖𝐞𝐞𝐤 𝟑 🗓️ (𝐏𝐚𝐫𝐭 𝟏)
- For the first half of the week, work through the Intermediate SQL lessons on Mode Analytics
SQL tutorial.

This will teach you:

○ GROUP BY
○ CASE
○ WHERE vs. HAVING
○ UNION
○ SELF-JOINs

👉 [Link]
Week 3 (Part 2)

After having every basic idea of SQL , Try to watch below mentioned playlist -

[Link]

Focus on videos of - Window functions, Joins, Subqueries, WIth or CTE


𝐖𝐞𝐞𝐤 4 – 6 🗓️
- Put your SQL knowledge to the test on DataLemur , Hackerrank, Leetcode & Stratascratch by
practicing the real SQL interview questions asked by companies like Facebook & Google.

Try to start from EASY level then move to intermediate to Advance.

[Link]

[Link]

[Link]

[Link]

SQL Project - (Not Mandatory but for learning you can do – it will take 1 day)

[Link]

You might also like