SQL Training | SQL Tutorial | Intellipaat
HTML-код
- Опубликовано: 2 июн 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😅😅😅
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.
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.
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
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.
Apne bahut acha bataya . School mei to kuch samajh hi nahi ata . Thanku somuch
Glad it was helpful. Keep learning with Intellipaat. :)
श्रीमान जी नमस्कार
मेरे ख्याल से आपने बहुत अच्छा प्रयास किया है डाटाबेस को समझाने का। पर अगर आप इस महत्वपूर्ण टॉपिक को थोड़ा साथ साथ हिन्द में समझाए तो बहुत अच्छे से समझ आए। धन्यवाद्।
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. :)
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
Best SQL course available on RUclips
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
One stop shop for SQL. Great step by step explanation!
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. :)
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...
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?
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
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.😊
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.
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.
Absolutely amazing vedio
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Thanks for the efforts, it helped me with running queries.
This video is far better than others available in utube.
Hi Rohit, thanks for your valuable feedback.
Thanks IntelliPaat. It was a awesome session on SQL. Crisp and Clear Explanation.
Thank you for watching. :)
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.
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.
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 :)
many thanks, your video is great when it comes to explainations and you showed usage as well. That`s cool)
Greetings from Ukraine
Very nicely explained...Thnk you
Welcome. Stay tuned to Intellipaat to keep learning. :)
Thank you so much, i am preparing for an interview and this tutorial has been helpful, God bless you.
Glad it was helpful!
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.
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.😊
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. :)
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. :)
1:56:28 case statement
2:23:10 MS SQL server
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.
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. :)
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.
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.
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. :)
Bharani Sir's voice feels so crisp and vibrant! A typical tutor's voice ❤️🔥
😃
A great initiation indeed. Kudos to your team for such great efforts.
Thanks Anjali. :)
Thanking in sanjubaba style:
Tum bahut mast sikhata hai🙌🤝
Hahahaaha thanks. :)
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.
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.
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. :)
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…
Very helpful for class 11,12 computer science students. With practical
Great. Keep learning with Intellipaat. :)
you've explained everything exceptionally well.... THANKYOU SIR
Glad you liked it. Keep learning with Intellipaat. :)
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.
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😊
sir, your teaching is absolutely amazing...I can understand every concept clearly that you are teaching.....I felt like you were right in front of me teaching to me only......Making this video really requires a lot of hard work by you and your team. Your teaching is like a river water flowing constantly and clearly without any obstacles and bugs........I request you to follow this holy work of teaching to continue further.......Now I can feel the real power of technology in front of me and I could realize what is technology exactly........Thank you so much sir........This Thanks is really very tiny in front of your teaching........Excellent keep it up......... I have a question that is why there are other videos also in intellipat regarding SQL FULL COURSE??????? I have seen the video of 3hours 8 minutes.......Do I have to see other videos of SQL FULL COURSE of 5hours and 6 hours as well????
Glad we could help!
Nice and easy to learn... Thanks to the man behind this video who is explaining this...✌️
Thanks a lot. Keep learning with Intellipaat.:)
Excellent video..Thank you..my SQL knowledge is refresh again..
Great to hear! 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. :)
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
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😊
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.
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.
Sir ur video and way of teaching is awesome but prepare for us ms sql live class
@Shaik Neeshma 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.
fantastic vedeo of Sql not just for beginners but also for the experienced. thanks a Lott.
Thanks. Stay tuned to Intellipaat to keep learning. :)
The best SQL course ❤️
Glad it was helpful! 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. :)
I have a doubt on 1:26:13 , could you mention the reference table of e_Age which is used to update e_age
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.:)
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.
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. :)
For beginner's this the best source, thank you very much, but i guess u missed NF stuff kindly help me with this.
Excellent explanation. The way you explained everything is great. I watched the whole video. Thank you very much.
Most Welcome @ketan Bagkar Keep Learning : )
It is a awesome video, very helpfull. THANKYOU SO MUCH
Welcome. :)
Very useful For beginners
Glad to hear that 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Explanation with an examples is very useful. Thanks for the video.🙂
Glad it was helpful. Keep learning with Intellipaat. :)
Hi Sir
Doubt on Substring
On the the second parameter where in the index value from where the substring start you have given the count as 9 .. it's bit confusing shouldn't it be 6
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 .
Glad it was helpful! @Aananthi Ganesan Do like & share our channel to get updates on upcoming videos.
Hi...I saw this video fully..can u provide for practicing sql which covers all topics...thanks in advance..
Pls make a full class on MS SQL server DBA .....plsssss
Sure, will work on it.
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.
Sir..Plese upload video about normalization n keys
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.
Love this video. Learning without less confusion.
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Sir plz make a video on java. And java frameworks spring and hibernate. Teacher for java are not good. Sir you plz make a video on java.. Your teaching technique is outstanding sir.
HI Saurav, please click on the following link for the complete java video tutorial. :)
Link: ruclips.net/video/8_JxMy4Gm04/видео.html
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
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
Good job sir
Thanks, Keep Learning with Intellipaat. :)
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
Very well explained ....thank you so much
Glad it was helpful!
Thank You Sir for all your efforts,
Welcome. :)
Very clean explaination ..keepit up👌
@afroz4802 Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
In the string function example like ltrim , upper, lower
Can we print our statement without using semicolon ; ?
Thank you so much for making it free for all.. Subscribed right away
Thanks for the sub!
Best tutorial video.
@Suraj Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Great video! Very clear and concise.
Hi Ben, glad you liked it. Share the video among your connections so that they get benefitted too.
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: ruclips.net/video/pJ3IPRqiD2M/видео.html
.net MVC tutorial will be uploaded very soon. Stay tuned!
goodjob brother.........................................................................
@Kumar Sameer Most welcome 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Thank u sooo much, v helpful video