Non-Brand Data
Subscribe
Sign in
Home
Podcast
About Non-Brand Data👇
Topic
Courses
Learning Resources
Archive
Data Analysis & SQL
Latest
Top
Discussions
Build Your Own Practice Dataset in Python with Faker
Create fictional customer and transaction tables for your next Python and SQL exercise
Oct 30
•
Cornellius Yudha Wijaya
5
1
Building an Interactive Data Analysis Notebook With marimo and DuckDB
Learn to build modern dashboard in a simple way
Oct 17
•
Cornellius Yudha Wijaya
2
1
Module 14: Writing the results and recommendations
A SQL result can be correct and still make a weak report. The table gives the numbers, but the reader still needs to know what they mean and what they…
Oct 4
•
Cornellius Yudha Wijaya
Module 13: When a SQL query needs optimization
In this module, we will learn how to read a PostgreSQL query plan and decide whether an index is worth keeping.
Oct 4
•
Cornellius Yudha Wijaya
Module 12: Checking whether your result is right
Let's learn how to check a SQL result before we use it in a report or recommendation.
Oct 2
•
Cornellius Yudha Wijaya
Module 11: Using window functions without changing the row count
Let’s learn how to calculate totals, running values, and ranks while keeping every order row in the result.
Oct 2
•
Cornellius Yudha Wijaya
Module 10: Breaking a query into steps with subqueries and CTEs
Let's learn how to split a long SQL query into named steps and check the result from each step.
Oct 2
•
Cornellius Yudha Wijaya
Module 9: When a join increases your numbers
Let's learn why a one-to-many join can increase a total and how to keep the number correct.
Oct 1
•
Cornellius Yudha Wijaya
Module 8: Choosing between INNER JOIN and LEFT JOIN
Let's learn how `INNER JOIN`, `LEFT JOIN`, and filter placement change the rows in our result.
Sep 30
•
Cornellius Yudha Wijaya
Module 7: How to define a metric clearly
Let's learn how to define a conversion rate so another person can calculate the same number.
Sep 29
•
Cornellius Yudha Wijaya
Module 6: WHERE and HAVING: filtering before and after GROUP BY
Let's learn when a condition belongs in `WHERE` and when it belongs in `HAVING`.
Sep 26
•
Cornellius Yudha Wijaya
Module 5: Counting the right thing with GROUP BY
Let's learn how `GROUP BY` changes the result and why `COUNT(*)` doesn't always count the thing we need.
Sep 20
•
Cornellius Yudha Wijaya
This site requires JavaScript to run correctly. Please
turn on JavaScript
or unblock scripts