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
September 2020
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