Additional Resources

📚 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

• 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

• 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

• 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

• 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

• 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.