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
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 💖💖👍👍
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.
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. 🙏
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 🙏🙏
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
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.
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. :)
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 .
Sir once again thank you for emboldening our careers. I have few questions to ask: 1) In case we need to store values in string data type and we want it to accept any lengths until 255 characters so that dynamically it can accommodate any lengths then can we write that? 2) Salary is something like private information, can we mask it while storing those values in database? can it be stored as a masked value? or we this encryption should be done in later stage? 3) while using insert stmnt, if again we declare the list of columns, can this list be different order, do we need to follow the order specifically? but yes while entering the values the order must follow the data types of the columns. 4) how to store values of different types, lets say for True I want to store 1, and false 0, can we use type cast and store these?
1. By default, when the length is not specified in the schema definition stage, it accepts any lengths until 255 characters. 2.This will be covered in the later sessions. (Dynamic data masking) 3. The values will be inserted in the same order as per the schema while creating the table. However, by listing the columns explicitly while inserting, the respective values will be inserted as per the order mentioned. 4. This would be covered later. Follow along and you will learn all the necessary concepts of SQL.
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.
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.
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 ?
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.
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?
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
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 :)
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...
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');
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 ?
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?
Hello Sir, thanks for the SQL sessions. They seem to be absolutely helpful. I had one query related to Insert multiple tables: We can give the values for first,middle,last names and so on but what if there is one data where there is no middle name and we have inserted values as (first name, middle name, last name, age, salary, location). The one date which doesn't have a middle name will throw an error if we run it for multiple tables? Kindly let me know on this. Thanks 😊
u can assign middle name as a unique key for all tables .Second option set it as a default option -->A or B .Third set it as null while defining the table
checkout the Big Data course details here: trendytech.in/?referrer=youtube_sql3
sir from where we can download notes of these lectures
@@madhurajsingh9463 notes mile bhai ?
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
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 💖💖👍👍
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.
Awesome sir
Very soon I will part of your big data course.
Amazing sir
Even fresher like me is understanding
Happy to hear that you are able to grasp the concepts much easily.
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. 🙏
Glad that you are finding the session useful :)
The way you explain and cover topics, anyone will fall in love with learning Sir!!😇😇
Thanks Sameer, that is really kind of you.
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 🙏🙏
Happy that you have found the series insightful. Noted your suggestions, will consider incorporating it in the upcoming sessions. :)
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
Thank you sumit sir , I am actually learning SQL the right and easy way .
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.
Thank you sir. It's very easy n simple to learn the way you have explained the basics concepts.
Your explanation is Crystal Clear Sir!Having a great time listening to this playlist.Tq sir!!
very well articulated content, though I know these concepts hearing from you again is so good. Thank you !
Glad to hear that :)
Wonderful session sir. You taught us as explicitly today as you always do.🙏
Happy that you found the session interesting :)
Hi Sir, this is amazing 💯!Here's a small request for you to kindly cover more topics in a session.
Considering the huge audience base, I have tried to balance the amount of content in each session without losing out on the attention of the viewers.
@@sumitmittal07 agreed
Amazing, Very Helpful. Always Excited for next lecture.
Awesome Sumit Sir, your videos make me so inspirational
It is very Useful for me as a Beginner
Its is quiet an amazing way to learn the RDBMS....Thumps Up To you sumit sir
Sir you ,you explain in very simple way
sir your lectures are very helpful.
It will be much more easy for us if we can get notes and query you write in session in discription .
I try to check if I can share the notes. Will do so wherever possible.
Sir, you will make everyone fall for any subject you teach. :)
That's really kind of you :)
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. :)
Humbled that my efforts are being noticed and appreciated :)
This is amazing explanation with so much of ease....super like..thanks for putting this across
Thank you sir for explaining the things in very simple yet effective way!
Learning this in order to get enrolled in your course.
That's wonderful session...
CRUD concept was explained very well
Happy that you found the session helpful and easy to understand.
thankyou so much sir your session is very helpful🙏
Nice way of teaching ,waiting for more lectures.
Wonderful session. The way of teaching is very interesting
Glad you liked it, Keep watching :)
NICE! Content quality is too good sir , APPRECIATE!!!!!
Very well buildup video on SQL.thanks Sir
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 .
Glad that you are finding it easy to understand.
Sir once again thank you for emboldening our careers. I have few questions to ask:
1) In case we need to store values in string data type and we want it to accept any lengths until 255 characters so that dynamically it can accommodate any lengths then can we write that?
2) Salary is something like private information, can we mask it while storing those values in database? can it be stored as a masked value? or we this encryption should be done in later stage?
3) while using insert stmnt, if again we declare the list of columns, can this list be different order, do we need to follow the order specifically? but yes while entering the values the order must follow the data types of the columns.
4) how to store values of different types, lets say for True I want to store 1, and false 0, can we use type cast and store these?
1. By default, when the length is not specified in the schema definition stage, it accepts any lengths until 255 characters.
2.This will be covered in the later sessions. (Dynamic data masking)
3. The values will be inserted in the same order as per the schema while creating the table. However, by listing the columns explicitly while inserting, the respective values will be inserted as per the order mentioned.
4. This would be covered later.
Follow along and you will learn all the necessary concepts of SQL.
@@sumitmittal07 Thank you very much for clearing the doubts sir :)
Best Regards,
Aditya
This is one of the amazing playlist that I have ever found...💖💖🤞🏻🤞🏻
bro from where i can get these lecture notes please reply
@@madhurajsingh9463 I created the notes by my self.
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.
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.
Hi sir the way you explain was very amazing thankyou
very good session
thank you Sumit sir
Very good explanation sir thank you so much
Great Tutorial, Sir❤
Good one to go
Really liked the session.
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 ?
Good Quality Teaching
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.
Thank you sir for SQL series
Thanks sir ji for this amazing content
Thanks sir for wonderful session again.
Keep watching and keep learning :)
Please upload more lecture. Waiting eagerly for them
Bundle of Thanks Sir Jee
Thanks a lot sir👍😊
very insightful learning
Wonderful session sir..🙏
Hi ,Sumith exellent Explanation....
The content and your way of teaching is really easy to understand .Where can I find your notes for quick revision?
Glad that you are finding the content easy to understand. I would advice to make notes alongside while watching the sessions.
Nice explanation sir
Well explained!
Thank you🙌
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?
Really Helpful Thank you sir
excellent sir!!!
Fantastic
Thank you, sir.🙂
Well structured lecture presented thankyou sumit💞
Happy that you are liking it :)
Really interesting session sir , thank you .
I like you work and thanks for effort
excellent
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
very well content
Thank you for this series. Is it possible to share the document where you write all the queries ?
Wonderful session sir ..
🙏
Great sir
Sir , how do you clear goorm IDE terminal I did not find shortcut..
Great video Sir!
thank u sir
amazing session.
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 :)
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...
awesome session
Glad that you are finding the session helpful.
Hi Sir, Request to create a video on Data modelling and Schemas
Rhanks a lot❤
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');
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 ?
Thank you sir for this wonderful video.
Sir also i have a question that how can we delete a single row on a table?
Thanks its working
Thank you for sessions. How do you clear screen ?
Thank you.
well defined
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?
and thank you for replay sir you are great
Can anyone help me with, which software is sir using for recording screen?
update delete is not shown how can u say its done?
Sir what is a difference between desc and select command ?
Pls share link of entire series.....Thank you !
Awesome
How to come out of DB? like we use USE DB statement to use the DB
Hello Sir, thanks for the SQL sessions. They seem to be absolutely helpful.
I had one query related to Insert multiple tables:
We can give the values for first,middle,last names and so on but what if there is one data where there is no middle name and we have inserted values as (first name, middle name, last name, age, salary, location).
The one date which doesn't have a middle name will throw an error if we run it for multiple tables?
Kindly let me know on this.
Thanks 😊
u can assign middle name as a unique key for all tables .Second option set it as a default option -->A or B .Third set it as null while defining the table
How to insert and retreive C++ structure into VARCHAR(255) datatype?