Тёмный

DDL : CREAT, DROP | SQL Commands 

Education 4u
Подписаться 901 тыс.
Просмотров 708 тыс.
50% 1

DDL commands i.e CREAT, DROP

Опубликовано:

 

20 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 226   
@lovelifeatfullest
@lovelifeatfullest 2 года назад
People will appreciative if you reply their questions instead of ignoring them. Many are Board exam students including myself, so it helps a lot which you should understand as a teacher
@srinukolla7566
@srinukolla7566 2 года назад
Madam you have good speaking skills mam please continue vedios mam full SQL fabulous teaching skills
@dheerajrajmistry3383
@dheerajrajmistry3383 5 лет назад
Ur way of presentation is really excellent u helped me alot thankyou so much
@larahporter8123
@larahporter8123 5 лет назад
Incredible! So simple to understand! You must be a teacher! Ty!
@prachigupta3496
@prachigupta3496 4 года назад
Mam really appreciable videos
@ankitrajput6790
@ankitrajput6790 4 года назад
Your video helped me to clear my BTech
@Anonymous-rb4uh
@Anonymous-rb4uh 5 месяцев назад
Thank you ma'am....make more such videos ❤😊
@messihumelkamu5871
@messihumelkamu5871 2 года назад
really you are great teacher thank you more we have earn a lot of knowledge frome you.
@saivenkatabharathyadavb2482
@saivenkatabharathyadavb2482 2 месяца назад
❤❤super mam nice understanding 🎉
@malli.c6581
@malli.c6581 4 года назад
madam .excellent madam.amazing .........thank u madam..
@sanjaygyara7638
@sanjaygyara7638 5 лет назад
CRYSTAL Clear, Thank you madam
@captainjacksparrow690
@captainjacksparrow690 3 года назад
yah! true.
@yamunadolu5684
@yamunadolu5684 3 года назад
Hlo
@monikadubey1238
@monikadubey1238 Год назад
thanku maam .....it is very easy language in easy words
@KiranKumar-yc2tz
@KiranKumar-yc2tz 2 года назад
Purge is a command and it's used to delete data from database permanently
@dk2602
@dk2602 2 года назад
Really greate vedio thank u mam
@umuanas634
@umuanas634 4 года назад
Madam your helpful allah bless you 💖
@tejaswinimallavarapu1979
@tejaswinimallavarapu1979 2 года назад
Your explanation is very good
@nathannathan7987
@nathannathan7987 3 года назад
It is useful.so please continue ur teaching mam
@poojakukreti8618
@poojakukreti8618 4 года назад
In introduction of ddl, we don't modify the data but the structure, columns and data type.
@sunilsahoo1113
@sunilsahoo1113 4 года назад
studio.ru-vid.com/show-UCvMmkKL1ZKXWPv1xMEZ1NXw
@maazahmedshariff3148
@maazahmedshariff3148 5 лет назад
Great work, it's simple clean and clear to understand 👏
@Princess-mr6zx
@Princess-mr6zx 2 года назад
Yes 🙏
@rachelpaulraj593
@rachelpaulraj593 3 года назад
Very clear explaination mam... thankyou
@MASTAN-oz3fp
@MASTAN-oz3fp Год назад
while creating the table we are using int . instead of using int we can use number datatype.......
@teddy93010
@teddy93010 3 года назад
Thank you ma'am. I was able to complete my assignment
@knandi73
@knandi73 Год назад
Please do not teach wrong. Create table command contains curly braces?
@sandeepkamlekar4002
@sandeepkamlekar4002 3 года назад
Madam ur explanation is good. Would u plz make videos on SAS basic program.
@abdulshakoor4794
@abdulshakoor4794 5 лет назад
Mam main ny abi 2 lecture ap k sony hn achy lagy hn kuch samj b aya ha ddl ka so baki b acha samj ata raha to m subscribe kr diya ha chenal or kaheen problem i to ap sy pochu ga. But agr response na mila to phar ap achi teacher ni kahlain ge or m ap ka subscriber
@dileepachari2571
@dileepachari2571 2 года назад
When we use char? When we use varchar? Pls reply ma'am
@437pavankalyan2
@437pavankalyan2 6 месяцев назад
when the name is having fixed length in that time we can use char, where as in the name is not fixed that means if user entering the name some ones name contains 4 characters and some ones name more than 4 characters in that time.. the length is not fixed..so we can use the varchar(varying)
@yasfurtado1583
@yasfurtado1583 6 лет назад
Thank you, you help me soo much
@h.rehaief3567
@h.rehaief3567 5 лет назад
you are an amazing teacher thanks a lot, one day if I have a job I will pay for your manicure :)
@thommandrunagendra6817
@thommandrunagendra6817 4 года назад
Hi Mam, could you please upload the notes, would be great helpful. Thanks Much
@sivadsiva1666
@sivadsiva1666 2 года назад
Ss mam
@vomeshpunia3680
@vomeshpunia3680 Год назад
No
@yamunadolu5684
@yamunadolu5684 3 года назад
Tqq mam .... Tqq so much mam🤗🤗
@yamunadolu5684
@yamunadolu5684 3 года назад
Hii
@yamunadolu5684
@yamunadolu5684 3 года назад
I love you so much yamuna dolu 🤗🤗
@Fatma-so1jv
@Fatma-so1jv 5 лет назад
Thank you. But I didn't understand what's the difference between char and varchar.
@susansamuel835
@susansamuel835 5 лет назад
The char is a fixed-length character data type, the varchar is a variable-length character data type. Because char is a fixed-length data type, the storage size of the char value is equal to the maximum size for this column. ... You can use char when the data entries in a column are expected to be the same size.
@GoFredBananass
@GoFredBananass 5 лет назад
I love your handwriting. Great tutorial.
@yamunadolu5684
@yamunadolu5684 3 года назад
Hlo
@abhiramlinga8899
@abhiramlinga8899 3 года назад
@@yamunadolu5684 hai
@yamunadolu5684
@yamunadolu5684 3 года назад
@@abhiramlinga8899 hii
@abhiramlinga8899
@abhiramlinga8899 3 года назад
@@yamunadolu5684 wt else
@yamunadolu5684
@yamunadolu5684 3 года назад
@@abhiramlinga8899 u tamil
@allcutieshere7837
@allcutieshere7837 Год назад
In SQL we don't use int we use only number data type
@muskii30
@muskii30 3 года назад
Mam Coloum ki jagah attribute BHi likh skte h na
@1minstatus989
@1minstatus989 3 года назад
Yes
@habteabghebrehiwot2592
@habteabghebrehiwot2592 2 года назад
God bless you, you solved my issues
@sandhyabashyal8493
@sandhyabashyal8493 2 года назад
In the `Employee` table ,phonenumber should be Integer instead of char!Thankyou❤
@MASTAN-oz3fp
@MASTAN-oz3fp Год назад
instead of using int . you can use number datatype.....
@mansinandgaonkar8492
@mansinandgaonkar8492 2 года назад
Mam pls... Adjust camera properly... As the page is not properly visible
@indrajitmukherjee8707
@indrajitmukherjee8707 4 года назад
Really helpful!!!
@tanayawarade3515
@tanayawarade3515 4 года назад
due to curly brackets its giving error......in create command rather it should be a circular bracket.
@sasivardhanreddykummetha1377
@sasivardhanreddykummetha1377 5 лет назад
why DO we use INT COMMAND WE CAN use NUMBER COMMAND on above functionality when your placing such data type u can use number data type its easy to process
@zubers58
@zubers58 5 лет назад
Grt work..got information abt sql
@sanjanabista9113
@sanjanabista9113 4 года назад
very helpful..really appreciate it
@mohanlucky7514
@mohanlucky7514 Год назад
When we use char and varchar what is deferent between two commands
@mikechibuye2081
@mikechibuye2081 3 года назад
This is so amazing
@vaishnavirajgure922
@vaishnavirajgure922 5 лет назад
( )only this bracket is allow in dbms. u r taking { } is it right ?
@sunilsahoo1113
@sunilsahoo1113 4 года назад
studio.ru-vid.com/show-UCvMmkKL1ZKXWPv1xMEZ1NXw
@Preethamvarma338
@Preethamvarma338 3 года назад
Yea ( ) brackets a re used in DBMS
@Just.feelthemoment
@Just.feelthemoment 3 года назад
But in creating table phone number should be int how varchar will come?
@Andrewtate200
@Andrewtate200 Год назад
Same doubt?
@yashikasharma6683
@yashikasharma6683 2 года назад
( ) mam these type of brackets are a better option
@YogeshPatil-lb1on
@YogeshPatil-lb1on 2 года назад
Aapko kinta time laga usko achhe se samjh ne ke liye
@virendrajaiswar7871
@virendrajaiswar7871 6 лет назад
Mam can you please tell me about how to solve quarries in bbms
@internationelworld1510
@internationelworld1510 2 года назад
good Explanimation...medam. where is TCLC Command...
@infinitynature6620
@infinitynature6620 3 года назад
Hi mam, can you please suggest any online classes for analog digital electronics and for cosm . Else please upload those vedios please mam
@ahmedsurat
@ahmedsurat 3 года назад
Desc also ddl command ... Nice video
@georgemathai1686
@georgemathai1686 4 года назад
wonder full teacher love your class ..george
@yamunadolu5684
@yamunadolu5684 3 года назад
Hlo
@niy444
@niy444 10 месяцев назад
thank you for this!
@Nani-np4rq
@Nani-np4rq 2 года назад
Nice explanation madam
@harish205
@harish205 5 лет назад
Good and neat explanation
@balu7928
@balu7928 Год назад
Mam Only 3 commands we have in SQL??!!!
@namitas.9424
@namitas.9424 4 года назад
Thanks mam It will help me tomorrow
@prithviraj6420
@prithviraj6420 4 года назад
Me too
@gt2341
@gt2341 3 года назад
Nice it is very helpful for me. Thanks mam.
@rakeshbarick5429
@rakeshbarick5429 3 года назад
You missing one command TCL- Transaction control Language
@partha2695
@partha2695 8 месяцев назад
😂
@pratikneupane8787
@pratikneupane8787 6 лет назад
I don't think phone number should be in varchar i think it's in int.
@danielamaria1465
@danielamaria1465 5 лет назад
it makes sense to be a varchar because you will not do any mathematical operations with the number.
@azeemuddin7100
@azeemuddin7100 5 лет назад
We have to use varchar2 Varchar2 will take alphabet and no. Also
@asheeshkumar1424
@asheeshkumar1424 5 лет назад
I think you are going to run some mathematical query with phone number i.e. list numbers ending in xx or starting from yy and ending to xx. or list number having xyz in middle of the numbers.
@naveenr663
@naveenr663 4 года назад
Hi mam I want SQL software application installing my system .
@jayakrishnach4346
@jayakrishnach4346 3 года назад
Me 2. Bro can u help me in installing I am studying polytechnic 2nd year
@yamunadolu5684
@yamunadolu5684 3 года назад
Hlo
@shravyaananthula9781
@shravyaananthula9781 2 года назад
Mam phone number is integer data type no mam u wrote varchar
@abhiramlinga8899
@abhiramlinga8899 3 года назад
Describe command explain cheyled mam ddl type
@yamunadolu5684
@yamunadolu5684 3 года назад
Hii
@yamunadolu5684
@yamunadolu5684 3 года назад
Hiii
@abhiramlinga8899
@abhiramlinga8899 3 года назад
@@yamunadolu5684 hi
@chandrashekark4491
@chandrashekark4491 2 года назад
Mam's phone num is int or varchar What type of datatype use
@MoinAnsari-s2r
@MoinAnsari-s2r 7 месяцев назад
Primary key is missing in create one i thought
@suryavathisuryavathi4571
@suryavathisuryavathi4571 2 года назад
Nice impramiaction mam
@titarexguruop
@titarexguruop 4 года назад
Thanks you so much mam
@pinkisalvi3076
@pinkisalvi3076 4 года назад
mem aap ne create command me dadatype int use kiya hai wha pr kya number nhi lik sakte hai
@smitabhagat5927
@smitabhagat5927 3 года назад
Thank u so much mam for this amazing lacture😊
@AryanGupta-uj9mo
@AryanGupta-uj9mo 2 года назад
hii
@abdulshakoor4794
@abdulshakoor4794 5 лет назад
But boht acha samj aya ha sbi tak thank you so much g. But ek problem i wo ya k change and rename ke query ni lagi g
@sunilsahoo1113
@sunilsahoo1113 4 года назад
studio.ru-vid.com/show-UCvMmkKL1ZKXWPv1xMEZ1NXw
@PGDCASujataVardhan
@PGDCASujataVardhan 3 года назад
Thank so much mam ji 🙏🙏🙏👌👌👌👌👌🙏🙏🙏🙏🙏
@naturelover1431
@naturelover1431 2 года назад
THANK YOU MAM 😊 🙏❤
@softbd2k192
@softbd2k192 4 года назад
clear concept,,,
@mynameisschool4857
@mynameisschool4857 6 лет назад
Mam schema ke bare me koi vdo ha.muze schema ke types smjne hai. External conceputal and internal
@khasimas3880
@khasimas3880 5 месяцев назад
Thanks 👍
@luckymusicprajuchannel7882
@luckymusicprajuchannel7882 Год назад
You missing one command TCL-transaction control language
@sathishnaidu670
@sathishnaidu670 Год назад
What about flashback and purge in DDL ..??
@pandu6275
@pandu6275 Год назад
Miru chepedhi notes ga rasuko vacha, dhini examlo raya vacha
@rakshakp696
@rakshakp696 2 года назад
Please put like class 1, class2 then only we can found easily otherwise it is difficult to find for freshers because we don't no about sql then how can we found this is class1 or class 2
@hebatoallahnasser7702
@hebatoallahnasser7702 5 лет назад
I am egyptian and I idore your writing way in explanation
@sunilsahoo1113
@sunilsahoo1113 4 года назад
studio.ru-vid.com/show-UCvMmkKL1ZKXWPv1xMEZ1NXw
@HariSrikanth-
@HariSrikanth- 3 года назад
😂😂😂
@ajaytalwar8603
@ajaytalwar8603 6 лет назад
Column name , data types write within a parenthesis ... Not in a braces...
@MandisaKhanyile93
@MandisaKhanyile93 10 месяцев назад
thank you
@devendranreddy122
@devendranreddy122 2 года назад
Tq somuch
@suryavathisuryavathi4571
@suryavathisuryavathi4571 2 года назад
Tq mam
@ashokdonthi9802
@ashokdonthi9802 3 года назад
mam your teaching is very vell but excute syntax in sql software please mam
@kunju.mp3799
@kunju.mp3799 Год назад
Structured qUuAaArRiEeye language.. 😇
@x_onkya174
@x_onkya174 3 года назад
Question kis type ka atta he in this question pe
@shaikmadarsa482
@shaikmadarsa482 2 года назад
Thanks mem
@mrudula1189
@mrudula1189 2 года назад
Mam phone number is not a varchar Phone number is integer
@captainjacksparrow690
@captainjacksparrow690 3 года назад
why dont u make it practical mam?
@positivity798
@positivity798 9 месяцев назад
Nice
@AbhiRam-nb2tg
@AbhiRam-nb2tg 2 года назад
Phone number is integer value
@adityashubham9034
@adityashubham9034 6 лет назад
Thanks ma'am
@RahulKumar-be9eg
@RahulKumar-be9eg 5 лет назад
Dear mam in Playlist there is no videos of Sql can you please provide me the link to access entire videos of SQL
@sunilsahoo1113
@sunilsahoo1113 4 года назад
studio.ru-vid.com/show-UCvMmkKL1ZKXWPv1xMEZ1NXw
@fr7260
@fr7260 5 лет назад
Can we write all the commands in the same line?
@amirhamzah6146
@amirhamzah6146 3 года назад
yes ofc
@ruqaiyyapatel8769
@ruqaiyyapatel8769 2 года назад
It is used ful interview also
@dindeeshwaridansena4972
@dindeeshwaridansena4972 2 года назад
What is varchar mam?
@ghufranulhaq4375
@ghufranulhaq4375 6 лет назад
over all your lec is good and easy to understand
@dindeeshwaridansena4972
@dindeeshwaridansena4972 2 года назад
Thankyou mam
@rakeshbarick5429
@rakeshbarick5429 3 года назад
DDL DML TCL DCL
Далее
DDL : ALTER, RENAME & TRUNCATE | SQL Commands
13:26
Просмотров 281 тыс.
Распаковка Monster High Potions №4
00:46
Просмотров 67 тыс.
dml in sql with examples
17:45
Просмотров 299 тыс.
JOINS IN SQL (with example )
8:46
Просмотров 614 тыс.
Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
28:34
dcl commands in sql with examples | GRANT, REVOKE |
10:05