Learn SQL Basics in Just 15 Minutes!

Learn SQL basics with this tutorial in just 15 minutes.
🔥Take our SQL for Business Analystics Course: www.careerprinciples.com/cour...
Download the database for this video: careerprinciples.myflodesk.co...
Download MySQL: dev.mysql.com/downloads/installer
In this tutorial, you'll learn how to use SQL using mySQL. First, you'll learn what SQL is and the different relational database management systems. Second, you'll learn to install mySQL in your computer. Third, you'll learn to import a real database for you to practice.
Then we'll get into writing queries. First we'll write simple SELECT statements, then SELECT with DISTINCT, and eventually aggregate functions such as COUNT or AVG. We'll then move on to filtering using the WHERE statement. Following that we'll learn to GROUP BY, ORDER BY, and even add a LIMIT. Finally, you'll learn to export your query scripts and results table and importing it into Excel or Power BI.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ SQL Intro
0:58​ - Installing mySQL
2:40​ - Importing a Real Database
4:04​ - SELECT statement
5:30 - DISTINCT
6:00 - Aggregate Functions
8:40​ - Filtering with WHERE
10:55 - Combing SELECT, COUNT & WHERE
11:45 - GROUP BY, ORDER BY and LIIMIT
15:10 - Exporting Data

Пікірлер: 127

  • @KenjiExplains
    @KenjiExplains3 ай бұрын

    🔥Take our SQL for Business Analystics Course: www.careerprinciples.com/courses/sql-for-business-analytics

  • @travelrepeat2532
    @travelrepeat25323 ай бұрын

    Please make a playlist to teach us SQL from beginner to Pro,thanks man

  • @aymen5506
    @aymen5506Сағат бұрын

    You a king for this for real, every other video about sql are just guys yappin about useless things, you got straight to the point, keep up the good work man

  • @alecseidman5601
    @alecseidman56013 ай бұрын

    Please make a full series, this was so helpful!

  • @mayowaadeleye9311
    @mayowaadeleye93113 ай бұрын

    Really enjoyed the video. Definitely looking forward to part 2. Thank you

  • @DhrumitMehta
    @DhrumitMehta3 ай бұрын

    Really enjoyed this! Would love a Part 2

  • @KenjiExplains

    @KenjiExplains

    3 ай бұрын

    thank you! I'll keep it noted :)

  • @nainglinnphyoe1231
    @nainglinnphyoe12314 күн бұрын

    I set off to data analytics career from sales career through your videos and it was really effective to me for its clear explanations with case study materials . I have learnt Power BI for data cleansing , visualization and reporting and now on the way to SQL with you. Thanks a million and you are the best !

  • @Osborne24
    @Osborne243 ай бұрын

    Hey Kenji, thanks for the video Just started learning SQL recently.

  • @janegathiaka4490
    @janegathiaka44902 ай бұрын

    Great content. Love the way you simplify difficult topics in a short time. Thanks Kenji

  • @shambhavimehrotra2554
    @shambhavimehrotra255429 күн бұрын

    So well and patiently explained! Thank you, Kenji!

  • @mirwansiregar
    @mirwansiregar3 ай бұрын

    Thank you so much Kenji, your channel is very resourcefull...you make it as main reference for everyone to learn data analyst

  • @Babyk4315
    @Babyk43152 ай бұрын

    Kenjii you are so smarttt, please upload a second part!!

  • @rameezhassan3289
    @rameezhassan32893 ай бұрын

    you are so smooth in explaining, awesome content

  • @sonngy123123
    @sonngy1231233 ай бұрын

    Hey man, your videos landed me an offer, just wanted to thank you

  • @waldw930
    @waldw9302 ай бұрын

    SQL video so great!! very clear explanation.

  • @comichantv7279
    @comichantv72793 ай бұрын

    Cool! will wait for part 2

  • @faisalgolden4897
    @faisalgolden48973 ай бұрын

    plz make full series on sql

  • @EdsonNascimentoEN
    @EdsonNascimentoEN3 ай бұрын

    Great tutorial - thanks a lot.

  • @sammyreal12
    @sammyreal123 ай бұрын

    Thank you so Kenji

  • @ibrahimmegahed2583
    @ibrahimmegahed25833 ай бұрын

    Great, Thank you! plz make full series on sql.

  • @silvestrecamposano6317
    @silvestrecamposano63173 ай бұрын

    Thanks again, Professor!....

  • @Helen.Channel988
    @Helen.Channel988Ай бұрын

    Wow, Indeed Beginner friendly, the demonstration is direct and enough to start learning SQL. Thank you.

  • @j.b.1342
    @j.b.13423 ай бұрын

    Dang! This is so good. Your course looks way better than the courses on Coursera. Looks well thought out and very practical with a fun set of data to use.

  • @abrahammoruti5967
    @abrahammoruti59673 ай бұрын

    Really enjoy your data analysis content Hopefully you'll make a tableau tutorial

  • @purushottam775
    @purushottam7753 ай бұрын

    Thank you!

  • @UwU-my5zv
    @UwU-my5zv3 ай бұрын

    Please with part 2. Very enjoyable.

  • @maangoswami5622
    @maangoswami56222 ай бұрын

    Really enjoyed the video.

  • @vincentnuhugimba8229
    @vincentnuhugimba8229Ай бұрын

    You are the best, you are born to teach🎉

  • @tranceformeeer
    @tranceformeeer2 ай бұрын

    I watched several videos about sql, also took a course on Udemy. The course was great, although I have to say Kenji explains everything VERY SIMPLE and STRAIGHTFORWARD! Please teach everything, you are doing it very very very well!

  • @yetundeokpanachi475
    @yetundeokpanachi4752 ай бұрын

    Thank You

  • @abdirashidbashir1762
    @abdirashidbashir1762Ай бұрын

    Very concise, very informative and saved me a lot of time. I appreciate the effort you put into this and I have subscribed and liked.

  • @maangoswami5622
    @maangoswami56222 ай бұрын

    Really enjoyed the video. Would love to have more of these type of videos

  • @KenjiExplains

    @KenjiExplains

    2 ай бұрын

    Part 2 on Sunday :)

  • @alexcolombu1025
    @alexcolombu10253 ай бұрын

    I know this question is going to come up for beginners. SQL is way better than Access as it is used to handle larger datasets. Now, will learning Access prior to SQL help you, sure but it won't make learning SQL any faster. However, if you learn SQL first, your access learning will be much faster and easier. So which should you start with? Go with SQL if you are looking for career growth and you wanna play with the big boys. For small companies with smaller data sets, Access should be fine. Hope this helps anyone looking for it. And as always Great videos from Kenji.

  • @vivekviv2487
    @vivekviv248718 күн бұрын

    Clear and Smooth explanation..! 😊

  • @ReactionSquad158
    @ReactionSquad1583 ай бұрын

    Marvellous sir Your 15 minutes video played a vital importance of SQL pls upload 2nd part. Thanks sir

  • @walkerjasmyne
    @walkerjasmyneАй бұрын

    I feel like I can really learn this wow you’re a great teacher!

  • @KenjiExplains

    @KenjiExplains

    Ай бұрын

    Lets go! Best of luck :)

  • @yohannaagbanaji8012
    @yohannaagbanaji80123 ай бұрын

    Hello, thanks for the video, it is an amazing video as usual. I am eagerly waiting for the part 2 of the SQL video.

  • @thaivang8726
    @thaivang87263 ай бұрын

    I'd love to see you make videos on Python as well. You always provided us with the best content.

  • @clementverdier2655

    @clementverdier2655

    3 ай бұрын

    Totally agree!

  • @ahmedabdou9047
    @ahmedabdou904712 күн бұрын

    thank you very good

  • @alexcolombu1025
    @alexcolombu10253 ай бұрын

    Could you make a video on overall formatting and margins in excel from beginner to advanced? Thank you and love your videos.

  • @infamismworldwild6248
    @infamismworldwild6248Ай бұрын

    Thank you

  • @markuskankare2911
    @markuskankare29112 ай бұрын

    Thanks a lot man. I'm studying Software Engineering in University and having exam from this topic. Helped a lot!

  • @KenjiExplains

    @KenjiExplains

    2 ай бұрын

    Awesome and best of luck my friend :)

  • @tarikkhaan6255
    @tarikkhaan62552 ай бұрын

    Love it

  • @senorbenny5773
    @senorbenny57732 ай бұрын

    Would really love to see a full series on this, I am willing to pay for it as well, you can maybe release 4-5 out of the 10 part series for free on youtube and the view access for the rest can be members only.

  • @jimdowell1729
    @jimdowell17292 ай бұрын

    this was great! very good video! totally new to SQL, but a wiz at excel formulas pivot tables and the like so this was very familiar. i wonder if there is a listing or database of operators that we can refer to when building formulas to query off of. thanks!

  • @ScholenEnt
    @ScholenEnt3 ай бұрын

    Your are good.

  • @ranjan1191
    @ranjan11912 ай бұрын

    Superb❤

  • @eddiesullivan9596
    @eddiesullivan95963 ай бұрын

    Yes, we definitely want part 2. Also I wonder if there is a way to connect API with MYSQL, such as Amazon Sellercentral or Walmart API

  • @JUZUZ-kr1bq
    @JUZUZ-kr1bq2 ай бұрын

    Wow thank you

  • @KenjiExplains

    @KenjiExplains

    2 ай бұрын

    You’re welcome 😊

  • @mcwahaab
    @mcwahaab2 ай бұрын

    Would be interesting to see a comparative analysis between SQL and Power Query and which one is the best

  • @mustakmnm7
    @mustakmnm76 күн бұрын

    please make detailed videos for intermediate and advanced asap 🙏🏽

  • @user-xp4ee7uc1x
    @user-xp4ee7uc1x3 ай бұрын

    Best..

  • @DanielRodriguez-of1cx
    @DanielRodriguez-of1cx3 ай бұрын

    Plz part 2 🙏🏼🙏🏼🙏🏼

  • @jituchablani3171
    @jituchablani31713 ай бұрын

    Hii Kenji, First of all great video. Thanks for sharing!! Had a question, all these things we can also do it with excel then what is the real use if SQL?

  • @lucybentzcrystal4440
    @lucybentzcrystal44402 ай бұрын

    I have been trading for about 6 months now and just about every mine, it backfires and slaps me in my face. Nearly impossible for me to catch more than a few points I try to do top down analysis but it doesn't work for me . I say to myself, clearly I'm in the 90% that lose money, so I open a demo account, do my analysis, then take the opposite of what I would normally take and get the same result. I'm starting to feel hopeless, any advice for a struggling trader?

  • @masangogabriel3356

    @masangogabriel3356

    2 ай бұрын

    Indeed, the recent market downturn serves as evidence that a vast majority of individuals lacked a sufficient understanding of the underlying financial dynamics at play.

  • @nobuhlerodrigocath2755

    @nobuhlerodrigocath2755

    2 ай бұрын

    Don't listen to him, don't give up. Mining takes time(months, even years) to master, even the pros learn everday. Never the less, if you lose money no matter which side you take, maybe you need to look at how you are managing active trades rather than how you are entering them. My advice, find a mentor . And also, try incorporating the use of oscillators, Bollinger and pivot points into your strategy. And most importantly move to higher TFs(4h or 1D preferably), you'll thank me later.

  • @lucybentzcrystal4440

    @lucybentzcrystal4440

    2 ай бұрын

    You're absolutely right. While I don't incur losses with every trade, my primary challenge lies in allowing my winning trades to fully develop. I often find that I miss out on significant movements in the market. Instead of capitalizing on these opportunities, my trades tend to reverse after initially moving in my favor. Additionally, I acknowledge that my entry points could be significantly refined. Finding a mentor to guide me through these challenges would be immensely beneficial, although I recognize that locating a reputable mentor is easier said than done. If you happen to know any legitimate mentors, I would greatly appreciate any recommendations you could provide.

  • @nobuhlerodrigocath2755

    @nobuhlerodrigocath2755

    2 ай бұрын

    I've been working with a financial advisor since I started investing. In today's market, the challenge lies in timing purchases and sales of trending stocks, which seems straightforward but can be tricky. My portfolio has grown significantly, making about $1500 bi-weekly. Essentially, what I'm saying is that the 5% of consistently profitable traders often fly under the radar; they're typically low-key individuals. I rely on my account manager to handle entry and exit orders for me.

  • @debocknolan6273

    @debocknolan6273

    2 ай бұрын

    Would you mind recommending the specific professional you utilize for their services? I'm facing numerous marketing challenges and could use some assistance.

  • @sebastiengrenade
    @sebastiengrenadeАй бұрын

    Im very new with sql and i have a question. Why do we use SQL while we can easily do it in Pivot Table.

  • @satheeshkumar9586

    @satheeshkumar9586

    28 күн бұрын

    size and complexity: Pivot tables can become cumbersome and slow with very large datasets

  • @ifoodieTV

    @ifoodieTV

    27 күн бұрын

    I agree with @satheeshkumar9586. But you asked a good question though.

  • @Stabu
    @Stabu20 күн бұрын

    My work would like me to start using SQL, but every time I'm looking at this, it always feels like I can do the SAME exact stuff in Excel with just using Excel formulas. SQL is faster with more data, I suppose, but are there any other advantages to it?

  • @aspectoflife
    @aspectoflifeАй бұрын

    perfect

  • @bharathbsbharath9061
    @bharathbsbharath90613 ай бұрын

    Will you make SQL projects for data analysis

  • @preetshah3793
    @preetshah37933 ай бұрын

    Make more videos on sql

  • @tatyanagrossett8002
    @tatyanagrossett80023 ай бұрын

    Good day, can you create a playlist for SQL please ?

  • @ShoOnlineAcademy
    @ShoOnlineAcademyАй бұрын

    Can you clean up on power query?

  • @camlex6310
    @camlex63102 ай бұрын

    Really helpful!!

  • @Travel203
    @Travel2033 ай бұрын

    Make more videos in SQL

  • @bear17293
    @bear172933 ай бұрын

    An intermediate video would be greatly appreciated as well. Thanks 😅

  • @jamesthuku4997
    @jamesthuku49972 ай бұрын

    Great! But how do i download SQL for Mac OS?

  • @preetshah3793
    @preetshah37933 ай бұрын

    Make a sql playlist

  • @rohitsoni181
    @rohitsoni1813 ай бұрын

    yess plz

  • @official_s3un
    @official_s3un2 ай бұрын

    Good good damn got me feeling like I know a lot now lol 😂

  • @majidislam1064
    @majidislam106423 күн бұрын

    Plz plz plz for beginner from basic plz

  • @bekesoft
    @bekesoft2 ай бұрын

    Hi can't find the file in the description

  • @juansanchez-kg2to
    @juansanchez-kg2toАй бұрын

    Is Power query similar to SQL?

  • @newcreator55
    @newcreator553 ай бұрын

    thank you. Great video!

  • @KenjiExplains

    @KenjiExplains

    3 ай бұрын

    Thank you for watching!

  • @NinaWagner-Fors
    @NinaWagner-Fors3 ай бұрын

    🙌

  • @KenjiExplains

    @KenjiExplains

    3 ай бұрын

    Cheers!

  • @nwabuking36
    @nwabuking36Ай бұрын

    I can't access the database/dataset used in the tutorial

  • @Ra-fb6gx
    @Ra-fb6gx25 күн бұрын

    can't. really import ,, there's a pop up that says: Unhandled exception: 'ascii' codec can't decode byte 0xef in position 0: ordinal not in range(128) 😫

  • @jlee6823
    @jlee68233 ай бұрын

    I am just wondering, how hard is it to master SQL? I struggled with programming in college especially C++. Coding is something that I find it very challenging.

  • @KenjiExplains

    @KenjiExplains

    3 ай бұрын

    I’d say it’s simpler than c++ and other programming languages but a step up from Excel/excel formulas

  • @jlee6823

    @jlee6823

    3 ай бұрын

    ​@@KenjiExplainsThank you. I went through Excel, Power BI course and started the VBA course you offered. SQL is also something that I want to learn.

  • @KenjiExplains

    @KenjiExplains

    3 ай бұрын

    That's awesome! I'd say compared to VBA it's about the same difficuly (perhaps even a touch easier than VBA)

  • @prezlamen
    @prezlamen2 ай бұрын

    Font is small! I can`t see

  • @wonderful-jg1dt
    @wonderful-jg1dt2 ай бұрын

    for some reason my files are not opening when i select download save

  • @Ra-fb6gx

    @Ra-fb6gx

    Ай бұрын

    same , im using macbook m1 ... idk why , i'm completely beginner with mysql 😥

  • @ayselmammadova5284
    @ayselmammadova52842 ай бұрын

    Hi,can you help me?

  • @NarendraMnr
    @NarendraMnr2 ай бұрын

    15 Mins passed by in a jiffy.

  • @EllahNnamdi
    @EllahNnamdi2 ай бұрын

    Please Kenji I did not see the link for the file

  • @KenjiExplains

    @KenjiExplains

    2 ай бұрын

    its in the description like i mentioned

  • @gbengamatthew1647
    @gbengamatthew164711 күн бұрын

    Please the link to download Sql is not here.

  • @KenjiExplains

    @KenjiExplains

    11 күн бұрын

    it's in the video description

  • @tobiomodunmiju9446
    @tobiomodunmiju94465 күн бұрын

    PLEASE WHY IS SQL BENCH NOT READING THE FULL DATA?

  • @tjbvillar
    @tjbvillarАй бұрын

    Mysql is a free software ?

  • @alapaher377
    @alapaher37710 күн бұрын

    no one zooms the screen , plz do it , thnks

  • @movierulzteluguguru
    @movierulzteluguguru2 ай бұрын

    Where is upload file link

  • @KenjiExplains

    @KenjiExplains

    2 ай бұрын

    In the description like I mentioned

  • @Rennsaiyan13
    @Rennsaiyan133 ай бұрын

    Second

  • @KenjiExplains

    @KenjiExplains

    3 ай бұрын

    lol

  • @saeedahmed1261
    @saeedahmed12612 ай бұрын

    Things change with time.1996 I wanted to learn sql but nothing was in my range.no quality tutorials,no help,very limited internet connection and much more. Now there are high quality fast connections,fast laptop but i am an old person and it doesn't stimulate any more.

  • @ARDIJAFARHDOK
    @ARDIJAFARHDOKАй бұрын

    Mr Kenji, u have 13 dots on your face. Nice..

  • @8ghaly
    @8ghaly3 ай бұрын

    Why would someone use sql over excel

  • @austinmathew8335

    @austinmathew8335

    3 ай бұрын

    Coz sql can handle huge amounts of data Excel can't.

  • @catboy721
    @catboy721Ай бұрын

    Yeah, I get this is for people with no background, but honestly, click-click-click through the installation steps is a bit unnerving. I think you should have at least a rudimentary explanation of what you're doing and what's being installed and configured. If something dies during these steps or a user needs to troubleshoot something, they're pretty much hosed if they don't know what's going on. Thanks,

  • @willzinner8813
    @willzinner88133 ай бұрын

    first

  • @KenjiExplains

    @KenjiExplains

    3 ай бұрын

    XD

  • @roadrunner911
    @roadrunner9112 ай бұрын

    fetched data for billionaires not shown completely why?

  • @mojammelhossain5524
    @mojammelhossain55242 ай бұрын

    plz make full series on sql