SQL for Data Analysis in 2 hours (with dataset + 50 queries)

[@chandrakantshimpi9050]

thank you ankit sir i saw many of sql videos but this type of teaching i cant see on youtube thanks for sharing

[@ankitbansal6]

It's my pleasure🙏

[@ankitbansal6]

It takes lot of efforts to create 2 hours video so please do like the video. It will motivate me to create more long form videos. 🙏

[@8754266374]

Sure keep doing 💪

[@kal_x9178]

Hukum

[@rajeshraja4784]

Sure Ankit🙌

[@2wards_trust]

Thanks Ankit, please share details of you next batch

[@prajwaljamunkar14]

You are incredible 🎉❤

[@kunalchakraborty6772]

SQL for Data Analysis - Key Topics & Timestamps 00:00 - Introduction and Purpose 02:40 - Understanding the Data 07:40 - Selecting Data 12:20 - Filtering Data 20:45 - Sorting Data 24:50 - Aggregate Functions 30:10 - Grouping Data 40:50 - Filtering Aggregated Data 50:10 - Joining Tables 01:00:00 - Left Joins 01:10:40 - Case When Statements 01:20:30 - Date Functions 01:30:50 - String Functions 01:40:00 - Conclusion

[@anjanashakya10]

Thanks for creating this video for someone to start from scratch, especially for folks who come from non-tech backgrounds. This was intuitive and very well explained. I'm looking forward to more such content for learning advanced SQL. Thanks again!

[@ankitbansal6]

Glad you enjoyed it!

[@anjaligondse]

Thanks for this video! It was fun and easy to start with.

[@DataScience-r8d]

I love this video . Your teaching style is amazing . All concepts are taught by tutor but we need a separate video of advanced sql questions for data analysis.

[@srinivasreddygundlapalli6712]

I finished this video.. Very useful and helpful for how functions will execute in order and very interesting concepts ❤❤❤

[@ankitbansal6]

Glad it was helpful!

[@raheemmd2503]

In order to conquer any technology we need have strong basics, this video is very clear and like refresher . Thanks man worth to watch.

[@ankitbansal6]

Glad to know that ☺️

[@anirudhsinghsolanki6256]

Date functions was my favorite. Very nicely instructed. Thank you Ankit bhai

[@ankitbansal6]

My pleasure😊

[@pratikth4unbreakable248]

Really Excited to get deep dive into this comprehensive course sir 😅

[@ankitbansal6]

Hope you enjoy it!

[@pr-rb6jl]

Very simple yet effective.....thanks for the Video...

[@Ajayzzz45]

Excellent explaination sir with such ease Thanks a lot for this

[@ankitbansal6]

You are most welcome

[@ishankshrivastava9234]

Wonderfully crafted and explained !!

[@ankitbansal6]

Thank you 🙏

[@rajvardhan465]

Guruji 🎉 Goat 🐐 in data Domin

[@TanveerKhan-cm9zh]

Very nice explanation with good command on topics supperrr ..

[@ankitbansal6]

Thank you so much 🙂

[@AkshayVerma-mu4ok]

Great session for revising SQL concepts!

[@rajatjain001]

It's a great video from zero to hero in sql

[@ankitbansal6]

Absolutely 💯

[@swastiktripathy8412]

Thanks for covering so many queries in this video.

[@ankitbansal6]

Hope you enjoyed it.

[@madhustips8304]

extra ordinary content

[@tnzlvisuals]

Need same 2HRS video on python.

[@priyaljain8797]

Great video for revision!

[@ankitbansal6]

Glad it was helpful!

[@pavitrashailaja850]

Very well made. Even a person who has zero knowledge on sql can understand. 👍

[@ankitbansal6]

Many thanks!

[@araditabanik362]

Very informative and useful videos for understanding the core concepts in sql. Kudos to your hard work Ankit.

[@ankitbansal6]

Glad you liked it!

[@Swag-q7t]

Great video.Kindly give dataset in csv format

[@amit_bahedia]

Amazing Video Ankit , the way you explain the concepts with real life examples in simple and sweet manner is remarkable

[@ankitbansal6]

So nice of you🙏

[@suriya_nandan6]

❤❤, thank you for making this kind of helpful tutorials

[@ankitbansal6]

My pleasure 😊

[@hemantkumar-qk3en]

Amazing video. It's not easy to post a 2-hour video and with no flaws. One can easily refer this a day before interview to sharpen the basics. Very useful :) Thank you for sharing

[@nithyapalanisamy4904]

clear explanation and explaining sql concepts along with excel is way to understand data analysis easily

[@ArtByDeeksha]

Valuable content and well explained, Thank you.

[@ankitbansal6]

Glad it was helpful!

[@sekharn2975]

A Great video Ankit, Thank you so much for this. hope you make a video on advanced sql as well

[@nikhiltrade]

This is very very very helpful Sir, Thank You

[@Ranjit-K9]

Hello Ankit this is a very use full video for every beginner can you please make one video on python interview questions for data analyst that'll help many of the learners and get some idea how the python questions where asked please do once's.

[@MrAlokmca]

Great session Ankit bhai , please create more videos like the same, thanks 🙏

[@ankitbansal6]

I will try my best

[@rasanivr]

Thank you, I used this video as a recap before my interview. ☺

[@ankitbansal6]

Awesome

[@vinayraj2960]

Great video but also requesting one video on advanced sql covering topics like SCD, Stored procedure, rank functions and more

[@chiranjeevivarma8258]

Plz do it for phython as well Bcoz the way of explanation you have given with exceptional clarity we can't get it from anywhere

[@theinsightminer08]

Great video to revise sql. Thanks sir for your efforts!!

[@ankitbansal6]

Most welcome!

[@boogieman8827]

Thank you sir for giving this course

[@rabisankarkar25]

Thanks a lot for your effort sir. It helped me a lot to revise the basic concepts. Also requesting you to make another one shot video like this solving advanced queries which involves topics like CTEs, subquery, etc.

[@nehatiwari9003]

Amazing video Ankit sir.. thank you so much for giving it for free 🙏

[@vishwassharma3312]

Thank you sir i have been waiting of complete sql video for a very long time. 👍👍❤️❤️🙏🙏

[@Sukkolu]

ln less than 2 hour covered all most all the SQL queries and functions, I have seen lots of SQL lectures, the lecture duration was 10+ hours, but i was not able to understand most of the functions and queries. The way you teaching Ankit sir is very good and easy to understand. Thank you sir for making such a learning stuff. ❤😍

[@ankitbansal6]

Glad to hear that😊

[@Uzair_khan2890]

Hi Ankit, Very Good content and explanation. kindly upload one more video related to advance Sql like stored procedure and window function.

[@roadtrippingwithmihir]

Hatss Off Ankit to your efforts ! great stuff

[@ankitbansal6]

Thanks a ton

[@Aadvika_karri]

Thanks for your video, yesterday I bought course in namaste Sql

[@ankitbansal6]

Awesome. You can do the course directly . This video doesn't cover advanced concepts.

[@naveenpinglay5402]

Really good explanation!

[@ankitbansal6]

Glad you think so!

[@aloksingh-ew3jf]

Thanks Ankit for sharing this, It is valuable. Expecting more such videos in coming days..

[@ankitbansal6]

My pleasure

[@arideepchakraborty5642]

Excellent explanation. Very useful video.

[@madhupincha7898]

This video was amazing for revision purpose Learnt the way how to think like SQL The way you compared and shown the difference of implementing things in Excel and SQL was something new i leaned The way sequence was execution of queries you explained was great now we no more have to remember those.

[@ankitbansal6]

Glad you enjoyed it 😊

[@EpicSharjeel]

Hi Ankit sir bs agar aj sql complete horha hai aur confidence milrha hai toh sirf apke wjh se plz sir interview questions bhi bta de complete SQL Series bna de

[@rajveerdhumal3143]

you are doing great work Ankit

[@Akashs-mb6jn]

Ankit this video is really helpful. I'm from a Commerce background I don't know how to write the codes. But you are teaching step by step and very slowly which helps me to understand easily also the Concepts are very clear. I'm waiting for your part 2 video.

[@ankitbansal6]

Glad to hear that😊

[@Thekingslayer-ig5se]

Great initiative brother. Well done. Will be much useful for people like me. I am working in a data engineering project and this will be useful for me

[@ankitbansal6]

Great 👍

[@positivity1247]

Thanks for this great efforts sirji ❤❤❤

[@pateldh23]

Please make videos on store procedure with temporary table its useage with html output please

[@sasmita406]

Hello Ankit sir , I saw this full video , it was awesome and clear the fundamentals of solving SQL questions . Thank you so much for making this video and made easy for all aspirants who are watching this video and start practicing the SQL questions onwards by seeing this video . Thank you so much . I would request you kindly make some more videos like this so that we can learn , understand and easy to solve all interview level of SQL questions. Thank you sir !

[@ankitbansal6]

Glad you liked the video. Do share with your friends.

[@awarabackpacker_]

Thanku very much for this video sir ❤

[@sureshgunasekar5762]

Great Explanation!!!

[@ankitbansal6]

Glad you liked it

[@ABQ06]

Can u please make video this same way on Advanced Sql like Window functions, CTE's,Stored procedures and temp tables etc Thanks

[@AkashGupta-ef2wm]

Thank you Ankit

[@anshu_chauhan471]

Thank you sir 🙏

[@ankitbansal6]

Most welcome

[@OppoTeam-u7s]

Please make another one for advance SQL in which topic like windows functions, cte , sub queries,etc

[@ChevroletGirl1974]

I agree!

[@shikharsaxena8984]

Great video sir 👏👏

[@ankitbansal6]

Keep watching💪

[@vandanapatil8182]

Pls bring in depth Advanced SQL lecture

[@rushivanjare97]

Ankit sir please make video on SSIS Integration tools

[@SandeepSharma-oc6wx]

Ankit Sir, please make a video on how you record the video, edit and upload. Complete process

[@gameply347]

Can we get a video on TRIGGERS, STORED PROCEDURES AND FUNCTION 🙌 ?

[@Hesralli_YanIde]

Thanks Ankit. 🤗

[@ankitbansal6]

My pleasure 😊

[@jahnavigupta3991]

Sir indeed it's a great video..I request u if u post the dataset it will be really helpful in csv or excel format....

[@ankitbansal6]

It's there in the description box

[@hairavyadav6579]

Sir nice video ❤ To bring twist please use hindi also....

[@Lokesh0595]

Thanks Ankith 🎉

[@koushiknaskar3052]

Please make video on advanced topics like stored procedure

[@ragulmarley4900]

😊super sir really

[@aryanverma9736]

Good work. ❤

[@9450140584]

Please share the link for Advanced Tutorial. Thanks

[@aditi_shetti]

Great video Sir. All your videos are really helpful. Can you also make a video on SQL projects to add to a fresher portfolio?😊

[@ankitbansal6]

Sure

[@fariahasan3965]

thank you💌

[@ankitbansal6]

You're welcome 😊

[@pateldh23]

Sir, We are waiting for your new videos in SQL server

[@madhupincha7898]

Next video suggestion is please add some portfolio projects in SQL Bcz most of channels covers basic dummy projects Please add some which we can add in our resume and portfolios

[@ankitbansal6]

Sure

[@anujasawant1655]

Can you create one video for the SQL data analyst projects to add to the resume?

[@ankitbansal6]

Sure I will do that

[@cryofficial2873]

@@ankitbansal6 thank you so much

[@AmitKumar-ly2rv]

​@@ankitbansal6I want to purchase a combo course of 4999, can you please give me a promo code so that I can avail the offer Ankit sir🙏

[@anujasawant1655]

@@ankitbansal6 thanks 😊

[@boogieman8827]

Can you also give videos for python for data analysis

[@Avi_raws]

Is it helpful for business analytics also?

[@ankitbansal6]

Absolutely

[@king-hc6vi]

Sir requesting you to bring such type of video for python as well...

[@ankitbansal6]

Sure

[@prashantjaiswal5260]

It will be very helpful if only same video is also made using python

[@nikhiltrade]

we need second part

[@SpreadingKahaniyan]

today's lunch done 🙂

[@VinothkumarSelva]

HI Ankit, Thanks for sharing the knowledge as always. Just out of curiosity, even though most of the other channels prefer postgres, i still see you prefer ms sql. Is there any advantage on it? Thanks

[@ankitbansal6]

Nothing as such. I am very used to it and feel comfortable while recording videos.

[@positivity1247]

For data analysis sql and Power bi is sufficient

[@ankitbansal6]

Yes

[@jayasuriyaa.d.7018]

please provide the advanced sql like interview level

[@harikachinnu7289]

Sir if sas programmer will learn SQL it will be useful sir ...

[@ankitbansal6]

Yes, definitely

[@amaanabdul5195]

Whether this video concepts are enough for data analytics

[@ankitbansal6]

Basics are covered. Advanced concepts are not covered.

[@amaanabdul5195]

@@ankitbansal6 please cover advanced topics too

[@OppoTeam-u7s]

Bhaiya make one another for advance SQL

[@muhammadahsanafzal7203]

I heard alot about your excellent teaching style.Whats the difference between this tutorial Sql course and your paid sql bootcamp?

[@ankitbansal6]

This covers only the basics. The course covers all advanced concepts and also you have assignments after each lecture. You have a couple of projects as well to solidify the skills. The course also covers the performance tuning part.

[@muhammadahsanafzal7203]

@@ankitbansal6 well explained!!! Thank you. For SQL bootcamp any promotion going on

[@ankitbansal6]

@@muhammadahsanafzal7203 recorded: ILOVESQL Live : EARLYBIRD

[@user-rc2uc1kv6w]

links are given for both mysql and ms sql so does that mean these codes can run in both?

[@ankitbansal6]

Yes

[@mr_unknown01112]

Form where we can download used data which is used in project

[@ankitbansal6]

Description box

[@mr_unknown01112]

@@ankitbansal6 ok thank you

[@mohits4841]

No one would accept during the interview that they follow Ankit Bansal, not even the interviewer 😂

[@mulikinatisiddarthasiddu8245]

Bro where is the data set

[@chitranshchaturvedi2333]

Bhaiya maine kal hi aapka course purchase kia hai Namastey sql ka To ye youtube bala course kru kya aapka ek baar main course chalu krne se pehle

[@ankitbansal6]

You directly do namaste SQL. Everything is covered there from the basics. This video doesn't have advanced concepts and assignments.

[@chitranshchaturvedi2333]

@@ankitbansal6 ok thank you sir

[@motiharicamera341]

Sir, hame diwali discount de dijiye course ke liye

[@RahulKumar-gt5sr]

sir, i am okay with this type of problem but still not able to solve interview question. please can you suggest me what should i have to do .

[@mulikinatisiddarthasiddu8245]

Bro practice the sql probelms bro

[@ArvindKumar-bf1ei]

Hello sir data analytics ka free course ya playlist bta digiye koy jo mujhe help karein please sir