Aggregating metrics: Using “GROUP BY”

Earlier, we’ve discussed that your database stores data at its most granular level. This means that every order creates one row in your orders table. Likewise, every click a customer makes creates one row in your clicks table. And every review you receive creates one row in your product reviews table. When this builds up […]

Filtering the data you want: The “WHERE” clause

Why is SQL necessary and useful? In essence, we have huge amounts of data and SQL enables us to extract what we need for specific business insights. So, filtering with the “WHERE” clause is a crucial part of using SQL. This Kaggle notebook contains all the code for following along with the examples. Run cells […]

Learning SQL Mid-Career: Why Survival SQL?

In your industry, you’ve been around the block, and then some. The value that your business acumen, experience, and domain expertise bring is immense. Yet, businesses are digitizing with increasing speed, especially since e-commerce is important for survival in a post-COVID-19 world. Therefore, you’ve probably thought about learning SQL – but as a busy mid-career […]