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.
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
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
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 😃
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??
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
00:02 ALTER command is used to change the structure of a schema in SQL. 01:46 Using ALTER command to add or remove columns in SQL tables. 03:24 Proper privileges required for altering column or datatype 04:55 Using ALTER command in SQL for modifying tables in Oracle 06:29 Using ALTER command to add and drop columns in a table. 08:08 Using ALTER command to modify column datatype and length in Oracle 09:44 The ALTER command in SQL can be used to add, drop, modify, and rename table columns and names. 11:24 The ALTER command in SQL allows us to add, drop, modify, and rename columns and tables, as well as apply constraints
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.
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.
can anyone tell where is the create command video.....sir talked about it in this video.....but its not there in the playlist.....a seperate video for create 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 ruclips.net/video/Nsv0MX3IDJE/видео.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
ruclips.net/video/eWFrau_sE34/видео.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.
I recommend this playlist to everyone so that he/she can get benefit of sir's efforts
Sir.. U put so much efforts.. Thank u very much.. May God bless you with all the happiness you want 😊
Such an amazing explaination. You deserve teacher of the year award!
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 :)
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
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
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
Best channel for best understanding
Thanks sir for teaching in such a wonderful way.... Salute to u sir.... Hats off for ur efforts.... Thanks a lot....
Love the way you teach us..Thank you so much sir ji..🙏🙏
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: ruclips.net/video/Nsv0MX3IDJE/видео.html
there is a little mistake while arranging the play list
create table video is the last video in this sql playlist(24 videos) .
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✊
ruclips.net/video/eWFrau_sE34/видео.html🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻
This channel deserves million of views and subscribers also ❤❤❤
Thanks 😊
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
mein toh fan ho gya bs aapka ...
Kya Gajab padhate ho sir aap .....
You are a great teacher in RUclips ❤️
I agree with you
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 😃
beautfully explained the way u teach is superb example r awsome as an unknow can undrstand thnks a lot sir
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??
Bigggg thank uuuu sirrrrr🎉🎉
Love from PAKISTAN
You are an outstanding teacher 😇😇😇😇😇😍😍😍😍😊😊😊😊
Sir u r the best teacher I have ever seen🥰🥰♥️
Thank you soo much sir.. your lectures are awesome.. Because of u my interest in dbms is increased.
thank you soo much you are the best teacher in the world🥰🥰
Really you put a lot effort in videos. No words to say. Thanks a lot sir.
Sir aapki videos ne exam mein kaafi help ki #thank you ,sir
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.
Waw fantastic teaching way.... Lots of thx sir 🙏
Thank you so much sir for making such kind of helping video.
Hi Varun i am following u r videos last 2 months on words... It is very useful to me. Thanks once again Varun u are Rock man.....
If our college teachers starts teaching like you!!!!!!!!🙂🙂
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
00:02 ALTER command is used to change the structure of a schema in SQL.
01:46 Using ALTER command to add or remove columns in SQL tables.
03:24 Proper privileges required for altering column or datatype
04:55 Using ALTER command in SQL for modifying tables in Oracle
06:29 Using ALTER command to add and drop columns in a table.
08:08 Using ALTER command to modify column datatype and length in Oracle
09:44 The ALTER command in SQL can be used to add, drop, modify, and rename table columns and names.
11:24 The ALTER command in SQL allows us to add, drop, modify, and rename columns and tables, as well as apply constraints
Gurujee shandar jabardast zindabaad
Thanku for wonderful tutorials
Keep Helping us by your videos...👌
Is there any command or keyword to see what tables we have in the database?
And what columns those tables have in them?
Sir apki video bahut helpfull h....
Thanku so much sir🙏🙏
Please provide the link for detailed videos of SQL commands
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.
May God bless u with happiness u want....thnkk u so much varun sir....🙏🙏🙏🙏🙏
Create command video is not there. Please put the link to that video. Thanks!
sir please make a video on difference among mySql, oracle, Microsoft server, mongo db
the way you teache is simply awesome.
can you please share us video on how install the platform your using
Mashallah style of teaching too good
You are such a good teacher bro. God Bless you.
Sir thank you so much to teache me so well...You are the very very best teacher .sir...Thanks from heartly
Thank you sir for practical knowledge 🙏🙏🙏
Sir you are grate tutor..
Hattts offf to ur knowledge... love from pakistan💞
Such a best explanation u have given 😌😌
great teaching methodology sir
thanks for this great content from Pakistan
Outstanding 👏
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
What about pgadmin and postgreSQL..
Sir plz make videos on all SQL command as soon as possible
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.
sir,, can u tell me how i download this ORACLE database software
Yeah same question. I also need to know. Have you found any solution?
would you please make a playlist on computer architecture and organization, like that
so good way which u tech sir and explain in easy way
sir really won many hearts
Sir Your SQL topic is uniqu unique
very fine teaching..thank you
Sir SQL pe jaldi jaldi vidio banaeye sir ap bahoot bariya se explain krte ho thanks sir
your teaching style really impressive. can you please guide the lecture reference on create as you mentioned in this video as previous lecture.
it is very helpful in my exam 🤗🤗🤗
thankuu sir 👼
Thanks sir.
It is very helpful.
Full explained, and brief , all clear❤️
You are greate and very brilliant
Great teaching way thank you very much sir.
Great Tutorial.
sir please tell me what is this software name
splendid teaching bhai
Sir plz upload a video on Versions of oracle and it's characteristics.
God Bless You Sir Ji
maza aa gya understood
Mujhe dbms nhi smajh me aata tha, aapne sara confusion clear kar diya sir
can anyone tell where is the create command video.....sir talked about it in this video.....but its not there in the playlist.....a seperate video for create command
At the last of the playlist
ruclips.net/video/eWFrau_sE34/видео.html
ASSALAM.U.ALAIKUM Thanks SIR ALLAH PAK BLESS YOU AND ALL YOUR FAMILIES AND ALL HUMANITY AMEEN.
Jay shree ram 🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩
Thanks alot sir very helpful for my exam.
Awesome explanation..👌👍
Great Explanation
Thanku soo much sir.. it's help me alot 😊
Create ka vedio kahan h play list m to h nahi
Sir, Can you please tell where is the lecture of create command, I couldn't find it.
Yaaaaa thanks sir verry very very best explanation sirrrr
i can't thank u even bcoz how much I'm grateful to you i can't explain
Awesome thanks 👍
Create command ki video nhi dali hai sir..
Thank u so much sir
Good explanation ❤
seeing this amazing person from Pakistan
Thanks
this is amazing sir more videos upload in DDL DQL
Thank you so much sir 🙏🙏