For SQL practice, you can go to @t. They have over 500 SQL exercises and interview questions from real companies. Their platform is free but you can use discount code gatesmashers for 15% off their premium features at @t
00:02 The ALTER command in SQL is used to make changes to an existing table's structure 01:46 The ALTER command in SQL is used to make changes in the table structure. 03:24 The ALTER command in SQL is used to add, remove, or modify columns and datatypes 04:55 The ALTER command in SQL is used to add, remove, and rename columns and tables. 06:29 The ALTER command in SQL is used to modify tables, such as adding or dropping columns. 08:08 The ALTER command in SQL allows us to modify the datatype and length of columns in a table. 09:44 The ALTER command in SQL is used to add, drop, modify, or rename columns and tables. 11:24 ALTER Command in SQL can be used to add, drop, modify, rename columns or tables, as well as add constraints.
Thank you so much sir for making my concepts more clear. I was tensed how will I be able to study this subject as our teacher in college doesn't teaches properly she used to directly give queries and tell us to solve and I was completely blank but you made it so much crystal clear just loved ur explaining method 😃
You have made sql super easy to learn. Thank you so much. I was struggling in getting the concepts clear. After watching & execution along side , I feel that I am a pro at it now . Really helpful :)
Sir , Aap toh Kota Factory web series ka RDBMS Wala Jeetu Bhaiya baan chuke ho. On serious note , These videos are extremely helpful for IT professional like me who wants to understand more on SQL and RDBMS .Thank you
Sir, your teaching is awesome ! I have a question, if we apply "Alter" command to modify column/delete column. it wont affect to existing data ?? Example if we reduce the size from Varchar(30) to 20.
kal Mera exam hai aur mai abhi syllabus shuru kar rahi hu ,sir ke help se pass hojaungi lagta hai but bohoth saal phele ke videos, bohot piche chal rahe hai kher knowledge toh knowledge hoti hai kabhi bekar nahi jati , thankyou sir for your valuable time
Sir these videos are genuinely helpful for the beginners. Ur commitment and hard work with minutest detail DBMS is really appreciable. I want to do a certification course in SQL , hope this will help me in that also. Regards
Hello I have doubt at 9:00 of this lecture whole we are modifying the datatype so the value entered already are in int so it doesn’t affect it?? For example we modified id to varchar and the already existing data in id contain numbers so how it doesn’t affect??
Why haven't you put the create command video in this playlist. There are so many videos that are in your channel related to DBMS but not in this playlist.
Hey i have a doubt , you have told earlier that we will use semi colon in the last sentence only but when u have shown the implementation , u have given semi colon after each command after create table , then alter table add column command and then drop column command also . Could u please specify the use of semi colons again and again ? Also please clarify the use of brackets in the syntax of the commands and not using the same brackets in the actual command when we write . How so ? Those brackets thing is really confusing me
When he told earlier it was in the case of create table where u are giving all specifications of the table.The whole thing he wrote there was an entire SQL command.The ; is mandatory when u finish the whole command.Here sir is giving separate commands for each task he performs so he provided ; in each of them in the end.As the create table command is very long and these are short that's where u got confused.Don't worry, just remember that the ; always comes at the end of each command.
For SQL practice, you can go to @t. They have over 500 SQL exercises and interview questions from real companies. Their platform is free but you can use discount code gatesmashers for 15% off their premium features at @t
I haven't find the video of create command
sir link ni hai./ for sql command practice
Sir pl. provide the full link. For @t there's showing nothing on google..
@@avinashthakur2485 th-cam.com/video/Nsv0MX3IDJE/w-d-xo.html
Dml and dcl commands ki video h hi nhi???
someone give him an award .. you teach so well.
...And get this man *an award.*
You are right
Really in short time.
Right dear
th-cam.com/video/eWFrau_sE34/w-d-xo.html🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻
00:02 The ALTER command in SQL is used to make changes to an existing table's structure
01:46 The ALTER command in SQL is used to make changes in the table structure.
03:24 The ALTER command in SQL is used to add, remove, or modify columns and datatypes
04:55 The ALTER command in SQL is used to add, remove, and rename columns and tables.
06:29 The ALTER command in SQL is used to modify tables, such as adding or dropping columns.
08:08 The ALTER command in SQL allows us to modify the datatype and length of columns in a table.
09:44 The ALTER command in SQL is used to add, drop, modify, or rename columns and tables.
11:24 ALTER Command in SQL can be used to add, drop, modify, rename columns or tables, as well as add constraints.
Sir.. U put so much efforts.. Thank u very much.. May God bless you with all the happiness you want 😊
I recommend this playlist to everyone so that he/she can get benefit of sir's efforts
there is no create table implementation in your last video, about which video are you talking? I started with SQL playlist. kindly reply.
EXACTLY
I ALSO HAD SAME QUERY KINDLY REVERT BACK SIR
Yes sir , there is no create query video. Please review it and provide that video.
Thank You.
yaa same here.No create table video
creat command link: th-cam.com/video/Nsv0MX3IDJE/w-d-xo.html
there is a little mistake while arranging the play list
create table video is the last video in this sql playlist(24 videos) .
Best channel for best understanding
Such an amazing explaination. You deserve teacher of the year award!
Thank you so much sir for making my concepts more clear. I was tensed how will I be able to study this subject as our teacher in college doesn't teaches properly she used to directly give queries and tell us to solve and I was completely blank but you made it so much crystal clear just loved ur explaining method 😃
Every semester some indian guy always safe me love from pakistan❤️
First learn some english bro, then come and learn SQL
@@obviousness251 English is just a language dont take it so hard bro😉
Sorry man, but it would only help u, I don't have a problem
@@obviousness251 He's in Pakistan ! English won't help
@@ujjwalbhardwaj5595 huehuehue
You have made sql super easy to learn. Thank you so much.
I was struggling in getting the concepts clear. After watching & execution along side , I feel that I am a pro at it now . Really helpful :)
This so helping. Hats off to you sir. Respect🙏🏻
Sir , Aap toh Kota Factory web series ka RDBMS Wala Jeetu Bhaiya baan chuke ho.
On serious note , These videos are extremely helpful for IT professional like me who wants to understand more on SQL and RDBMS .Thank you
Thank you so much for your love and support
mein toh fan ho gya bs aapka ...
Kya Gajab padhate ho sir aap .....
Sir, your teaching is awesome ! I have a question, if we apply "Alter" command to modify column/delete column. it wont affect to existing data ?? Example if we reduce the size from Varchar(30) to 20.
kal Mera exam hai aur mai abhi syllabus shuru kar rahi hu ,sir ke help se pass hojaungi lagta hai but bohoth saal phele ke videos, bohot piche chal rahe hai kher knowledge toh knowledge hoti hai kabhi bekar nahi jati , thankyou sir for your valuable time
I love your lecture.Simply awesome !
I don't know why but after seeing you I think Chhole is your fav dish.
Thank you so much 😀 yes its my favorite
Is there any command or keyword to see what tables we have in the database?
And what columns those tables have in them?
Love the way you teach us..Thank you so much sir ji..🙏🙏
Thanks sir for teaching in such a wonderful way.... Salute to u sir.... Hats off for ur efforts.... Thanks a lot....
beautfully explained the way u teach is superb example r awsome as an unknow can undrstand thnks a lot sir
Sir these videos are genuinely helpful for the beginners. Ur commitment and hard work with minutest detail DBMS is really appreciable. I want to do a certification course in SQL , hope this will help me in that also.
Regards
Please provide the link for detailed videos of SQL commands
can you please share us video on how install the platform your using
You are an outstanding teacher 😇😇😇😇😇😍😍😍😍😊😊😊😊
Hello I have doubt at 9:00 of this lecture whole we are modifying the datatype so the value entered already are in int so it doesn’t affect it??
For example we modified id to varchar and the already existing data in id contain numbers so how it doesn’t affect??
You are a great teacher in TH-cam ❤️
I agree with you
This channel deserves million of views and subscribers also ❤❤❤
Thanks 😊
Sir u r the best teacher I have ever seen🥰🥰♥️
Thanku for wonderful tutorials
Bigggg thank uuuu sirrrrr🎉🎉
Love from PAKISTAN
Why haven't you put the create command video in this playlist. There are so many videos that are in your channel related to DBMS but not in this playlist.
I just kept the Book away and Watching this whole playlist(Currently i'm on 46/72😉) for my Placement preparation in B.Tech.
ThankYou.
All the best for your placements..bless you
@@GateSmashers Thanks
@@Mojemoye all the best
Even I am but for University exam great job @varun singla gate smashers rock✊
th-cam.com/video/eWFrau_sE34/w-d-xo.html🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻
Sir you are grate tutor..
thank you soo much you are the best teacher in the world🥰🥰
What about pgadmin and postgreSQL..
You are greate and very brilliant
Waw fantastic teaching way.... Lots of thx sir 🙏
Mashallah style of teaching too good
Create command video is not there. Please put the link to that video. Thanks!
I'm following this playlist to complete my outline of DBMS but I the list I can't found the CREAT Command in DDL. sir plzzzz m ake a solution
Sir aapki videos ne exam mein kaafi help ki #thank you ,sir
sir really won many hearts
very fine teaching..thank you
Sir Your SQL topic is uniqu unique
God Bless You Sir Ji
Thank you so much sir for making such kind of helping video.
Really you put a lot effort in videos. No words to say. Thanks a lot sir.
sir please make a video on difference among mySql, oracle, Microsoft server, mongo db
Is it complete SQL tutorial?
Thank u so much sir
Gurujee shandar jabardast zindabaad
Thanks
maza aa gya understood
Sir, Can you please tell where is the lecture of create command, I couldn't find it.
Sir plz make videos on all SQL command as soon as possible
Thank you soo much sir.. your lectures are awesome.. Because of u my interest in dbms is increased.
Great Tutorial.
Hi Sir, hope you are doing good .
Please let me know if i want to go for MySql rather then oracle , is it fine ?
the way you teache is simply awesome.
Keep Helping us by your videos...👌
your teaching style really impressive. can you please guide the lecture reference on create as you mentioned in this video as previous lecture.
while altering table we have to write table and tableName and in column colname
so good way which u tech sir and explain in easy way
Happy Birthday Sir 🎂
Yaaaaa thanks sir verry very very best explanation sirrrr
nicely explained ! but cant find CREATE lecture .please guide
Amazing videos I guess best among all tutorials of SQL
Thanks a ton
@@GateSmashers sir i need help to download and install the oracle interface you were using.
A download link would be helpful too.
For table we add column for that we want to give values how we give
Great Explanation
You are such a good teacher bro. God Bless you.
Sir
Why should I use varchar where only char can be used?
splendid teaching bhai
where you discuss about create command
would you please make a playlist on computer architecture and organization, like that
Mujhe dbms nhi smajh me aata tha, aapne sara confusion clear kar diya sir
Thanks sir
May God bless u with happiness u want....thnkk u so much varun sir....🙏🙏🙏🙏🙏
great teaching methodology sir
thanks for this great content from Pakistan
Thank you so much sir 🙏🙏
Sir apki video bahut helpfull h....
Thanku so much sir🙏🙏
Thanks sir.
It is very helpful.
how to insert data in a newly created column in the existing SQL table please sir
Great teaching way thank you very much sir.
Awesome thanks 👍
Sir thank you so much to teache me so well...You are the very very best teacher .sir...Thanks from heartly
Hey i have a doubt , you have told earlier that we will use semi colon in the last sentence only but when u have shown the implementation , u have given semi colon after each command after create table , then alter table add column command and then drop column command also .
Could u please specify the use of semi colons again and again ?
Also please clarify the use of brackets in the syntax of the commands and not using the same brackets in the actual command when we write . How so ? Those brackets thing is really confusing me
When he told earlier it was in the case of create table where u are giving all specifications of the table.The whole thing he wrote there was an entire SQL command.The ; is mandatory when u finish the whole command.Here sir is giving separate commands for each task he performs so he provided ; in each of them in the end.As the create table command is very long and these are short that's where u got confused.Don't worry, just remember that the ; always comes at the end of each command.
Good explanation ❤
Please make a video on installation of Oracle express edition.
Outstanding 👏
Sir can you also please describe how to install this program for windows
Thank you sir for practical knowledge 🙏🙏🙏
bhaiya isse video ki tarah saare sql pdha do please phle theory firr implementation
Professional Technology
Create ka vedio kahan h play list m to h nahi
Sir SQL me bhi ise apply kr sakte hai
Kya gazab sir ..
Thanku sir ji
sir when u are adding or droping the data by using alter the process is happening in row but u r sayin in column pls clarify it
please tell me ,Oracle or sql server 2019 managment studio ,which are batter??