Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3
HTML-код
- Опубликовано: 18 июн 2024
- 🚨 WANT MORE? GET MY FULL SQL COURSE HERE: geni.us/lbia_sql
WATCH PART 2 HERE: • Learn Basic SQL in 15 ...
WATCH PART 3 HERE: • Learn Basic SQL in 15 ...
🎥 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.
🔵 LEARNSQL.COM
A comprehensive set of 56 hands-on online SQL courses for teams and individuals
geni.us/learnsql
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
🏠 JOIN THE LEARN BI ACADEMY - geni.us/lbi_academy
🚀 BECOME A BI ANALYST - geni.us/lbia_biasp
🏆 TAKE THE BI CONSULTANT MASTERCLASS - geni.us/lbia_bicm
🧰 TOOLS & SKILLS
Excel For BI Analysts - geni.us/lbia_excel
SQL For BI Analysts - geni.us/lbia_sql
Power BI For BI Analysts - geni.us/lbia_powerbi
Tableau For BI Analysts - geni.us/lbia_tableau
Looker Studio For BI Analysts - geni.us/lbia_lookerstudio
📊 DATA ANALYST PROJECTS
All Projects - geni.us/lbia_projects
Ben’s Pizzeria - geni.us/pizzaproject
Hotel Reservations - geni.us/hotelproject
Multi-Channel Marketing - geni.us/multichannelproject
Call Centre - geni.us/callcentreproject
🎥 RECOMMENDED VIEWING
7 Steps to Your 1st BI Analyst Job - geni.us/7stepstobivid
Learn Basic SQL in 15 Minutes - geni.us/learnbasicsql15-1
BI For Beginners Playlist - geni.us/biforbeginners-play
📕 FREE EBOOKS
7 Top Tips For Better Dashboard Design - geni.us/dashdes-ebook
Skills You Need To Succeed In BI - geni.us/biskills-ebook
7 Steps to Your 1st BI Job - geni.us/7stepstobi-ebook
📊 DATA HUBS & WEBSITES:
Power My Analytics - geni.us/YLc9Re
Windsor.ai - geni.us/windsorai
Kaggle - www.kaggle.com/
Statista - www.statista.com/
Data World - data.world/
DISCLAIMER: Some of the above links are affiliate links where I'll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏
✅ LET'S CONNECT!
BUSINESS INQUIRIES - learnbi.online/contact
CONSULTING CALL WITH ADAM - geni.us/bookacall-adamfiner
JOIN MY MAILING LIST - geni.us/PSgRsF
FACEBOOK GROUP - geni.us/learnbi-fbg
🧑🏻💻 DATA. Get the database here - www.kaggle.com/hugomathien/so...
mysql
#sqltutorial #sql #learnsql
🚨 WANT MORE? GET MY FULL SQL COURSE HERE: geni.us/lbia_sql
You just summarized a month's worth of college lectures in 17 min. Thank you
You’re very welcome!
this is what you get in college? im getting this in highschool
Lmao
@@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
@@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
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!
You're very welcome, glad you like it!
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!
Right! I love how straightforward this was!
@@chazmcbride4 they stretch out the video all for the almighty youtube algorithm; kind of sad because distracts you alot from what you want to learn.
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.
You're very welcome!
All by yourself? I hope you are being compensated fairly bc that is ridiculous.
That's sick, congratulations for branching out and being an MVP! Hoping to do something similar
@@tannerconklin400 most definitely not lmao
Just curious, did you have any previous IT experience?
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!
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! :)
You’re welcome. Glad it helped!
same with me hehe
Hope u did well
How did your interview go?
Here for the exact same reason - a great refresher course!
These 17 minutes taught me what my lecturer had taught us in 1 month, but with much more clarity!
Glad you found it helpful!
real
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.
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.
Don’t know if you check RUclips but what are your thoughts on growth in the field and barriers to entry for someone like a CS major with some web dev experience?
This really is a very good intro to SQL. Great job.
I was lost on how to use SQL even the foundations part. This was very clear for me to understand. Thank you!
You're welcome, glad it helped!
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
Glad it was helpful!
How’s it going
Did you land the job? 🙏🏾
Did you get data anyslist job
What's it like out there? Jumping into SQL and data viz myself hoping to find a similar role
WATCH PART 2 HERE: ruclips.net/video/gm6tNK_iOHs/видео.html
WATCH PART 3 HERE: ruclips.net/video/w3ea4fKiS2g/видео.html
GET MY FULL SQL COURSE HERE: geni.us/lbia_sql
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!!!
You’re very welcome, I’m glad you found it useful.
How is your data analysis training going?
@@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
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!!
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.
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!
Amrutha, that was inspiring, going to watch the session now 😃
This was profoundly helpful as a beginner about to learn SQL. Thank you for sharing this concise step-by-step, visually demonstrated tutorial.
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.
Glad you liked it!
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!
Glad it was helpful!
Concise, straight to the point, useful.
Good for recapping this basic knowledge.
Glad you liked it 👍🏻
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.
Glad it was helpful!
Amazing
Calm, organized explanation
High quality, clear Audio
Short, to the point
Literally couldn't ask for more.
Thank you 🙏
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.
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.
Thanks a lot for this video! As a beginner, i was feeling a necessity to see how the BI analyst works in practice.
You’re welcome, glad you got value from the video.
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!
Loved the video. I had to stop it several times to take notes, I've learnt a great deal. Thank you!
You’re very welcome!
Literally learned more in this video than a whole semester of uni😆
Wonderful! 😁
👀 Part 2 of Basic SQL in 15 Minutes just posted here: ruclips.net/video/gm6tNK_iOHs/видео.html
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?
hi sir thank u for the lessons ,can u share with me the DB data for my practice plz
⬇️ START YOU BI JOURNEY HERE ⬇️
🔥 GET THE ULTIMATE GUIDE TO GOOGLE DATA STUDIO 🔥
HEAD ON OVER TO geni.us/datastudiocourse
I have a job interview coming up that requires knowledge in SQL. This has been a great help
You're gonna crush it!
@@LearnBI I got a 2nd interview tomorrow! Thanks for the confidence boost
@@acoen4411 you got the job?.
I just love how it went from "Oh, SQL is that simple???" to "WTF is going on..." real fast 😄 Great vid, thanks!
It’s easy when you know how! 😂
You're my Hero
🤣 you're very welcome, glad I could help!
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
You're welcome, good luck for the interview! 🤞🏻
I was struggling to put all this information together in my studies, but this helped immensely. Thank you.
"As always, stay Bi-Curious!" What an epic way to end the video! hahaha
Always!
Exactly the basic refresher I was looking for, thanks!
You're welcome, don't forget to subscribe!
#eazzylearninglab fallow us
Amazing use of FIFA players in the study. Made it really easy to grasp everything about SQL.
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 !!
Great video and very clear! This is very helpful for people that are trying to improve skills in BI like me, thank you!
You’re welcome!
This tutorial is gold, how clear and concise it is!
Glad you like it!
I have an interview tomorrow and wanted to revise SQL querying quickly. Came across this video, totally worth it!
Wishing you the best of luck 🤞
How did you get on?
Really clear, thanks so much!
Such a simple explanation. Great video thank you!
You’re welcome, don’t forget to subscribe!
Learned a lot in 17 minutes! All structured and cool presentation!
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!
You're welcome, glad to help!
You elaborated SQL basics in such a great way that can be learned quickly and easy. Appreciated
Great tutorial! Needed to refresh my SQL skills :)
Glad you liked it!
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. 😂
Glad I could help!
Really well-packed video! Could be used as a refresher, too.
getting a head start on studying before I take a college course on SQL in the fall
Huge amount of information clearly presented in a short time. Thanks 😄👍
You’re welcome
You are a fantastic teacher, you make it look so simple and easy. You definitely gained a new subscriber, keep up the great work 👏🏼👌🏿
Thank you for your kind feedback 🙏🏻
Definitely subscribed instantly ❤ I’d love to sign up for the class starting in Jan
That was really helpful! I'm completely new to SQL and this was such a help to understand what SQL actually DOES. Thank you!
Great! Glad you found it helpful
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
Glad to help!
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
You might want to get that checked out 🤣 Just one click on "Beautify SQL" will fix it for me 😀
What an amazing vid! THANK YOU A LOT!
You're very welcome!
Thank you Adam!! You're the best!
Didnt know anything about Sql but now am eager to learn simple and sound
Awesome Video, I am just in 'awe'. I am a beginner and this video gives me the motivation I need. Thanks a ton again:)
You're very welcome!
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.
Excellent!
What a simple straightforward method of teaching from a brilliant mind. Thanks for the great insight you have given.
You're very welcome!
Thank you so much for making it possible for me to learn so much about SQL in a short period of time! Until I watched this video, I was unsure where to begin learning SQL for Business Analysis.
This was so well made. The progression of learning with road bumps really does show the trouble shooting explanation in real time 👌👏
Glad you liked it!
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.
Hi Prasanna, not a dumb question at all! May I suggest you watch this video: ruclips.net/video/z4IxOU4KpMk/видео.html. It should answer your question
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
You're very welcome!
MADE MY CONCEPTS MORE CLEAR.Thank youu😃
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?
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 RUclips algorithm. Sorry.
Thank you Adam, it was really interesting and I got to learn the basics of SQL.
Glad you liked the video!
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.
You're very welcome, glad you found it useful!
I learned more in this video than my 8 years at my community college. Thx.
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
You're welcome, thanks for the feedback!
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 :)
I just figured it out :)
This man just said "Until next time, stay BI-Curious" HAHAHAHA
Thank you I appreciate the in-depth explanation and being patient with those of us who are learning the basics
You're very welcome, thanks for watching
.
Thank you. This is the best video I came across to prepare for an interview in 15 mins
Great to hear!
A couple of jobs I need to go for refer to SQL skills and this video gave me some confidence to learn. Great presentation
Glad you found it useful!
I have an MCQ tomorrow, I really need this. I should have studied more but here we are
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!!
You’re very welcome! Hope you get back to work soon.
thanks for your video, was perfect. This give everyone an idea what SQL is it for.
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
You’re very welcome!
Great video! As a Fifa addict and recently certified PM, this example is absolute GOLD. Subscribed!
Thanks!
Thank you so much for this. Great video!
I appreciate the instruction and the presentation. Looking forward to learning more!
Thanks, more content coming in the next few weeks
Great video! Thank you for a clear explanation!
You’re welcome!
I literally had an understanding of it within 5 minutes of your video. Thank you!
Glad it helped!
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!
You're very welcome!
Thank you! This helped me considerably.
You’re welcome!
I learned more in these 15 minutes than I did in the past month of college
Don’t forget to watch part 2 Learn Basic SQL in 15 Minutes (PART 2) | Creating Tables | SQL Tutorial | Business Intelligence
ruclips.net/video/gm6tNK_iOHs/видео.html
Thanks for the video 🙏🏽 I’ve been wanting to learn SQL. we Can also all agree on Messi is better according to the Data.
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!!!
Thanks!
@@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?
Great job making it informative and quick!
You're welcome, don't forget to subscribe!
Awesome! I love the football example. Easy understand
Much needed 🤧❤️
Really impressive. A 'complex' subject in a very simple way.
Thanks!
This was helpful. Thank you!
I have run queries for many years, but never created them. This video is extremely helpful
Glad you found it helpful
Great intro, very helpful. Thanks!
You're very welcome!
This really took away my fear of SQL. Thank you Adam!!
You’re welcome!
I am an analyst but have avoided SQL like fire till now. I always thought it was like programming (it technically is), but it's just a data-organizing tool. Thank you, I'm not afraid of the code anymore :)
Glad to help!
Thank you for this very informative video. Didn't realize I could learn so much in such a short time frame. You're the best!
Thank you for your kind feedback 👍🏻
I never comment on videos but this was fantastic. I'm taking a course in Coursera and had to come here to really understand because I was so lost. THANK YOU!!
Glad it was helpful!