🐍 Week 1 Recap: Python & SQL Essentials for MLOps 🚀

Hi everyone! 👋
Welcome back to my blog where I’m documenting my journey of transitioning into MLOps. This week, I focused on building strong foundations in two essential areas: Python and SQL.

---

🔹 Python Basics (Chapters 0–6 – CodeWithHarry)

I started with Python from CodeWithHarry’s beginner-friendly course. These chapters gave me a solid understanding of how Python works behind the scenes.

What I learned:

• Different data types like integers, floats, strings, booleans, lists, dictionaries, tuples, and sets

• Looping structures (for, while) and how to use break and continue effectively

• Creating and using functions to write clean and reusable logic

• Typecasting and common built-in functions

Reflection:

This week’s Python practice made me more confident in writing small logic-based programs, which is crucial before moving into data handling and automation in MLOps.

---

🔹 SQL Basics (Videos 1–10 – Kudvenkat)

Alongside Python, I also learned the basics of SQL with Kudvenkat’s clear explanations. SQL is essential for data extraction and reporting — a key part of MLOps workflows.

What I covered:

• How to use SELECT and WHERE to query databases

• Understanding how JOINs work to combine data across tables

• Using GROUP BY for aggregation and insights

• Learning how to filter and sort results meaningfully

Reflection:

Understanding how to structure queries and retrieve only the data I need has been an empowering step. It makes me feel more in control of real-world datasets.

---

🛠️ Tools I Used This Week:

• VS Code – for Python practice

• MySQL Workbench – for SQL query testing

---

✍️ Written by Kaviya K — MLOps learner, career switcher, and tech blogger in progress.