|
Every other Friday, I share one practical lesson, highlight a blog post, and share 3 bite-sized resources to help you upskill and stay updated.
KELLY'S BYTES By Kelly J. Adams Hey! Thanks for subscribing and here’s this weeks edition lesson: Main Lesson: SQL User-Defined Functions One of the big improvement I’ve made in my SQL workflow recently is using User-Defined Functions (UDFs) in BigQuery. Here’s why: What it is: A UDF is a custom function you define to simplify repetitive logic in SQL queries. It can be written in SQL (my preference) or JavaScript. How it helps: Reduces redundancy, improves maintainability, and ensures...
KELLY'S BYTES By Kelly J. Adams Hey! Thanks for subscribing and here’s this weeks edition lesson: Main Lesson: Using SQL for Better Data Analysis Recently, I’ve made improvements to my SQL Skills from SQL for Data Analysis by Cathy Tanimura. One lesson for me was the importance of using less common SQL functions, like CROSS JOINs, for more flexible analyses. Here’s why this matters: What it is: CROSS JOINs allow you to combine all rows from two datasets, which is especially useful for filling...
KELLY'S BYTES By Kelly J. Adams Hey! You might’ve noticed that I’ve changed the format of my newsletter. I’ve been spending the last few weeks really thinking about how I want to structure my content from now on. So each newsletter contains: Main Lesson: Something I’ve learned or am working on 3 bite-sized resources: Still related to data or learning new skills Main Lesson: SQL Functions Understanding how data flows into tables has been a game-changer for my SQL workflow. Here’s why:...