Register and get free Certificate for the course: glacad.me/3DX1rWU 🔹 Topics Covered: 00:00:00 - Agenda 00:01:18 - Introduction to DBMS & SQL 00:03:55 - Types of Data Models 00:09:09 - ER Diagram 00:09:39 - What is DBMS 00:14:17 - Introduction to RDBMS 00:16:14 - Features of RDBMS 00:18:30 - RDBMS vs Traditional Approach 00:19:10 - Normalization Subsets of Normalization 00:22:28 - Functional Dependency 00:25:42 - Types of Functional Dependency 00:27:55 - First Normal Form 1NF 00:30:20 - Second Normal Form 2NF 00:33:14 - Third ormal form 3NF 00:34:44 - What is SQL? 00:36:06 - Why SQL? 00:36:54 - SQL Terms 00:37:48 - SQL Data Types 00:39:38 - SQL Constraints 00:42:50 - SQL Command Groups 00:43:06 - DDL 00:55:39 - DML 01:05:42 - DCL 01:05:45 - TCL 01:09:53 - SQL Operators 01:35:38 - SQL Functions 01:51:12 - SQL Joins 02:30:15 - Lab Session
My family is not financially strong. Fee courses for advanced computer languages are therefore not affordable. In this case your TH-cam videos are a blessing. Please upload more such courses here. And a big thanks for explaining in hindi
I am getting an error you have an error in your SQL syntax check the manual that corresponds to your Mysql server version - like this error is showing while creating the table do you know bro how to resolve it?
Are bhaiya bhut bhut dhyanwaad, apne bharat mai sab angrez bne pde h... Are bhaiya insaan sabse best learning apni bhasha mai hi seekh paata h aache se
1:1:00 we don't need to enter the column name again and again once we create a table we can only use INSERT INTO Employees VALUE ( value, value , value );
At 1:35:08 - Group by clause, you have entered first name, max salary,dept from table group by dept. 1. For SALES we have JIMMY with max salary but the command returns JENNIFER. 2. For TECH we have MATT with max salary but the command returns CHARLIE. Please check and let me know the correct command.
Hey, thanks for pointing it out. Yes, it is giving out the first names for each department instead of giving the names corresponding to the salary. You can just remove 'first_name' from the clause and get max salary from each department.
It is very useful content for everyone beginners. I have tried before multiple time learn SQL but didn't get but I saw your concept . it is very helpful. Thank you so much sir you are providing free leaning for everyone.
Sir,Thankyou so much for this vedio.I am an IT professional and I am watching this in my training phase.This proved very helpful to me.I m not a person who engage much with comments and channels but this one is so superb that you earned my Like ,Comment and Subscribe as well.
Your videos are Awesome Sir. Just a note that there is one error at "1:35:09" ,This SQL query is wrong as When using the GROUP BY clause in an SQL query, any non-aggregated columns in the SELECT clause must be included in the GROUP BY clause. So in this we cannot use non-aggregate column (first_name) with SELECT clause. and same error at 1:38:35 in HAVING clause as well.
It was a great learning experience for me. Prior time to this video, I had no idea what is SQL except for the abbreviation. But now I can confidently say, I have little more knowledge than just abbreviations. Thanks to the tutor I really appreciate Great Learning to post this content on youtube.
We are glad you found our video helpful. If you want to also do assessments and projects along with learning the course please visit and enroll for the free course on our website here: glacad.me/FreeCourses_1000Hours If you complete the courses and the assessments here you will also get a certificate of completion.
Sir, I would like to thank you alot... as I m fresh in the Mysql language ... by watching your SQL tutorial ... i learned alot... i will work more in this .. please give some more information on DCL and TCL. and also request u to make some video on result making and printing from visual studio by taking data from Excel or MySQl.
Thanks a lot. We are glad you found our video helpful. Your request has been noted. We are working on creating a lot more content for learners like you. Meanwhile, do not forget to subscribe to our channel so that you get notified whenever we upload a new tutorial.
Government Shiksha ko free nhi kr rhi h but great TH-camr h jo free me content de rhe h study k liye , I hope Studdy/Shiksha Sabko mil payegi... with Acuracy and Quality , isse hmare Country Rapidly Progress krega.. Waise Ghenhu Chawal(Anaaj) free h UP me but ye Sawal paida nhi krti h jabki Shiksha Sawaal paida krti h learner k mind me gov se ask krne k liye.
Your way of understanding is excellent. Every problem was slowed down, now I think I will find my destination easily… Thank you very much... You are fabulous.!!! Once again thank you GREAT LEARNING
I'm from commerce background at first I was very scared that how can I learn SQL from basic to intermediate but THANKYOU GREAT LEARNING for helping me to learn SQL From basic to intermedate. Thankyou.
Sir.... we never met but still I respect you from my heart....Your video is such a valuable content and very knowledgeable.. I did not know about a single word in SQL but I have seen after giving 3 hours of my life that because of this one video Now I write queries and also clear my basics of SQL.... Thankyou Sir once again. Keep shining.
00:05 Learn SQL for data management. 02:31 Importance of a database in managing company data 07:24 Understanding relational data and graph base model in SQL 09:55 Database management system is essential for storing, managing, and retrieving data. 14:39 Relational data stored in tables with rows and columns 17:08 Understanding the importance of employee IDs for uniqueness in tables. 21:31 Understanding data modification and normalization in SQL 23:51 Understanding functional dependencies in SQL. 28:26 Normalization of data in SQL 30:40 Understanding partial dependency and decomposing tables 35:05 Introduction to SQL and its importance in database management 37:15 Introduction to RDBMS and Database Management Systems 41:51 Primary keys ensure uniqueness and identification in SQL databases. 44:01 Creating a table and altering the structure using SQL commands. 48:28 Creating and describing a table in SQL 50:38 Explaining the process of modifying and renaming columns in SQL. 56:16 SQL allows manipulation of data using commands like INSERT, UPDATE, and DELETE. 58:30 SQL basics for beginners in Hindi 1:04:29 Understanding and using delete commands in SQL 1:06:55 Understanding privileges and data control in SQL 1:11:24 Using logical operators to filter data in SQL. 1:13:57 Using SQL operators and conditions for data extraction. 1:18:57 Using comparison operators in SQL 1:21:31 Comparison operators and special operators in SQL 1:27:18 Understanding SQL numerical operations and functions 1:30:05 Using group by clause to group and update data in SQL. 1:35:09 Understanding GROUP BY clause in SQL 1:37:30 SQL query syntax for filtering and ordering data 1:42:12 Creating a table and using union operator in SQL 1:44:32 Creating and managing tables and records in SQL 1:50:54 Explanation of inner join in SQL 1:53:06 SQL join types and their usage 1:57:39 Creating and managing departments and their operations using SQL 2:00:34 How to perform extras in SQL queries 2:05:33 Illustrating SQL commands and joins 2:08:13 Understanding SQL table creation and data import 2:12:27 Using select and union operators in SQL with subquery 2:14:52 How to write queries for selecting specific data in SQL 2:20:12 Select players from match one with common player id in sms2 2:22:48 Select and from cricket players. Use like operator to extract names. 2:27:57 Using SQL commands to make changes in the database. 2:30:37 Creating tables and defining columns in SQL databases 2:35:00 The tutorial covers inserting data into tables and selecting data from tables 2:37:28 Exploring arm joint and database management 2:43:37 Modifying and manipulating tables and data in SQL 2:46:17 Creating and managing tables in SQL 2:52:51 Updating time in SQL for different time zones 2:56:34 SQL select statements and limits introduction
Just Finished This Tutorial on SQL and Databases.What an Amazing and Well Structured content it is!. literally i Become a big fan of your Voice and Teaching Skills .hats of you sir ji and proud on you .thanks for saving my a lot time.
thank you, sir...this was really helpful..I am a beginner in coding and starting with SQL and this video helped me a lot :). sir I have a doubt,, what is the difference between MySQL and SQL
SQL stands for Structured Query Language, it is a language used to modify or create databases. MySql is a Database Management System(DBMS), it is a software that is used to manage databases.
You’re welcome, we're glad we could help you😇 To answer your question, MySQL is a relational database management system, whereas SQL is a query language used to maintain data in databases.
I'm watching this video on daily basis and it relates very much with the informatica! This videos is very easy and convenient for comprehension so love this video.
Sir your way of teaching is speechless it is soo awesome and your content is too informative. Sir also upload videos on Software design and architecture for beginners
Hi, thank you for your kind words. Your all support motivates us a lot to deliver such informative content. And, yes we will work on your suggestion. Do subscribe to get yourself updated for our upcoming videos. Thank you.
Really Sir you taught very well. Best freely available video on this 🌍 for the beginners looking to start learning SQL. Sir can u pls make a Advanced Complete SQL tutorial as well.. That will be really grt for us.😊
SQL is abbreviated as Standard Query Language. SQL is a Query language that lets you store, access, and update data in the database, and it also helps create a new database and implement functions. Knowledge of SQL is a step toward becoming a software developer.
Thank you so much Great learning Team You really Highly motivated with your easy approachable on subject... hopefully I will be a Data Analyst by giving my hard time on it... one more could you please provide any classes I want to learn more... from you U R Fab!!!🤩👍
Hi, we are glad that you liked this video. Your support motivates us to deliver such informative videos. And, yes we do provide classes in the form of live sessions on our TH-cam channel on regular basis, which is also an interactive session where all your doubts will be cleared. Do subscribe to check all the details of our upcoming live sessions. Thank you:)
I am getting an error you have an error in your SQL syntax check the manual that corresponds to your Mysql server version - like this error is showing while creating the table do you know bro how to resolve it?
This is so amazing .. explained the concepts in simple laymen's terms which were very easy to understand especially for a non-technical person like me.
After watching this video then I realized why it's is called great learning platform because actually it having great learning osm sir 🙏I am very thankful to you that I understand everything about sql after watching this video 🙏🙏
.i am myself in teaching profession.....i like it like anything........now i understood why government is putting focus on learning in learning languages. aap bhut hi sahi samjhate h sir.......
mera bsc IT complte hoga abhi but aapka video bhut accha laga muze concept clear hua 38 minute dekha hu but abji fir se dekhunga me aur notes banaunga thanks for sharing video really than
Hi @Arnav, we are glad to know that you liked our video. On our TH-cam, you will find ample of videos in Hindi, you can check those as well. Moreover, every day we also have live sessions both in Hindi and English, you can check all the details regarding our upcoming sessions on our community posts. Do subscribe and keep supporting, thank you
Hey @keval, We are glad you liked our video. For real time update, subscribe on our TH-cam Channel. Visit our website for more free videos like these: glacad.me/FreeCourses_1000Hours
At 1:35:08 - Group by clause, you have entered first name, max salary,dept from table group by dept. 1. For SALES we have JIMMY with max salary but the command returns JENNIFER. 2. For TECH we have MATT with max salary but the command returns CHARLIE. Please check and let me know the correct command. Is there any error
At 1:35:16 as we can see that in sales department jimmy has highest salary i.e 700000 but at 1:35:20 ,max salary in sales department is of jennifer, why?, according to table it should be jimmy
Learn SQL very easily thank u sir. Really Appreciable please tell me where can I get internship in SQL for experience because I am now fresher please tell me opportunity in SQL
bhai ek do din m interview h mera and you are a life saviour man poora video dekhne m mujhe 5-6 hrs lage but i'm confident in DBMS now and all credits goes to you sir.... bus thodi practice aur and i'm sure interview m fod dunga m... Thanks again Tushar
Hi, we also hope you will like this video, whenever you watch it. Do subscribe and check other videos and we hope you will learn a lot from them as well. Thank you
Joyeeta Chakraborty Joyeeta Chakraborty 4 months ago My family is not financially strong. Fee courses for advanced computer languages are therefore not affordable. In this case your TH-cam videos are a blessing. Please upload more such courses here. And a big thanks for explaining in hindi 343 Mukku Abhishek Achary Mukku Abhishek Achary 6 months ago It was a great learning experience for me. Prior time to this video, I had no idea what is SQL except for the abbreviation. But now I can confidently say, I have little more knowledge than just abbreviations. Thanks to the tutor I really appreciate Great Learning to post this content on youtube. 23 Amit Sharma Amit Sharma 4 months ago Fantastic Job Sir This 3 hours course is awesome for those students who are preparing for interviews. 21 Aas Mohammad Aas Mohammad 1 year ago Your way of understanding is excellent. Every problem was slowed down, now I think I will find my destination easily… Thank you very much... You are fabulous.!!! Once again thank you GREAT LEARNING 15 Great Learning Akhil Krishna Akhil Krishna 1 year ago Sir,Thankyou so much for this vedio.I am an IT professional and I am watching this in my training phase.This proved very helpful to me.I m not a person who engage much with comments and channels but this one is so superb that you earned my Like ,Comment and Subscribe as well. 11 Amarjit Maity Amarjit Maity 5 months ago Really a great video for beginners in SQL. I am now feeling confidence in further proceeding with SQL in my career. Thank you very much GL .... Ankit khurana Ankit khurana 1 year ago At 1:35:08 - Group by clause, you have entered first name, max salary,dept from table group by dept. 1. For SALES we have JIMMY with max salary but the command returns JENNIFER. 2. For TECH we have MATT with max salary but the command returns CHARLIE. Please check and let me know the correct command. 21 Great Learning sana khan sana khan 5 months ago very informative and great way of clearing DBMS. Professor, why are you not doing this lab in access? we use access in class, so I just wanted to ask the difference. 1 Sudhanshu Dwivedi Sudhanshu Dwivedi 6 months ago Your way of understanding is excellent. Every problem was slowed down, now I think I will find my destination easily… Thank you very much...🙏🙏🙏🙏🙏🙏❤❤❤❤❤❤ You are fabulous.!!! Once again thank you GREAT LEARNING 4 Kishan Jalan Kishan Jalan 2 months ago This is so amazing .. explained the concepts in simple laymen's terms which were very easy to understand especially for a non-technical person like me. KNIGHt Rowdy KNIGHt Rowdy 4 months ago Really Sir you taught very well. Best freely available video on this 🌍 for the beginners looking to start learning SQL. Sir can u pls make a Advanced Complete SQL tutorial as well.. That will be really grt for us.😊 1 Miss Gupta Miss Gupta
Now I know I have not done anything wrong, enrolling for a postgraduate diploma with great learning. People say spending so much money on this is not worth but they are wrong.
Sir, i have a query regarding table. A table having 6 month data of customer sales. And multiple entry in same month. Table have customer name, selling date and month, amount. Now i wanted to make a summary of customer wise and month wise which customer had purchased highest in amount and in frequency.
We're glad that we could help you Ravin. Do subscribe to Great Learning for more such amazing content. Alternatively, you can also check out Great Learning Academy for more such free Courses with certification here: glacad.me/FreeCourses_1000Hours
Hi @shalini, thank you for your appreciation. And, we do have a 6 hours of video on Tableau, which will help you, here is the link to check the video: th-cam.com/video/6mBtTNggkUk/w-d-xo.html. Thank you:)
@Thank you so much team. Currently, I have started Python tutorial that's also well explained. These tutorial helps those people who are interested to make his/her career but due to high fees they kill their dreams but this is the platform where they learn n later earn well. Really Thankful to you and team. 😊👍
Omg, that's so kind of you sir, I am preparing for a software testing interview I wanted to just basic learning but you have learned to be a lot of things, thanks over and over again
![SQL Course for Beginners [Full Course]](http://i.ytimg.com/vi/7S_tz1z_5bA/mqdefault.jpg)
![SQL Course for Beginners [Full Course]](/img/tr.png)
Register and get free Certificate for the course: glacad.me/3DX1rWU
🔹 Topics Covered:
00:00:00 - Agenda
00:01:18 - Introduction to DBMS & SQL
00:03:55 - Types of Data Models
00:09:09 - ER Diagram
00:09:39 - What is DBMS
00:14:17 - Introduction to RDBMS
00:16:14 - Features of RDBMS
00:18:30 - RDBMS vs Traditional Approach
00:19:10 - Normalization Subsets of Normalization
00:22:28 - Functional Dependency
00:25:42 - Types of Functional Dependency
00:27:55 - First Normal Form 1NF
00:30:20 - Second Normal Form 2NF
00:33:14 - Third ormal form 3NF
00:34:44 - What is SQL?
00:36:06 - Why SQL?
00:36:54 - SQL Terms
00:37:48 - SQL Data Types
00:39:38 - SQL Constraints
00:42:50 - SQL Command Groups
00:43:06 - DDL
00:55:39 - DML
01:05:42 - DCL
01:05:45 - TCL
01:09:53 - SQL Operators
01:35:38 - SQL Functions
01:51:12 - SQL Joins
02:30:15 - Lab Session
How can I register for certification
Please help krdo yr koi atleast apni jo probelm face kr rha hu voto koi btaye ke kyu aarahi hain
Thanks for explain
@@Deeksha-The_Initiation online and before join the course you can bargain..
Sir ji ye SQL software kha se milega education version vala
My family is not financially strong. Fee courses for advanced computer languages are therefore not affordable. In this case your TH-cam videos are a blessing. Please upload more such courses here. And a big thanks for explaining in hindi
Hii
Hello joyeeta where are you from...?
This really makes my heart melt, I wish you all the best joyeeta. I’m sure you will make your family proud.
@@double_a_creation75 ...kolkata
@@yahyakhankhokhar1840 ..ook
विश्वास नही होता, sql tutorial हिंदी में, कोई तो है जो हिंदीभाषियों के बारे में भी सोचता है, हृदय से धन्यवाद
I am getting an error you have an error in your SQL syntax check the manual that corresponds to your Mysql server version - like this error is showing while creating the table do you know bro how to resolve it?
I am a Ruby on Rails developer and this course is very helpful for improving my SQL skills and I can easily relate to Rails databases.
🔹 Topics Covered:
00:00:00 - Agenda
00:01:18 - Introduction to DBMS & SQL
00:03:55 - Types of Data Models
00:09:09 - ER Diagram
00:09:39 - What is DBMS
00:14:17 - Introduction to RDBMS
00:16:14 - Features of RDBMS
00:18:30 - RDBMS vs Traditional Approach
00:19:10 - Normalization Subsets of Normalization
00:22:28 - Functional Dependency
00:25:42 - Types of Functional Dependency
00:27:55 - First Normal Form 1NF
00:30:20 - Second Normal Form 2NF
00:33:14 - Third ormal form 3NF
00:34:44 - What is SQL?
00:36:06 - Why SQL?
00:36:54 - SQL Terms
00:37:48 - SQL Data Types
00:39:38 - SQL Constraints
00:42:50 - SQL Command Groups
00:43:06 - DDL
00:55:39 - DML
01:05:42 - DCL
01:05:45 - TCL
01:09:53 - SQL Operators
01:35:38 - SQL Functions
01:51:12 - SQL Joins
02:30:15 - Lab Session
Fantastic Job Sir
This 3 hours course is awesome for those students who are preparing for interviews.
Brother
It is really helpful give ans fast
Are bhaiya bhut bhut dhyanwaad, apne bharat mai sab angrez bne pde h... Are bhaiya insaan sabse best learning apni bhasha mai hi seekh paata h aache se
1:1:00 we don't need to enter the column name again and again once we create a table we can only use INSERT INTO Employees VALUE ( value, value , value );
At 1:35:08 - Group by clause, you have entered first name, max salary,dept from table group by dept.
1. For SALES we have JIMMY with max salary but the command returns JENNIFER.
2. For TECH we have MATT with max salary but the command returns CHARLIE.
Please check and let me know the correct command.
Hey, thanks for pointing it out. Yes, it is giving out the first names for each department instead of giving the names corresponding to the salary. You can just remove 'first_name' from the clause and get max salary from each department.
Yes I am also confused about this
SIr, this is the best video, I came across, Tomorrow I'm having interview....this has boosted my confidence. THANKS A TON, Sir :)
kaisa gya interview ?
It is very useful content for everyone beginners. I have tried before multiple time learn SQL but didn't get but I saw your concept . it is very helpful. Thank you so much sir you are providing free leaning for everyone.
Sir,Thankyou so much for this vedio.I am an IT professional and I am watching this in my training phase.This proved very helpful to me.I m not a person who engage much with comments and channels but this one is so superb that you earned my Like ,Comment and Subscribe as well.
Sir how can I contact with you please reply
Indians are freaking intelligent people. And the way you guys teach is Nobel work for all of us. Thank you, from pakistan.
Your videos are Awesome Sir. Just a note that there is one error at "1:35:09" ,This SQL query is wrong as When using the GROUP BY clause in an SQL query, any non-aggregated columns in the SELECT clause must be included in the GROUP BY clause. So in this we cannot use non-aggregate column (first_name) with SELECT clause. and same error at 1:38:35 in HAVING clause as well.
I was finding the difficulty! Thanks for the comment
same here
sir SQL is very complicated topic that you will make very easy thanks sir
You cleared so much up for me that I was confused about. Thanks a million!.... Plz show us Informatica in hindi too.
It was a great learning experience for me. Prior time to this video, I had no idea what is SQL except for the abbreviation. But now I can confidently say, I have little more knowledge than just abbreviations. Thanks to the tutor I really appreciate Great Learning to post this content on youtube.
Hlo
Web developer ki preparation kre h
@@narayansaini6501 2xy6
I never thought dbms can be this much easy, thankyou sir for your efforts😃
We are glad you found our video helpful. If you want to also do assessments and projects along with learning the course please visit and enroll for the free course on our website here: glacad.me/FreeCourses_1000Hours If you complete the courses and the assessments here you will also get a certificate of completion.
same
@@vikashpandey4220 hiii
Ye btao ye course complete hai ya fir complete padhne k bad bhi beginner hi rhenge ?
Ye course fresher job k liye sufficient hai ?
At 1:02:16, Sir ke employees bohut ache hai, company bobut taraki karegi.
Sir, I would like to thank you alot... as I m fresh in the Mysql language ...
by watching your SQL tutorial ... i learned alot...
i will work more in this ..
please give some more information on DCL and TCL.
and also request u to make some video on
result making and printing from visual studio by taking data from Excel or MySQl.
Thanks a lot. We are glad you found our video helpful. Your request has been noted. We are working on creating a lot more content for learners like you. Meanwhile, do not forget to subscribe to our channel so that you get notified whenever we upload a new tutorial.
Government Shiksha ko free nhi kr rhi h but great TH-camr h jo free me content de rhe h study k liye , I hope Studdy/Shiksha Sabko mil payegi... with Acuracy and Quality , isse hmare Country Rapidly Progress krega.. Waise Ghenhu Chawal(Anaaj) free h UP me but ye Sawal paida nhi krti h jabki Shiksha Sawaal paida krti h learner k mind me gov se ask krne k liye.
Meko sql ka zero knowledge tha aapke video ki wjh se hi mai sql smjh paya aur query likhne lga thnks great learning ❤
Thank you so much. Nobody explained the normalization with this detail before ♥️
You’re welcome, we're glad we could help you😇 Make sure you subscribe to us and hit the bell icon to get notified about our amazing upcoming content.
No .of Subscribers not show utuber capacity, hardwork.... Wonderfull 💯
Your way of understanding is excellent.
Every problem was slowed down, now I think I will find my destination easily…
Thank you very much...
You are fabulous.!!!
Once again thank you GREAT LEARNING
You’re welcome, we're glad we could help you😇 Make sure you subscribe to us and hit the bell icon to get notified about our amazing upcoming content.
Just want to say a ton of thanks for explaining such concepts with simplicity and very understandable approach. 🙏
You made this complex topic so easy. Worthy watching ❤. And you earn a subscriber as well
I'm from commerce background at first I was very scared that how can I learn SQL from basic to intermediate but THANKYOU GREAT LEARNING for helping me to learn SQL From basic to intermedate. Thankyou.
Sir.... we never met but still I respect you from my heart....Your video is such a valuable content and very knowledgeable.. I did not know about a single word in SQL but I have seen after giving 3 hours of my life that because of this one video Now I write queries and also clear my basics of SQL.... Thankyou Sir once again. Keep shining.
00:05 Learn SQL for data management.
02:31 Importance of a database in managing company data
07:24 Understanding relational data and graph base model in SQL
09:55 Database management system is essential for storing, managing, and retrieving data.
14:39 Relational data stored in tables with rows and columns
17:08 Understanding the importance of employee IDs for uniqueness in tables.
21:31 Understanding data modification and normalization in SQL
23:51 Understanding functional dependencies in SQL.
28:26 Normalization of data in SQL
30:40 Understanding partial dependency and decomposing tables
35:05 Introduction to SQL and its importance in database management
37:15 Introduction to RDBMS and Database Management Systems
41:51 Primary keys ensure uniqueness and identification in SQL databases.
44:01 Creating a table and altering the structure using SQL commands.
48:28 Creating and describing a table in SQL
50:38 Explaining the process of modifying and renaming columns in SQL.
56:16 SQL allows manipulation of data using commands like INSERT, UPDATE, and DELETE.
58:30 SQL basics for beginners in Hindi
1:04:29 Understanding and using delete commands in SQL
1:06:55 Understanding privileges and data control in SQL
1:11:24 Using logical operators to filter data in SQL.
1:13:57 Using SQL operators and conditions for data extraction.
1:18:57 Using comparison operators in SQL
1:21:31 Comparison operators and special operators in SQL
1:27:18 Understanding SQL numerical operations and functions
1:30:05 Using group by clause to group and update data in SQL.
1:35:09 Understanding GROUP BY clause in SQL
1:37:30 SQL query syntax for filtering and ordering data
1:42:12 Creating a table and using union operator in SQL
1:44:32 Creating and managing tables and records in SQL
1:50:54 Explanation of inner join in SQL
1:53:06 SQL join types and their usage
1:57:39 Creating and managing departments and their operations using SQL
2:00:34 How to perform extras in SQL queries
2:05:33 Illustrating SQL commands and joins
2:08:13 Understanding SQL table creation and data import
2:12:27 Using select and union operators in SQL with subquery
2:14:52 How to write queries for selecting specific data in SQL
2:20:12 Select players from match one with common player id in sms2
2:22:48 Select and from cricket players. Use like operator to extract names.
2:27:57 Using SQL commands to make changes in the database.
2:30:37 Creating tables and defining columns in SQL databases
2:35:00 The tutorial covers inserting data into tables and selecting data from tables
2:37:28 Exploring arm joint and database management
2:43:37 Modifying and manipulating tables and data in SQL
2:46:17 Creating and managing tables in SQL
2:52:51 Updating time in SQL for different time zones
2:56:34 SQL select statements and limits introduction
Just Finished This Tutorial on SQL and Databases.What an Amazing and Well Structured content it is!. literally i Become a big fan of your Voice and Teaching Skills .hats of you sir ji and proud on you .thanks for saving my a lot time.
Where did you practise this
On which softeare
Excellent teaching 👍 each topic teach perfectly. And easily understanding sir!!!
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Hello sir,
What is the difference between MySQL plus and SQL workbench.
Other people are using only SQL plus
Please answer
Reallyyy very very very helpful video, Thankuu so much great learning......
Glad you liked it. Subscribe to our TH-cam channel for more videos!
@@greatlearning sir it is a full course
Sir is it full sql for data science or we need more ?
Fantastic Job Sir ....
Best Video for Who are preparing for Data Analytics and SQL .... This 3 hour was the best 3 hours of your career
You are totally amazing. You helped me a lot. Tomorrow I am having my viva of dbms... It will be good bcz of you thnks a lot.
You’re welcome, we're glad we could help you😇 Make sure you subscribe to us and hit the bell icon to get notified about our amazing upcoming content.
@@greatlearning sir please tell how to install & configure workbench ?
Thanks sir and God bless to guide all the students who can afford the tution..
Really most helpful video on TH-cam about SQL
Glad you liked it. Subscribe to our TH-cam channel for more videos!
@@greatlearning ok
thank you, sir...this was really helpful..I am a beginner in coding and starting with SQL and this video helped me a lot :).
sir I have a doubt,, what is the difference between MySQL and SQL
SQL stands for Structured Query Language, it is a language used to modify or create databases.
MySql is a Database Management System(DBMS), it is a software that is used to manage databases.
You’re welcome, we're glad we could help you😇 To answer your question, MySQL is a relational database management system, whereas SQL is a query language used to maintain data in databases.
very helpful video sir . Thanks a lot for this video ❤🙏
great video !! theory and practise both are perfectly maintained in this video
Thank you sir. Tomorrow is my interview.
Best of luck Xavier 😜
thank you very much sir cleared everything in 2.5 hours which i have missed to learn in 1 month classes
2.5 hrs nahi 2.9 hrs C
2.97 hrs😂
Yeah! 😂
Tami marathi cho
You’re welcome, we're glad we could help you😇 Make sure you subscribe to us and hit the bell icon to get notified about our amazing upcoming content.
Sir super duper hit explaination🎉🎉one time me hi samaj aa gya🎉🎉
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Can you please tell me which software is using in this video
I'm watching this video on daily basis and it relates very much with the informatica! This videos is very easy and convenient for comprehension so love this video.
Very useful for beginners, i started my SQL journey from this video.
Sir your way of teaching is speechless it is soo awesome and your content is too informative. Sir also upload videos on Software design and architecture for beginners
Hi, thank you for your kind words. Your all support motivates us a lot to deliver such informative content. And, yes we will work on your suggestion. Do subscribe to get yourself updated for our upcoming videos. Thank you.
love this video, you explained everything with so much ease. thank you!
Great Sir , your way of teaching is absolutely tremendous........... Easy to under stand for everyone 💞
Glad to know you liked it!😊 Do check out more of our content, and don't forget to subscribe to our channel!
Thank you so much sir for explaining SQL in hindi
Really Sir you taught very well. Best freely available video on this 🌍 for the beginners looking to start learning SQL. Sir can u pls make a Advanced Complete SQL tutorial as well.. That will be really grt for us.😊
Thanks 😊 great learning
Bhai after this course are you able to solve SQL query questions ?
SQL is abbreviated as Standard Query Language. SQL is a Query language that lets you store, access, and update data in the database, and it also helps create a new database and implement functions. Knowledge of SQL is a step toward becoming a software developer.
Thank you Sir 🙏🙏🙏🙏♥️♥️♥️
Awesome Explained. Thank You!
Glad you liked it. Subscribe to our TH-cam channel for more videos!
Thanks for your vedio
Your video is very helpful for every student
Is this course is available in English also?. If not ,please post in English also. It will be very useful. Thank you great learning
We will be releasing SQL English as well in the coming days, do subscribe the channel so you don't miss out! :)
75% Indian use hindi
Thank you so much Great learning Team You really Highly motivated with your easy approachable on subject... hopefully I will be a Data Analyst by giving my hard time on it... one more could you please provide any classes I want to learn more... from you U R Fab!!!🤩👍
Hi, we are glad that you liked this video. Your support motivates us to deliver such informative videos. And, yes we do provide classes in the form of live sessions on our TH-cam channel on regular basis, which is also an interactive session where all your doubts will be cleared. Do subscribe to check all the details of our upcoming live sessions. Thank you:)
@@greatlearning sure
I am getting an error you have an error in your SQL syntax check the manual that corresponds to your Mysql server version - like this error is showing while creating the table do you know bro how to resolve it?
@@thewonderfulclips7390 select database first
@@thewonderfulclips7390 u can fo like
create database emp;
Use emp ;
create table employees.....
sir you are a great teacher
Anyone can learn anything
If you teach like this 🙏
This is so amazing .. explained the concepts in simple laymen's terms which were very easy to understand especially for a non-technical person like me.
Thanks Sir
Is a Lot of Thanks
Very Very Helpfull SQL
All Clear DBMS nd SQL
You’re welcome, we're glad we could help you😇 Make sure you subscribe to us and hit the bell icon to get notified about our amazing upcoming content.
After watching this video then I realized why it's is called great learning platform because actually it having great learning osm sir 🙏I am very thankful to you that I understand everything about sql after watching this video 🙏🙏
Wow great session.. I am learning this for data analyst.. I learnt this just 3 hours.. Thank u very. Much sir
is this topic enough for data analyst?
Make this SQL course up for certification in Great Learning's website
Yes, we ill take your suggestion into consideration. Stay Tuned with us
.i am myself in teaching profession.....i like it like anything........now i understood why government is putting focus on learning in learning languages.
aap bhut hi sahi samjhate h sir.......
😃😃🙏 thank you so much sir for making this vedio, sir your voice makes this vedio special 🙂👏👏
Can you please tell if this course is useful for placement preparation as well?
mera bsc IT complte hoga abhi but aapka video bhut accha laga muze concept clear hua 38 minute dekha hu but abji fir se dekhunga me aur notes banaunga thanks for sharing video really than
Thankyou Sir for Hindi 🙏🙏
Hi @Arnav, we are glad to know that you liked our video. On our TH-cam, you will find ample of videos in Hindi, you can check those as well. Moreover, every day we also have live sessions both in Hindi and English, you can check all the details regarding our upcoming sessions on our community posts. Do subscribe and keep supporting, thank you
@@greatlearning Ok Sir
thank you sir my sql first lesson started from this video and i understood each and every thing from your tutorial thank you very much
Thanks for SQL, Great Learning !
Sir make video tutorial on Pl/SQL, Plz.
Hey @keval, We are glad you liked our video. For real time update, subscribe on our TH-cam Channel. Visit our website for more free videos like these: glacad.me/FreeCourses_1000Hours
bht aaala bhai khush rahain love from pakistan.... bht acha samjhaya Urdu/Hindi main thnx alot.
Great.. What a precisely and wonderfully explained lecture 👍
Thanks sir.. 💓💓
Glad we could help. Please do subscribe to our channel and click on the bell icon so that you get a notification of our new videos
At 1:35:00, the answer is wrong. Jennifer DOES NOT earn highest in Sales, it's Jimmy.
Yup, the approach shown is a little wrong
@@sourabhmeena1996 Yes. The answer shown in this video is wrong.
Is this course include table functions, window functions, scalar functions, stored procedures?
Hey, this tutorial does not include table functions and window functions but we will keep your suggestion in mind and come up with a tutorial on it
At 1:35:08 - Group by clause, you have entered first name, max salary,dept from table group by dept.
1. For SALES we have JIMMY with max salary but the command returns JENNIFER.
2. For TECH we have MATT with max salary but the command returns CHARLIE.
Please check and let me know the correct command.
Is there any error
Thank you sir ... I'm really happy 🤩 after watching this. Sir please provide the the document link so that we can download and read it in offline.
1:35:30 - Group by clause showing wrong output, it shows max of salary by dept not by first name... the select query just fetching the first name
after watching many videos finally got the best video....also your voice amazing bhai.......
Glad we could help!😇 Subscribe us and hit the bell icon so that you never miss any update from us.
thanks sir its worth it bahot mehnat ke baad kaam ki video mili...........thanks
Thank you for this wonderful tutorial!!!
At 1:35:16 as we can see that in sales department jimmy has highest salary i.e 700000 but at 1:35:20 ,max salary in sales department is of jennifer, why?, according to table it should be jimmy
See my reply.. I have sorted out this issue...
Nice explained.
Where can I find this application for practice?
Here is the link for downloading MySQL Workbench: dev.mysql.com/downloads/workbench/
Bhut ache se smjhaya sir apne .... dhanyawad 🙏 apka
Learn SQL very easily thank u sir. Really Appreciable please tell me where can I get internship in SQL for experience because I am now fresher please tell me opportunity in SQL
There are various platforms/websites where the internship offers are posted. Please check them.
were to do internship
bhai ek do din m interview h mera and you are a life saviour man poora video dekhne m mujhe 5-6 hrs lage but i'm confident in DBMS now and all credits goes to you sir.... bus thodi practice aur and i'm sure interview m fod dunga m...
Thanks again
Tushar
kya hua interview ka bro
very well explaination sir ... i like way you teach ..
Hope I like this video multiple times.
Hi, we also hope you will like this video, whenever you watch it. Do subscribe and check other videos and we hope you will learn a lot from them as well. Thank you
Joyeeta Chakraborty
Joyeeta Chakraborty
4 months ago
My family is not financially strong. Fee courses for advanced computer languages are therefore not affordable. In this case your TH-cam videos are a blessing. Please upload more such courses here. And a big thanks for explaining in hindi
343
Mukku Abhishek Achary
Mukku Abhishek Achary
6 months ago
It was a great learning experience for me. Prior time to this video, I had no idea what is SQL except for the abbreviation. But now I can confidently say, I have little more knowledge than just abbreviations. Thanks to the tutor I really appreciate Great Learning to post this content on youtube.
23
Amit Sharma
Amit Sharma
4 months ago
Fantastic Job Sir
This 3 hours course is awesome for those students who are preparing for interviews.
21
Aas Mohammad
Aas Mohammad
1 year ago
Your way of understanding is excellent.
Every problem was slowed down, now I think I will find my destination easily…
Thank you very much...
You are fabulous.!!!
Once again thank you GREAT LEARNING
15
Great Learning
Akhil Krishna
Akhil Krishna
1 year ago
Sir,Thankyou so much for this vedio.I am an IT professional and I am watching this in my training phase.This proved very helpful to me.I m not a person who engage much with comments and channels but this one is so superb that you earned my Like ,Comment and Subscribe as well.
11
Amarjit Maity
Amarjit Maity
5 months ago
Really a great video for beginners in SQL. I am now feeling confidence in further proceeding with SQL in my career. Thank you very much GL ....
Ankit khurana
Ankit khurana
1 year ago
At 1:35:08 - Group by clause, you have entered first name, max salary,dept from table group by dept.
1. For SALES we have JIMMY with max salary but the command returns JENNIFER.
2. For TECH we have MATT with max salary but the command returns CHARLIE.
Please check and let me know the correct command.
21
Great Learning
sana khan
sana khan
5 months ago
very informative and great way of clearing DBMS. Professor, why are you not doing this lab in access? we use access in class, so I just wanted to ask the difference.
1
Sudhanshu Dwivedi
Sudhanshu Dwivedi
6 months ago
Your way of understanding is excellent.
Every problem was slowed down, now I think I will find my destination easily…
Thank you very much...🙏🙏🙏🙏🙏🙏❤❤❤❤❤❤
You are fabulous.!!!
Once again thank you GREAT LEARNING
4
Kishan Jalan
Kishan Jalan
2 months ago
This is so amazing .. explained the concepts in simple laymen's terms which were very easy to understand especially for a non-technical person like me.
KNIGHt Rowdy
KNIGHt Rowdy
4 months ago
Really Sir you taught very well. Best freely available video on this 🌍 for the beginners looking to start learning SQL. Sir can u pls make a Advanced Complete SQL tutorial as well.. That will be really grt for us.😊
1
Miss Gupta
Miss Gupta
Now I know I have not done anything wrong, enrolling for a postgraduate diploma with great learning. People say spending so much money on this is not worth but they are wrong.
That was so on point! Thank you 😇
I need a video about foreign key
same
Sir, i have a query regarding table.
A table having 6 month data of customer sales. And multiple entry in same month. Table have customer name, selling date and month, amount. Now i wanted to make a summary of customer wise and month wise which customer had purchased highest in amount and in frequency.
Thank you for SQL video, Great learning!
Thank You!
Thanks sir, very Informative Tutorial, much useful for me and others, I'm BCA 2nd year student also working.
We're glad that we could help you Ravin. Do subscribe to Great Learning for more such amazing content. Alternatively, you can also check out Great Learning Academy for more such free Courses with certification here: glacad.me/FreeCourses_1000Hours
@@greatlearning Dear sir, I have subscribed already. I will check your website link. Thank you!
Thankyou so much sir❤️ you are such great teacher 👍🏻
You’re welcome, we're glad we could help you😇 Make sure you subscribe to us and hit the bell icon to get notified about our amazing upcoming content.
sir I have no words to express my gratitute , this the best explanation of sql thank a lotttttttttttttttttttttttttttttttt
It is really helpful video. Thank you so much for your great efforts to make it understan. Looking for Tableau project also. 🤘
Hi @shalini, thank you for your appreciation. And, we do have a 6 hours of video on Tableau, which will help you, here is the link to check the video: th-cam.com/video/6mBtTNggkUk/w-d-xo.html. Thank you:)
@Thank you so much team. Currently, I have started Python tutorial that's also well explained. These tutorial helps those people who are interested to make his/her career but due to high fees they kill their dreams but this is the platform where they learn n later earn well. Really Thankful to you and team. 😊👍
@@greatlearning sir please tell how to download & configure WORKBENCH
You are teach very easy language and provide concept very easy way. Thank you so much sir.
Omg, that's so kind of you sir, I am preparing for a software testing interview I wanted to just basic learning but you have learned to be a lot of things, thanks over and over again
You are great sir🙏 you have cleared my concept today. So thankyou very much
Irony died when Sheldon Cooper started working in support 😂😂
Hehe, we hear you! Thanks for watching!😇