SQL Training | SQL Tutorial | Intellipaat

[@Intellipaat]

👋 Guys everyday we upload high quality in depth tutorial on your requested topic/technology so kindly SUBSCRIBE to our channel👉( bit.ly/Intellipaat ) & also share with your connections on social media to help them grow in their career.🙂

[@maheshr9080]

Hi, I tried to download this from microsoft website as shown, however, I got the ISO file and not the one that's displayed here. Any workaround ?

[@jeetendramaurya7560]

Sir Android studio par bhi video bana do.. in deep

[@nagarajanramanathan2055]

l.

[@amitkumar_417]

Can't able to see these small words

[@poojakukreti8618]

At 1.21.00 how did we get 7 records after applying right join. when there were only 6 in both the tables. This is really confusing

[@Intellipaat]

Following topics are covered in this video: 01:07 - what is a database 01:28 - database management system 03:37 - introduction to sql 04:57 - sql server installation 09:26 - tables in sql 11:05 - how to select a database from existing list 12:35 - data types in sql 13:09 - different datatypes in sql 16:04 - constraints in sql 17:58 - how to create a table in sql 24:53 - select statement syntax 27:50 - select distinct syntax 29:18 - where clause 32:06 - and, or, not operator 39:01 - like , between operator 43:30 - functions in sql 58:59 - order by and top clause 56:40 - group by statement 01:06:23 - delete statement 01:09:21 - inner join 01:14:10 - left join 01:17:46 - right join 01:21:08 - full join 01:27:39 - delete using join 01:29:40 - union operator 01:36:05 - views in sql 01:41:30 - merge table 01:47:12 - types of user defined function 01:53:38 - temporary table 02:01:22 - iif() function 02:07:39 - stored procedure 02:10:18 - exception handling 02:10:24 - try/catch 02:14:44 - transactions in sql 02:19:38 - database administrator 02:31:40 - backup & restore of databases 02:46:17 - dynamic management views 02:54:22 - performance monitoring 02:59:35 - data integrity

[@esakkijeyaraman2859]

Is creating custom type exists ?

[@esakkijeyaraman2859]

Can u pls provide cursor tutorial

[@nectar4103]

Intellipaat doing awesome work for us☺

[@shekar762]

It’s good to get certification in SQL certification for better career and more calls from HR Try practice certification exams in Vullam website 🥳

[@mycreations5723]

Index😅😅😅

[@anitaanand7099]

I have gone through so many SQL Videos but after few mins felt boring. But this video on SQL by Intellipaat is fantastic. This video is recommended for Non IT graduate as well who want to entering analytics. Thank you Bharani Sir you have made each concept so understandable and also liked your mellifluous voice... Thank you so much Intellipaat.

[@vishalmakhija2895]

Amazing .i am not even tech savvy but could understand every single word. Kudos to ur hardwork and dedication in making such an insightful video .

[@Intellipaat]

Glad you liked it. Keep learning with Intellipaat. :)

[@Siva-xq1qd]

This is the one-stop point for SQL learning!!! Thank you so much to share in-depth knowledge in simplest way for all levels of students.

[@Intellipaat]

Glad you liked it. Keep learning with Intellipaat. :)

[@SaifaliLE]

Hello ! I have a doubt. do you need to know programming for learning SQL??

[@v.ashokkumarv.ashokkumar8364]

md saif ali it’s not required to know programming language for SQL

[@AM-jw3dr]

I was struggling before finding suitable course for beginner but now i'm not, if you are beginner learner of sql and you find this course you are so lucky.

[@Intellipaat]

@A M Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.

[@shanabid_2655]

Thank you, sir m, from Lahore, Pakistan and I learn many core SQL concepts from You. I say again thanks live a peaceful life, dear Sir.

[@Intellipaat]

Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.

[@prathameshyadav2001]

1:56:28 case statement 2:23:10 MS SQL server

[@sudhakarsudhakar529]

The first ever video for 3 hours not wasted even single second. Thank you so much. S this enough for learning complete SQL?

[@Intellipaat]

Glad it was helpful! Keep learning with Intellipaat😊

[@JEEspinar]

Congratulations! I saw many videos in You Tube about Sql Server and you deserve 1000/1000 in rating. Your Job is excellent Blessings from Ecuador

[@Intellipaat]

Thank you for watching.

[@anuanu6288]

Totally agree! Its so easy to learn and interesting. Thank you intellipatt

[@SYD_Technologies]

Tq sir .. Great sql video in youtube..Plese upload following topics also.. SQL with SQL As SQL limit SQL select multiple,As,IN,first ,last ,rondom Sql Alter table . Sql Copy table Sql Temp table

[@Intellipaat]

Sure, will forward the topic to the respective team and will upload the video soon. Please subscribe to Intellipaat channel & press the bell icon so that you don't miss that video from us.

[@SYD_Technologies]

Please upload I have interview...

[@piyushbisht3229]

glad this is free of cost and this video is perfect example of " where is will then there is a path"..thank you so so much

[@Intellipaat]

Glad it was helpful! @piyush bisht Do like, share & subscribe to our channel to get updates on upcoming videos.😊

[@piobasartejr.7686]

With much gratitude, although it's very challenging to remember all of these information I am confident that by watching the video repeatedly will help me to fully comprehend all of these. I was amaze by the speaker because he taught SQL will details and full explanation.

[@Intellipaat]

Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.

[@vibetribewithsupriya3285]

Really very well explained in simple terms. Thank You very much for this video..

[@Intellipaat]

You are most welcome @Vibe Tribe with Supriya

[@bithibithi4989]

Absolutely amazing vedio

[@Intellipaat]

Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@muralikumaar9456]

Best SQL course available on KZbin

[@Intellipaat]

Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@Rohit-tz6gs]

This video is far better than others available in utube.

[@Intellipaat]

Hi Rohit, thanks for your valuable feedback.

[@nburnwal3690]

Thankyou sir. Your lecture video is very easy to learn all the basics of SQL query. It couldn't be more effective and clear.

[@Intellipaat]

Glad it was helpful. Keep learning & upgrading your skills with Intellipaat. :)

[@googledev566]

Why it couldn't more effective n clear?

[@BalvinderSingh-uh3my]

Man I've been looking for a deeper insight into TSQL Thank You I'm a DBA in the UK.

[@Intellipaat]

Hi Balvinder, thanks for your comments. Also share videos among your connections so that they get benefitted too.

[@BalvinderSingh-uh3my]

@@Intellipaat Thanks Parji you ever in London give me a shout I've lived here all my life.

[@eb5333]

You know what, Indians are kind and nice teachers with the right way explanation that human could understand material very clear and well! probably because of the soviet school... :-) thank you.

[@Intellipaat]

Well said! Thanks.

[@sooroo9444]

This is the best course in youtube!! You have managed to cover it all. Great job done!!

[@Intellipaat]

Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.

[@sivakamydhakshinamurthy3212]

One stop shop for SQL. Great step by step explanation!

[@mwadeghunyange4656]

Top! One of the best tutorial ever. I really enjoyed watching this tutorial.

[@Intellipaat]

Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.

[@mauryar16]

Very nicely explained...Thnk you

[@Intellipaat]

Welcome. Stay tuned to Intellipaat to keep learning. :)

[@mrdypk4830]

Great work!!! this is first time i'd ever watch a complete tutorial in you tube. Thanks a lot for this information...

[@Intellipaat]

Glad it was helpful. Keep learning & upgrading your skills with Intellipaat. :)

[@Suraj-xi2bt]

Apne bahut acha bataya . School mei to kuch samajh hi nahi ata . Thanku somuch

[@Intellipaat]

Glad it was helpful. Keep learning with Intellipaat. :)

[@priyar.1641]

your voice is clear and explanation is too good....learnt a lot from your channel... thank you so much :)

[@Intellipaat]

@Priya R Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@thrinadhgundarapu6959]

even i know before little basics but can't perform , after watching this i felt very simple to learn by your videos 🙏 TQ for your efforts pls make more like this 💐

[@Intellipaat]

@THRINADH GUNDARAPU Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.

[@andrews13]

well organised & arranged . starting from the scratch including showing the downloading of set up files. Great work!

[@Intellipaat]

Glad you liked it Ashish. Keep learning with Intellipaat. :)

[@harathitankala6391]

Easy to understand the audio. But no option to change video quality. Facing issue to understand diagrams( evaluation of SQL server) expecting evaluation of SQL server video with clarity. Thank you

[@Intellipaat]

Noted. @HARATHI TANKALA Do like, share & subscribe to our channel to get updates on upcoming videos.😊

[@harathitankala6391]

@@Intellipaat sure

[@lindakide4570]

Waaaaw, I have seen no detailed and acurate tutorial like this one. I love it so much and it has literally ushered me into data base management. Thanks for the good work

[@Intellipaat]

Glad it was helpful! keep learning.

[@bunu2996]

Excellent video..Thank you..my SQL knowledge is refresh again..

[@Intellipaat]

Great to hear! Keep learning with Intellipaat😊

[@searez7251]

I have a question @ 1:27:10 First I want to thank you all for the tutorials, it is one of the best online tutorials one can find on the internet. Here is my question. Even though we can update employee age using join syntax, why we need to go the hard way while we can just update the e_age on Analytics department by just using the Only UPDATE command, and it returns the same result ? (you can see below). UPDATE employee SET e_age=e_age+10 WHERE e_dept= 'analytics';

[@naghsriimmiddisetti3998]

Nope it will increase +10 age in analytics…

[@mr.satwik6589]

Your voice is so clear . Thanks for the session.

[@Intellipaat]

Glad you liked it 😊 @Mr. Satwik Do like, share & subscribe to our channel to get updates on upcoming videos.

[@ranjudeviagarwal3282]

I have my practical exam tomorrow and the video helped me very much thanks for making it.. 😊😊

[@Intellipaat]

Glad it was helpful. Keep learning with Intellipaat. :)

[@alaliogoli8807]

Thank you so much, i am preparing for an interview and this tutorial has been helpful, God bless you.

[@Intellipaat]

Glad it was helpful!

[@venuchaganti]

Good one. Best SQL sessions that I have seen. Watched completely. Keep it up 👍

[@Intellipaat]

Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@phalswaladitya]

Very helpful for class 11,12 computer science students. With practical

[@Intellipaat]

Great. Keep learning with Intellipaat. :)

[@rajpanwar11]

श्रीमान जी नमस्कार मेरे ख्याल से आपने बहुत अच्छा प्रयास किया है डाटाबेस को समझाने का। पर अगर आप इस महत्वपूर्ण टॉपिक को थोड़ा साथ साथ हिन्द में समझाए तो बहुत अच्छे से समझ आए। धन्यवाद्।

[@adarshpal4219]

Zabardast video sahb maza aa gya tommarrow is my practical of it class 12 student

[@Intellipaat]

Thanks and welcome @PW IANS pathshala Do like, share & subscribe to our channel to get updates on upcoming videos.😊

[@palaniappan2581]

Bharani Sir's voice feels so crisp and vibrant! A typical tutor's voice ❤️🔥

[@Intellipaat]

😃

[@zamanjony7493]

Love this video. Learning without less confusion.

[@Intellipaat]

Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@pallavigupta660]

sir this video is really nice covered every concept very clearly thanku so much sir...

[@Intellipaat]

@Pallavi Gupta Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@vaibhavsrivastava4099]

fantastic vedeo of Sql not just for beginners but also for the experienced. thanks a Lott.

[@Intellipaat]

Thanks. Stay tuned to Intellipaat to keep learning. :)

[@kamaleshs7433]

I found it very useful......and i have an exam on sql in 2 days Thank you

[@Intellipaat]

Glad it was helpful. Keep learning with Intellipaat. :)

[@subhakarmarsakatla713]

The best SQL course ❤️

[@Intellipaat]

Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.

[@pradeepalappuzha]

simple,lucid and easy to follow. Thank You👍

[@Intellipaat]

@Pradeep Kumar Most welcome 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@afonsoosorio2099]

An amazing tutorial by all standards. Smaller dataset for demo, highly impactfull. Missing only the windows functions for full advanced SQL tutorial. Well done, keep it up

[@Intellipaat]

Glad it helped! @Afonso Osorio.

[@SYD_Technologies]

Sir..Plese upload video about normalization n keys

[@Intellipaat]

Sure, will forward the topic to the respective team and will upload the video soon. Please subscribe to Intellipaat channel & press the bell icon so that you don't miss that video from us.

[@sriharihari3511]

Good job sir

[@Intellipaat]

Thanks, Keep Learning with Intellipaat. :)

[@ZacK-rp6vz]

Thanks IntelliPaat. It was a awesome session on SQL. Crisp and Clear Explanation.

[@Intellipaat]

Thank you for watching. :)

[@ayushdikshit104]

Nice and easy to learn... Thanks to the man behind this video who is explaining this...✌️

[@Intellipaat]

Thanks a lot. Keep learning with Intellipaat.:)

[@kirtihoney3822]

Hatsoff to share your knowledge thank you very much with clear audio n video.. .

[@Intellipaat]

Glad you liked it. Keep learning with Intellipaat. :)

[@ashutoshshinde3141]

Thanking in sanjubaba style: Tum bahut mast sikhata hai🙌🤝

[@Intellipaat]

Hahahaaha thanks. :)

[@mdakhtarkhan4235]

Thank you very much sr, your classes is helpful , I learnt SQL from your classes , It is my Humble request may u provide SSIS classes vedio ,

[@Intellipaat]

Thank you. Stay tuned to Intellipaat for more updates😊

[@prathibhachowdary4915]

Great work.i learned the concepts clearly. I spent almost a month to learn SQL but i was not clear in concepts. Keep doing

[@suresh8204]

How much time it need to learn.offline course duration??

[@prathibhachowdary4915]

@@suresh8204 I took 7hrs for installing n doing the examples along with video

[@suresh8204]

Any need of previous knowledge to learn sql????

[@prathibhachowdary4915]

@@suresh8204 no need. They will teach u from scratch

[@prathibhachowdary4915]

@@suresh8204 it depends on u suresh

[@shaikneeshma904]

Sir ur video and way of teaching is awesome but prepare for us ms sql live class

[@Intellipaat]

@Shaik Neeshma Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@SharifD-PaletteAnArtdsb]

Explanation with an examples is very useful. Thanks for the video.🙂

[@Intellipaat]

Glad it was helpful. Keep learning with Intellipaat. :)

[@vasu4ug]

i liked ur presentation

[@narendrass7260]

Very well explained ....thank you so much

[@Intellipaat]

Glad it was helpful!

[@PrashantMeti.Official]

Sir Pls Make Video On Error Clear Series...Facing Primary Constrain Error while inserting values Into table.

[@Intellipaat]

Sure, will forward the topic to the respective team and will upload the video soon. Please subscribe to Intellipaat channel & press the bell icon so that you don't miss that video from us.

[@bharaths3324]

This video is enough to know about MS-SQL. This is crisp and clear. Thank you guys for your efforts.

[@Intellipaat]

Our pleasure! @Bharath S Do like, share & subscribe to our channel to get updates on upcoming videos.

[@bharaths3324]

@@Intellipaat it is already done. Good works are always appreciated.

[@nikunjramchandani134]

The teacher is good in this video i like it if you are new to sql just use w3school and this video

[@Intellipaat]

@nikunj ramchandani Thanks for watching😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@NexGenSlayer]

Going to watch this video this weekend! Scrolling through your other videos and I'm so glad to have come across your ad! Your videos selection is extensive and all seems to be up to date. Love the commitment and your care for your students!

[@Intellipaat]

Thank you so much man. Keep learning & upgrading your skills with us. :)

[@mayanksinghchauhan6409]

You are great sir ji

[@Intellipaat]

Welcome. :) Keep learning with Intellipaat. :)

[@chiradeepsen]

Very effective

[@Intellipaat]

Thanks. Keep learning with Intellipaat. :)

[@palithapushpakumara4623]

Excellent explanation Si. The way you explained everything is great. I watched the whole video. Thank you very much.

[@Intellipaat]

Glad you liked it. Keep learning with Intellipaat😊

[@divyapundhir3410]

Such a very helpful with very polite language thanks to you very much

[@Intellipaat]

Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@SriramChandu007]

Very useful For beginners

[@Intellipaat]

Glad to hear that 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@hasanoudaHASAN]

Perfect. Thank you

[@brihaspatimanitrivedi4595]

It was so at the point and helped in refreshing all my concepts, thanks alot, a request if we can get one or more videos on complete course for java plz

[@saisandhyadinchetty7141]

Hi sir Is this single tutorial enough to get complete knowledge on SQL Plz respond sir I want to mention it under my technical skills in resume

[@krsameer1]

goodjob brother.........................................................................

[@Intellipaat]

@Kumar Sameer Most welcome 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@suman9371]

ur explanations r very clear. thank u sir.

[@Intellipaat]

Glad it was helpful. Keep learning with Intellipaat. :)

[@Happymoon789]

Well done in details, , explained in easy way to understand how & what. Thank you so much Professor.

[@Intellipaat]

@Julie Jiang You are very welcome! Do like, share & subscribe to our channel to get updates on upcoming videos.

[@Ajaykumar-bx1dq]

Thank you so much make a great video for everyone it is great session sir

[@Intellipaat]

Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@afroz4802]

Very clean explaination ..keepit up👌

[@Intellipaat]

@afroz4802 Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@prachitsht582]

The videos really simplifies SQL for me!! Is there a possibility to get the notes or the content of the video? 👍

[@Intellipaat]

@Prachit Shete Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.

[@ANJALIKUMARI-pu7kd]

A great initiation indeed. Kudos to your team for such great efforts.

[@Intellipaat]

Thanks Anjali. :)

[@maheshbilla5048]

Simply awesome👍👏😊

[@Intellipaat]

@mahesh billa Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@sujithkumarjack]

Excellent explanation Sir. Well Done! Feels like attending a live class. Amazing..!!

[@Intellipaat]

Thank you for watching. :)

[@mdshadulhaya746]

Fine best skilled result oriented best COMPUTER DATABASE PRACTICAL TUTORIALS.

[@Intellipaat]

Thanks. Stay tuned to Intellipaat channel. :)

[@venkateshsingamsetty5155]

Thank you so much Good people good thoughts Keep growing #Intellipaat

[@Intellipaat]

Thanks for the kind words. Keep learning & upgrading your skills with Intellipaat. :)

[@aananthiganesan3462]

I have gone through many videos but later I felt i don't understand when they touch topics nevertheless this one is so helpful for understanding and the way they given syntax details were good to go .

[@Intellipaat]

Glad it was helpful! @Aananthi Ganesan Do like & share our channel to get updates on upcoming videos.

[@Linkario86]

Your Tutorial is awesome man. I got the ideas of the concept better and learned more about MSSQL in these Hours than in the Entire Semester. It's really really good. I Subbed for sure, cause I feel I can learn more from you and please, please keep up your good work!

[@Intellipaat]

Hi, glad you liked it. Keep learning from Intellipaat. Please share share videos among your friends so that they get benefitted too.

[@Linkario86]

@@Intellipaat I forwarded it to my class

[@kumar1992dev]

Best tutorial video.

[@Intellipaat]

@Suraj Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@rangareddy9465]

Hi Sir, it's very help full and great, my question is i am working on Power is it sufficient for first 2 hours

[@Intellipaat]

Hi Ranga, please watch here: kzbin.info/www/bejne/lavMoKKaoKmNarc

[@surbhiaadivlogs]

Thanku so much for giving us wonderful knowledge in such easy way thanku so much for sql

[@Intellipaat]

Thanks . Glad it was helpful Surbhi. Keep learning & upgrading your skills with us.

[@pankajlohar2527]

Your explanation strategy is very good kindly make a video on .net MVC and Python

[@Intellipaat]

Hi Pankaj, thanks for your comment. Here's the link for Python: kzbin.info/www/bejne/pnuWeoOIps53aK8 .net MVC tutorial will be uploaded very soon. Stay tuned!

[@immanuel2677]

Thank you so much for making it free for all.. Subscribed right away

[@Intellipaat]

Thanks for the sub!

[@harshaguduri8119]

Simple and very helpful 😊😊

[@Intellipaat]

Glad it was helpful. Keep learning with Intellipaat. :)

[@venpro8705]

Do a video on DATA STRUCTURES PLZ....

[@Intellipaat]

Sure . Noted. Will upload soon. :)

[@shalinivijayravikumar9713]

hi sir your explanation is wow....can i prepare this topic alone for ms sql job.....guide me sir so that i prepare well.thanks in advance.

[@Intellipaat]

If you wish to get Personal support Kindly call our course advisors on IND: [phone] US: 1-800-216-8930 (Toll-Free).

[@Nky_Alfred]

Thanks for uploading, I have a problem connecting sql server, it telling me my instance parameters is wrong,and I'm confused what to input into the login and even the password, I thought it was same I created when I was installing the sql developer. I need help

[@Intellipaat]

@Nky Alfred For personal support you can reach out to our course advisors on IND : [phone] US : 1-800-216-8930 (Toll Free).

[@disha1741]

nice explanation with example........it seems like best brush up course.....Thank you so much

[@Intellipaat]

Thanks Disha. Glad it was helpful. :)

[@shravankumarerra7936]

Pls make a full class on MS SQL server DBA .....plsssss

[@Intellipaat]

Sure, will work on it.

[@geetikabansal2196]

Thankyou very much Sir!!!!!

[@Intellipaat]

Welcome. Keep Learning with Intellipaat. :)

[@pkrg9977]

Really useful for beginners(especially non computer science ),great explanation.. can u guys make course on HTML,CSS,JAVASCRIPT and UNIX..for NON CS background students thank you

[@Intellipaat]

Sure . Noted. Will upload soon. :)

[@syednoumanullahshah4227]

Sir your teaching method is very amazing, it helps us alot in mastering sql server, can you please make a detail video on "SECURING SQL SERVER". Like logins, server roles, database roles, granting and revoking permissions, etc. Will be waiting for your kind response. Thanks in Advance Regards: Syed Noumanullah from Pakistan

[@Intellipaat]

Sure Syed, we will work on this topic and upload it soon, Stay tuned to Intellipaat😊

[@syednoumanullahshah4227]

@@Intellipaat I will stay tuned, also hitted the 🔔 as disperately waiting for the video. Thanks again.. Stay always happy and blessed.

[@sundarrajan8306]

Brother I am working in mnc. I got mssql stream in my training and also I am going get only mssql related projects. Mssql is worthy or not? I need a clarity

[@kbagkar]

Excellent explanation. The way you explained everything is great. I watched the whole video. Thank you very much.

[@Intellipaat]

Most Welcome @ketan Bagkar Keep Learning : )

[@rahulsrivastava1048]

Im relatively new to the channel & Watched Only 2 Videos (this nd the Complete Devops one) nd i must admit you guys are providing some seriois quality content :) Please keep the good work up :)