Take ownership of your data: The end-goal
We’ve come to the end of the Survival SQL series. Hopefully, you think the posts are relevant and easy to […]
Mid-Career Tech
Mid-Career Tech
Subqueries and CTEs: Multi-step problems
As you progress, you’ll find situations where you need to combine more than one data pull to answer your question.
Mid-Career Tech
Window functions : Automate lengthy Excel tasks
“Find our 5 best-selling products by country.””What was the 7-day moving average revenue for every day last month?” Chances are,
Mid-Career Tech
Sort your data with “ORDER BY”
Most of you will use Excel to manipulate and plot the data you pull with SQL. Eventually, you’re likely to
Mid-Career Tech
When to use more complex joins
As you pull your data more often, you may encounter situations where you need more complex joins than what we’ve
Mid-Career Tech
Define your own metrics: Operators & conditionals
As you become confident with pulling data, you’ll start wanting more control over the metrics you report on. Hence, you’ll
Mid-Career Tech
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
Mid-Career Tech
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
Mid-Career Tech
Your first SQL joins: reading the “FROM” clause
You’ve got a first query from your company, and you’re ready to start making sense of it. First of all,