Additional Resources
๐ Additional Resources for Interns
Section titled โ๐ Additional Resources for InternsโThis page gathers helpful articles, documentation, and cheat sheets to support your learning throughout the internship. None of these are mandatory โ just helpful reads if you want to dive deeper or need support.
๐ Python for Data Work
Section titled โ๐ Python for Data Workโ-
Pandas Cheatsheet (Official)
Great reference for cleaning, filtering, merging, and reshaping data. -
10 Minutes to pandas
A fast and practical introduction for hands-on learners. -
Python Data Cleaning Tips (Real Python)
Tips on dealing with missing values, formatting, and duplicates.
๐๏ธ SQL + PostgreSQL
Section titled โ๐๏ธ SQL + PostgreSQLโ-
PostgreSQL SELECT Tutorial
Start with the basics, then explore joins, filters, and subqueries. -
Mode SQL Tutorial (Interactive)
Perfect for visual learners with real datasets and hands-on exercises. -
SQL JOIN Visualizer
Use this to understand how INNER, LEFT, RIGHT, and FULL JOINs work.
๐งโ๐ป Git & GitHub
Section titled โ๐งโ๐ป Git & GitHubโ-
GitHub Flow Explained
Understand branching, pull requests, and how we collaborate. -
Oh Shit, Git!?!
A friendly and funny guide to fixing common Git mistakes. -
Learn Git Branching (Interactive)
Visual simulator to practice branching and merging safely.
๐ ETL, Schema Design & Data Engineering
Section titled โ๐ ETL, Schema Design & Data Engineeringโ-
What is ETL? (IBM)
Get familiar with Extract-Transform-Load as a core data process. -
Database Normalization Explained
Understand how to design clean and scalable relational schemas. -
SQL Upsert Patterns
Learn the mechanics of inserting or updating data smartly.
๐ฏ Bonus: Soft Skills for Data Interns
Section titled โ๐ฏ Bonus: Soft Skills for Data Internsโ-
Writing Better Commit Messages
Clean, clear commit logs = happier reviewers. -
How to Ask Good Questions
A must-read for communicating blockers on GitHub or Slack.
๐ Keep this list bookmarked, and return to it anytime youโre stuck or curious!
If you find a resource you love, suggest it to the team โ weโre always learning too.