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
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
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
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
Aug 2022
S7E29: A Verbal Math Practice Plan for Case interviews
Send us a textLast week, we shared 8 tips and tricks for case interview math. Today, we're going a little deeper with a short clip from last year's Case Math Intensive. Enjoy! Join this year's Math Intensive on August 16, 6-9PM ET: JOIN Additional Links Get 1:1 cas ... Show More
11m 23s
Listen to millions of songs and podcasts on Anghami