SQL Course | SQL Tutorial For Beginners | Learn SQL | Intellipaat
HTML-код
- Опубликовано: 5 авг 2024
- 👉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 sales@intellipaat.com, or call us at: +91- 7847955955
Website: intellipaat.com/microsoft-sql...
Facebook: / intellipaato. .
LinkedIn: / intellipaat
Twitter: / intellipaat
Telegram: t.me/s/Learn_with_Intellipaat
Instagram: / 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.
Can you please do MS SQL DBA tutorial...
Sure . Noted. Will upload soon. :)
Ethical Hacking
Please make a tutorial on competetive coding
Phython
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 :)
No one dislike.. please check first
@@romychaudhary3410 Dislikes are not visible after RUclips is updated. Subham sarin posted that comment two years ago, at that time dislikes are visible.
About😊😊aa😊
@@SomnathLondheh hi
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..
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!
Glad it helped!
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. :)
Sure. Noted. Will upload soon. :)
Muskan Soni nothing is difficult just we have to think like it's easy and it helps us to release pressure from us
Before watching this video, I stumbled upon many other company videos but this is indeed the best among all. Great work Intellipaat team 👍
Glad you liked it!
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.👍👍
Glad it was helpful!
i find it Very easy to learn sql. Best course on youtube ever.
thank you all Intellipaat team for this video. i loved a lots, the content inside. thanks for the great video.
Fabulous explanation 🔥🔥
I have brush up all the command in 5 hours
Pls make such type of video on ds algo
by far, this is the best video on SQL. Great Job!!
Glad you liked it. Keep learning with Intellipaat. :)
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.
Thanks for your feedback Shivam, we will look after that issue. Keep learning with 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.🙂
After 3:41:20 the video is very much useful in preparation for interview. Thank you very much for the video.
Glad it was helpful!
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.
Glad to hear that
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🙏
Glad to hear that! Keep learning with Intellipaat😊
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.😊
Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.
Did you make any notes yourself !!
This is really good lecture!! Lecturer voice sounds good!!
Thank you for watching. :)
This is an informative course... Can you please create a architecture video for sybase, postgres and DB2.
I like this teacher.
Teacher like word pretty much😂
Thank you for watching. :)
Pretty much is 100 time
I highly requested you make stock control tutorial video from product table, customer table and suppliers in Microsoft Access.
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
One of the best SQL explanations on RUclips. I've learnt so much. Thank you!
Great to hear! @Dawn Huttoe. Do like, share & subscribe to our channel to get updates on upcoming videos.
Excellent experience Sir perfectly explained ,even a fresher can become an expert
Thank you Harish. Please subscribe to our channel for more such content
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.
Thanks for the feedback.
@@Intellipaat pls consider Android user also 😂#pc user
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
@surendra bhupathi Glad you liked it. Do like, share & subscribe to our channel to get updates on upcoming videos.
This is the best video on SQL. Great Job!!
Glad you think so!
SQL starts at 10:17
Thx
Thank you for save my 10 mins
Thank you so much sir. It really helped me a lot.
Glad it was helpful. Keep learning with Intellipaat. :)
I started today learning SQL #intellipaat
Thanks for the free and useful Tutorial on SQL!
Welcome. Keep learning with Intellipaat 😊
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
Thank you for watching. :)
Totally worth it 👌👌👌 and also loved the way you guys maintain the description it really helps thanks for the content !!!
Glad you liked it. Keep learning with Intellipaat. :)
@@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
Nice explanation from scratch for beginners Thank u🙂, and please do a video on manual testing.
Sure Arun kumar. Please do subscribe to Intellipaat and press the bell icon so that you will not miss that video from us😊
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
Sure! We'll work on it. Meanwhile, Do like, share & subscribe to our channel to get updates on upcoming videos.
You did an amazing delivery, i am glad i came across this tutorial, would highly recommend!
Thanks Wanda, Keep learning with Intellipaat😊
thank u so much u r better than many teacher very neat and clear explanations
Thank you for watching. :)
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.
Thank you Alexis, Please do subscribe to Intellipaat and Stay updated😊
Very Good.... for new learner's
excellent training and explained step by step with example, really super, Good Work
Thank you very much! @siva kumar Do like, share & subscribe to our channel to get updates on upcoming videos.
One of the best tutorial on SQl i hv come across. Superb job and got clarity about how to use. Thank you so much💐💐
@Kiran Lingadalli Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.
Excellent video! All explained in layman terms, thank you so much @intellepaat
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
It was a great course. Well organized and explained.
@irfan daud Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Wt ab the next level of SQL....looking for a video which explains in depth.
Thanks a lot sir god bless u
Awesome video for Beginners, learned so much from this, Thankyou.
Great to hear! Don't forget to subscribe to our channel.
Hiii
Thank you so much.. really very helpful vedio..👍
Glad it was helpful. Keep learning with Intellipaat. :)
Great job, it's very helpful. thanks a lot bro 😀😊
Glad it was helpful! Keep learning with Intellipaat😊
Amazing explanation..
Thankyou for your educational support for learning SQL 😀🙏 Much needed👍
Happy to help!
Hiiiii
Great explanation
Thank you @intellipaat... you people are doing a fabulous job
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
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...
will this particular course would be enough for placements and beginers?
more than enough
Great explanation this is enough for sql learners..
yes it is enough to know the basics.
Only basics.. Then where is advance
very helpful, informative.. like it, thank you so much.
Glad it was helpful!
Please upload videos on Django, REST API, web crawling over Python
Hi Antim, please watch here: ruclips.net/video/wVNixBpvUOs/видео.html
video's pretty much good.
Superb explanation
Sir, ur video is so informative and I'm so thankful to u sir
It's my pleasure @B19EC187L Yogeshwari Chilukamari Do like, share & subscribe to our channel to get updates on upcoming videos.😊
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_';
This course is enough for Business Analyst Internship. As I am switching my field to BA. Technically, I am not from CS background
It is best video i found for mysql thnkuuuuu sirr☺️☺️♥️♥️♥️♥️♥️
So nice of you @dazel Do like, share & subscribe to our channel to get updates on upcoming videos.😊
Collection of data and the mustered data stored in that place is called database
Very excellent course thank you intellipat
You are welcome!
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.....
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;
No, you need to mention from which table you are extracting the column.
Very useful, energetic voice 👍 Thank you 🥳
You’re welcome 😊 @snehal vaidya Do like, share & subscribe to our channel to get updates on upcoming videos.
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 ❤
Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.
Hello, Are the Tables of MERGE statements gone wrong or is it my interpretation wrong? Can anyone please clarify it
This information is very useful...♥️♥️♥️
Glad to hear that! Keep learning with Intellipaat😊
Thanks a lot, I really learnt a lot🙂
Glad it was helpful!. @Shadow Do like, share & subscribe to our channel to get updates on upcoming videos.😊
Thank you so much it was very helpful 🙂
Glad it helped!
It is really helpful thank u so much sir
🙏
Glad it was helpful. Please stay tuned to Intellipaat😊
thank you so much for such a great stuff. please provide the notes of all the content
Will upload soon @Shahdab Shaikh Do like, share & subscribe to our channel to get updates on upcoming videos
Thanku sirr very helpful 😀😀😀
Welcome
Thank you - this was very helpful.
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Sir I'm working as SQL developer(fresher) I'm very much interested doing certification in sql through online. Please inform me process of certification and provide if any link is available 😊☺️
I like this channel so much
Thank you :)
Great program
This is nice tutorial
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...!!!!!!
Sure . Noted. Will upload soon. :)
hello .,
after we use truncate statement the entire table is deleted except structure , what to do if we want to get the same data back of that particular table
Sir String functions are not working in oracle sql, is there anyway or any other syntax for string?
I have been facing problem with syntax error.
One line of code working now, but after writing few lines, once it shows syntax error, the whole code is getting error sign after deleting one after another. Even the first line worked before then shows syntax error and highlighted.
How can I solve the problem?
You are my fav you tube channel
Thank you for watching our videos.🙂
A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control. How to fix.
I am using MySQL in Ubuntu os and the same update command I have given it doesn't work it giving error as ERROR 1064(42000)
Hi good tutorial. I want to know about class,objects, function. Help me out
Great job Man 👍
Thank you for watching. :)
create database salman;
create table employee(
e_id int not null,
e_name varchar(20)
e_salary int,
e_age int,
e_gender varchar(20),
e_department varchar(20),
primary key(e_id)
);
having error in e-salary line?what should i do?
could you please do a video about sap hana
Good , helpful......#pretty much sir👍👍🤣
Thank you for watching. :)
Sir i am not able to see the Result section in the left of message...please let me know how tp generate it..
2:20:00 why the result is so confusing the tables should be vise versa thank you
Thank you
Thank you for watching. :)
This video is very helpful!
Glad it was helpful!
Great video!!!, Can you make videos on azure data bricks please..
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.
Is there any updates and syntax changes from one database to another while frequent updates
Is inner join and intersect statement same?