👋 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.🙂
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
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.
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.
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
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.
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.
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
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.
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';
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 💐
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
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
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
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!
👋 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.🙂
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 ?
Sir Android studio par bhi video bana do.. in deep
l.
Can't able to see these small words
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
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
Is creating custom type exists ?
Can u pls provide cursor tutorial
Intellipaat doing awesome work for us☺
It’s good to get certification in SQL certification for better career and more calls from HR
Try practice certification exams in Vullam website 🥳
Index😅😅😅
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.
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.
Glad you liked it. Keep learning with Intellipaat. :)
Hello !
I have a doubt. do you need to know programming for learning SQL??
md saif ali it’s not required to know programming language for SQL
Guys, what else do you want to learn from Intellipaat? Comment down below and let us know so we can create more such tutorials for you.:)
Thanks for SQL tutorial.
Please post Blue prism beginner and SAP beginner tutorials?
Thanks for this videos... Design patterns with real time application
First thanks for these osm video...
Pls make video related to computer networking
Web internet technologies tutorials followed by standard textbook syllabus wise
Hi Afreed, here's sap beginners tutorial: bit.ly/2wXYndg
Blue prism we will upload in a week. Stay tuned.:)
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 .
Glad you liked it. Keep learning with Intellipaat. :)
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.
Well said! Thanks.
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
Thank you for watching.
Totally agree! Its so easy to learn and interesting. Thank you intellipatt
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.
Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.
Best SQL course available on TH-cam
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
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
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.
Please upload I have interview...
One stop shop for SQL. Great step by step explanation!
This video is far better than others available in utube.
Hi Rohit, thanks for your valuable feedback.
This is the best course in youtube!! You have managed to cover it all. Great job done!!
Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.
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.
Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.
Thankyou sir. Your lecture video is very easy to learn all the basics of SQL query. It couldn't be more effective and clear.
Glad it was helpful. Keep learning & upgrading your skills with Intellipaat. :)
Why it couldn't more effective n clear?
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
Glad it was helpful! keep learning.
Man I've been looking for a deeper insight into TSQL Thank You I'm a DBA in the UK.
Hi Balvinder, thanks for your comments. Also share videos among your connections so that they get benefitted too.
@@Intellipaat Thanks Parji you ever in London give me a shout I've lived here all my life.
1:56:28 case statement
2:23:10 MS SQL server
The first ever video for 3 hours not wasted even single second. Thank you so much. S this enough for learning complete SQL?
Glad it was helpful! Keep learning with Intellipaat😊
Top! One of the best tutorial ever. I really enjoyed watching this tutorial.
Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.
Great work!!! this is first time i'd ever watch a complete tutorial in you tube.
Thanks a lot for this information...
Glad it was helpful. Keep learning & upgrading your skills with Intellipaat. :)
Really very well explained in simple terms. Thank You very much for this video..
You are most welcome @Vibe Tribe with Supriya
well organised & arranged . starting from the scratch including showing the downloading of set up files. Great work!
Glad you liked it Ashish. Keep learning with Intellipaat. :)
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.
@A M Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.
Your voice is so clear . Thanks for the session.
Glad you liked it 😊 @Mr. Satwik Do like, share & subscribe to our channel to get updates on upcoming videos.
Excellent video..Thank you..my SQL knowledge is refresh again..
Great to hear! Keep learning with Intellipaat😊
Thank you so much, i am preparing for an interview and this tutorial has been helpful, God bless you.
Glad it was helpful!
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
Glad it was helpful! @piyush bisht Do like, share & subscribe to our channel to get updates on upcoming videos.😊
The best SQL course ❤️
Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.
your voice is clear and explanation is too good....learnt a lot from your channel... thank you so much :)
@Priya R Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Good one. Best SQL sessions that I have seen. Watched completely. Keep it up 👍
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
fantastic vedeo of Sql not just for beginners but also for the experienced. thanks a Lott.
Thanks. Stay tuned to Intellipaat to keep learning. :)
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';
Nope it will increase +10 age in analytics…
Thanks IntelliPaat. It was a awesome session on SQL. Crisp and Clear Explanation.
Thank you for watching. :)
Zabardast video sahb maza aa gya tommarrow is my practical of it class 12 student
Thanks and welcome @PW IANS pathshala Do like, share & subscribe to our channel to get updates on upcoming videos.😊
This video is enough to know about MS-SQL. This is crisp and clear.
Thank you guys for your efforts.
Our pleasure! @Bharath S Do like, share & subscribe to our channel to get updates on upcoming videos.
@@Intellipaat it is already done.
Good works are always appreciated.
Absolutely amazing vedio
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
simple,lucid and easy to follow. Thank You👍
@Pradeep Kumar Most welcome 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
I found it very useful......and i have an exam on sql in 2 days
Thank you
Glad it was helpful. Keep learning with Intellipaat. :)
Very helpful for class 11,12 computer science students. With practical
Great. Keep learning with Intellipaat. :)
I have my practical exam tomorrow and the video helped me very much thanks for making it.. 😊😊
Glad it was helpful. Keep learning with Intellipaat. :)
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 💐
@THRINADH GUNDARAPU Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.
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
Glad it helped! @Afonso Osorio.
sir this video is really nice covered every concept very clearly thanku so much sir...
@Pallavi Gupta Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Bharani Sir's voice feels so crisp and vibrant! A typical tutor's voice ❤️🔥
😃
Apne bahut acha bataya . School mei to kuch samajh hi nahi ata . Thanku somuch
Glad it was helpful. Keep learning with Intellipaat. :)
Nice and easy to learn... Thanks to the man behind this video who is explaining this...✌️
Thanks a lot. Keep learning with Intellipaat.:)
Simply awesome👍👏😊
@mahesh billa Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Perfect. Thank you
Very clean explaination ..keepit up👌
@afroz4802 Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
ur explanations r very clear.
thank u sir.
Glad it was helpful. Keep learning with Intellipaat. :)
Very useful For beginners
Glad to hear that 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Best tutorial video.
@Suraj Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Great work.i learned the concepts clearly. I spent almost a month to learn SQL but i was not clear in concepts. Keep doing
How much time it need to learn.offline course duration??
@@suresh8204 I took 7hrs for installing n doing the examples along with video
Any need of previous knowledge to learn sql????
@@suresh8204 no need. They will teach u from scratch
@@suresh8204 it depends on u suresh
Hatsoff to share your knowledge thank you very much with clear audio n video.. .
Glad you liked it. Keep learning with Intellipaat. :)
Simple and very helpful
😊😊
Glad it was helpful. Keep learning with Intellipaat. :)
Superb explanation bro......👌👌👌
Thanks. keep learning with intellipaat
Glad it was helpful. Keep learning with Intellipaat. :)
Fine best skilled result oriented best COMPUTER DATABASE PRACTICAL TUTORIALS.
Thanks. Stay tuned to Intellipaat channel. :)
Excellent explanation Si. The way you explained everything is great. I watched the whole video. Thank you very much.
Glad you liked it. Keep learning with Intellipaat😊
Well done in details, , explained in easy way to understand how & what. Thank you so much Professor.
@Julie Jiang You are very welcome! Do like, share & subscribe to our channel to get updates on upcoming videos.
i liked ur presentation
Very nicely explained 👍
Thank you 🙂
You are great sir ji
Welcome. :) Keep learning with Intellipaat. :)
Thank you so much for making it free for all.. Subscribed right away
Thanks for the sub!
Thank You Sir for all your efforts,
Welcome. :)
Great Job
Thanking in sanjubaba style:
Tum bahut mast sikhata hai🙌🤝
Hahahaaha thanks. :)
Excellent explanation Sir. Well Done! Feels like attending a live class. Amazing..!!
Thank you for watching. :)
Thanks sir for shairing a good vedio 😊😊
Glad it was helpful. Keep learning with Intellipaat. :)
you've explained everything exceptionally well.... THANKYOU SIR
Glad you liked it. Keep learning with Intellipaat. :)
A great initiation indeed. Kudos to your team for such great efforts.
Thanks Anjali. :)
Explanation with an examples is very useful. Thanks for the video.🙂
Glad it was helpful. Keep learning with Intellipaat. :)
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
Noted. @HARATHI TANKALA Do like, share & subscribe to our channel to get updates on upcoming videos.😊
@@Intellipaat sure
Thank you so much make a great video for everyone it is great session sir
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Thanku so much for giving us wonderful knowledge in such easy way thanku so much for sql
Thanks . Glad it was helpful Surbhi. Keep learning & upgrading your skills with us.
No one can explain like this 👍👍👍
Thank you so much😀 Keep learning with Intellipaat
Good job sir
Thanks, Keep Learning with Intellipaat. :)
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 ,
Thank you. Stay tuned to Intellipaat for more updates😊
VERY USEFUL. THANKS FOR THE VIDEO
You are welcome
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
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
The teacher is good in this video i like it if you are new to sql just use w3school and this video
@nikunj ramchandani Thanks for watching😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
goodjob brother.........................................................................
@Kumar Sameer Most welcome 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
It is a awesome video, very helpfull. THANKYOU SO MUCH
Welcome. :)
its awesome ......... explaining is too good
Thank you so much 😀
Thanks for liking @sivaji kanathala Do like, share & subscribe to our channel to get updates on upcoming videos
Thank you so much
Good people good thoughts
Keep growing #Intellipaat
Thanks for the kind words. Keep learning & upgrading your skills with Intellipaat. :)
Great video! Very clear and concise.
Hi Ben, glad you liked it. Share the video among your connections so that they get benefitted too.
Excellent explanation. The way you explained everything is great. I watched the whole video. Thank you very much.
Most Welcome @ketan Bagkar Keep Learning : )
nice explanation with example........it seems like best brush up course.....Thank you so much
Thanks Disha. Glad it was helpful. :)
Really clear and useful!! 5 Stars!!!!!!
Glad it was helpful!
Nicest way of explaining
Glad you liked it Chand. Keep learning with Intellipaat. :)
Very good teacher. Great learning experience.
Thank you! 😃 @Tarun Kumar
Thankyou very much Sir!!!!!
Welcome. Keep Learning with Intellipaat. :)
Such a very helpful with very polite language thanks to you very much
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Very straight forward......Amazing stuff.
Thanks. Stay tuned to Intellipaat to keep learning. :)
Hey bharani.. Superb bro
Thanks. Stay tuned to Intellipaat channel to keep learning & upgrading your skills . :)
That was a awsm explanation.
Thanks
Most welcome@Riya sharma
Thanks 😊🙏
Welcome 😊
Thank you sir 🙏
@Kirti Soni Most welcome 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
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!
Thank you so much man. Keep learning & upgrading your skills with us. :)