Scribd
Upload
2 views2 pages

SQL Python Statistics 1 Month Timetable

The document outlines a 1-month study timetable focusing on SQL, Python, and Statistics, dedicating approximately 3-4 hours per day for 6 days a week. It is divided into four weeks, each covering different topics and concepts, with a mix of theory, practice problems, and projects. Tools recommended for practice include Jupyter Notebook, SQLite, and Kaggle.

Uploaded by

Allanki Divya
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
2 views2 pages

SQL Python Statistics 1 Month Timetable

The document outlines a 1-month study timetable focusing on SQL, Python, and Statistics, dedicating approximately 3-4 hours per day for 6 days a week. It is divided into four weeks, each covering different topics and concepts, with a mix of theory, practice problems, and projects. Tools recommended for practice include Jupyter Notebook, SQLite, and Kaggle.

Uploaded by

Allanki Divya
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

1-Month Study Timetable: SQL, Python, and Statistics

General Strategy General Strategy


- Time per day: ~3-4 hours
- Days per week: 6 (1 rest day)
- Split:
- Python: 40%
- SQL: 30%
- Statistics: 30%
- Tools: Use Jupyter Notebook, SQLite, Kaggle for practice.

Week Week 1: Basics & Setup


Day | Python | SQL | Statistics
-------- | ------------------------------------- | ---------------------------------- | -------------------------
Mon | Python setup, syntax, variables | Intro to DBs, SELECT | What is statistics?
Tue | Lists, Tuples, Dictionaries | Filtering, ORDER BY | Scales of measurement
Wed | Conditional statements, loops | Aggregate functions | Mean, median, mode
Thu | Functions, scope, return | GROUP BY, HAVING | Variance, std deviation
Fri | Practice problems | SQL practice | Practice problems
Sat | Mini Python project | Revision | Statistics quiz
Sun | Rest or recap | |

Week Week 2: Intermediate Concepts


Mon | List comprehensions, string methods | JOINs (INNER, LEFT) | Probability basics
Tue | File & exception handling | JOINs contd. | Independent vs dependent
Wed | Lambda, map, filter, zip | Subqueries | Permutations & combinations
Thu | Practice problems | SQL practice | Central limit theorem
Fri | File reader/CSV analyzer project | Revision | Practice problems
Sat | Practice all | Practice SQL | Statistics quiz
Sun | Rest or recap | |

Week Week 3: Applied Learning


Mon | NumPy basics | CASE, IFNULL | Hypothesis testing intro
Tue | Pandas basics | Views, indexes | p-values, t-tests
Wed | Data cleaning with Pandas | SQL on datasets | Confidence intervals
Thu | Merging data in Pandas | Window functions | Chi-square test
Fri | Mini data analysis project | Sample DB queries | Data distributions
Sat | Python + SQL via SQLite3 | Practice everything | Mini stat analysis
Sun | Rest or recap | |

Week Week 4: Real-world Practice


Mon | Kaggle dataset exploration | Querying dataset | Descriptive stats
Tue | Data visualization | Save outputs to CSV | Interpretation
Wed | Build analysis script | Query tuning | Correlation & regression
Thu | Practice test | Practice test | Practice test
Fri | Mini project | Refine project | Present findings
Sat | Final review | Push to GitHub | Summary notes
Sun | Rest & celebrate celebrate | |

You might also like