Getting started with SQL - Session 1 | Learn SQL the right way | Trendytech
Вставка
- Опубліковано 30 вер 2024
- 𝐖𝐚𝐧𝐭 𝐭𝐨 𝐌𝐚𝐬𝐭𝐞𝐫 𝐒𝐐𝐋? 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐭𝐡𝐞 𝐫𝐢𝐠𝐡𝐭 𝐰𝐚𝐲 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐬𝐨𝐮𝐠𝐡𝐭 𝐚𝐟𝐭𝐞𝐫 𝐜𝐨𝐮𝐫𝐬𝐞 - 𝐒𝐐𝐋 𝐂𝐡𝐚𝐦𝐩𝐢𝐨𝐧𝐬 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫!
"𝐀 8 𝐰𝐞𝐞𝐤 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐝𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐭𝐨 𝐡𝐞𝐥𝐩 𝐲𝐨𝐮 𝐜𝐫𝐚𝐜𝐤 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰𝐬 𝐨𝐟 𝐭𝐨𝐩 𝐩𝐫𝐨𝐝𝐮𝐜𝐭 𝐛𝐚𝐬𝐞𝐝 𝐜𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬 𝐛𝐲 𝐝𝐞𝐯𝐞𝐥𝐨𝐩𝐢𝐧𝐠 𝐚 𝐭𝐡𝐨𝐮𝐠𝐡𝐭 𝐩𝐫𝐨𝐜𝐞𝐬𝐬 𝐚𝐧𝐝 𝐚𝐧 𝐚𝐩𝐩𝐫𝐨𝐚𝐜𝐡 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐚𝐧 𝐮𝐧𝐬𝐞𝐞𝐧 𝐏𝐫𝐨𝐛𝐥𝐞𝐦."
𝐇𝐞𝐫𝐞 𝐢𝐬 𝐡𝐨𝐰 𝐲𝐨𝐮 𝐜𝐚𝐧 𝐫𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐟𝐨𝐫 𝐭𝐡𝐞 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 -
𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐋𝐢𝐧𝐤 (𝐂𝐨𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐨𝐦 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLINR
𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐋𝐢𝐧𝐤 (𝐂𝐨𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐨𝐦 𝐨𝐮𝐭𝐬𝐢𝐝𝐞 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLUSD
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐥𝐞𝐚𝐫𝐧 𝐁𝐢𝐠 𝐃𝐚𝐭𝐚 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫?
𝐜𝐡𝐞𝐜𝐤𝐨𝐮𝐭 𝐭𝐡𝐞 𝐛𝐢𝐠 𝐝𝐚𝐭𝐚 𝐜𝐨𝐮𝐫𝐬𝐞 𝐝𝐞𝐭𝐚𝐢𝐥𝐬
𝐖𝐞𝐛𝐬𝐢𝐭𝐞 : trendytech.in/...
I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.
In the video we will be learning
What is a Database
What is a Table
Relational vs NoSQL DB
What is SQL
MySQL vs SQL
How to get a quick setup for working
Creating/dropping a Database
Creating/dropping a Table
𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
🔅Sumit LinkedIn - / bigdatabysumit
🔅Sumit Instagram - / bigdatabysumit
If you're looking to master SQL with real time usecases & looking to crack top product based companies, this tutorial is for you. Just follow through and you'll be able to write SQL queries in no time.
SQL, short for Structured Query Language, is a language used by software developers, data engineers, data scientists and anyone who works with data. With SQL, you can store data in relational databases and write queries to extract valuable information.
Even if you are someone who is working on SQL Server, Oracle DB, PostgreSQL or any other relational DB. Then you should be able to use your learning with hardly 5% syntax change.
#SQL #RDBMS #database #bigdata #dataengineering
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
Thank you Sumit sir,, I feel very happy !! A new skill will be added to my profile now. I hope in future you could teach us python also that does not have to be free.
Dear sir I am facing an issue when giving mysql-ctl cli; which shows command not found... Kindly help
same issue
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.
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?
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 😢
Sumit sir ur lecture s clear and thoughtful understand able 👍🏻👍🏻👍🏻
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
Same
Hi Sumit sir i am getting this error while creating table - "ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 6" Please help how to fiix this issue?
Hello sir.
GOORMIDE IO not working properly due to interface changes. Could you please make seperate video to open account on GOORMIDE ?
This course content is Amazing Sir, Love this content. Thankyou so much sir :)
Sir where did you write the definition I meant notepad or what where 1,2,3,4 numbers were showing??? What is that?
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 :)
Please share the document. THANKS!
You are a great teacher, Sir! Absolutely fantastic explanation. Very easy to follow and to understand the concepts to the core.
Can anyone tell me without having personal laptop can we work goorm and can create our tables is that free ?
Not able to create goorm id. Error showing "please try again in a few minutes"
Excelent, course to internautas Sql, thank a lot for sharing your talent Sr. Sumit
Sir please Hindi mein bhi bataiye .ya fir Hindi English dono mein bataiye .please
Very informative sir. Where the database will be saved after creation? Will it be on the container?
Super sir you start from basics I will learn from this
plople link you sharing valuable knowledge freely are gems of IT industry, thank you so much
Humbled
Hi, I am unable to create a container in goormid. Can you please help me?
mysql> create database Sandhya;
ERROR 1006 (HY000): Can't create database 'Sandhya' (errno: 15628928)
I m from commerce background .can i get good job in microsoft or etc like companies.
Hi great content but some of these commands does not work in SSMS
How to save this? After saving as save as everything vanishes away why?
How to save this? After saving as save as everything vanishes away why?
while i am trying to create the container, its getting failed. can anyone help me on that.
Hello sir, can you share this document?
Hi Sumit sir, can get your online class to learn SQL
Thank u Sir ❣️
Awesome lecture
Real time use SQL queries videos upload sir
Hi sir,,
Very nice video and easily understandable concept,,,,pls let me know from how many sessions I can go for big data course from trendytech??
Happy to know that you could grasp the concepts easily. You could very well start learning Big Data alongside.
Life time unforgotable knowledge
Thankyou for amazing teaching way and looking forward for upcoming precious sessions..
Thank you for those kind words. Keep watching and learning :)
sir from where we can get notes of your lecture
@sumitmittal07 Your lectures are truly invaluable! However, I'm encountering an issue where I can't seem to view the same screen as yours while creating a container on GroomIDE, particularly during tasks like installing SQL or setting locations. As a result, I'm unable to practice effectively. Could you please assist me with this
You could try to use anyother online services like CodePen / AWS Cloud9 in place of Groom IDE. Or you could install MySQL on your local system for your practice.
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!
Sir Hindi me tutorials banao 🔥
very nice way to teach. thank u Sir.
Can please you share this slides with us?
Awsome an amazing start-up!!
SIR have u upload video of partition by function ....???? kindly explain partitionby function
Are these query Like SHOW DATABASE, DESCRIBE, ETC not working in MS SQL? It is says "Could not find stored procedure"
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.
jab sir ne sql-cti ctl use kiya can anyone tell me how to remove all the unnecessary stuff i am tired.....how to remove???????????/
ctrl+l
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.
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.
Nicely explained sir! Where can I get those notes just to refer in future?
I would strongly advice to make notes as it would help you in retaining whatever you have learnt for a long time.
#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
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
Sir please provide notes of this session
Unable pratice in goormide
have only good things to tell
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
Really sir , you clear all the doubts. Bcz I am non it background. Your way of teaching very easy and helpful.
where do we find the running notes ?
You made SQL easy for us. 😊
Mahab Ana. Ra tha m s series
Amazing 🔥
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 :)
How to come out from a particular database instead of using drop query. I have used drop query, database is deleted.
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?
Lots love from Odisha Sir . The way of Teaching is Awsome 🙏🙏🙏
Hi, where can I find this document (text file)? Is it shared by some mean? sorry could not find it.
Hello Sumit sir, great explanation I have request to you can you teach Hadoop ,Spark related tutorial through yotube
Sir it would be great if you will share the notepad.txt file that you write and teach us on video, it will be great help and save time of learners, as I have to take screenshots for your playing video, which is difficult to place at single place, which makes barrier at revision time
Sir, I differ to you in the very first sentence. There are many type of database which are not tables !
Thanks a ton ,
I was getting syntax error for age INT can you help me .
It's really helpful video, keep making and helping students like me
@34:05 Nice video, thanks sir,👍👍🙏🏼🙏🏼 but in the subsequent sessions also you did not talk abt installing databases like MYSQL!! How to use that to run these commands? 🤷♂🤷♂🙄🙄
Thanks for your efforts. ❤️ grateful 🙏
thank you Debanjan, I hope you liked the video
can I get running notes ?
@15:40 here windows users need to select different option right in OS dropdown?
Can anyone tell me where can I get the document for this video and the next videos ?
Thank you sumit for this video. I really liked using ide for getting started with a database.
Thank you sir , funtastic way of explanation sir .
Thank you sumint sir for the super content
I am really that you are liking the content.
Greate sir ! I request you to please provide us the notes which you are teaching.
Pls can u explain sap hana module,I need a good source for sap hana can u suggest if any
Can practice hadoop too(hive... Etc..) on groom
Thank You sir
Excellent stuff, sir.. Thanks a lot.Hope we will get something like NOsql soon.
thank you sir for this informative session :)
I am glad that you liked the session Richa
You should allow captions in all your videos..!!
Awesome video.. Could you please make the same for hbase/mongoDB ?
Wow you have a great teaching skill ❤️😍
Just amazing to start and learn sql, your videos really made easy everything. Thanku so much sir
You changing life's millions at a time.
Feeling humbled :)
Learnt :
How to create a DB
How to drop a DB
How to create a table in a DB
How to drop it
Is it necessary that database will contains data in form of tables only?
very nice presentation..
Thank you so much sir
In how many sessions SQl course complete?
Goodone
Thank you for this Great content Sir 🙂
Really happy to see that you are liking the series :)
Thanks for this video Sir !!
I hope you are finding it helpful.
a very simple explanation thank you sir;