Great content Sumit Sir. In my last 14 years of work experience in Data & Analytics field, there is no single day that I have not used SQL for data analysis. And with this SQL course you are helping data aspirants to learn the SQL proper way and relevant to industry. I am a big fan of your teaching and looking forward to the upcoming sessions! With this I have a request for Python course, I hope to see the course or training in future. Thanks again sir for the efforts and knowledge share! #Respect #Trendytech
I'm looking for data science job. I know SQL but I still wanted to watch this video of your's. I must say that you are an amazing tutor. Your way of teaching is so very simple and is helpful for many of them. great job Sumit. Keep going..
I believe in the concept, teach a man how to fish rather than giving him a fish. Sir, you are helping so many people update themselves and move forward in their respective lives. More power to you sir....Thank you for this amazing video series.
Sir this is INDEED one of the finest and simplest content on SQL, we need more teachers like you who can also understand the question from our side . THANKYOU SIR, MUCH NEEDED :D
Sumit Sir As soon as I got notification I just throw all the stuff that I was doing Just came here to see the very first SQL video of the most awaited series ❤️❤️
I just started this course and loving it from each of the points you have described in such a simple way. May I please get best sources where I can practice sql queries?
Thank you Sumit Sir for this initiative to start SQL Course. And the first video for SQL is as amazing as your Big data videos. And now I feel I am addicted to your teaching method. I really enjoyed it! Waiting for next videos!!!
Thanks a lot sir for sharing this amazing session with us. I have a doubt, can we say that what DevC++ is to C++, MySQL is to SQL in the terms that C++ is a language and DevC++ allows us to work on it and same goes for the other two, is it so? Do correct me if I am wrong. Also sir it would be really nice if you could also introduce what is DDL, DCL, DML etc and how to know which commands fall under which category?
Thank you Sumit sir for creating a series for a subject which is very important and yet the material for it is scattered into pieces and if one wants to learn he/she has to collect and connect those pieces but a good continues series of topics with this playlist will definitely help anyone all these pieces at single place.
2 quick questions sir: 1) can you explain once we connected to Mysql Database, and when we are using the command show databases; does that mean our main Mysql databases has internally n number of databases? 2) Standard notation to folllow should be database_name.Schema_name.table_name? when can we omit schema name??
1. A system can have one or more instances of SQL server installed and each instance of SQL server can contain one or many databases. So to answer your question, a single server can have multiple databases. 2. Schema name can be omitted when you are already using the same database where the table is present. However, database name and schema name becomes mandatory if you are trying to access this table from a different path.
wonderful efforts but please .. please For more clarification and understanding of who they are not Indian speakers ... really you should activate CC " subtitles caption" feature in your videos .. thanks in advance
#Appreciate your hard work Sumit Sir and your outstanding SQL course I have never seen such a lovely course anywhere in the market. People, now they realized what awesome it is, I am looking forward to providing the same course for python,aws, Ms azure, GCP, Docker, cd/CID, Kubernetes which are high on demand and also for the interview process as they all start asking these things in depth. Due to lack of knowledge in these fields as we all not meeting the criteria in an awesome company, hope you will.Wagal
Thank you for videos, nothing is free in todays world and no one is ready to share their Knowledge and time with others for various reasons, your videos are exceptional and i strongly believe these videos will be good Base for who ever listening and practice, kudos to you sumit and your Team..
The contents are articulated in very well. I really enjoyed a lot while going through this session. Looking forward the same in the upcoming sessions as well ☺
after using the command line SELECT database(); it shows null while in show database trendytech already exists , how to sort this out ? kindly help please
checkout the Big Data course details here: trendytech.in/?referrer=youtube_sql2
Can I take this course I am having 5 yrs of experience as a plsql/SQL developer and having experience in python as well
Great content Sumit Sir. In my last 14 years of work experience in Data & Analytics field, there is no single day that I have not used SQL for data analysis. And with this SQL course you are helping data aspirants to learn the SQL proper way and relevant to industry.
I am a big fan of your teaching and looking forward to the upcoming sessions!
With this I have a request for Python course, I hope to see the course or training in future.
Thanks again sir for the efforts and knowledge share! #Respect #Trendytech
I'm looking for data science job. I know SQL but I still wanted to watch this video of your's. I must say that you are an amazing tutor. Your way of teaching is so very simple and is helpful for many of them. great job Sumit. Keep going..
Most simplified way of teaching
I believe in the concept, teach a man how to fish rather than giving him a fish. Sir, you are helping so many people update themselves and move forward in their respective lives. More power to you sir....Thank you for this amazing video series.
Thank you for those kind words. Really happy to see that many of you are liking the SQL series.
Good one. Thanks for making this video
One of the best SQL course in the world and the way of teaching is excellent.
Hi Sir,
I am fresher and I have to switch to the industry of data science, I have learned most of the essential things in this session.
Super sir you start from basics I will learn from this
Am here from LinkedIn...thank you.
Sir this is INDEED one of the finest and simplest content on SQL, we need more teachers like you who can also understand the question from our side .
THANKYOU SIR, MUCH NEEDED :D
Appreciate those kind words. Really happy that you found the session simple and effective.
You changing life's millions at a time.
Feeling humbled :)
Really sir , you clear all the doubts. Bcz I am non it background. Your way of teaching very easy and helpful.
Sumit Sir As soon as I got notification
I just throw all the stuff that I was doing
Just came here to see the very first SQL video of the most awaited series ❤️❤️
thank you Shaikh for such a wonderful comment :)
Sumit sir ur lecture s clear and thoughtful understand able 👍🏻👍🏻👍🏻
This course content is Amazing Sir, Love this content. Thankyou so much sir :)
Nice class for SQL being in my life
You made SQL easy for us. 😊
Excelent, course to internautas Sql, thank a lot for sharing your talent Sr. Sumit
Which is very good to starts with from novice to expert level.
One of the best Content ever.
Lots love from Odisha Sir . The way of Teaching is Awsome 🙏🙏🙏
Awsome an amazing start-up!!
Brilliant. For the first time, I applied something that i learnt in the very first video.
You are a great teacher, Sir! Absolutely fantastic explanation. Very easy to follow and to understand the concepts to the core.
sir please upload whole big data videos on this channel your teaching style is so good even school student also get easily understood
Since the Big Data Program is an extensive 6 months course, it wouldn't be practical to include them here on TH-cam.
Sumit Sir you are an inspiration for our generation, Thanks a lot for your endless efforts towards us
means a lot, thank you so much :)
Best introduction video for Sql and sir your way of teaching is really good
Fruitful first class 😊
I just started this course and loving it from each of the points you have described in such a simple way. May I please get best sources where I can practice sql queries?
Thank you Sumit Sir for this initiative to start SQL Course. And the first video for SQL is as amazing as your Big data videos. And now I feel I am addicted to your teaching method. I really enjoyed it! Waiting for next videos!!!
Happy to hear that you are finding my SQL series effective. Hope you will enjoy your SQL learning.
Thanks a lot sir for sharing this amazing session with us. I have a doubt, can we say that what DevC++ is to C++, MySQL is to SQL in the terms that C++ is a language and DevC++ allows us to work on it and same goes for the other two, is it so? Do correct me if I am wrong. Also sir it would be really nice if you could also introduce what is DDL, DCL, DML etc and how to know which commands fall under which category?
Thank u Sir ❣️
Awesome lecture
Thank you Sumit sir for creating a series for a subject which is very important and yet the material for it is scattered into pieces and if one wants to learn he/she has to collect and connect those pieces but a good continues series of topics with this playlist will definitely help anyone all these pieces at single place.
Yes, that was the intention behind starting this series :)
Thankyou for amazing teaching way and looking forward for upcoming precious sessions..
Thank you for those kind words. Keep watching and learning :)
2 quick questions sir:
1) can you explain once we connected to Mysql Database, and when we are using the command show databases; does that mean our main Mysql databases has internally n number of databases?
2) Standard notation to folllow should be database_name.Schema_name.table_name? when can we omit schema name??
1. A system can have one or more instances of SQL server installed and each instance of SQL server can contain one or many databases. So to answer your question, a single server can have multiple databases.
2. Schema name can be omitted when you are already using the same database where the table is present. However, database name and schema name becomes mandatory if you are trying to access this table from a different path.
@@sumitmittal07 Thnq sir :)
Started today. Thanks for the detailing
The Time You Put In Really Shows !
You're Amazing !
thanks for this awesome feedback.
Amazing 🔥
Very Nice and interactive session to know about the basics of databases..Thank you sir.
Thank you sumit for this video. I really liked using ide for getting started with a database.
Just amazing to start and learn sql, your videos really made easy everything. Thanku so much sir
Awesome sir❤, Thank you for this series
Finally wait is over as you said, I will be addicting for this series for sure !! Thanks a lot Sumit.
I will give my 100%
Nice sir I am really exited while seeing the videos of SQL lecture.
Wonderfull way of teaching
You are a great Teacher sir . salute your passion.
thank you Sonu
wonderful efforts but please .. please For more clarification and understanding of who they are not Indian speakers ... really you should activate CC " subtitles caption" feature in your videos .. thanks in advance
#Appreciate your hard work Sumit Sir and your outstanding SQL course I have never seen such a lovely course anywhere in the market. People, now they realized what awesome it is, I am looking forward to providing the same course for python,aws, Ms azure, GCP, Docker, cd/CID, Kubernetes which are high on demand and also for the interview process as they all start asking these things in depth. Due to lack of knowledge in these fields as we all not meeting the criteria in an awesome company, hope you will.Wagal
thank you very much Wagal
very nice presentation..
Thank you so much sir
Thank you sir , funtastic way of explanation sir .
Dear Sumit Ji, your way of teaching is really amazing.God bless you for all your efforts.
Excellent and great session
Sir there are two types of database rdbms and ordbms
For salary you can use smallmoney or money as datatype
great
Great work sir what a easy way to understand the basics of SQL looking forward to complete the session 🙌🙌🙌 highly recommend for the beginners ✨✨
Wow you have a great teaching skill ❤️😍
It's really helpful video, keep making and helping students like me
Thank you for videos, nothing is free in todays world and no one is ready to share their Knowledge and time with others for various reasons, your videos are exceptional and i strongly believe these videos will be good Base for who ever listening and practice, kudos to you sumit and your Team..
plople link you sharing valuable knowledge freely are gems of IT industry, thank you so much
Humbled
Just love it. Thank you sir for this amazing series.
Super quality of content video as like paid #trendytech big data course video. Thank you sumit Sir for this free content video for every learner.
We will make it better than paid content.
Wonderful content and more important your explanation which is very clear that is directly feeding in mind.
Thank you
Glad you enjoyed it!
Thank you sumint sir for the super content
I am really that you are liking the content.
Excellent stuff, sir.. Thanks a lot.Hope we will get something like NOsql soon.
Thanks for this video Sir !!
I hope you are finding it helpful.
Great content Sir 🙏
Very informative video 👍🏻
Sumit sir, please explain the relation between MySQL and nodejs. Thank you for the video. 🙏
Thanks for your efforts. ❤️ grateful 🙏
thank you Debanjan, I hope you liked the video
Beat Explanation.
a very simple explanation thank you sir;
Thanks for a nice session . Easy to understand 🙂.
understood this class very well!! Thanks, sir
Thank you for this Great content Sir 🙂
Really happy to see that you are liking the series :)
Very informative sir. Where the database will be saved after creation? Will it be on the container?
Love you sir for this content ❤
SIR have u upload video of partition by function ....???? kindly explain partitionby function
Hello sir.
GOORMIDE IO not working properly due to interface changes. Could you please make seperate video to open account on GOORMIDE ?
Sir where did you write the definition I meant notepad or what where 1,2,3,4 numbers were showing??? What is that?
It's insightful.
What's the frequency of video upload.
Atleast 2 videos per week. But I want to try my best for 3 videos each week.
You should allow captions in all your videos..!!
have only good things to tell
Great video Sir!
Can practice hadoop too(hive... Etc..) on groom
The contents are articulated in very well. I really enjoyed a lot while going through this session. Looking forward the same in the upcoming sessions as well ☺
Thank you so much Sir .. very helpful session for beginners..and revise for experts.👍
Thank you sir. Nice vedeo
Thank you so much sir for the basics.
Hats off to you sir, really loved the way you teach🔥👏❤️
excellent
Goodone
Thankyou so much sir.
Thank You sir
Hi great content but some of these commands does not work in SSMS
thank you sir for this informative session :)
I am glad that you liked the session Richa
Dear sir I am facing an issue when giving mysql-ctl cli; which shows command not found... Kindly help
same issue
@15:40 here windows users need to select different option right in OS dropdown?
after using the command line SELECT database(); it shows null while in show database trendytech already exists , how to sort this out ? kindly help please
Hi sir, for some reason i am not able to use groomide. after using few commands in the container, it stops working. Any solution this?
Can't open groomide, it doesn't verify my gmail account... And I looked up all the videos briefly, it is all done on groomide 😢
Thanks a lot sir, you are the best🙌