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
Oct 9
180: The 10 MOST CLUTCH Quarterbacks in NFL History (Backed by Data Science)
Who’s the most clutch quarterback in NFL history — Tom Brady, Patrick Mahomes, Aaron Rodgers, or someone completely unexpected? We’ll use Python + Data Science to figure it out. 👉 Try Sphinx for free - https://www.sphinx.ai⏱️ TIMESTAMPS00:00 - Who’s the most clutch QB? 00:40 - P ... Show More
15m 51s
Oct 1
179: How I Use PRIVATE Data ETHICALLY In the New Era of AI
There is an impossible choice most organizations face. Companies building modern AI face a brutal, binary-feeling decision: either ship a privacy-first model that “kinda low key sucks,” or ship a high-performing model that likely exposes sensitive personal data. Luckily, there's ... Show More
7m 57s
Sep 23
178: The One Skill That Makes You More Valuable Than Senior Analysts (ft. Mike Cisneros)
Data storytelling matters more than ever. If you have the ability to make your analysis understood—and acted on—it can make you more valuable than analysts with twice your experience. In this episode, Mike Cisneros walks us through his practical, tactical playbook to turn good an ... Show More
37m 3s
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
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
Jun 2023
5 Rules To Interviewing
Episode 08: When you’re ready to hire an employee for your business, you might feel accomplished that you’ve reached the level to build a team. However, that means hiring the wrong person could potentially set your business back. Evaluating talent is one of the hardest functions ... Show More
11m 24s