logo
episode-header-image
Nov 2023
25m 25s

86: SQL Simplified: For Data Beginners

Avery Smith - Data Career Coach
About this episode

SQL is the most important data skill you can learn on your journey. And it doesn’t need to be complicated. In this episode, dive into a short SQL introduction, basic SQL commands and know how SQL can help you land your data job.

Tune in now!


🗄️ Join FREE SQL hands-on workshop this December!

⭐ Leave a Podcast review & get your bonus!

🤝 Ace your data analyst interview with the interview simulator

📩 Get my weekly email with helpful data career tips

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

🏫 Check out my 10-week data analytics bootcamp


Timestamps:

(06:01) - How to get better in SQL

(08:41) - SQL commands to know

(20:48) - Come join FREE SQL hands-on Workshop


Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Mentioned in this episode:

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

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

Up next
Today
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
Sep 2023
Exploring SQL and ETL
The evolution of SQL and the ease of access to ever larger sizes of computational power has made SQL and ETL a useful pairing for practitioners in the data space. But how do they work together exactly? And what challenges can it pose? Bharani Subramaniam and Madhu Podila discuss ... Show More
31m 57s
Jun 2019
85: Management consulting storyboards
How do I build the storyboard and why is it done so early? is a new strategy skills video podcast we released this week. It is one of our more in depth episodes taken as sample video from one of our strategy studies. This episode is complimentary and available on iTunes, Youtube, ... Show More
21m 22s
Oct 2021
On Graph Databases | The Backend Engineering Show
I get a lot of emails asking me to talk about graph databases, so I want to start researching them, but I wanted to give you guys the framework of how I think about any databases to defuse any “magic” that might be there. In this video, I discuss what constrains a database and ho ... Show More
22m 27s
Jun 2023
Welcome to the Data Driven Podcast -- Benjamin Shapiro // I Hear Everything
Welcome to the Data Driven Podcast, where we dive deep into the art and science of data storytelling. Our mission is to help professionals from all backgrounds develop the skills needed to transform complex data into compelling narratives that drive clear business direction and r ... Show More
15m 9s
Apr 2025
How To Start Making Money With $0 (STEP-BY-STEP GAMEPLAN) | DATASETS
Listen on Spotify here: https://open.spotify.com/show/4TPpyiI1rqmbBOkORjH2N0Join the revolution. Follow the podcast to elevate yourselves with DataSets.Turn on the notifications. Listen on Spotify here: https://open.spotify.com/episode/18hsHNGW19Z07mSMPFut9a🍵 UNLOCK 14 BIOHACKIN ... Show More
17m 11s
Jun 2024
How to Scale your Startup with Growth Levers: Matt Lerner
Sponsored by Brilliant - visit https://brilliant.org/DeepDive/ and the first 200 of you will get 20% off Brilliant's annual premium subscription. I’ve built a brand new community for like-minded people called Productivity Lab. We’ll have online classes, workshops, and coaching to ... Show More
2h 32m
Apr 2022
#695: How to Effectively Manage Deals in the Pipeline
In this episode Bill and Bryan address “deal management”, which is another word for how to control and lead the sales process. They also give you some thoughts on how to best build momentum at the start of the process. It is one of the three biggest challenges we find companies h ... Show More
16m 7s
Mar 2023
S9E23: How a Biology Major Landed an EY-Parthenon Summer Internship
Send us a textWe're excited to bring you today's episode where Eric Lu shares insights from his journey into consulting. A Duke University Biology major, Eric wanted to combine his love for business with his passion for healthcare through a career in consulting. He land ... Show More
25m 18s
Apr 2021
S3E20: How Can I Network My Way Into McKinsey, Bain, or BCG?
Send us a textNetworking Intensive: Register Here In this episode, Namaan Mian (COO) and Stephanie Knight (Chief Learning Officer) debunk commonly held networking myths, lay out a roadmap for success, and share best practices and tips along the way. They cover: Why to networkWhen ... Show More
31m 20s
Mar 2023
S9E25: 4 Ideas to Fill Career Gaps In Your Resume
Send us a textStruggling to gain traction in your consulting job hunt due to career gaps on your resume? Listen in. Today, we're sharing 4 ideas to help you fill in those pesky resume gaps that are stopping your progress. Relevant Links Resume & cover letter edits: Learn Mor ... Show More
15m 16s