Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

WATCH PART 2 HERE: • Learn Basic SQL in 15 ...
WATCH PART 3 HERE: • Learn Basic SQL in 15 ...
🚨 WANT MORE? GET MY FULL SQL COURSE HERE: geni.us/lbia_sql
🎥 NEW NAVICAT TUTORIAL - • My Favourite SQL Tool ...
In this SQL tutorial for beginners, you'll learn how to write basic SQL queries to ask for data from databases in just 15 minutes. To become a business intelligence analyst, you'll need to know this valuable skill! Here I'll teach you what is SQL.
What you learn over the course of these videos can be applied to MySQL, PostgreSQL, SQL Server and others.
☕️ WANT TO SAY A QUICK THANK YOU? Why not Buy Me A Coffee? Thanks for your support! www.buymeacoffee.com/adamfiner
🔵 LEARNSQL.COM
A comprehensive set of 56 hands-on online SQL courses for teams and individuals
geni.us/learnsql
🎓 SKILLSHARE - Get a 30-day free trial of Skillshare Premium!
geni.us/skillshare30day
✅ Navicat - Get 5% Off With This Link
geni.us/navicat_vb
📊 DATA HUBS FOR GOOGLE DATA STUDIO, EXCEL AND MORE:
Power My Analytics: geni.us/YLc9Re
Windsor.ai - geni.us/windsorai
🔴 Don't forget to subscribe:
kzbin.info....
00:00 Introduction
01:12 Why learn SQL for BI?
02:22 Tutorial start
03:43 SQL SELECT statement
05:07 AS field alias
05:32 WHERE clause
09:54 ORDER BY clause
10:54 INNER JOIN
13:08 Aliasing tables
14:00 GROUP BY clause
15:58 HAVING clause
16:49 Outro
🙏 SUPPORT THE CHANNEL 🙏
Paypal Donations - paypal.me/vitaminbi
*** 👀 RECOMMENDED WATCHING 👀 ***
- Business Intelligence For Beginners Playlist
• BI For Beginners
*** 🎓 VITAMIN BI EDUCATION ONLINE COURSES 🎓 ***
LEARN BUSINESS INTELLIGENCE WITH DATA STUDIO
geni.us/datastudiocourse
*** 🛠 TOOLS AND SERVICES I RECOMMEND 🛠 ***
🧰 The tool I use to help me manage my channel, get video ideas, rank videos and more: vidiq.com?afmc=7ho
📹 Everything I use to make videos and stream:
geni.us/Z4zeqS
*** 📖 ⬇️ FREE EBOOKS TO DOWNLOAD ⬇️ 📖 ***
7 Steps to Landing Your First BI Analyst Job
geni.us/7stepstobi-ebook
7 Top Tips For Better Dashboard Design
geni.us/dashdes-ebook
The Skills You Need To Succeed In Business Intelligence
geni.us/biskills-ebook
📖 THE DATA VISUALISATION BIBLE 📖
amzn.to/3CKiPiV
🎥 MY KZbin GEAR
My Camera - amzn.to/3J5lbeo
Most Used Lens - amzn.to/3hXoE2Q
B-Roll Lens - amzn.to/3pSUeDh
Main Tripod - amzn.to/3pSUeDh
Vlogging Tripod - amzn.to/3tOpJPZ
Main Key Light - amzn.to/366KaPI
Softbox - amzn.to/35HrR46
LED Panel Kit - amzn.to/35K3Lpf
Teleprompter - amzn.to/3hWGT8p
Main Microphone - amzn.to/3t1n1aK
Mic Boom Arm - amzn.to/3hUHzuX
Lavelier Microphone - amzn.to/3vVUi8V
C-Stands - amzn.to/3vZMoLN
Computer - amzn.to/3KB3RhU
Disclaimer: Some of these links go to one of my websites and some are affiliate links where I'll earn a small commission if you make a purchase at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏
✅ LET'S CONNECT:
For business inquiries visit www.learnbi.online/contact
Sign up for my mailing list to be the first to hear about new videos and special offers
geni.us/PSgRsF
Twitter - @learnbi_online
Facebook - @learnbionline
Get the database here - www.kaggle.com/hugomathien/so...
mysql
#sqltutorial #sql #learnsql

[@LearnBI]

🚨 WANT MORE? GET MY FULL SQL COURSE HERE: geni.us/lbia_sql

[@xxmahir3000xx]

You just summarized a month's worth of college lectures in 17 min. Thank you

[@LearnBI]

You’re very welcome!

[@HO-bk7kf]

this is what you get in college? im getting this in highschool

[@angelusvastator1297]

Lmao

[@graymaybe8587]

@@HO-bk7kf obviously you’re probably younger than the original commenter - now these courses are being offered in high school and obviously that wasn’t always the case. I’m 26 and coding wasn’t really stressed at all and I went to a great high school. Get over yourself kid lol

[@HO-bk7kf]

@@graymaybe8587 so a 26 year old adult just decided to insult someone who they suspect is far younger then themselves just because they said that they were learning this in highschool? Get a life dude

[@jroamer6339]

This is the only video I've found that actually teaches SQL without a massive amount of talking that doesn't say anything. You're concise and easy to follow. Appreciate it!

[@LearnBI]

You're very welcome, glad you like it!

[@chazmcbride4]

agreed. no 20 minute preamble on why SQL is important and yadda yadda. If I didn't know why SQL was important I wouldn't have clicked on the video in the first place!

[@joanmcgrath5790]

Right! I love how straightforward this was!

[@adamgradidge7130]

Thank you sir! I'm a completely self taught one man IT department that has just been given the task of producing all the business' sales and valuation reports from our stock management system using SQL. You have just saved me hours of pain trying to figure it all out myself. Will definitely be going through the rest of your videos.

[@LearnBI]

You're very welcome!

[@tannerconklin400]

All by yourself? I hope you are being compensated fairly bc that is ridiculous.

[@chrysanth267]

That's sick, congratulations for branching out and being an MVP! Hoping to do something similar

[@virusDETECTED]

@@tannerconklin400 most definitely not lmao

[@certified_by_jt.]

Just curious, did you have any previous IT experience?

[@yamanmustafa]

I've been putting off learning SQL as I was scared. Thanks for this informative, brief, yet concise introduction to SQL. It's nowhere near as bad as I thought it would have been!

[@nekogod]

I've been a BI analyst for Dixons (currys, pc world etc) for the last 10 years and basically had to teach myself SQL, something like this would have been so useful back then. Really concise and easy to follow.

[@LearnBI]

Thanks for the feedback, appreciate it. I taught myself SQL on the job as well so I made this video as something me back then would have needed.

[@ryanpatel2001]

These 17 minutes taught me what my lecturer had taught us in 1 month, but with much more clarity!

[@LearnBI]

Glad you found it helpful!

[@1vsoo]

real

[@julianpaulonogueiratorres7627]

I took a course on SQL, but I have not used it for quite some time. I wanted to brush up on the syntax because I am preparing for an interview, and this video covered everything I need, concisely and effectively! Thank you, Vitamin Business Intelligence! :)

[@LearnBI]

You’re welcome. Glad it helped!

[@katarashadow]

same with me hehe

[@angelusvastator1297]

Hope u did well

[@l8diva]

How did your interview go?

[@japeriawilliams4470]

Here for the exact same reason - a great refresher course!

[@johnadair4979]

This really is a very good intro to SQL. Great job.

[@yayitsmelody4948]

I was lost on how to use SQL even the foundations part. This was very clear for me to understand. Thank you!

[@LearnBI]

You're welcome, glad it helped!

[@tewodrosteklu7845]

I am preparing to shift from Economics and Business degree to Data Analytics and I just started R studio program for data analysis and the next step that I was thinking to study SQL and I am so satisfied with the way you're explaining and very easy to understand. Thank you so much Adam Finer!!!

[@LearnBI]

You’re very welcome, I’m glad you found it useful.

[@habtamtsegaw640]

How is your data analysis training going?

[@FireJach]

@@habtamtsegaw640 I have masters of economics degree and I am doing same thing because my uni taught me nothing important. I am learning everything from the internet, especially from youtube. Excel, PowerBi and SQL. Maybe I will grab basics of Python later

[@ElroyDesmond]

Perfect video for anyone who is thinking about getting into SQL and wondering if it really as complicated (or rather as easy) as people say it is.

[@LearnBI]

Glad you liked it!

[@tonguetiedtemptrix]

This was profoundly helpful as a beginner about to learn SQL. Thank you for sharing this concise step-by-step, visually demonstrated tutorial.

[@coreyjoyner1372]

this was such a great quick video. I'm diving into SQL looking to land a Data Analyst position soon. Thanks for educating! Now going to re-watch before checking out part 2

[@LearnBI]

Glad it was helpful!

[@vincentliang3342]

How’s it going

[@kyokendl373]

Did you land the job? 🙏🏾

[@miladredwan448]

Did you get data anyslist job

[@EKaneGrant]

What's it like out there? Jumping into SQL and data viz myself hoping to find a similar role

[@jp00349]

A big thank you to Vitamin BI and Adam Finer - as a fiftysomething old-school marketer with very limited understanding of BI dailies this tutorial has been groundbreaking. Analysts who work with me and all other vloggers purporting to teach you SQL lack the skills to convey a message - Adam knows how to teach the uninitiated, which is the basis of success. Much respect and thanks again.

[@LearnBI]

Very kind words indeed, thank you it's very much appreciated☺️. I taught myself SQL on the job so that's where the tutorial is coming from. It's what I wish I had had when I started. It's seems to be very popular which is fantastic.

[@joanmcgrath5790]

This was a great refresher! I do not get to use it in my organization and I needed a few reminders. I appreciate this video!

[@amruthavenugopal6117]

Hi there, I've watched quite a few videos of SQL and other tools too but never really understood completely or felt interested but this video was truly interesting. I understood everything you said and kind of got a boost to my confidence to learn as someone with no foundation in SQL. Thank you so much!!

[@LearnBI]

You're very welcome, thank you for your kind feedback. I'm really glad I could help you make a bit more sense of SQL.

[@tsison8974]

Thanks Adam for sharing this wealth of knowledge. I am switching gear to becoming a business analyst which requires SQL for data mining. This is very helpful. Thanks to you!

[@intellectMind2024]

Amrutha, that was inspiring, going to watch the session now 😃

[@marcos_silvestri]

Concise, straight to the point, useful. Good for recapping this basic knowledge.

[@LearnBI]

Glad you liked it 👍🏻

[@Catherinee]

Literally learned more in this video than a whole semester of uni😆

[@LearnBI]

Wonderful! 😁

[@rajjay1079]

Amazing use of FIFA players in the study. Made it really easy to grasp everything about SQL.

[@SH4D0SKU11]

Amazing Calm, organized explanation High quality, clear Audio Short, to the point Literally couldn't ask for more.

[@LearnBI]

Thank you 🙏

[@siamrahman1409]

This actually came up on one of my technical coding interview screening assessments. So glad I found this video, this is very valuable content. Thanks for the help!

[@LearnBI]

Glad it was helpful!

[@kasnarfburns210]

Thanks for this video. I'm considering training to be a data analyst so these peeks into SQL are helpful. I'm beginning to see how useful SQL can be.

[@LearnBI]

Glad it was helpful!

[@danpaxton3535]

getting a head start on studying before I take a college course on SQL in the fall

[@gianvictor9884]

Thanks a lot for this video! As a beginner, i was feeling a necessity to see how the BI analyst works in practice.

[@LearnBI]

You’re welcome, glad you got value from the video.

[@arxsyt8190]

You're my Hero

[@LearnBI]

🤣 you're very welcome, glad I could help!

[@acoen4411]

I have a job interview coming up that requires knowledge in SQL. This has been a great help

[@LearnBI]

You're gonna crush it!

[@acoen4411]

@@LearnBI I got a 2nd interview tomorrow! Thanks for the confidence boost

[@liviu445]

@@acoen4411 you got the job?.

[@sarafonsecalevy9310]

Loved the video. I had to stop it several times to take notes, I've learnt a great deal. Thank you!

[@LearnBI]

You’re very welcome!

[@AndrewAkaHrun]

This tutorial is gold, how clear and concise it is!

[@LearnBI]

Glad you like it!

[@jannerick2]

Exactly the basic refresher I was looking for, thanks!

[@LearnBI]

You're welcome, don't forget to subscribe!

[@aanaybhure7079]

#eazzylearninglab fallow us

[@RabeaJarrar]

"As always, stay Bi-Curious!" What an epic way to end the video! hahaha

[@LearnBI]

Always!

[@ayushpanjabi9791]

I have an interview tomorrow and wanted to revise SQL querying quickly. Came across this video, totally worth it!

[@dinclusivenihilus9828]

Wishing you the best of luck 🤞

[@LearnBI]

How did you get on?

[@ladyhorror4758]

I was struggling to put all this information together in my studies, but this helped immensely. Thank you.

[@josecardenas2736]

Great video and very clear! This is very helpful for people that are trying to improve skills in BI like me, thank you!

[@LearnBI]

You’re welcome!

[@matthewalford1985]

Such a simple explanation. Great video thank you!

[@LearnBI]

You’re welcome, don’t forget to subscribe!

[@jegorr111]

Recently discovered you and am very happy. I am studying Data Analytics and SQL gets me really bad. Just could not get as it is like learning the language . You explain in simple terms, visually, with examples while correcting mistakes! Perfect . Those longer codes with different symbols before, after and so forth is litter harder and hope you will cover more of those !!

[@koredeoloniyo7620]

What a simple straightforward method of teaching from a brilliant mind. Thanks for the great insight you have given.

[@LearnBI]

You're very welcome!

[@katarashadow]

Great tutorial! Needed to refresh my SQL skills :)

[@LearnBI]

Glad you liked it!

[@AlonsoJavier-pn2mb]

Learned a lot in 17 minutes! All structured and cool presentation!

[@infamousstreaming2899]

I got a database exam coming soon so I'm kind of rushing everything and when I stumbled across your video, and you explain everything really clearly and good. Thanks a mill man!

[@LearnBI]

You're welcome, glad to help!

[@MsPhilippaB]

Really clear, thanks so much!

[@sphamandlandlovu3554]

You are a fantastic teacher, you make it look so simple and easy. You definitely gained a new subscriber, keep up the great work 👏🏼👌🏿

[@LearnBI]

Thank you for your kind feedback 🙏🏻

[@jking4714]

Definitely subscribed instantly ❤ I’d love to sign up for the class starting in Jan

[@user-in3jd6cm2t]

I just love how it went from "Oh, SQL is that simple???" to "WTF is going on..." real fast 😄 Great vid, thanks!

[@LearnBI]

It’s easy when you know how! 😂

[@Loudaddy]

Thank you for this! I got a job that I’m under qualified for and they asked me to find some data! This video saved my butt

[@LearnBI]

You’re very welcome!

[@irinamicov]

Really well-packed video! Could be used as a refresher, too.

[@stuarttelford7063]

Huge amount of information clearly presented in a short time. Thanks 😄👍

[@LearnBI]

You’re welcome

[@icyliciousblue]

What an amazing vid! THANK YOU A LOT!

[@LearnBI]

You're very welcome!

[@SirenSaysxx]

Thank you Adam!! You're the best!

[@TheUltimateToad]

Adam, this was amazing. I'm doing coursework with the open uni who try teach this through endless pages of text which I just never understood. You've made it so much clearer. Thank you

[@LearnBI]

Glad to help!

[@vickyvic8619]

THANK YOU FOR THIS TUTORIAL!!! 😁 I have been waiting in limbo for days for my teacher to respond and this just saved what little sanity I had left. 😂

[@LearnBI]

Glad I could help!

[@samnnamani]

You just saved me 500 pounds. My job species SQL queries, I’m used to Scripting and I knew I could learn this easily but not expecting in 15 minutes 😂😂 Thanks so much. I off and running already with excellent results.

[@LearnBI]

Excellent!

[@MohammadSaeedSaeedi]

You elaborated SQL basics in such a great way that can be learned quickly and easy. Appreciated

[@vishnupriyachimata4573]

Awesome Video, I am just in 'awe'. I am a beginner and this video gives me the motivation I need. Thanks a ton again:)

[@LearnBI]

You're very welcome!

[@BradBartram]

As someone who has used SQL for decades and taught it at the college level, this was a great intro. I do have to say that your indentation and formatting though is making my eye twitch. lol

[@LearnBI]

You might want to get that checked out 🤣 Just one click on "Beautify SQL" will fix it for me 😀

[@LindaDeeTee]

That was really helpful! I'm completely new to SQL and this was such a help to understand what SQL actually DOES. Thank you!

[@LearnBI]

Great! Glad you found it helpful

[@SlymeTyme59]

Thank you I appreciate the in-depth explanation and being patient with those of us who are learning the basics

[@LearnBI]

You're very welcome, thanks for watching

[@prasannasilva7754]

Hi Adam, this is a really clear tutorial. my question might look somewhat dumb but I want to have answered it since I am a beginner and confused at some certain points. is this related to MySQL as well? thank you.

[@LearnBI]

Hi Prasanna, not a dumb question at all! May I suggest you watch this video: kzbin.info/www/bejne/sGWsqYKLabCjg80. It should answer your question

[@SScarnati]

This was so well made. The progression of learning with road bumps really does show the trouble shooting explanation in real time 👌👏

[@LearnBI]

Glad you liked it!

[@gangstalker]

Thanks man, I lied on a job application, you came in clutch

[@LearnBI]

Glad to help!

[@rahimhussain8727]

Thank you so much for this. Great video!

[@theresadickson3632]

Great video! Am thrilled by your explanation. But could you help do a zoomed version for those who use mobile and have no access to laptops?

[@LearnBI]

Thank you. I’m afraid it’s too late for me to redo the video and adding a different version wouldn’t be good for the KZbin algorithm. Sorry.

[@joshuaemmanuelfrancis2703]

Thank you Adam, it was really interesting and I got to learn the basics of SQL.

[@LearnBI]

Glad you liked the video!

[@hafizbello98]

Where have you been all my working life! 17 mins later, i'm like, ok now i understand why SQL is so useful. Thanks for this.

[@LearnBI]

You're very welcome, glad you found it useful!

[@henmarreiq4005]

A very helpful video! Could you possibly do a vid based on a condensed version of the oracle exam?

[@antares1233062]

I was always kinda scared of certain tech, like sql, it seemed so big and scary. Honestly I love working with arrays, I don't know why I waited this long, Thank you, but showing me this beauty :D

[@LearnBI]

You're welcome, thanks for the feedback!

[@csknyy]

I have one small question. How did you open the database on the program? If you had that step, I'd love to follow your steps while doing the same thing on my own screen :) Other than that, the video series is great. Thanks for all of the details and insights :)

[@csknyy]

I just figured it out :)

[@chibilume]

SQL was so intimidating but now that i have sometime after getting laid off in Nov, this has been the best crash course! Much more efficient than LinkedIn learning courses. Ty!!

[@LearnBI]

You’re very welcome! Hope you get back to work soon.

[@jcvanrooyen5372]

Great video! As a Fifa addict and recently certified PM, this example is absolute GOLD. Subscribed!

[@LearnBI]

Thanks!

[@LearnBI]

👀 Part 2 of Basic SQL in 15 Minutes just posted here: kzbin.info/www/bejne/nZ6ZpYGBlM6CftU

[@partumscripto9526]

what would happen in the case of your example "t_m%" if i switched it to "t%m%" ? Would that still be a legit code?

[@ezjdnfyfg]

hi sir thank u for the lessons ,can u share with me the DB data for my practice plz

[@LearnBI]

⬇️ START YOU BI JOURNEY HERE ⬇️ 🔥 GET THE ULTIMATE GUIDE TO GOOGLE DATA STUDIO 🔥 HEAD ON OVER TO geni.us/datastudiocourse

[@troyedler6383]

I appreciate the instruction and the presentation. Looking forward to learning more!

[@LearnBI]

Thanks, more content coming in the next few weeks

[@AnitaPatel-mq2fp]

This is informative information! I've not touched SQL for over 1 year and this helps me understand it much better. Thank You so much

[@LearnBI]

You're very welcome!

[@user-xc2yc3vz5e]

.

[@shakirhussain7712]

Thank you. This is the best video I came across to prepare for an interview in 15 mins

[@LearnBI]

Great to hear!

[@Hoonin]

Great job making it informative and quick!

[@LearnBI]

You're welcome, don't forget to subscribe!

[@unitedhybrid187]

I literally had an understanding of it within 5 minutes of your video. Thank you!

[@LearnBI]

Glad it helped!

[@Lemrah]

This man just said "Until next time, stay BI-Curious" HAHAHAHA

[@Mailme81]

A couple of jobs I need to go for refer to SQL skills and this video gave me some confidence to learn. Great presentation

[@LearnBI]

Glad you found it useful!

[@cheahanqi964]

Awesome! I love the football example. Easy understand

[@Rowiep]

I have run queries for many years, but never created them. This video is extremely helpful

[@LearnBI]

Glad you found it helpful

[@ShighetariVlogs]

Lovely and useful 3 years later, thank you for making this type of content :)

[@LearnBI]

My pleasure

[@EL1MF]

thanks for your video, was perfect. This give everyone an idea what SQL is it for.

[@taayakin1108]

LOVE this video and how you explain things! Would love to see a video on the various joins that you mentioned as a possibility. :)

[@LearnBI]

Try this…How To Join Data In SQL? Discovering The Relational Database Model kzbin.info/www/bejne/b2GWdIeBm6-ebZY

[@nikkimoon1520]

Great video! Thank you for a clear explanation!

[@LearnBI]

You’re welcome!

[@jeanpaulizabayo720]

Thank you! This helped me considerably.

[@LearnBI]

You’re welcome!

[@afiqjaffarran]

I have an interview for data analyst in few hours and know nothing about sql. I'm jumping from sales to data analyst without the proper skills and qualifications. I only knew basic html,css,and js. And thank god for that now I know how sql works. Thank youuuuu

[@LearnBI]

You're welcome, good luck for the interview! 🤞🏻

[@twistedstyles]

I learned more in this video than my 8 years at my community college. Thx.

[@achybellahpergo5459]

Didnt know anything about Sql but now am eager to learn simple and sound

[@IntricateMoon]

Best tutorial so far.

[@user-dm8zs6xq7m]

what a special , thank you!!

[@syaoransakura8839]

I had an interview for the database on 20th December. And I wanna a short video as I can. Seems this video is just perfect

[@LearnBI]

Great, glad it helped

[@gabrielmichael378]

Really impressive. A 'complex' subject in a very simple way.

[@LearnBI]

Thanks!

[@haydenmacfarlane7194]

Great intro, very helpful. Thanks!

[@LearnBI]

You're very welcome!

[@assancamara7178]

Giving only a like to this lesson video does not satisfy me. Tank u, it helped a lot.

[@LearnBI]

My pleasure

[@katlegomehlape8623]

AMAZING VIDEO! Very easy and understandable.

[@LearnBI]

Glad it was helpful!

[@sarahconner2832]

Thank you because I can't stand sitting in class with a bunch of people who can't keep up. This is all I needed. I got it. Awesome. 😎 Subscribed, liked and shared!!!

[@LearnBI]

Thanks!

[@sarahconner2832]

@@LearnBI When I first saw the video, it was so blurry, because most phones are set up for automatic low quality to save on data, but if you go into the settings for video quality you can manually set it to high quality, and then it becomes clear and very easy to follow. I do not recall if you suggested to the target market that if it doesn't show up clearly, that they should adjust the settings for better quality image, but it might help you get the results that you are looking for, because I had a hard time keeping up myself, until I adjusted my settings to high quality, where I could see it quite clearly, and I was actually quite thrilled about it!!! You did an excellent job. I cannot wait until I have time to sit down and concentrate and learn more and more and more!!!! Thank you!!! I love listening to a man who actually has something intelligent to say, and knows what he is talking about!!! You are an awesome fella!!! You can tell your woman that I said that!!! You have a fan! 😉 Do you have any practice worksheets you could post, that we could screenshot so we can practice queries on our spreadsheet software. Or perhaps a link to practice queries at?

[@chooselife2388]

Thanks for the lesson...A bit to fast for me, but I've just started.

[@Sushi0923]

Just recently subscribed to you. I am currently trying to find ways of studying SQL and hopefully land a job as a data analyst. Thank you so much for putting videos like this!

[@LearnBI]

You're very welcome!

[@Ollie0llie]

I learned more in these 15 minutes than I did in the past month of college

[@LearnBI]

Don’t forget to watch part 2 Learn Basic SQL in 15 Minutes (PART 2) | Creating Tables | SQL Tutorial | Business Intelligence kzbin.info/www/bejne/nZ6ZpYGBlM6CftU

[@dustindineen4533]

This is great stuff!!