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?
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.
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
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
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 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.
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.
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.
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
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.
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.
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
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.
2:54 error 12:48:50 update bank_holidays set end_time= utc_timestamp() Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. 0.000 sec
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.
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.
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 🙏🙏
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.
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.
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
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.
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.😊
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
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
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
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?
.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.......
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
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
Thanks a lot. We are glad you found our video helpful. We are working on creating a lot more content for learners like you. Do subscribe to our channel so that you get notified whenever we upload a new tutorial. 😊
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
🔹 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
विश्वास नही होता, 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.
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
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
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
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
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
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.
You cleared so much up for me that I was confused about. Thanks a million!.... Plz show us Informatica in hindi too.
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 ?
Meko sql ka zero knowledge tha aapke video ki wjh se hi mai sql smjh paya aur query likhne lga thnks great learning ❤
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
No .of Subscribers not show utuber capacity, hardwork.... Wonderfull 💯
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 ?
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
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.
Indians are freaking intelligent people. And the way you guys teach is Nobel work for all of us. Thank you, from pakistan.
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.
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.
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
Just want to say a ton of thanks for explaining such concepts with simplicity and very understandable approach. 🙏
Kindly correct the group by clause example , first_name should not be there in the query.(1:35:00)
Thank you.
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.
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
You made this complex topic so easy. Worthy watching ❤. And you earn a subscriber as well
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
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.
2:54 error
12:48:50 update bank_holidays set end_time= utc_timestamp() Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. 0.000 sec
great video !! theory and practise both are perfectly maintained in this video
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 ?
sir SQL is very complicated topic that you will make very easy thanks sir
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.
love this video, you explained everything with so much ease. thank you!
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.
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.
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 🙏🙏
Very useful for beginners, i started my SQL journey from this video.
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 ?
bht aaala bhai khush rahain love from pakistan.... bht acha samjhaya Urdu/Hindi main thnx alot.
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 ❤🙏
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.
Thank you so much sir for explaining SQL in hindi
Hello sir,
What is the difference between MySQL plus and SQL workbench.
Other people are using only SQL plus
Please answer
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?
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.
Hi Great Learning,
at 1:38:09, tutor had explained the concept which is not providing correct output as name and salary column both are varying
Really most helpful video on TH-cam about SQL
Glad you liked it. Subscribe to our TH-cam channel for more videos!
@@greatlearning ok
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...
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.
thanks sir its worth it bahot mehnat ke baad kaam ki video mili...........thanks
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!
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
Thanks sir and God bless to guide all the students who can afford the tution..
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
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.😊
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
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
Bhut ache se smjhaya sir apne .... dhanyawad 🙏 apka
😃😃🙏 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?
i learnt alot of things about sql today was very much helpful for me 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
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 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.
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
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.....
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.
Thank you for SQL video, Great learning!
Thank You!
.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 for this wonderful tutorial!!!
very well explaination sir ... i like way you teach ..
This video is very much helpful for me.. Thank you. Keep uploading videos of other subjects of computer science
That was so on point! Thank you 😇
I need a video about foreign key
same
sir you are a great teacher
Anyone can learn anything
If you teach like this 🙏
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
I am at 2:00:18 just 1 hr to complete this lecture!
Make this SQL course up for certification in Great Learning's website
Yes, we ill take your suggestion into consideration. Stay Tuned with us
awesome explanation, I understood everything, thank you so much. 🎉🎊🔥🔥💃💃🕺🕺🙏🙏👍🤟
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
thanks a lot! I prepared for my lab mid-exam just by watching this lecture.
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
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
Irony died when Sheldon Cooper started working in support 😂😂
Hehe, we hear you! Thanks for watching!😇
Thank you Sir 🙏🙏🙏🙏♥️♥️♥️
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 sir my sql first lesson started from this video and i understood each and every thing from your tutorial thank you very much
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.
Your Hindi videos are really helpful to understand , hope you'll record more videos on different topics, Great learning with love❤️
Thanks a lot. We are glad you found our video helpful. We are working on creating a lot more content for learners like you. Do subscribe to our channel so that you get notified whenever we upload a new tutorial.
😊
You are great sir🙏 you have cleared my concept today. So thankyou very much
Your explanation is outstanding 👍
Glad you liked it. Subscribe to our TH-cam channel for more videos!
Thank you so much sir you are great teacher with great knowledge 🙏
Just completed the video🙏
Nice explained.
Where can I find this application for practice?
Here is the link for downloading MySQL Workbench: dev.mysql.com/downloads/workbench/
The group by function video 1:35 the function is not working when we don't use the First_Name in group by clause.