SQL Training | SQL Tutorial | Intellipaat
Вставка
- Опубліковано 12 чер 2024
- 👉In this SQL training video you will learn end to end about ms sql developer & server. This SQL tutorial is all you need to get started with this technology.
🔥Intellipaat SQL course: intellipaat.com/microsoft-sql...
#SQLTraining #SQLTutorialforBeginners #SQLTutorial
📝Following topics are covered in this SQL Tutorial video:
0:00 - sql training
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
📌 Do subscribe to Intellipaat channel & get regular updates on videos: bit.ly/Intellipaat
📕 Read complete SQL Server tutorial here: bit.ly/2F9oqCL
📔 Get SQL Server cheat sheet here: bit.ly/2KljiiP
📰 Interested to learn SQL still more? Please check similar SQL blogs here:- goo.gl/d3a6H2
Are you looking for something more? Enroll in our MS SQL Server course and become a certified SQL professional (intellipaat.com/microsoft-sql.... It is a 16 hrs training where you can learn SQL through instructor led training provided by Intellipaat which is completely aligned with industry standards and certification bodies.
If you’ve enjoyed this SQL for beginners, Like us and Subscribe to our channel for more similar informative SQL course tutorials.
Got any questions about SQL training? Ask us in the comment section below.
----------------------------
Intellipaat Edge
1. 24*7 Life time Access & Support
2. Flexible Class Schedule
3. Job Assistance
4. Mentors with +14 yrs
5. Industry Oriented Course ware
6. Life time free Course Upgrade
------------------------------
Why should you watch this SQL tutorial for beginners video?
The SQL is one of the most important programming languages for working on large sets of databases. Thanks to the Big Data explosion today the amount of data that enterprises have to deal with is humongous. We are offering the top SQL tutorial that can be watched by anybody to learn SQL. Our SQL tutorial has been created with extensive inputs from the industry so that you can learn SQL easily.
Who should watch this SQL tutorial?
If you want to learn structured query language to become fully proficient and expert in managing the database solutions, managing various operations on databases, migrating it to the cloud and scale on demand then this Intellipaat explanation on SQL is for you. This Intellipaat SQL beginners tutorial is your first step to learn SQL. Since this SQL video can be taken by anybody, so if you are a Software developers and IT professionals, SQL and database administrators, Project Managers, Business Analysts and Managers, Business Intelligence professionals, Big data and Hadoop professionals or someone aspiring for a career in SQL development then you can also watch this SQL tutorial to take your skills to the next level.
Why should you opt for a SQL career?
SQL optimization has always been a popular topic in database management. SQL Database optimization can be an extremely difficult task, in particular for large-scale data wherever a minute variation can result or impact drastically on the performance. So learning this skill will definitely help you grab the best jobs in top MNCs after finishing Intellipaat SQL online training. The entire Intellipaat SQL course is in line with the industry needs.There is a huge demand for SQL certified professional. The salaries for SQL professional are very good. Hence this Intellipaat SQL database tutorial for beginners is your stepping stone to a successful career!
------------------------------
For more Information:
Please write us to sales@intellipaat.com, or call us at: +91- 7847955955
Website: intellipaat.com/microsoft-sql...
Facebook: / intellipaatonline
LinkedIn: / intellipaat
Twitter: / 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.🙂
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😅😅😅
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. :)
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
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. :)
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. :)
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.
One stop shop for SQL. Great step by step explanation!
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.
Thanks IntelliPaat. It was a awesome session on SQL. Crisp and Clear Explanation.
Thank you for watching. :)
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.
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.
Thanks for the efforts, it helped me with running queries.
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. :)
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😊
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.😊
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
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.
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. :)
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
Excellent explanation Sir. Well Done! Feels like attending a live class. Amazing..!!
Thank you for watching. :)
Thank you so much, i am preparing for an interview and this tutorial has been helpful, God bless you.
Glad it was helpful!
Bharani Sir's voice feels so crisp and vibrant! A typical tutor's voice ❤️🔥
😃
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.
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.
Nice and easy to learn... Thanks to the man behind this video who is explaining this...✌️
Thanks a lot. Keep learning with Intellipaat.:)
This video is far better than others available in utube.
Hi Rohit, thanks for your valuable feedback.
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.
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.
many thanks, your video is great when it comes to explainations and you showed usage as well. That`s cool)
Greetings from Ukraine
Very helpful for class 11,12 computer science students. With practical
Great. Keep learning 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.
Love this video. Learning without less confusion.
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
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😊
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.
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
Sure . Noted. Will upload soon. :)
It is a awesome video, very helpfull. THANKYOU SO MUCH
Welcome. :)
Explanation with an examples is very useful. Thanks for the video.🙂
Glad it was helpful. Keep learning with Intellipaat. :)
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.
Hi i listen this up to stored procedure this was very useful to me thanks a lot bro
Hi Dharan, cool, finish soon and start practicing to master sql. :)
Absolutely amazing vedio
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Awesome !!! Thanks For the Valuable Video, Which gives lot of detailed things for perfect understanding of SQL
Glad you liked it. Keep learning with Intellipaat. :)
Best SQL course available on UA-cam
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
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. :)
Thank You Sir for all your efforts,
Welcome. :)
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 :)
Excellent video..Thank you..my SQL knowledge is refresh again..
Great to hear! Keep learning with Intellipaat😊
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...
Very nicely explained...Thnk you
Welcome. Stay tuned to Intellipaat to keep learning. :)
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. :)
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.
Perfect. Thank you
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.
Excellent ........thank you sir
Glad you liked it Poloju. Keep learning with Intellipaat. :)
Sir, please make a video comprising complete guidance for XML(from Excel) & TDL creation on our own for export purpose
Sure . Noted. Will upload soon. :)
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.
Thank you so much for making it free for all.. Subscribed right away
Thanks for the sub!
ur explanations r very clear.
thank u sir.
Glad it was helpful. 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😊
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.
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.
Hi Intellipaat Team, U guys are really awesome.. Just love the way u ppl explain. My sincere request is i want one full course video on Mainframe Cobol as well..as it will be helpful for ppl lyk me who work in that stream
Sure . Noted. Will upload soon. :)
Very straight forward......Amazing stuff.
Thanks. Stay tuned to Intellipaat to keep learning. :)
Apne bahut acha bataya . School mei to kuch samajh hi nahi ata . Thanku somuch
Glad it was helpful. Keep learning with Intellipaat. :)
fantastic vedeo of Sql not just for beginners but also for the experienced. thanks a Lott.
Thanks. Stay tuned to Intellipaat to keep learning. :)
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.
wow great teaching i love it
Hi Jagadeesh, thanks for your comments. Keep learning & upgrading your skills with Intellipaat. Please subscribe to Intellipaat channel & press the bell icon so that you don't miss any videos from us.
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.
Excellent explanation. The way you explained everything is great. I watched the whole video. Thank you very much.
Most Welcome @ketan Bagkar Keep Learning : )
1:56:28 case statement
2:23:10 MS SQL server
Your explanation strategy is very good kindly make a video on .net MVC and Python
Hi Pankaj, thanks for your comment. Here's the link for Python: ua-cam.com/video/pJ3IPRqiD2M/v-deo.html
.net MVC tutorial will be uploaded very soon. Stay tuned!
Thank you very much! I have subscribed for your channel....
Thanks. Keep learning & upgrading your skills 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.
Hatsoff to share your knowledge thank you very much with clear audio n video.. .
Glad you liked it. Keep learning with Intellipaat. :)
your video is very helpful
Glad it was helpful. Keep learning & upgrading your skills with Intellipaat. :)
i liked ur presentation
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
Sure Syed, we will work on this topic and upload it soon, Stay tuned to Intellipaat😊
@@Intellipaat I will stay tuned, also hitted the 🔔 as disperately waiting for the video. Thanks again.. Stay always happy and blessed.
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
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.😊
Very well explained ....thank you so much
Glad it was helpful!
Nicest way of explaining
Glad you liked it Chand. Keep learning with Intellipaat. :)
Thank u sooo much, v helpful video
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!
Hi, glad you liked it. Keep learning from Intellipaat. Please share share videos among your friends so that they get benefitted too.
@@Intellipaat I forwarded it to my class
Simple and very helpful
😊😊
Glad it was helpful. Keep learning with Intellipaat. :)
Hii sir...it's very helpful...thank u so much ...can u please upload complete manual testing process with project?
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.
Thanks sir for shairing a good vedio 😊😊
Glad it was helpful. Keep learning with Intellipaat. :)
Thanking in sanjubaba style:
Tum bahut mast sikhata hai🙌🤝
Hahahaaha thanks. :)
Thank you somuch...feels like in a interesting class...
Glad to hear that
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, that was very helpful
Glad it was helpful!
श्रीमान जी नमस्कार
मेरे ख्याल से आपने बहुत अच्छा प्रयास किया है डाटाबेस को समझाने का। पर अगर आप इस महत्वपूर्ण टॉपिक को थोड़ा साथ साथ हिन्द में समझाए तो बहुत अच्छे से समझ आए। धन्यवाद्।
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
Thank you so much
Good people good thoughts
Keep growing #Intellipaat
Thanks for the kind words. Keep learning & upgrading your skills with Intellipaat. :)
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…
Great video - thanx!!
Glad it helped!
VERY USEFUL. THANKS FOR THE VIDEO
You are welcome
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.
Really clear and useful!! 5 Stars!!!!!!
Glad it was helpful!