SQL for Data Analysts and Data Scientists IN 1 HOUR
ฝัง
- เผยแพร่เมื่อ 7 ก.พ. 2025
- PRACTICE SQL, AND PYTHON HERE: stratascratch....
Patreon: / shashankkalanithi
Become a Data Analyst and get ready for your Interviews with this quick course on SQL.
Course Notes: bit.ly/shashank...
Course Files: bit.ly/shashank...
Hardware:
MX Master 3 amzn.to/3sTroBW
LG 35in Curved Monitor amzn.to/39pPzR3
USB-C Hub amzn.to/31Ip8Sl
MacBook Pro Retina 16 Inch amzn.to/2PSwZde
Twitter: / kalamari95
This 1-hour tutorial equals an 8-week online SQL course I swear!!! Thank you!!!!!
Is this really true broo????
@@aniketsingh3364 i swear it true..
REALLY? im gonna be happy then
NO you are exaggerating. It is nice and summary kind of video.
Stop exaggerating .It is good for start and too much compact but good for a fresh start.
This channel is the reason I'm able to feed my kids
😄😂
Very real
One of the most underrated and valuable Data analyst channels in TH-cam. Really appreciate the content!
Thanks so much Miguel! I hope the content is useful and helpful :)
Free video content WITH notion notes and course materials
This person deserves the world
@@ShashankData Hi Shashank, thanks for this wonderful video. I am starting a new role as a data analyst and I was wondering how to atleast get to know the basics faster. It worked well! Please post more SQL tutorial videos like this
I more agree with you ,great man ......
Yup!
I have paid so much money in several classes and bootcamps but have not been able to understand and grasp the concept and actually coding with SQL. You have simplified writing queries and UNDERSTAND why things are done to fetch needed info when coding. THANK YOU AND YOUR AMAZING. You blessed us with the way your brain computes SQL which is KISS. Stand for Keeping It Simple Stupid. haha blessing dear
I've watched about 50 videos regarding this subject. This is by far the best and most relevant. Thank you
Thanks a lot for content
27:37 I love when column names and table name are in lowercase while SQL syntax are all uppercase. I find it easier to read.
in one hour, you gave me and i believe all viewers the enormously powerful push to put long steps in data analysis field, SQL 1 Hour from you equal weeks from any other courses. great job and please give us more of this
I like your thought process as you go through. You show your mistakes that we all naturally make and how you resolve them.
Dude I just did your data manipulation video yesterday and now I just came across your SQL one by accident. I am an analyst who has been traveling for a few months and need to get back in the swing and get a job so your videos are great ways to get my mind thinking in that domain again.
Great work, I’m looking at getting into the Data analyst role, and you’ve really put together such a smooth path into the career. Looking forward to more videos
You're a ROCKSTAR, man!!! Congratulations, one of the best videos I've seen on this topic! Subscribed, keep them coming!
by far the best SQL lesson i’ve seen, been trying to get the right file to download all day and now I got it in 15 seconds. Shashank you’re an absolute legend love all your vids i’ve watched!!
This is the best channel I've ever found. You make great videos so detailed for whoever wants to start their career as a data analyst including me
Good Job sir !! Keep up the good work👍👍👍
I totally agree! As someone who just picked up SQL and is still practicing, learning tips and tricks, other videos on youtube and classes for that matter isn't as detailed or doesn't explain to where a beginner would understand it. Thank you x3 Shashank for this! Would love to see that video on dates!
Goodluck to us on this life changing journey. See u at the top
Excellent run through! I finally got excited about SQL again. Thanks so much for putting this together!
Thanks for this!... Hopefully, this will help me with my Data Analyst interview tomorrow.
i love how by your language its evident you recognize that much of your audience is foreign. its like you are teaching us the way you would teach your cousins in your motherland. Thank you for thinking about us. I appreciate it
Shaskhank, thank you so much! I'm just starting my DS journey and you're the best channel on youtube that actually demonstrate all the steps needed at the very beginning.
Regards,
Daniel from Brazil
Ainda bem que colocou teu nome se não seria impossível de saber valeu Br !
The reason tbhsi video is amazing is because you demonstrate how easy and fast you can Google your problems or questions. Amazing
Hi, Another great video, congrats on your new job and moving to West coast from Texas.
Thanks
I had only watched the first few minutes (7 mins or so) - thank you for your clear diction. I did not have to pause and/or slow down the playback in order to understand what was being said. The content is excellent as I progressed, and I have subscribed. Again, thank you.
hey Shashank, recently joined a MNC as data analyst , was finding sols for a query and stumbled across your yt channel. Amazing content tho for a begineer , if u dont mid I would like to get a sepatate video for windows functions are they are a bit tricky to understand but are really useful in real life scenarios , would highly appreciate if u make one on them. Regardless amazing content!! hoping to impart knowledge like u do in future .
Imma data analyst and this was nice. The only thing that I need to try out is union all that was new to me lol
Great video. I have a lot of stuff to practice. Thanks so much.
Old man trying to get into data analytics. Thanks !
Nice last minute interview prep video. Almost everything covered in 1 hour great.
This is an amazing course! Thank you so much for providing all this information for free in a very structured way! I really appreciate how you get straight to the point without overcomplicating things.
I love this, so simple yet well-detailed
This channel is so underrated ....You deserve more subscribers
This is great staring point. I wish there were more real life entry projects to do that you can start scaling up each time you pass.
Best video I've come across by far! I've been looking for that video or that training course that left me feeling a "spark" that would give me that mechanism that launched me into the next phase of my education and this was it! Thank you!
One of the best and understandable explanation for beginners! Thanks bro🙏
Your channel is one of the most underrated channels. Love your work buddy. Thanks alot
This is probably the best analyst series I've come across by far.
Great content as always! Looking forward to seeing more videos on SQL. In one of your early python videos, I found it very helpful that you went through a real life assignments from one of your clients, maybe you can show something like that with SQL? Also, you mentioned that you will put an example of a large query in the notes to show us the order of commands. Did I miss that in the notes or is it not there yet? Thanks for all that you do!
Can you share a link of that Python video tutorial please
The only tutorial that could hold my attention. Thank you for doing this! New fave informational channel.
Thank you so much for this video! I am on the look out for the master query list mentioned in the video. I might be over looking it.
Great work, very detailed for a 50 minute tutorial
Thanks for this great video!!!
I am relatively new to anything w.r.t coding and data but I would say that you have explained SQL in a manner that I will surely remember the basic concepts. I really appreciate the references to how SQL is used in real data analytics applications and on the job scenarios.
Just a side note, I came to know of this video thanks to John David Ariansen as I had asked him for any reference material for SQL specifically meant for Data Analytics (I am doing a course on the silverstone analytics learning platform).
I really liked your teaching style and I would surely take up your courses if you plan to start any Data Analytics related courses!!!
Once again a big thanks for your efforts!!!
can you show us with a real case study as how and when do you use SQL? that would be really helpful
hey, did you find something for this?
@@anjalitewatia9961 I would be interested Anjali
Your channel is the best I have seen. Great. I have subscribed to the channel already.
I was ready to spend money on a refresher course because I have not used sql in over 10 years. Thank you for this video
I have done a few SQL courses but this one beats them all. Easy to follow and great explanations.
Thank you Shhashank, found you on tik tok! I am close to finishing a certificate program for Data Analytics and am using your videos to freshen up my skills. Fingers crossed I will get that Data job :)
did u get it?
Finally I found a video on sql I’ve been looking for….thanks a lot Shashank!
watching in 2025 - great video, easy to follow and practice, lots of aha moments , thanks SK!
Thank you so much Shashank
Great Guy you are. Very important and valuable person.
Exellent video, simple and easy to understand....love it!!!!
you are different from others content creators, you share a lot of practical, like REAL LIFE IN JOB experience.
Thank you for taking the time to do this video. Very much appreciated!
Damn! This is great! I’m a software engineer at my company and we’ve just introduced databases and this is great!
What SQL book do you recommend to have as a handbook on your desk for referrals ?
He is iron data analyst... You do.super videos ...Bring more videos like this for power bi, tableau, python and more etl tools or cloud services like azure etc
Nice overview of some the most important knowledge for passing interviews!
Thank you sir! I'm preparing my SQL interview and this helps me a lot. Thank you so much!
cant open the file as it wants to create a new one, if it has the name of the database u provided it tells me "a file with that name already exist creating a new one will replace that file" ...
Edit: So if i click on "browse" to open the file it doesnt work, i actually had to put the path manually in there otherwise it would overwrite the file, for whatever reason?!
This man just clearly says, My notes and google can explain better instead of trying to prove he is SQL GOD. I really love the originality because we all can relate to this and this is natural. Such a nice tutorial.
Thank you so much Ryan!
Thank you sooo much. This was so informational and detailed for a beginner! Like, put some ads on the video bc I feel bad watching all this for free (even the detailed notes and other resources are free).
Thank you for the kind words Silvia! And great callout just added a couple of extra ones, I think you might have gotten lucky and been able to skip all of them haha.
Your content gives me hope. Thank you.
Excellent tutorial. I really liked the format. Very useful
Just found your page and I love your work! It would've helped if you scrolled down on the query results to make it clear that ROW_NUMBER restarts when the partition changes. Thanks for making this, it was super helpful!
Hey I am watching this the next day I watched 'Ricky Stinicky' movie and when you explained 'join' with your two hands as circles, it reminded me of the scene from the movie about their boss doing 'the' imitation. Also covering essentials under 1 hr is hard while providing everything is so cool!
ELEGANT || EASY || EFFECIENT
Awesome 1 hr session bro.
so far have forwarded your video to 5 more people who are learning.
keep doing similar stuff and help people.
Hey Shashank, it would be really nice if you teach us how to impost new csv files into Dbeaver.
I am happy to find this video; because it is in logical sequence.
Thank you very much, Shashank.
Good video to refresh within an hour . Thank you for taking time and doing it
You are really setting us up for success. Thank you so much!
Thank you so much for the kind words! I’m glad you find the videos useful
Just starting my DA journey…your video is great for quick revision for beginners..
One of the best Data Analyst out there 👏
The best SQL Video I have watched so far. Thank you so much for this amazing content.
Thank you for your effort to pull this together. How do we select parameters with parenthetical plural in the passenger column?
For instance you gave example using "Alone"
How do we select 'Friend(s)'
And even 'kid(s)'??
Thankyou for making this videos, very insightful !!!
Hey Shashank! Thanks for sharing your knowledge.
How did you split your windows like that? I just use the regular Mac option but I would like to know that program. Also I’m just learning about data analysis and am pursuing it as a career
Damn!!! Thank you for spending time putting all this stuff together.
Of course! More courses to come in the future :)
This is so usefull. This is first time I touched on anything technical in my life. Didn't skip even one ad here 😂 Thank you Shashank 🙌
Are there any other youtube videos that would build on to this? Loved this as a primer.
Great Content, you make me feel confident, none of my college teachers could do that.
Really excellent introduction. Thanks for taking the time to do this, I hope it pays off!!
Your notes are very good for interview perspective for active recall.
Your tutorials are the best. Please keep doing them. I'm learning so much.
Thank you for being short and to the point; this was so helpful!
You are simply the Best. You are changing my world. Thk you so much
This was a great video tutorial! Thank you.
Great job man, great video👍
This 1-hour tutorial equals to a whole semester of my university
Same... LOL
Bro that was amazing. You are a really good educator.
very well explained, thanks for this video.....please upload more videos on SQL.....you are amazing !!!!!
Thank you! This was extremely useful!
Another fantastic video. Thank you for taking the time to create helpful content.
Of course and thank you for your support!
This was really nice video.Please upload next level video.
Can you do more of these videos ! 😭 learned alot or even a course ? I'll buy lol you explain very well. Thanks lots.
Thank you so much for this Shashank.
You rule.
The notes you make are amazing. Thankyou for blessing us man!
Thank you Nivair :)
@@ShashankData hi.. Are you planning to conduct any live training classes for data analytics?
this is not 99% nor 101 % , this is 100% perfect channel for DS
Thanks alot for this video… i have mastered a number of concepts
Bless youtube algorithm, I found this gem. ❤️ This is what I needed. Thanks a lot for making this 🙏
Thank You so much bro for this......
I found your video randomly, surprisingly I found this one, with notes in Notion, which I have been using last 1 year. I see lots of notes online but your notes in the notion are best, superb.
Thank you so much once again...
Great video. You have covered pretty much everything what I needed in just one video 👍
Thanks
Thank you sir ,for these database lectures. 🥺🥺 I am a naive in db stuff. These are helping me a lot. Once again thank you so much sir for sharing all these for free 😭🙏🙏