21 Jul 2025 Agnieszka Kozubek-Krycuń 5 Fun SQL Projects You Can Do in a Weekend (For Free!) Want to turn your weekend into a fun learning sprint and make your resume shine? With just a few hours (and zero cost), you can build impressive SQL projects that show off your skills to future employers. Here are five ideas to get you started — no database design or fancy tools required! Fun SQL projects? Yes, really! SQL isn’t just about dry reports or endless tables — it can actually be a fun, creative way to explore your favorite topics, analyze real-world data, and even learn more about yourself. Read more 17 Jul 2025 Agnieszka Kozubek-Krycuń SQL Practice That Feels Like the Real Thing: Meet dbt Want to take your SQL practice beyond just querying data? dbt (data build tool) is an open-source framework that lets you transform raw data into clean, reliable models — all using SQL. It’s the perfect way to practice real-world data transformations and start thinking like a data professional. Practicing SQL by writing the SELECT queries over and over can get boring fast. And let’s be honest — it’s easy to run out of ideas for what to query next. Read more 3 Jul 2025 Agnieszka Kozubek-Krycuń Beach Reads for Data Nerds: Top SQL Resources for Summer 2025 Sunscreen? Check. Sunglasses? Check. A data book that’s actually fun to read? Absolutely. This summer, we’re rounding up the most interesting SQL and data-themed books to keep your brain challenged – even while you’re off the clock. Sure, you could pack a murder mystery or a romance novel for your summer break – but if you’d rather kick back with something that sharpens your data brain, this guide is just what you need. Read more 26 Jun 2025 Agnieszka Kozubek-Krycuń SQL Crash Course: Learn SQL in One Sitting Ready to dive into SQL? In just one sitting, you’ll learn the essential SQL queries to start working with databases, from selecting and filtering data to sorting results. Got an hour? That’s all you need to start writing real SQL queries. In this crash course, we’ll cover the essential basics: selecting data, filtering results, and sorting. These are the building blocks for working with databases, and by the end, you'll be able to run your first queries with confidence. Read more 19 Jun 2025 Agnieszka Kozubek-Krycuń SQL Game Night: Play Guess the Output! Think you know SQL? Put your skills to the test with a fun and fast-paced game where you guess the output of real SQL queries — no pressure, just play! Tired of traditional SQL tutorials? Start with the interactive SQL Basicscourse to build a solid foundation — then put your skills to the test with SQL Game Night: Play Guess the Output! 🎯 It’s a fast, fun challenge that asks just one question: Read more 12 Jun 2025 Agnieszka Kozubek-Krycuń How to Group by Week in PostgreSQL Need to analyze data by week in PostgreSQL? Here's how to group your records using built-in date functions for clear, time-based insights. Grouping data by week is a common requirement in reporting. It’s often used in business reporting to track metrics like weekly revenue, user signups, or website traffic. Grouping by week helps smooth out daily fluctuations and gives you a clearer view of trends over time. It's especially helpful when comparing performance across consistent time intervals, like " Read more 5 Jun 2025 Agnieszka Kozubek-Krycuń SQL Queries You'll Actually Use in Real Life Learn the essential SQL queries that data analysts, marketers, and product teams rely on every day – with simple, relatable examples. When you're just starting with SQL, it's easy to get overwhelmed by syntax and theory. But here’s the truth: most professionals – whether they’re data analysts, marketers, or product managers – use a small set of SQL queries over and over to get real work done. You don’t need to learn everything at once. Read more 27 May 2025 Agnieszka Kozubek-Krycuń How to Build a Data Dashboard (Even if You Just Started Learning SQL) Dive into building your own data dashboard with this beginner-friendly guide—even if you're just starting with SQL. Using BigQuery, public datasets, and Looker Studio, you'll learn how to easily create an impressive dashboard. If you're a data analyst—or aiming to become one—learning SQL is essential. SQL, or Structured Query Language, is the language used to pull and analyze data from databases, helping you turn raw numbers into real insights. But if you’re just starting out, coming up with project ideas can be the hardest part. Read more 20 May 2025 Agnieszka Kozubek-Krycuń Beginner SQL Project: Build a Report With BigQuery and Looker Want to practice your SQL skills on a real dataset? In this beginner-friendly project, you’ll use BigQuery and Looker to explore Chicago’s crime data and build your first interactive report – no advanced experience needed! If you want to get better at SQL, nothing beats working on real projects. Practice is where your skills truly grow – and today, you’ll take a big step forward. In this beginner-friendly project, you’ll create a simple crime report based on the Chicago Crime public dataset, using BigQuery to write SQL queries and Looker Studio to build an interactive dashboard. Read more 13 May 2025 Agnieszka Kozubek-Krycuń SQL and Chill: 5 Fun Datasets to Practice With on a Friday Night Tired of boring practice datasets that make SQL feel like work? Kick back and sharpen your skills with five fun, quirky datasets that make learning SQL feel more like playing. It’s Friday night. You’re not in the mood to go out, there’s nothing good left to stream, and your brain is craving something a little more satisfying than scrolling your phone. So you fire up your laptop, open your SQL editor, and settle in for a different kind of unwind. Read more «« « 1 2 3 4 » »»