Learn SQL the right way - Session 2 | Trendytech

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐌𝐚𝐬𝐭𝐞𝐫 𝐒𝐐𝐋? 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐭𝐡𝐞 𝐫𝐢𝐠𝐡𝐭 𝐰𝐚𝐲 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐬𝐨𝐮𝐠𝐡𝐭 𝐚𝐟𝐭𝐞𝐫 𝐜𝐨𝐮𝐫𝐬𝐞 - 𝐒𝐐𝐋 𝐂𝐡𝐚𝐦𝐩𝐢𝐨𝐧𝐬 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫!
"𝐀 8 𝐰𝐞𝐞𝐤 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐝𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐭𝐨 𝐡𝐞𝐥𝐩 𝐲𝐨𝐮 𝐜𝐫𝐚𝐜𝐤 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰𝐬 𝐨𝐟 𝐭𝐨𝐩 𝐩𝐫𝐨𝐝𝐮𝐜𝐭 𝐛𝐚𝐬𝐞𝐝 𝐜𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬 𝐛𝐲 𝐝𝐞𝐯𝐞𝐥𝐨𝐩𝐢𝐧𝐠 𝐚 𝐭𝐡𝐨𝐮𝐠𝐡𝐭 𝐩𝐫𝐨𝐜𝐞𝐬𝐬 𝐚𝐧𝐝 𝐚𝐧 𝐚𝐩𝐩𝐫𝐨𝐚𝐜𝐡 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐚𝐧 𝐮𝐧𝐬𝐞𝐞𝐧 𝐏𝐫𝐨𝐛𝐥𝐞𝐦."
𝐇𝐞𝐫𝐞 𝐢𝐬 𝐡𝐨𝐰 𝐲𝐨𝐮 𝐜𝐚𝐧 𝐫𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐟𝐨𝐫 𝐭𝐡𝐞 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 -
𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐋𝐢𝐧𝐤 (𝐂𝐨𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐨𝐦 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLINR
𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐋𝐢𝐧𝐤 (𝐂𝐨𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐨𝐦 𝐨𝐮𝐭𝐬𝐢𝐝𝐞 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLUSD
To enhance your career as a Cloud Data Engineer, Check trendytech.in/?src=youtube&su... for curated courses developed by me.
I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.
MySQL is the world's most popular open source database.
TABLE OF CONTENT
1:20 CRUD Operations
2:50 Create table
8:45 Insert Statement
14:50 Inserting quote as value in insert statement
18:00 Inserting multiple rows in one insert statement
22:18 Null and not null values
26:45 Default values
32:10 Combination of not null and default values
𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
🔅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

[@sumitmittal07]

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

[@madhurajsingh9463]

sir from where we can download notes of these lectures

[@aryanatri9904]

@@madhurajsingh9463 notes mile bhai ?

[@aritra1414]

The thing that I particularly liked about your sessions is that you are teaching basic concepts but based on scenarios. Which will be more helpful to people.

[@navneet2649]

Till now as a beginner and not from IT background, and having no prior knowledge of coding, I am able to understand things, hope it stays the same in future lectures also! Thanks a lot 💖💖👍👍

[@yashdhas8202]

Amazing, Very Helpful. Always Excited for next lecture.

[@ananttrivedi23]

Its is quiet an amazing way to learn the RDBMS....Thumps Up To you sumit sir

[@Kurnool-Mokshi]

Hi Sumit sir, my name is prasad, Your explanation is simply super and even non IT students also can easily understand in this video, we learned below things 1 create table 2 simple inserts and multiple inserts 3 datatype mismatch 4 null values and default values 5 combination of null values and default values

[@swetajagtap5640]

Thank you sumit sir , I am actually learning SQL the right and easy way .

[@veereshb.l.j157]

Thank you sir for explaining the things in very simple yet effective way!

[@vipsharma1]

This is amazing explanation with so much of ease....super like..thanks for putting this across

[@bipulmukherjee422]

Sir, the way you taught is so nice, easily understandable . sir in the very first of todays session you said that things will not work if you only watch videos. you have to practice it very well.. sir could you say in next session the from where we can practice and how to practice the things.. it will be very helpful for us.. Thanks a lot to make a session like this.

[@DatawithHimanshu]

Thank you sir. It's very easy n simple to learn the way you have explained the basics concepts.

[@eldhosevarghese8063]

Nice way of teaching ,waiting for more lectures.

[@ksktest187]

Very well buildup video on SQL.thanks Sir

[@dhireshparijatam1833]

Good Quality Teaching

[@ManiChandana2033]

Your explanation is Crystal Clear Sir!Having a great time listening to this playlist.Tq sir!!

[@dilawarjalil8842]

Bundle of Thanks Sir Jee

[@dhrubajyotichatterjee129]

Sumit sir, great learning from you. Sir can you make some dedicated series on NoSQL and Python. If possible. Thanks for your efforts really appreciatable.

[@Someone-rj3vu]

Your sessions are really very easy to understand. Hard to find such content at no charge. Thankyou for taking your time out and doing this for your audience. Looking forward to further sessions. 🙏

[@sumitmittal07]

Glad that you are finding the session useful :)

[@pranaymasane1180]

It is very Useful for me as a Beginner

[@CricketLivejavwad]

Hi sir,I hope you are doing well,I just completed this video and I can say that your way of teaching is superb as you relate this basic topic with real world application scenario.I love your way of scenario based teaching. Thank you sir

[@AnandPatil-eu1tl]

Thanks sir ji for this amazing content

[@sachinrathore7319]

Please upload more lecture. Waiting eagerly for them

[@amithadeepak2012]

Really liked the session.

[@sebastiansrikanth]

Awesome Sumit Sir, your videos make me so inspirational

[@pratapranvir7428]

Really interesting session sir , thank you .

[@firozgade3849]

Excellent and Wonderful session sir . Already Know SQL but brushing up the basics again. Easy to Understand and everybody can understand that.👌👍👏🙌 Down the Line are we going to cover ACID properties , Normalization etc ?

[@abhishekshukla8642]

NICE! Content quality is too good sir , APPRECIATE!!!!!

[@amritmanash7950]

Very good explanation sir thank you so much

[@ramakrishnap8516]

excellent sir!!!

[@piXiesviral]

Learning this in order to get enrolled in your course.

[@balajipanchal1364]

Sir you ,you explain in very simple way

[@syedfahad-ev9rk]

I like you work and thanks for effort

[@sureshnagur6486]

Really Helpful Thank you sir

[@sparshbansal305]

Hi sir, I am beginner at the end of the session 2 where you are explaining combination of null and default, after putting not null in location while creating table and if we insert manual null with inverted commas it is taking the value as null.

[@user-dn9du6gy7n]

very good session thank you Sumit sir

[@avinashpandey6518]

Hi sir the way you explain was very amazing thankyou

[@tarunrishishwar2651]

amazing session.

[@chandranshuyadav3515]

Nice explanation sir

[@Garima_singh_3]

Thanks a lot sir👍😊

[@brayanrai2880]

Well explained!

[@ishwarkumar8919]

thankyou so much sir your session is very helpful🙏

[@anujkalamkar8813]

Wonderful session sir..🙏

[@drishtisahu7887]

very insightful learning

[@amit_negi5]

very well content

[@arunprasadhsj]

very well articulated content, though I know these concepts hearing from you again is so good. Thank you !

[@sumitmittal07]

Glad to hear that :)

[@mouligodavarthi-yme1701]

Good one to go

[@Aman-vq6fz]

Thank you.

[@mohammadmazhar6184]

Hi Summit, what if I want to add NOT NULL constraints or default etc to the existing table instead of dropping and creating new table all together. Example there is a database and table in production and having data inside so I can not delete the table and re-create it else will loose the data but at the same time I want to add NOT NULL constraint as I just realised it now, then how can it do that?

[@sameerpandey2344]

The way you explain and cover topics, anyone will fall in love with learning Sir!!😇😇

[@sumitmittal07]

Thanks Sameer, that is really kind of you.

[@RahulKumar-gt8uz]

Hey Sumit, Nice content. Just a small question When you created the first record in employee table it too 0.14 sec to execute the statement and second record took 0.01 sec, why there is a time difference in execution of two statements. Thanks :)

[@tanu02444]

Thanks its working

[@ajitpawar7632]

Thank you sir for SQL series

[@sagnikchakraborty734]

Thank you sir for this wonderful video. Sir also i have a question that how can we delete a single row on a table?

[@randomlycreation6445]

Awesome sir Very soon I will part of your big data course. Amazing sir Even fresher like me is understanding

[@sumitmittal07]

Happy to hear that you are able to grasp the concepts much easily.

[@nurulqamar213]

excellent

[@ranga3194]

Thank you sir

[@mansicreation3071]

Awesome

[@sukantabala2514]

Great Tutorial, Sir❤

[@saurabhdhyani4498]

Great video Sir!

[@sanyuktademgunde110]

Hi Sir, These sessions are really very helpful But in session 2 CRUD operations "update" keyword is not used For updating the the values in the table what keyword we have to use?

[@shubhamSharma-du4ir]

Thank you, sir.🙂

[@sayantanchowdhury5791]

Hi sir how can we update the table description after creating the table , without dropping the table ?i.e for example I have created the table first time without default value as Bangalore but later I want to set a default value as Bangalore but I want to do it without dropping the table ....can i do it ?if so how can we do then ?

[@ankurdixit1196]

Sir , how do you clear goorm IDE terminal I did not find shortcut..

[@Nikhil-qi4oz]

Hi Sir This query is not inserted in the table and Not showing as middle name NuLL insert into employee values ('Rajesh','Sharma',32,2000,'Bangalore');

[@MrZubaid12345]

Thank you for this series. Is it possible to share the document where you write all the queries ?

[@nonabahar8307]

thank u sir

[@sandeepdeshpande1025]

Hi sir! I’m from a non tech background and tryin to the get into tech role and this is my beginning step. Is this playlist the right place for me to start ?

[@namratapatil777]

Hi Sir, Request to create a video on Data modelling and Schemas

[@mynksrswt483]

Sumit sir do we need to drop each time table to update table schema, i have this doubts what if i have too many records which i don't want to remove and still i have to update table schema

[@harshrajvaghela699]

this sql playlist is completely used for carrier in cloud computing

[@shaikhraheman2826]

That's wonderful session... CRUD concept was explained very well

[@sumitmittal07]

Happy that you found the session helpful and easy to understand.

[@rohitsamanta5258]

Another wonderful session sir thank you and one thing I am not getting when I am performing this applying these commands in my laptop some of operation I'm not getting could you please help me to understand how can ask my doubts? Please reply...

[@gaurav942010]

Fantastic

[@poojasmriti7548]

Hello Sir, I saw both of your videos and let me admit they are really really good. Easy to understand and then to practice!! Frst of all thanks a lot for helping so many of us. 2 advices I would like to give :- 1. If you can tell us through the topic what questions are being asked in interviews from that topic, it would be really helpful. 2. Please try to include more topics in one video. Again, thanking you Sir for doing this Noble Work for all of us 🙏🙏

[@sumitmittal07]

Happy that you have found the series insightful. Noted your suggestions, will consider incorporating it in the upcoming sessions. :)

[@prasaddodla2230]

Hi ,Sumith exellent Explanation....

[@harshitaggarwal3554]

Hello Sir, Thanks a lot it is very interesting and helpful. The quotes concept which you have tell us that how to give single quote in name does'nt work in postgres. So does it work only in sql server

[@learntoday7783]

Rhanks a lot❤

[@shardulpatil7260]

great session

[@dilipchawda3004]

Pls share link of entire series.....Thank you !

[@kiran4608]

Thank you🙌

[@jenildoshi5626]

Hi Sumit sir, Can you please let me know from where should I access the Notes prepared by you. I am unable to locate link for the training notes which you have prepared in Notepad. Thank you!

[@mudpieman_tech584]

Can anyone help me with, which software is sir using for recording screen?

[@rudraraju2467]

Great sir

[@AmazingMusician359]

Thank you for sessions. How do you clear screen ?

[@cebeb54vishwajithrajendran55]

Sir what is a difference between desc and select command ?

[@shubhamekbote1628]

update delete is not shown how can u say its done?

[@sudheervennapu309]

well defined

[@pratipghosh7596]

Sir, you will make everyone fall for any subject you teach. :)

[@sumitmittal07]

That's really kind of you :)

[@sunilreddy9407]

nice sir

[@karthikeyankarthik4752]

Just suggestion to insert records with single quotes -- eg) insert into employee values('Tamanna''s','R','Raju',31,35000,'chennai'); this way also we can go.

[@softdev7506]

How to insert and retreive C++ structure into VARCHAR(255) datatype?

[@dheerajlakkakula5983]

Sir, the way you taught is so nice, easily understandable . Can you please take some lectures on CASE statement how to use it and much more , i am facing difficulties in understanding it . Thank you sir .

[@sumitmittal07]

Glad that you are finding it easy to understand.

[@farooquisaquib8806]

How to come out of DB? like we use USE DB statement to use the DB

[@vutv5742]

Completed

[@techtransform]

What a depth and covered all the scenarios, Appreciate your effort for the quality content as always, now a days Other Content creator are hiring and cascade the work, and here this makes you unique, keep it like this always. :)

[@sumitmittal07]

Humbled that my efforts are being noticed and appreciated :)

[@grraul01]

If we want to modify the Definition of Table can we do that , Without dropping the table ?

[@RK-xg3qp]

What is the notepad sir is using in this video?

[@harshrajvaghela699]

and thank you for replay sir you are great

[@birjeshnarwariya4757]

helpful

[@user-sy1en8qg5p]

U must habe to respond for my message, some times groom ide ,,,stucks and after sometime it dont works,is there any soultion for that ,