Getting started with SQL - Session 1 | Learn SQL the right way | Trendytech

[@sumitmittal07]

checkout the Big Data course details here: trendytech.in/?referrer=youtube_sql2

[@shushantvirat8361]

Can I take this course I am having 5 yrs of experience as a plsql/SQL developer and having experience in python as well

[@nithinkoneri408]

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

[@malashrimasnaik9069]

Most simplified way of teaching

[@manjuladas]

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

[@AdityaSharma-xh8tg]

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.

[@sumitmittal07]

Thank you for those kind words. Really happy to see that many of you are liking the SQL series.

[@pramjee007]

This course content is Amazing Sir, Love this content. Thankyou so much sir :)

[@AbdulRazzak725]

Good one. Thanks for making this video

[@sampaulson0009]

Really sir , you clear all the doubts. Bcz I am non it background. Your way of teaching very easy and helpful.

[@aquaman9285]

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

[@sumitmittal07]

Appreciate those kind words. Really happy that you found the session simple and effective.

[@manjunaths661]

Super sir you start from basics I will learn from this

[@bala4939]

One of the best SQL course in the world and the way of teaching is excellent.

[@hvkeee]

Sumit sir ur lecture s clear and thoughtful understand able 👍🏻👍🏻👍🏻

[@rakesh_bangla]

You are a great teacher, Sir! Absolutely fantastic explanation. Very easy to follow and to understand the concepts to the core.

[@shaikhraheman2826]

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 ❤️❤️

[@sumitmittal07]

thank you Shaikh for such a wonderful comment :)

[@familyalamocha557]

Excelent, course to internautas Sql, thank a lot for sharing your talent Sr. Sumit

[@wagalprasad1869]

Awsome an amazing start-up!!

[@niranjanbiswal6625]

Lots love from Odisha Sir . The way of Teaching is Awsome 🙏🙏🙏

[@Jai-xq5hi]

Best introduction video for Sql and sir your way of teaching is really good

[@rozinasaherwala4686]

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!!!

[@sumitmittal07]

Happy to hear that you are finding my SQL series effective. Hope you will enjoy your SQL learning.

[@emraan86]

Thankyou for amazing teaching way and looking forward for upcoming precious sessions..

[@sumitmittal07]

Thank you for those kind words. Keep watching and learning :)

[@manishtiwari7511]

You changing life's millions at a time.

[@sumitmittal07]

Feeling humbled :)

[@devendragovande]

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.

[@sumitmittal07]

Yes, that was the intention behind starting this series :)

[@pinku1010]

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?

[@AnzarDraboo]

Brilliant. For the first time, I applied something that i learnt in the very first video.

[@moumideychowdhury5648]

Sumit Sir you are an inspiration for our generation, Thanks a lot for your endless efforts towards us

[@sumitmittal07]

means a lot, thank you so much :)

[@kiranjape3941]

Very Nice and interactive session to know about the basics of databases..Thank you sir.

[@PankajKumar-kv4yk]

Wonderful content and more important your explanation which is very clear that is directly feeding in mind. Thank you

[@sumitmittal07]

Glad you enjoyed it!

[@naveenkumarnaravala]

Thank you sumit for this video. I really liked using ide for getting started with a database.

[@shubhangisingh2886]

Just amazing to start and learn sql, your videos really made easy everything. Thanku so much sir

[@SuryaPrakashbabul]

One of the best Content ever.

[@RajendraPatel.]

You made SQL easy for us. 😊

[@sunilreddy9407]

Nice sir I am really exited while seeing the videos of SQL lecture.

[@gouravbhandari6286]

Amazing 🔥

[@prashantkandarkar8993]

sir please upload whole big data videos on this channel your teaching style is so good even school student also get easily understood

[@sumitmittal07]

Since the Big Data Program is an extensive 6 months course, it wouldn't be practical to include them here on KZbin.

[@pravinmahindrakar6144]

Which is very good to starts with from novice to expert level.

[@beinghappy9223]

Thank u Sir ❣️ Awesome lecture

[@subashtks4202]

Nice class for SQL being in my life

[@kunalbeardlookrajput5005]

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.

[@navneet2649]

@15:40 here windows users need to select different option right in OS dropdown?

[@pridename2858]

Excellent stuff, sir.. Thanks a lot.Hope we will get something like NOsql soon.

[@webWorld404]

plople link you sharing valuable knowledge freely are gems of IT industry, thank you so much

[@sumitmittal07]

Humbled

[@sreekataru]

Finally wait is over as you said, I will be addicting for this series for sure !! Thanks a lot Sumit.

[@sumitmittal07]

I will give my 100%

[@shiboopoudal6853]

Fruitful first class 😊

[@varshakumari8065]

It's really helpful video, keep making and helping students like me

[@Indo-Euro]

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.

[@sumitmittal07]

We will make it better than paid content.

[@vishalbarot8588]

Awesome sir❤, Thank you for this series

[@avijitchatterjee8228]

The Time You Put In Really Shows ! You're Amazing !

[@sumitmittal07]

thanks for this awesome feedback.

[@RakeshG619]

Can practice hadoop too(hive... Etc..) on groom

[@wagalprasad1869]

#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

[@sumitmittal07]

thank you very much Wagal

[@rohitsamanta5258]

Great work sir what a easy way to understand the basics of SQL looking forward to complete the session 🙌🙌🙌 highly recommend for the beginners ✨✨

[@ritikaritika18]

Wow you have a great teaching skill ❤️😍

[@shahaababbasi2115]

SIR have u upload video of partition by function ....???? kindly explain partitionby function

[@Ram17291]

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

[@PallaviGandalwad]

Thank you sir , funtastic way of explanation sir .

[@dhaneeshchandran5528]

Started today. Thanks for the detailing

[@AdityaSharma-xh8tg]

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??

[@sumitmittal07]

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.

[@AdityaSharma-xh8tg]

@@sumitmittal07 Thnq sir :)

[@simranvolunesia]

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?

[@shanuyadav801]

Sir where did you write the definition I meant notepad or what where 1,2,3,4 numbers were showing??? What is that?

[@manojacharya2336]

Dear Sumit Ji, your way of teaching is really amazing.God bless you for all your efforts.

[@Kumarsanal]

very nice presentation.. Thank you so much sir

[@priyatamnayak2208]

Dear sir I am facing an issue when giving mysql-ctl cli; which shows command not found... Kindly help

[@vanshagarwal1355]

same issue

[@arvindkumar0779]

Very informative video 👍🏻

[@rahulranjan5067]

Just love it. Thank you sir for this amazing series.

[@khushbukhushalani1092]

Wonderfull way of teaching

[@YourYTHUB]

Great content Sir 🙏

[@nikhildhananajayrao7013]

Thanks for this video Sir !!

[@sumitmittal07]

I hope you are finding it helpful.

[@itssonu259]

You are a great Teacher sir . salute your passion.

[@sumitmittal07]

thank you Sonu

[@ngehpeace6772]

Am here from LinkedIn...thank you.

[@devasaniganesh8196]

Thank you sumint sir for the super content

[@sumitmittal07]

I am really that you are liking the content.

[@shubhamnagarkar5845]

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?

[@MJGamingML]

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 😢

[@debanjanmazumder7259]

Thanks for your efforts. ❤️ grateful 🙏

[@sumitmittal07]

thank you Debanjan, I hope you liked the video

[@Simbaforever]

Hello sir. GOORMIDE IO not working properly due to interface changes. Could you please make seperate video to open account on GOORMIDE ?

[@sugumarsrinivasan]

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 ☺

[@shilpi0508]

Hi, I am unable to create a container in goormid. Can you please help me?

[@akshay8756]

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

[@ruparanjanmohapatra726]

It's insightful. What's the frequency of video upload.

[@sumitmittal07]

Atleast 2 videos per week. But I want to try my best for 3 videos each week.

[@hashimamr]

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

[@grand_masti_ipl5548]

Love you sir for this content ❤

[@ashishthakur8619]

understood this class very well!! Thanks, sir

[@chandranisaha3188]

Thanks for a nice session . Easy to understand 🙂.

[@pradipita]

Are these query Like SHOW DATABASE, DESCRIBE, ETC not working in MS SQL? It is says "Could not find stored procedure"

[@157_keshavlichade6]

a very simple explanation thank you sir;

[@zaffer2024]

Sir there are two types of database rdbms and ordbms For salary you can use smallmoney or money as datatype

[@sumitmittal07]

great

[@agnimitraghosal3384]

Very informative sir. Where the database will be saved after creation? Will it be on the container?

[@amithadeepak2012]

Thanks a ton , I was getting syntax error for age INT can you help me .

[@rahulreddy-l9c]

where do we find the running notes ?

[@shubhammeshram8504]

Excellent and great session

[@sauravkumarsonu5539]

Hats off to you sir, really loved the way you teach🔥👏❤️

[@kinjalkothari-dq6oc]

Hello Sumit Sir, Quick question I tried working on the Goorm IDE for sesstion 1 and session 2, but I am unable to save the tables and steps created. When clicked on Save or Save as option on the top right. I am getting an pop up of Cannot find Opened File. Due to this I need to start everything from the scratch. Can you please guide with solution on this

[@mana.sharma]

Same

[@shashanksingh7867]

Goorm ide automatically fill python in my module sir...I am not filling mysql

[@rajeshsable9529]

Thank you so much Sir .. very helpful session for beginners..and revise for experts.👍

[@durgaprasadnagisetti]

Thank you for this Great content Sir 🙂

[@sumitmittal07]

Really happy to see that you are liking the series :)

[@shubhamSharma-du4ir]

Thank you so much sir for the basics.

[@zkhan2023]

Beat Explanation.

[@shanmukhamchowdary5199]

how to clear the screen in goorm ide?

[@navneet2649]

@19:25 how can we get the document?

[@anudeeputtaravilli6388]

How to come out from a particular database instead of using drop query. I have used drop query, database is deleted.

[@pallavin6533]

Thank you Sumit sir for this wonderful content. Your efforts to make everyone understand the concepts is great and it's helping many students to understand and also to use in their work. There is no better thing in this world than sharing the knowledge. Once again Thank you sir.. :)

[@sumitmittal07]

thank you Pallavi for the trust that you have in my teaching. Means a lot.

[@saurabhdhyani4498]

Great video Sir!

[@nonabahar8307]

Thank you so much sir for creating these contents. Lov the way you teach!