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
Mid-Career Tech
If you’re Gen X or Gen Y in tech, it’s a rough ride. Mid-career tech professionals of the 2020s have weathered two storms: data science and generative AI. In the spirit of continuous learning, I’m sharing how I’m navigating and evolving in this increasingly challenging space. Join me!
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,
Mid-Career Tech
Using a beginner SQL book efficiently
Perhaps you have started your SQL journey by trying to read a beginner SQL book from start to end. In
Mid-Career Tech
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