profile

Kelly's Bytes

Kelly's Bytes - 3/15/24 (#94) - My Experience Building a SQL Course

Published over 1 year ago • 1 min read

KELLY'S BYTES

By Kelly J. Adams

Hey!

It's Friday, March 14, 2024 which means another issue of Kelly's Bytes. Every other Friday I share: 1 new blog post from me; and 3 bite-sized resources related to topics like data analytics, switching careers or learning new skills.

View past editions of my newsletter here.

Announcement: If you didn’t know or if you don’t follow me on [LinkedIn], I just launched a 4 hour free SQL course* with Luke Barousse*. My blog post this week dives into my experience building this course.

Affiliate Link Disclaimer: This newsletter includes affiliate links, indicated with a * at the end, for the course I co-created. If you decide to purchase the course through these links, I may receive a small commission at no extra cost to you. This support helps me continue to provide content. Thank you for your support!

Blog Post

My newest blog post, Behind the Scenes: Creating a SQL Course goes into:

  • Launched SQL course with Luke, enhancing data analysis skills.
  • Course design balances foundational queries with advanced data manipulations.
  • What I learned while making this course.
    ​

View my blog here.

Bite-Sized Resources

📺 Video: [Data Science] The Harsh Reality of Being a Data Scientist from Sundas Khalid who currently works at a FAANG company. She talks about challenges like lack of growth, ambiguity of job descriptions/responsibilities, not being understood by people.

🎧 Podcast: [Data Analytics] Ken's Nearest Neighbors where Ken Jee interviews people in the fields of data science, sport analytics, health and more. Most of the episodes are an hour long.

📝 Post: [Data Analytics] LinkedIn post from Connor Dickson with what separates a junior data analyst from a senior data analyst: query optimization. Which is something I’ve been personally working on. He goes into some general tips on how to improve your queries.

Content

📊 How to Become a Data Analyst: Check out my ultimate guide on how you can become a data analyst.

📊 Data Analytics Resources: View all the resources (like podcasts, courses, etc.) I used to learn data analytics.

📊 Start Here: Interested in data analytics but not sure where to start? Check out my blog post.

Until the next Friday,

- Kelly

Kelly's Bytes

Kelly Adams | Data Analyst | Writer

My newsletter where I share one practical lesson, highlight a blog post, and share 3 bite-sized resources to help you up skill and stay updated.

Read more from Kelly's Bytes

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...

5 months ago • 1 min read

KELLY'S BYTES By Kelly J. Adams Hey! Thanks for subscribing and here’s this weeks edition lesson: Main Lesson: T-Shaped Approach to Learning One of the biggest improvements I’ve made in my career planning is by adopting the T-shaped approach to skill-building. Here’s why it’s worth considering: What it is: A framework that balances deep expertise in one area (like data analytics) with broad knowledge across related areas (like business departments and industries). How it helps: It keeps your...

6 months ago • 1 min read

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...

7 months ago • 1 min read