Your SQL is great. But can you actually ship? Sam and Shifra kick off Season 1 (since Saturdata is zero-indexed) by covering the unsung skills that separate someone who writes queries from someone who builds things: terminal literacy, dependency management, Git, notebooks, and why UV might be Python's best friend right now. Plus, a deep dive into Marimo, the notebook tool that fixes everything you hate about Jupyter.

🌊 Check out the deep dive here: https://youtu.be/SWcLulIhVkg

We talk about:

- Terminal basics and why middle-school-level literacy is all you need

- Virtual environments, dependency conflicts, and why UV is the move

- Git fundamentals: staging, committing, and why humans still need to be in the loop

- What's wrong with Jupyter notebooks (and who's fault it is)

- Marimo: reactive notebooks, SQL cells, and dashboards all in one

Chapters:

0:00 - Welcome back (and why season two is called season one)

0:47 - Auxiliary data skills: the glue holding everything together

2:08 - How this season works: yap episodes + deep dives

4:01 - What auxiliary skills actually are (bash, docker, makefiles, oh my)

5:43 - Terminal literacy: your middle school diploma starts here

10:12 - Finding your terminal on Mac, Windows, and the WSL escape hatch

11:52 - Essential commands every data person should know

15:46 - Notebooks: an educational tool that accidentally went to production

19:55 - The biggest problems with traditional Jupyter notebooks

23:37 - Virtual environments and dependency conflicts, explained

26:30 - UV: the one tool to rule them all

30:24 - Git: version control, branching, and why humans still need to be in the loop

38:15 - Marimo: the next-generation notebook that fixes everything

47:28 - Closing thoughts

Unused tables cluttering your database aren't just a cost problem, they're a focus problem.

Sam explains how regular data audits can eliminate mental noise and free your team to think about what actually matters. A little cleanup goes a long way! 🧹✨

#reels #saturdata #data #dataengineering #dataops #productivity #DataTeams

When a stakeholder asks a question in a meeting, data fluency means you already know the tables, the filters, and exactly where to look before they finish talking.

Shifra breaks down why this skill is the foundation of every great data analyst, from understanding cardinality to querying partitioned data efficiently.

Master this and people will see the confidence in your presence before you even pull up a single query. 🔍📊#reels #saturdata #data #dataanalyst #datafluency #analytics #bigdata

Sam and Shifra drop a golden rule every data engineer needs to hear: always name your columns explicitly.

If your upstream table changes, you want your pipeline to break loudly so you can fix it fast rather than silently bloat your storage costs for months.

Think of it as a built-in data quality check!

💥#reels #saturdata #data #dataengineering #SQL #pipelinetips #dataqualiy

In a stakeholder meeting, someone will always ask "how'd you get that number?" Shifra breaks down why every data professional needs to be self-validating and ready to defend their query like a case in court. Your analysis is only as strong as your ability to explain it in terms anyone can understand. 🧑‍⚖️📊

#reels #saturdata #data #dataanalytics #datascience #stakeholdermanagement #datacareer

Senior data folks aren't winning because they write better queries. They win because they can connect the dots, build the pipeline, and actually get something in front of people. A recursive CTE is cool, but a working dashboard beats sharing your screen on SQL code every time. Level up beyond the query! 🚀#reels #saturdata #data #SQL #dataengineering #careergrowth #dataskills

Git has a feature called "blame" that tells you exactly who wrote every line of code. It's not just for laughs though, it helps teams know who to ping when something breaks or needs explaining. The real question is: when AI is writing your code, who does Git blame point to? 👀#reels #saturdata #data #git #coding #techhumor #devlife

When every step of your pipeline is validated by AI, who's actually checking the work? Sam breaks down why removing humans from the Git loop might be the biggest risk we're not talking about. Keep at least one human in the loop before anything hits main! 👀

#reels #saturdata #data #AI #devops #GitTips #techdebate