[go: up one dir, main page]
Scribd
Upload
29 views3 pages

Python & SQL Roadmap For Data Analyst

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
29 views3 pages

Python & SQL Roadmap For Data Analyst

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
You are on page 1/ 3

Python Roadmap -

First complete Python Basics from below mentioned course

https://www.youtube.com/watch?v=kqtD5dpn9C8&t=1786s

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

https://www.w3resource.com/python-exercises/basic/

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

https://www.youtube.com/watch?v=r-uOLxNrNk8&t=683s

Complete atleast 3-4 case study from below playlists -

https://youtube.com/playlist?list=PL_1pt6K-CLoDMEbYy2PcZuITWEjqMfyoA

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

https://datalemur.com/python-interview-questions

Python Project (Optional) -

https://lnkd.in/emzcrzTX

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

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!

👉 https://sqlbolt.com/
𝐖𝐞𝐞𝐤 𝟐 🗓️
- 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!

👉 https://lnkd.in/gJfvU3PV
𝐖𝐞𝐞𝐤 𝟑 🗓️ (𝐏𝐚𝐫𝐭 𝟏)
- 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

👉 https://lnkd.in/gNsUPN6q
Week 3 (Part 2)

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

https://youtube.com/playlist?list=PLavw5C92dz9Ef4E-1Zi9KfCTXS_IN8gXZ

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.

http://datalemur.com/

https://leetcode.com/problemset/database/

https://www.hackerrank.com/

https://www.stratascratch.com/

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

https://lnkd.in/eq9jqcBq

You might also like