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
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
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 26
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
Listen to millions of songs and podcasts on Anghami