10 years ago today, we dropped Victory Through Harmony exclusively on Soundcloud. The Mixtape is now available on all DSPs https://t.co/jOTglMlqr5
We dedicate this milestone to our brother and producer, Raymond Anyafulu aka Yung Bali who passed away earlier this month after a short illness. Forever in our hearts. 🕊️🫶🏿
As someone who works with SQL daily and runs SQL queries on over 900 Terabytes of data here are some of the SQL rules i work with:
- Capitalize all commands/functions, lowercase fields with underscores
- Quote table names with “”
- Leading commas before field/CTE names (not trailing)
- WHERE 1=1 pattern for easier debugging
- Indentation to clearly delineate code blocks
- Comments for complex calculations, corner cases, special logic
- Clean names - no cryptic abbreviations, use full descriptive words with underscores
- CTEs over subqueries (except for deduplication/ranking patterns)
- Descriptive CTE names - no single letters, no reusing field names
- Explicit GROUP BY field names - no numbers; grouped fields listed first in SELECT
- Parameter CTE at the top for reusable values (dates, thresholds, etc.)
- Field ordering: Keys Timestamps → Dimensions → Metrics
- USING instead of ON when joining on same-named columns
Do you have any more I can incorporate?
In my data analytics journey, and one thing I keep hearing from experienced analysts is:
Practice is what makes the difference.
So I researched and compiled 15 websites where aspiring data analysts can practice, build projects and grow their skills.
👇
You have learned Excel, SQL, Power BI: congratulations.
Practice here for free:
EXCEL: https://t.co/Fy8XuxqvkL
SQL: https://t.co/Zb4bqPqecU
Power BI: https://t.co/sDvIW6ls3z
Keep learning.