SQL Course | SQL Tutorial For Beginners | Learn SQL | Intellipaat

👉This SQL course video is an SQL tutorial for beginners where you will learn SQL end to end. This SQL tutorial is all you need to get started with this technology.
🔥 Intellipaat SQL course: intellipaat.com/microsoft-sql...
#SQLCourse #SQLTutorialforBeginners #LearnSQL #SQL #StructuredQueryLanguage
📝Following topics are covered in this SQL Tutorial video:
00:00 - SQL full course
01:13 - What is Data?
02:22 - What is Database?
04:15 - Why need a Database?
08:20 - Database Management System(DBMS)
10:19 - Introduction to SQL
11:40 - Relational Databases
14:17 - Sample SQL Query
16:20 - SQL vs NoSQL
18:00 - Applications of SQL
21:00 - Basics of SQL
21:28 - SQL Tables: Fields
21:58 - SQL Tables: Records
23:18 - SQL Tables: Datatypes
25:50 - CRUD Operations
26:42 - What can SQL do?
28:10 - CRUD Operation Demo
38:00 - Installation of SQL Server
45:32 - Data Types in SQL
46:10 - Different Data Types in SQL
51:30 - Create Table Syntax
54:16 - Insert Query Syntax
57:55 - Select Statement Syntax
01:00:53 - Select Distinct Syntax
01:02:20 - Where Clause in SQL
01:05:10 - Operators in SQL
01:17:37 - Functions in SQL
01:26:00 - Order By and Top Clause in SQL
01:29:40 - Group By Clause in SQL
01:33:13 - Having Clause in SQL
01:36:04 - Update Statement in SQL
01:39:24 - Delete Statement in SQL
01:41:18 - Truncate Statement in SQL
01:42:22 - Joins in SQL
02:02:43 - Union Operator in SQL
02:05:27 - Except Operator in SQL
02:07:10 - Intersect Operator
02:09:05 - Views in SQL
02:11:45 - Alter Table in SQL
02:14:32 - Merge Statement in SQL
02:20:10 - User Defined Functions in SQL
02:26:40 - Temporary Table in SQL
02:29:30 - Case Statement in SQL
02:34:23 - IIF Function in SQL
02:38:04 - Stored Procedure in SQL
02:43:16 - Exceptional Handling
02:43:25 - Try/Catch Blocks in SQL
02:47:45 - Transactions in SQL
02:52:38 - Database Administrator
02:52:50 - Roles of Database Administrator
02:54:22 - Types of DBA
02:56:12 - Intro to MS SQL Servers
03:02:24 - SQL Server Sysytem Databases
03:04:08 - Quiz
03:04:40 - Backup & Restore of Database
03:05:18 - Restoring "AdventureWoks" Database through GUI
03:07:25 - Recovery Models
03:18:54 - Quiz
03:19:17 - Dynamic Management Views
03:20:04 - Catagories of DMV's
03:24:30 - Activity Monitor
03:25:00 - Starting Activity Monitor
03:27:25 - System Monitor/Performance Monitor
03:30:20 - Working with SQL Server Profiler
03:32:02 - Quiz
03:32:36 - Data Integrity
03:32:52 - Categories of Data Integrity in SQL
03:33:45 - Index in SQL
03:34:15 - Types of Indexes in SQL
03:37:07 - Fragmentation in SQL
03:39:15 - Rebuilding in SSMS
03:40:43 - Quiz
03:40:56 - SQL Job Trend
03:41:20 - SQL Interview Questions
📌 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 full course, 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 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 [e-mail], or call us at: [phone]
Website: intellipaat.com/microsoft-sql...
Facebook: / intellipaato. .
LinkedIn: / intellipaat
Twitter: / intellipaat
Telegram: t.me/s/Learn_with_Intellipaat
Instagram: / intellipaat

[@Intellipaat]

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.

[@Boss-vt5fv]

Can you please do MS SQL DBA tutorial...

[@Intellipaat]

Sure . Noted. Will upload soon. :)

[@KaytanArya]

Ethical Hacking

[@AnmolKumar-ci7qz]

Please make a tutorial on competetive coding

[@alokkumarshah6401]

Phython

[@Intellipaat]

👋 Guys everyday we upload 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.🙂

[@gladyskiruga5801]

This is the BEST Video ever! After several struggles with SQL This video made everything so clear. THANK YOU SO MUCH, Intellipaat is SUCH A BLESSING!

[@Intellipaat]

Glad it helped!

[@muskansoni1265]

Hey guys, you're doing great job by helping us to understand these difficult courses easily. Please upload an advanced SQL tutorial video as well. It would be much helpful. :)

[@Intellipaat]

Sure. Noted. Will upload soon. :)

[@mdarif-uo8kh]

Muskan Soni nothing is difficult just we have to think like it's easy and it helps us to release pressure from us

[@shubhamsarin2263]

How can people dislike this video? We are getting to learn so much for free, rather we should be grateful. Also, lot of effort goes behind in editing. My lock-down is not so bad with Intellipat :)

[@romychaudhary3410]

No one dislike.. please check first

[@shankarchaitanyacreations4174]

@@romychaudhary3410 Dislikes are not visible after KZbin is updated. Subham sarin posted that comment two years ago, at that time dislikes are visible.

[@SomnathLondhe]

About😊😊aa😊

[@bulbulfans7011]

​@@SomnathLondheh hi

[@hemalatha-pk2hh]

Hi.. I'm learning sql from your videos.. Its pretty much understandable n excellent acsent.. I hve watched many videos of intellipaat.. Why don't you guys upload a video of creating project completely and videos of mockinterview.. Becoz it should be a complete package to become sql developer..

[@Shanky_Fitness007]

Before watching this video, I stumbled upon many other company videos but this is indeed the best among all. Great work Intellipaat team 👍

[@Intellipaat]

Glad you liked it!

[@shivamkamdi6822]

Thank you so much IntelliPaat for such great lecture. 💕 But, i also request you that, please take bigger font size so that text are visible in 360/480p quality too.

[@Intellipaat]

Thanks for your feedback Shivam, we will look after that issue. Keep learning with Intellipaat :)

[@manishav9675]

Thank you intellipaat team. This course was really informative and helped me to attend and perform well in SQL interview.pls continue to do more videos.👍👍

[@Intellipaat]

Glad it was helpful!

[@kritikarya3204]

thank you all Intellipaat team for this video. i loved a lots, the content inside. thanks for the great video.

[@dawit7956]

by far, this is the best video on SQL. Great Job!!

[@Intellipaat]

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

[@piyushjohari8615]

Fabulous explanation 🔥🔥 I have brush up all the command in 5 hours Pls make such type of video on ds algo

[@navyarangu6916]

This is really good lecture!! Lecturer voice sounds good!!

[@Intellipaat]

Thank you for watching. :)

[@SanjayParwesh]

Really an awesome teaching...i don't know anything about this SQL, but after watching this Video, its made me very easy to get understanding..Thank you Sir🙏

[@Intellipaat]

Glad to hear that! Keep learning with Intellipaat😊

[@leolwin8976]

I have watched 1hr and 26minutes. This video is really helpful to me. The explanation is very simple and clear. Everyone from beginner state can easily understand. Thanks a lot.

[@Intellipaat]

Glad to hear that

[@zakriabacha2477]

i find it Very easy to learn sql. Best course on youtube ever.

[@95nikhil]

After 3:41:20 the video is very much useful in preparation for interview. Thank you very much for the video.

[@Intellipaat]

Glad it was helpful!

[@girlwithamess2533]

Its one of the BEST TUTORIALS on SQL.. I was so concerned for myself cause it's very important topic but you helped me alot and I'm looking forward to watch more videos of your channel.🌟 . . I guess you should make PDF notes of the exact same thing you taught and provide the link in the description box. It'll be really helpful.😊

[@Intellipaat]

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

[@adyashasatpathy4436]

Did you make any notes yourself !!

[@qweqwerty3694]

This is an informative course... Can you please create a architecture video for sybase, postgres and DB2.

[@AbdurRahim-ot5gp]

I highly requested you make stock control tutorial video from product table, customer table and suppliers in Microsoft Access.

[@yogendramaarisetty]

Recommended course for beginner. Suggestion: Zoom in the code editor for bigger font cuz while learners implementing the queries it would be easy for them to watch it without full screen mode.

[@Intellipaat]

Thanks for the feedback.

[@rahulkatare802]

@@Intellipaat pls consider Android user also 😂#pc user

[@dawnhuttoe7204]

One of the best SQL explanations on KZbin. I've learnt so much. Thank you!

[@Intellipaat]

Great to hear! @Dawn Huttoe. Do like, share & subscribe to our channel to get updates on upcoming videos.

[@haseenamansoory2644]

I like this teacher. Teacher like word pretty much😂

[@Intellipaat]

Thank you for watching. :)

[@dj...9062]

Pretty much is 100 time

[@krishnasurvase9325]

Totally worth it 👌👌👌 and also loved the way you guys maintain the description it really helps thanks for the content !!!

[@Intellipaat]

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

[@krishnasurvase9325]

@@Intellipaat for sure I'm gonna subscribe and add more about database like difference of all the sql DB's and features advantages and so on

[@surendrabhupathi549]

Thank you so much with free of cost you guys are providing almost SQL,. Explanation was awesome, good effort,guys once again thank you.....so much

[@Intellipaat]

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

[@harislee6200]

Excellent experience Sir perfectly explained ,even a fresher can become an expert

[@Intellipaat]

Thank you Harish. Please subscribe to our channel for more such content

[@shabnambegum5742]

Thank you so much sir. It really helped me a lot.

[@Intellipaat]

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

[@vennilavasudevan5039]

Sir can u prepare entire course of java. There are very less exposure to topics like strings, functions, arrays in Java. It will be nice if you give equal importance such complicated topics

[@tracyanele653]

You did an amazing delivery, i am glad i came across this tutorial, would highly recommend!

[@Intellipaat]

Thanks Wanda, Keep learning with Intellipaat😊

[@arunkumarn8396]

Nice explanation from scratch for beginners Thank u🙂, and please do a video on manual testing.

[@Intellipaat]

Sure Arun kumar. Please do subscribe to Intellipaat and press the bell icon so that you will not miss that video from us😊

[@nagavenkat9864]

It was a good tutorial. I would be happy to learn RPA for Blue Prism & Automation Anywhere courses. I have already checked out the UIPath. Thanks

[@Intellipaat]

Thank you for watching. :)

[@manikanta-zy8vd]

This is the best video on SQL. Great Job!!

[@Intellipaat]

Glad you think so!

[@maheshbabu-te8sk]

thank u so much u r better than many teacher very neat and clear explanations

[@Intellipaat]

Thank you for watching. :)

[@thecodingmentor7701]

Thanks for the free and useful Tutorial on SQL!

[@Intellipaat]

Welcome. Keep learning with Intellipaat 😊

[@bollanagasaiteja6185]

I started today learning SQL #intellipaat

[@MrBenny218]

Very Good.... for new learner's

[@sivakumar-bw4hf]

excellent training and explained step by step with example, really super, Good Work

[@Intellipaat]

Thank you very much! @siva kumar Do like, share & subscribe to our channel to get updates on upcoming videos.

[@ProudIndies]

Excellent video! All explained in layman terms, thank you so much @intellepaat

[@Intellipaat]

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

[@kiranlingadalli6921]

One of the best tutorial on SQl i hv come across. Superb job and got clarity about how to use. Thank you so much💐💐

[@Intellipaat]

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

[@alexisarcegomez8698]

Another awesome video, thank you very much for this excellent content, the only thing that i would like to know is, where can i find or download the database that you are using?, it would be helpful. Greeting from Mexico.

[@Intellipaat]

Thank you Alexis, Please do subscribe to Intellipaat and Stay updated😊

[@antimghosh7208]

Please upload videos on Django, REST API, web crawling over Python

[@Intellipaat]

Hi Antim, please watch here: kzbin.info/www/bejne/rYexmqt4pduIhdU

[@ridhikapoor1610]

Awesome video for Beginners, learned so much from this, Thankyou.

[@Intellipaat]

Great to hear! Don't forget to subscribe to our channel.

[@avulasasi143s]

Hiii

[@rnikumbh3042]

Thank you so much.. really very helpful vedio..👍

[@Intellipaat]

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

[@srivennila9574]

Thankyou for your educational support for learning SQL 😀🙏 Much needed👍

[@Intellipaat]

Happy to help!

[@avulasasi143s]

Hiiiii

[@deepakshukla2527]

Thank you @intellipaat... you people are doing a fabulous job

[@Intellipaat]

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

[@Ashokmerfey]

SQL starts at 10:17

[@taniajamwal9762]

Thx

[@Unkno7668]

Thank you for save my 10 mins

[@vishnuvamshi4645]

Fallen in love with intellipaat... And useful suggestion:- make use of some complex examples for the commands instead of simple one everyone are making use of same examples Eg:- for substring fn take example of email address and show the eg

[@Intellipaat]

Sure! We'll work on it. Meanwhile, Do like, share & subscribe to our channel to get updates on upcoming videos.

[@nitinkeshri5155]

Thanks a lot sir god bless u

[@mukeshwarreddy5355]

Wt ab the next level of SQL....looking for a video which explains in depth.

[@reshmabahadur7564]

Great job, it's very helpful. thanks a lot bro 😀😊

[@Intellipaat]

Glad it was helpful! Keep learning with Intellipaat😊

[@TheGamingBrawler8945]

Collection of data and the mustered data stored in that place is called database

[@anbazhaganrajan1280]

Amazing explanation..

[@irfandaud7380]

It was a great course. Well organized and explained.

[@Intellipaat]

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

[@yuvrajkhatri2789]

very helpful, informative.. like it, thank you so much.

[@Intellipaat]

Glad it was helpful!

[@sridhardeekonda7868]

Great explanation this is enough for sql learners..

[@Intellipaat]

yes it is enough to know the basics.

[@santa007ize]

Only basics.. Then where is advance

[@BECLYogeshwariChilukamari]

Sir, ur video is so informative and I'm so thankful to u sir

[@Intellipaat]

It's my pleasure @B19EC187L Yogeshwari Chilukamari Do like, share & subscribe to our channel to get updates on upcoming videos.😊

[@munishgoswami2789]

video's pretty much good.

[@rajipoka7372]

Superb explanation

[@snehalvaidya5843]

Very useful, energetic voice 👍 Thank you 🥳

[@Intellipaat]

You’re welcome 😊 @snehal vaidya Do like, share & subscribe to our channel to get updates on upcoming videos.

[@shahdabshaikh9976]

thank you so much for such a great stuff. please provide the notes of all the content

[@Intellipaat]

Will upload soon @Shahdab Shaikh Do like, share & subscribe to our channel to get updates on upcoming videos

[@babitasrivastava6684]

Thanku so much sir in school its really so exhausting to ask it from my computer teacher, she don't really tells the answer also she usually makes a drama of the student who ask things . Thanks again for helping ❤

[@Intellipaat]

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

[@Dazelsea]

It is best video i found for mysql thnkuuuuu sirr☺️☺️♥️♥️♥️♥️♥️

[@Intellipaat]

So nice of you @dazel Do like, share & subscribe to our channel to get updates on upcoming videos.😊

[@sampathkumar5699]

Very excellent course thank you intellipat

[@Intellipaat]

You are welcome!

[@apoorvajyoti8066]

will this particular course would be enough for placements and beginers?

[@Intellipaat]

more than enough

[@phanidattareddyyh1886]

Could you please make a video about how to learn Cyber Security in a step by step process, and how to land on a job...!!!!!!

[@Intellipaat]

Sure . Noted. Will upload soon. :)

[@munikumarreddy]

This information is very useful...♥️♥️♥️

[@Intellipaat]

Glad to hear that! Keep learning with Intellipaat😊

[@harishv3821]

Thank you so much it was very helpful 🙂

[@Intellipaat]

Glad it helped!

[@shauryab897]

Thanku sirr very helpful 😀😀😀

[@Intellipaat]

Welcome

[@vaishnavimalik3018]

It is really helpful thank u so much sir 🙏

[@Intellipaat]

Glad it was helpful. Please stay tuned to Intellipaat😊

[@Shadow-fw9qc]

Thanks a lot, I really learnt a lot🙂

[@Intellipaat]

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

[@sunilsaikumar7030]

If anyone using PostgreSQL And getting error at 1:14:26 u need to typecast integer. The Commad will be select * from employee where e_age::text like '3_';

[@ramahanuman8271]

Database is collection of data which supports supports storage and manipulation of data in a easy way

[@Intellipaat]

Okay😊

[@sameerb.v.k5121]

Great job Man 👍

[@Intellipaat]

Thank you for watching. :)

[@Katlaw219]

Thank you - this was very helpful.

[@Intellipaat]

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

[@sreshththakkar7357]

Sir , plzzz....... can we get a video's on python it will also help to all cbse students of class 12 because this is in syllabus.....

[@shubhangiagrawal336]

This is nice tutorial

[@golamohit6762]

This course is enough for Business Analyst Internship. As I am switching my field to BA. Technically, I am not from CS background

[@khoanguyen-yn1bi]

I like this channel so much

[@Intellipaat]

Thank you :)

[@arifshaik8405]

Great video!!!, Can you make videos on azure data bricks please..

[@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.

[@PriyaYadav-sg1vm]

Good , helpful......#pretty much sir👍👍🤣

[@Intellipaat]

Thank you for watching. :)

[@amarsharma466]

This video is very helpful!

[@Intellipaat]

Glad it was helpful!

[@ziyan.pati9]

Sir at 1:49:28, Can we write it as: Select e_name, e_dept, d_name, d_location from employee Left join department ON employee.e_dept= department.d_name;

[@Intellipaat]

No, you need to mention from which table you are extracting the column.

[@carandcycling2102]

Great program

[@chaitanyaykuntam8556]

could you please do a video about sap hana

[@we_conduct]

Loved it)

[@Intellipaat]

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

[@powerofjudge3082]

Thank u and love u dude for helping so much

[@Intellipaat]

Welcome, Keep learning with Intellipaat😊

[@powerofjudge3082]

@@Intellipaat sir ur data anylsist 6 hour program is enough for applying as data anylsist in any company after learning of ur Ms SQL, python and Excel or I need study more sir please suggest I m in very trouble

[@khushbukushwah4991]

Thank you

[@Intellipaat]

Thank you for watching. :)

[@ganeshbhalerao6324]

Superbly discribed

[@Intellipaat]

Thanks a lot @Ganesh Bhalerao. Do like, share & subscribe to our channel to get updates on upcoming videos.

[@madhavi007kapu9]

Hi sir,Best video for SQL.can u please explain about sap ABAP also

[@Intellipaat]

Thank you!

[@sandeepd7893]

Sir,how you create two tables in a single database while solving INNER JOIN problem(01:42:22 - Joins in SQL)...Can you please explain this in a proper way...

[@DanielNelson320]

Great explanation

[@Intellipaat]

Glad you liked it! Keep learning with Intellipaat😊

[@bhagwagapyar]

This is the best lecture 👌 🙌 👏

[@Intellipaat]

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

[@bhagwagapyar]

@@Intellipaat already

[@udayptp]

You are my fav you tube channel

[@Intellipaat]

Thank you for watching our videos.🙂

[@krishnaraovasudevan8520]

Hi good tutorial. I want to know about class,objects, function. Help me out

[@pankajmishra2087]

Sir please make video to shorting( as name) data from visual basic and show to excel file

[@Intellipaat]

Sure. Noted. Will upload soon. :)

[@aaminvahora771]

Thxsir helping me

[@Intellipaat]

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

[@latishsaai9757]

sir pls make a video on cybersafety and cybercrime

[@nomorelove2me]

Good leaning.. pretty much good.... ,😜

[@Intellipaat]

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

[@NeerajSharma-cb4hq]

This is very helpful vedio sir ji

[@Intellipaat]

Thanks and welcome

[@talkingoutloudtol4465]

First of all thnks for this valuable video, if you could plz confirm if digits and chars can be used in a table

[@Intellipaat]

Welcome😊