🔥Take our SQL for Business Analystics Course: www.careerprinciples.com/courses/sql-for-business-analytics
@nainglinnphyoe12317 ай бұрын
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 !
@travelrepeat253210 ай бұрын
Please make a playlist to teach us SQL from beginner to Pro,thanks man
@Feedthesheep_9 күн бұрын
I second this. Please do this bro. You're a wonderful teacher
@alecseidman560110 ай бұрын
Please make a full series, this was so helpful!
@DhrumitMehta10 ай бұрын
Really enjoyed this! Would love a Part 2
@KenjiExplains10 ай бұрын
thank you! I'll keep it noted :)
@ShimaGodlove6 ай бұрын
I'm literally taking a data science course but now that you explained it deeply and understandably I'm slightly getting every query and it's logic. looking forward for more like this one for real. Thanks bro!
@dessinatriceimen725221 сағат бұрын
You have really just clarified everything in 17min, thank you so much
@sonngy12312310 ай бұрын
Hey man, your videos landed me an offer, just wanted to thank you
@aymen55067 ай бұрын
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
@goldennuggetinfo84685 ай бұрын
This is my very first SQL video. I clicked through a few and knew this would be best. Perfect walk through.
@petermapoma3666 ай бұрын
I like the way you teach especially the fact that you make complicated things simple that's a plus. I don't regret subscribing to your channel.
@Osborne2410 ай бұрын
Hey Kenji, thanks for the video Just started learning SQL recently.
@mariahmirandalima32893 ай бұрын
this is one of the best content i have watched so far, everything is well explained, thank you
@thaivang872610 ай бұрын
I'd love to see you make videos on Python as well. You always provided us with the best content.
@clementverdier265510 ай бұрын
Totally agree!
@faisalgolden489710 ай бұрын
plz make full series on sql
@mayowaadeleye931110 ай бұрын
Really enjoyed the video. Definitely looking forward to part 2. Thank you
@markuskankare291110 ай бұрын
Thanks a lot man. I'm studying Software Engineering in University and having exam from this topic. Helped a lot!
@KenjiExplains10 ай бұрын
Awesome and best of luck my friend :)
@Babyk431510 ай бұрын
Kenjii you are so smarttt, please upload a second part!!
@Bojerthe10 ай бұрын
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.
@Nahzh-m1rАй бұрын
Thank you so much. I know 'thank' is a word but i'm thanking you from the bottom of my heart!
@tranceformeeer9 ай бұрын
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!
@j.b.134210 ай бұрын
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.
@shambhavimehrotra25548 ай бұрын
So well and patiently explained! Thank you, Kenji!
@janegathiaka44909 ай бұрын
Great content. Love the way you simplify difficult topics in a short time. Thanks Kenji
@Helen.Channel9888 ай бұрын
Wow, Indeed Beginner friendly, the demonstration is direct and enough to start learning SQL. Thank you.
@mirwansiregar10 ай бұрын
Thank you so much Kenji, your channel is very resourcefull...you make it as main reference for everyone to learn data analyst
@othmanaitmaatallah58166 ай бұрын
The Best SQL introduction ever!!!!
@MonaLove1436 ай бұрын
You covered some essential tips on how to write the code in a cleaner format. Awaiting the next part to this series.
@KenjiExplains6 ай бұрын
part 2 is already live on my channel :)
@MonaLove1436 ай бұрын
@KenjiExplains will check it out, thanks for replying Kenji..😊
@godstv9345 ай бұрын
You just earned yourself a subscriber
@senorbenny577310 ай бұрын
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.
@Anshieee185 ай бұрын
i saw many videos but this was the best video in terms of understading
@Bojerthe10 ай бұрын
Could you make a video on overall formatting and margins in excel from beginner to advanced? Thank you and love your videos.
@abdirashidbashir17629 ай бұрын
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.
@walkerjasmyne9 ай бұрын
I feel like I can really learn this wow you’re a great teacher!
@KenjiExplains9 ай бұрын
Lets go! Best of luck :)
@rameezhassan328910 ай бұрын
you are so smooth in explaining, awesome content
@ReactionSquad15810 ай бұрын
Marvellous sir Your 15 minutes video played a vital importance of SQL pls upload 2nd part. Thanks sir
@subhankarbanerjee30225 ай бұрын
I'm from India brother ur content in very informative and easy to learn for anyone
@asafzilberberg66487 күн бұрын
Great explanation
@vincentnuhugimba82299 ай бұрын
You are the best, you are born to teach🎉
@eddiesullivan959610 ай бұрын
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
@abrahammoruti596710 ай бұрын
Really enjoy your data analysis content Hopefully you'll make a tableau tutorial
@ibrahimmegahed258310 ай бұрын
Great, Thank you! plz make full series on sql.
@vivekviv24878 ай бұрын
Clear and Smooth explanation..! 😊
@maangoswami56229 ай бұрын
Really enjoyed the video. Would love to have more of these type of videos
@KenjiExplains9 ай бұрын
Part 2 on Sunday :)
@waldw9309 ай бұрын
SQL video so great!! very clear explanation.
@sebastiengrenade9 ай бұрын
Im very new with sql and i have a question. Why do we use SQL while we can easily do it in Pivot Table.
@satheeshkumar95868 ай бұрын
size and complexity: Pivot tables can become cumbersome and slow with very large datasets
@ifoodieTV8 ай бұрын
I agree with @satheeshkumar9586. But you asked a good question though.
@yaritzamartinez11115 ай бұрын
Pivot Tables are useful for small data sets. Usually you'd use SQL when your data has 20+ columns and over 20K rows.
@RZing4 ай бұрын
most of the data are saved in database , not in spreadsheets.
@itsundisclosed4 ай бұрын
Pivot tables are great for smaller datasets but for relational, larger datasets, they aren't able to do the work sql can. SQL is a powerhouse for larger scale databases.
@yohannaagbanaji801210 ай бұрын
Hello, thanks for the video, it is an amazing video as usual. I am eagerly waiting for the part 2 of the SQL video.
@UwU-my5zv10 ай бұрын
Please with part 2. Very enjoyable.
@mcwahaab10 ай бұрын
Would be interesting to see a comparative analysis between SQL and Power Query and which one is the best
@EdsonNascimentoEN10 ай бұрын
Great tutorial - thanks a lot.
@jimmerdood9 ай бұрын
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!
@mwlammbi26502 ай бұрын
I can't beleive i am really learning how to use SQL i used to struggle so much with this.
@comichantv727910 ай бұрын
Cool! will wait for part 2
@mustakmnm77 ай бұрын
please make detailed videos for intermediate and advanced asap 🙏🏽
@dminc_25017 күн бұрын
nice video sir 😊
@user-mx1pe7qe8d4 ай бұрын
That's amazing. thanks a lot.
@Stabu8 ай бұрын
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?
@michaelslade9904Ай бұрын
I recently came across your video and would like to practice some of the principles you show in this video. I am having difficulty in downloading the appropriate "mysql" program due to the fact that I must download it from Microsoft store. could you give the name of program specifically.
@amazur6205 ай бұрын
PERFECT, THANKS
@jituchablani317110 ай бұрын
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?
@rashmimishra21776 ай бұрын
Thank You kenji
@bear1729310 ай бұрын
An intermediate video would be greatly appreciated as well. Thanks 😅
@maangoswami56229 ай бұрын
Really enjoyed the video.
@tatyanagrossett800210 ай бұрын
Good day, can you create a playlist for SQL please ?
@silvestrecamposano631710 ай бұрын
Thanks again, Professor!....
@purushottam77510 ай бұрын
Thank you!
@sammyreal1210 ай бұрын
Thank you so Kenji
@DanielRodriguez-of1cx10 ай бұрын
Plz part 2 🙏🏼🙏🏼🙏🏼
@ahmedabdou90477 ай бұрын
thank you very good
@yetundeokpanachi47510 ай бұрын
Thank You
@ScholenEnt10 ай бұрын
Your are good.
@bharathbs200010 ай бұрын
Will you make SQL projects for data analysis
@ranjan119110 ай бұрын
Superb❤
@JUZUZ-kr1bq10 ай бұрын
Wow thank you
@KenjiExplains10 ай бұрын
You’re welcome 😊
@edaa18614 ай бұрын
hi kenji can you give detail for ınstalling sql server for mac system ? There are those who recommend some servers and applications, but it is said that they cause problems with overheating the computer.
@magedx70592 ай бұрын
you are awesome
@jlee682310 ай бұрын
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.
@KenjiExplains10 ай бұрын
I’d say it’s simpler than c++ and other programming languages but a step up from Excel/excel formulas
@jlee682310 ай бұрын
@@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.
@KenjiExplains10 ай бұрын
That's awesome! I'd say compared to VBA it's about the same difficuly (perhaps even a touch easier than VBA)
@official_s3un10 ай бұрын
Good good damn got me feeling like I know a lot now lol 😂
@ShoOnlineAcademy8 ай бұрын
Can you clean up on power query?
@tarikkhaan625510 ай бұрын
Love it
@Kemmydai5 ай бұрын
Hi there! I love your videos and have been using them for a while but I can't go very far with this one because I think the database table is broken somehow now. I've tried importing other sample .csv tables to my Richlist table (as a test) and they've worked but this one keeps flagging the error "Unhandled exception: 'ascii' codec can't decode byte 0xef in position 0: ordinal not in range(128) Check the log for more details." I've checked online for solutions and to no avail, please help. Thank you!
@jamesthuku49979 ай бұрын
Great! But how do i download SQL for Mac OS?
@joshuayoung19354 ай бұрын
What type of database file format does sql support
@Karachigayathri4534 ай бұрын
Do u have full course on sql sir for free in ur channel?
@thecounfusedgrapher3 ай бұрын
Hi Kenji upon uploding file it gave an error Unhandled exception: 'ascii' codec can't decode byte 0xc3 in position 2215: ordinal not in range(128) Check the log for more details. helpppp mac user
@MayorSom6 ай бұрын
How does get grasp of all these formulas?? My mind seem to go blank after awhile. Same issue with Excel too. My mind just goes blank when it comes to actually recounting the formulas
@raphsenyoke2059Ай бұрын
I want to use your video to teach a class, do I have your permission?
@preetshah379310 ай бұрын
Make more videos on sql
@juansanchez-kg2to8 ай бұрын
Is Power query similar to SQL?
@majidislam10648 ай бұрын
Plz plz plz for beginner from basic plz
@preetshah379310 ай бұрын
Make a sql playlist
@Camara22-l7t2 ай бұрын
I am unable to install the sql on my pc, although my Windows is not activated. Is there any other wat to get it installed please
@camlex631010 ай бұрын
Really helpful!!
@Travel20310 ай бұрын
Make more videos in SQL
@wonderful-jg1dt10 ай бұрын
for some reason my files are not opening when i select download save
@Ra-fb6gx8 ай бұрын
same , im using macbook m1 ... idk why , i'm completely beginner with mysql 😥
@nwabuking369 ай бұрын
I can't access the database/dataset used in the tutorial
@SayeedChowdhury-d1m10 ай бұрын
Best..
@Ra-fb6gx8 ай бұрын
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) 😫