Articles Cookbook
29 May 2025
Jakub Romanowski

Supercharge Your Notion Workflow With SQL

If you're using Notion to stay organized but feel like it's missing something when it comes to data analysis, you're not alone. In this article, I’ll show you how to supercharge your Notion workflow with SQL so you can go beyond tracking tasks – and start making smarter, data-driven decisions. I’ve always liked using Notion to keep things organized – whether it’s tracking projects at work, planning content, or just storing personal notes.
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
22 May 2025
Jakub Romanowski

Full-Text Search in SQL: Going Beyond LIKE Queries

If you're looking for smarter ways to search through your database, you're in the right place. In this article, I’ll show you how to use full-text search in SQL to go beyond basic LIKE queries and start writing more powerful, accurate, and efficient searches. Have you ever written a SQL query using LIKE – something like WHERE name LIKE '%apple%' – and thought, "Okay, this kind of works... but isn't there something more advanced?
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
15 May 2025
Jakub Romanowski

Beyond the DBA: Exploring Emerging Data Roles for SQL Enthusiasts

SQL skills are in high demand – not just for maintaining databases, but for powering analytics, insights, and automation across industries. While Database Administrators (DBAs) still play an important role, the data field has expanded to include positions like Data Engineers, Analysts, and BI Developers that use SQL in new and practical ways. In this article, you'll explore how these roles differ, what skills they require, and how you can move into them by building on your existing SQL knowledge.
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
8 May 2025
Jakub Romanowski

SQL Meets Google Calendar: Analyze a Year in Meetings

Do you ever feel like your calendar is running your life? Back-to-back meetings, barely any time to get actual work done – and no idea where your time went? You're not alone. What if you could run a quick SQL query and know exactly how much time you spent in meetings last year, which months were the busiest, and whether your weekly syncs are eating up your mornings? That’s what this guide is all about.
Read more
6 May 2025
Agnieszka Kozubek-Krycuń

SQL Intermediate Practice Questions

Ready to take your SQL skills to the next level? These intermediate questions will help you practice real-world scenarios using GROUP BY, CASE WHEN, subqueries, CTEs, and more. If you’ve already mastered SQL basics and feel comfortable writing simple queries, it’s time to level up. Intermediate SQL skills are key to handling real-world reporting, deeper analysis, and solving more complex data tasks that go beyond basic SELECT statements. In this article, you’ll practice essential techniques like GROUP BY, CASE WHEN, subqueries, and Common Table Expressions (CTEs).
Read more
1 May 2025
Jakub Romanowski

Exploring the Future of MS SQL Server Careers: Opportunities, Trends, and Growth

When people search for "the future possibility of a career in MS SQL Server," they’re usually looking for more than just reassurance – they want clarity. Is this a smart field to commit to? Will the jobs still be around in five or ten years? And if they double down on SQL Server, will it actually lead to better opportunities? The good news is that all signs point to yes – but the answers are more nuanced than a simple yes or no.
Read more
1 May 2025
Jakub Romanowski

Free Course of the Month: 2025 Monthly SQL Practice Sets – Basic

Ready to sharpen your SQL skills with real-world challenges? We’ve got something special for you! Our 2024 Monthly SQL Practice Sets - Basic course is completely free throughout May 2025 – and it’s the perfect way to improve your SQL by doing, not just reading. Hey, got a minute? If you're looking to boost your SQL skills, now's the perfect opportunity. We've just made our 2024 Monthly SQL Practice Sets - Basic course completely free for the entire month of May 2025.
Read more