Sources

There’s a few topics I’m often asked for resources on. I wanted to put them all in one place.

Learning Python

Beginner

• Python Discord: This is a very active Discord with people of all skill levels
• PyDis resources: Python Discord publishes a great list of beginner resources.
• Harvard’s CS50 Series: CS50 isn’t a single course, it’s a collection of great courses. CS50 for Python is a great starting point, followed by CS50 for AI.

Intermediate

• The Missing Semester of your CS Education

Advanced

• FoDE
• Landscape of High-Performance Python

Conference Talks

Watching conference talks are your best bet to level up your Python skills

• EuroPython 2023 Videos
• Pycon US 2023 Videos

Learning SQL

Beginner

• sql_python_tutorial
• python.org Tutorial
• Khan
• Kaggle Intro

Interactive Lessons

• sqlbolt
• selectstarsql
• datawars.io: Not solely SQL

Intermediate

• PDM

Advanced

• HackerRank SQL Challenges

Helpful Sites

• dbfiddle.uk
• DuckDB Shell

Fun and Interesting Stuff

• ReadMe Maturity Model
• F U Pay Me
• Naked Ifs
• Pytz - Fastest Footgun

Stats

Beginner

• https://www.youtube.com/c/3blue1brown

Misc

• https://www.itl.nist.gov/div898/handbook/ : I love this book for EDA. It’s incredibly exhaustive and doesn’t stop yielding great stuff.
• https://mml-book.github.io/book/mml-book.pdf
• https://www.statlearning.com/
• https://arxiv.org/abs/2106.11342

Financial Data Analysis

• How to spot Backtest Overfitting, along with https://www.youtube.com/watch?v=e3h9xf3p1DE
• Advances in Financial Machine Learning

The Classics

Please actually read these. Don’t just skim the summary and think you’ve got it.

• Mythical Man Month
• Innovator’s Dilemma
• The Fallacy of Premature Optimization
• Stevey’s Google Platforms Rant