logo
episode-header-image
Mar 2023
9m 55s

50: FREE 5-Step SQL Course & Project

Avery Smith - Data Career Coach
About this episode

📤 In this episode, Avery’s going to walk you through how you can teach yourself SQL for FREE with this awesome 5-step course.


🌟 Join the data project club!

“25OFF” to get 25% off (first 50 members).


📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp


Timestamps:

(0:24) - What is SQL?

(1:08) - Step 1: Download Datasets

(2:03) - What is CSV files?

(2:44) - Step 2: Setup SQL environment with the dataset

(3:37) - Step 3: Learn SQL for free with W3Schools

(4:50) - Step 4: Come up w/ probing questions for your data

(6:09) - Step 5: Write up your findings

(7:00) - Project Write-up Platform


Mentioned Links:

Kaggle: https://www.kaggle.com/datasets

bit.io: https://bit.io/

W3Schools: https://www.w3schools.com/sql/


Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Mentioned in this episode:

💙 Thank you for subscribing & leaving a review

Thanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support.

Join The Next Cohort of The Accelerator

Want to land your first data job? Join my data bootcamp to get EVERYTHING you need to land your first data job! Excel, SQL, Tableau, Power BI, Python, R? Yup. Projects? Lots of them. LinkedIn help? Of course. Resume optimization? You betcha. Job hunting strategy? Duh. Click to learn more!

https://www.datacareerjumpstart.com/daa

Up next
Jul 8
168: Stop Doing Random Data Courses - Read These Books Instead
Tired of spending money on data courses you never finish? Here are 7 essential books that will actually boost your analytical skills, with no subscription required! Plus, make sure to tune in till the end as one lucky listener will get a free book from this list! Get the books he ... Show More
15m 30s
Jul 1
167: Hiring Manager Explains: How to Become a Healthcare Analyst (Jason Bryll)
Jason Bryll is a healthcare analytics expert and hiring manager with nearly two decades of experience. In this episode, Jason explains what healthcare analytics entails, why it's essential, and the role of AI in the field. More importantly, you'll learn how to stand out to hiring ... Show More
40m 43s
Jun 24
166: You’re Already a Data Analyst (You Just Don’t Know It)
Turn your current tasks into clear, resume-ready bullets that sound more data-focused👉 Resume Transformer: https://datafairy.io/GMM2DJKWM9Here's a realization you need to hear: You're a Data Analyst ALREADY. You're not as far away as you think you are. In this episode, I teach y ... Show More
14m 23s
Recommended Episodes
May 2024
My 5 Step A/B Testing Process For Networking Emails | Ep #542
Austin shares his 5 step process for testing your networking email template and iterating until it’s the best it can be!Time Stamped Show Notes:[0:25] - Why A/B testing is important in networking[3:03] - Start with 3 email templates[4:19] - Test your email templates to some low-p ... Show More
8m 26s
Jan 2020
5 Ways to Make IEP Data Collection Work
IEP data collection is one of the most difficult things that I hear teachers trying to figure out.  Let’s face it, everyone tells you to take data, but few people actually walk through how to do it. So in this episode, I want to walk you through what the 3 things that we need our ... Show More
17m 53s
May 2024
3 Ways To Research Private Companies | Ep #541
Austin shares his 3 step process for researching private companies. Public companies share a lot of data, but so do private companies, if you know where to look!Time Stamped Show Notes:[0:28] - Why research is important[1:39] - Find interviews with employees or the leadership tea ... Show More
12m 1s
Jun 2023
#2356 - Q&A: “How should I handle freelance contracts?”
A freelance writer is using Chat-GPT to help draft his articles. So far, so good—but he needs help with figuring out client contracts.Side Hustle School features a new episode EVERY DAY, featuring detailed case studies of people who earn extra money without quitting their job. Th ... Show More
4m 33s
Oct 2021
#1738 - Q&A: How to approach a company about a partnership?
Today’s listener has an interesting challenge: he wants to reach out to a company he bought a product from and offer to partner with them. He’s already tracked down their key employees on LinkedIn. What’s the next step? Show notes: SideHustleSchool.comEmail: team@sidehustleschool ... Show More
6m 14s
Sep 2020
Best Practices Working with Billion-row Tables in Databases
In this video, I discuss 3 methods to work with tables of billion rows. This discussion is inspired by a comment on my YouTube video on Twitter System Design right here https://www.youtube.com/watch?v=gfq-LG9ZJQA&lc=UgyYbm5889dW0XtKhsV4AaABAg Chapters Intro 0:00 1. Brute Force Di ... Show More
14m 28s
Jul 2022
#2030 - Q&A: “I want to be the ‘posture guy,’ but how will I make money?”
Today’s caller seeks to brand himself as The Posture Guy. Sounds catchy! How can he turn this memorable branding into a steady source of income? Side Hustle School features a new episode EVERY DAY, featuring detailed case studies of people who earn extra money without quitting th ... Show More
3m 37s
Jul 2023
#591: Update Your Course Content In 5 Simple Phases
>>> HEAD HERE TO GRAB THE FREEBIE FOR THIS EPISODE: Your Course Update Bundle! Need a content update? Here’s my simple 5-phase process for updating course content The thought of updating your course content can be daunting. I know that because I’ve felt this way many times before ... Show More
27m 10s
Jul 2021
The Final 5 Questions (Ep. 25)
Here we are: the end of time (for this podcast). We mark this historic moment, after so many years of podcasting, with one last batch of listener questions.This week’s episode is sponsored by:Brilliant: Accelerate your learning in math, science, and computer science. Start learni ... Show More
2h 5m
May 2023
#2330 - Failure Friday: Chicken Rental Service Fails to Egg-cite
In this week’s Failure Friday segment, we hear from a Boise entrepreneur with the goal of bringing chickens to city dwellers. Alas, in the end the business is forced to flee the coop.Side Hustle School features a new episode EVERY DAY, featuring detailed case studies of people wh ... Show More
6m 4s