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
Yesterday
174 : He was unemployed for 1,000 days. Now he’s a data analyst. (Josh Gledhill)
Josh Gledhill was a music‑industry professional who, after 1,026 days of unemployment, landed not one but two data job offers. In this episode, he shares how he overcame dyslexia and how he used Threads, a 40‑page PRINTED Portfolio, and the SPN Method to become a data analyst at ... Show More
46m 56s
Aug 19
173: 13 Signs You’re on the Right Track to Landing Your First Data Job
Feeling behind on your data journey? Don't worry. Today, I'll list down the 13 signs that prove you're actually ahead (even if you're actually doing just some of these).✨ Try Julius today at https://landadatajob.com/Julius-YT💌 Join 10k+ aspiring data analysts & get my tips in yo ... Show More
15m 33s
Aug 12
172: Tesla Data Analyst: This is how to land a data job (Lily BL)
What does it take to land a data analyst job at Tesla, and what challenges await you once you're there? Join me as I interview Lily BL, a former Tesla data analyst, who reveals her exhilarating journey in the world of data at one of the world's most innovative companies.💌 Join 1 ... Show More
34m 15s
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