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
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
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)
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.
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.
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
Ur way of presentation is really excellent u helped me alot thankyou so much
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
Madam you have good speaking skills mam please continue vedios mam full SQL fabulous teaching skills
Incredible! So simple to understand! You must be a teacher! Ty!
Your video helped me to clear my BTech
Thank you ma'am....make more such videos ❤😊
thanku maam .....it is very easy language in easy words
CRYSTAL Clear, Thank you madam
yah! true.
Hlo
Mam really appreciable videos
really you are great teacher thank you more we have earn a lot of knowledge frome you.
Really greate vedio thank u mam
madam .excellent madam.amazing .........thank u madam..
❤❤super mam nice understanding 🎉
Very clear explaination mam... thankyou
Madam your helpful allah bless you 💖
It is useful.so please continue ur teaching mam
I love your handwriting. Great tutorial.
Hlo
@@yamunadolu5684 hai
@@abhiramlinga8899 hii
@@yamunadolu5684 wt else
@@abhiramlinga8899 u tamil
Your explanation is very good
Great work, it's simple clean and clear to understand 👏
Yes 🙏
Purge is a command and it's used to delete data from database permanently
Thank you ma'am. I was able to complete my assignment
Hi Mam, could you please upload the notes, would be great helpful. Thanks Much
Ss mam
No
In introduction of ddl, we don't modify the data but the structure, columns and data type.
studio.th-cam.com/channels/vMmkKL1ZKXWPv1xMEZ1NXw.html
you are an amazing teacher thanks a lot, one day if I have a job I will pay for your manicure :)
Madam ur explanation is good.
Would u plz make videos on SAS basic program.
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
Nice explanation madam
When we use char? When we use varchar?
Pls reply ma'am
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)
Tqq mam .... Tqq so much mam🤗🤗
Hii
I love you so much yamuna dolu 🤗🤗
In SQL we don't use int we use only number data type
In the `Employee` table ,phonenumber should be Integer instead of char!Thankyou❤
instead of using int . you can use number datatype.....
You missing one command TCL- Transaction control Language
😂
Thank you, you help me soo much
( )only this bracket is allow in dbms. u r taking { } is it right ?
studio.th-cam.com/channels/vMmkKL1ZKXWPv1xMEZ1NXw.html
Yea ( ) brackets a re used in DBMS
Thank you. But I didn't understand what's the difference between char and varchar.
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.
Thank so much mam ji 🙏🙏🙏👌👌👌👌👌🙏🙏🙏🙏🙏
I don't think phone number should be in varchar i think it's in int.
it makes sense to be a varchar because you will not do any mathematical operations with the number.
We have to use varchar2
Varchar2 will take alphabet and no. Also
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.
while creating the table we are using int . instead of using int we can use number datatype.......
Thanks mam
It will help me tomorrow
Me too
Nice it is very helpful for me. Thanks mam.
wonder full teacher love your class ..george
Hlo
good Explanimation...medam. where is TCLC Command...
( ) mam these type of brackets are a better option
Mam can you please tell me about how to solve quarries in bbms
Mam Coloum ki jagah attribute BHi likh skte h na
Yes
Thank u so much mam for this amazing lacture😊
hii
God bless you, you solved my issues
When we use char and varchar what is deferent between two commands
Aapko kinta time laga usko achhe se samjh ne ke liye
But in creating table phone number should be int how varchar will come?
Same doubt?
Desc also ddl command ... Nice video
Hi mam
I want SQL software application installing my system .
Me 2. Bro can u help me in installing I am studying polytechnic 2nd year
Hlo
very helpful..really appreciate it
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
due to curly brackets its giving error......in create command rather it should be a
circular bracket.
Mam pls... Adjust camera properly... As the page is not properly visible
I am egyptian and I idore your writing way in explanation
studio.th-cam.com/channels/vMmkKL1ZKXWPv1xMEZ1NXw.html
😂😂😂
What about flashback and purge in DDL ..??
Nice impramiaction mam
Describe command explain cheyled mam ddl type
Hii
Hiii
@@yamunadolu5684 hi
Hi mam, can you please suggest any online classes for analog digital electronics and for cosm .
Else please upload those vedios please mam
Mam Only 3 commands we have in SQL??!!!
mem aap ne create command me dadatype int use kiya hai wha pr kya number nhi lik sakte hai
Grt work..got information abt sql
Column name , data types write within a parenthesis ... Not in a braces...
Primary key is missing in create one i thought
Good and neat explanation
THANK YOU MAM 😊 🙏❤
You're from Kerala??
Really helpful!!!
This is so amazing
Miru chepedhi notes ga rasuko vacha, dhini examlo raya vacha
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
studio.th-cam.com/channels/vMmkKL1ZKXWPv1xMEZ1NXw.html
You missing one command TCL-transaction control language
Question kis type ka atta he in this question pe
What is varchar mam?
Mam phone number is integer data type no mam u wrote varchar
Mam's phone num is int or varchar
What type of datatype use
Can we write all the commands in the same line?
yes ofc
mam your teaching is very vell but excute syntax in sql software please mam
It is used ful interview also
Last me delete wale command me
( Dml) kha se aa gya
Can we use varchar R number in place of int and char
No
Mam schema ke bare me koi vdo ha.muze schema ke types smjne hai. External conceputal and internal
why dont u make it practical mam?
mam , what about TCL Commands ?
Transfer control language
@@devanshuyadav1691, I have asked commands not the fullform
studio.th-cam.com/channels/vMmkKL1ZKXWPv1xMEZ1NXw.html
Dear mam in Playlist there is no videos of Sql can you please provide me the link to access entire videos of SQL
studio.th-cam.com/channels/vMmkKL1ZKXWPv1xMEZ1NXw.html
Mam phone number is not a varchar
Phone number is integer
What is database?
Where is TCL ?
What about TCL
thank you for this!
Madam revoke and grand missing mam
Structured qUuAaArRiEeye language.. 😇
Thanks you so much mam
Where's DQL and TCL it's gone to where 😂😂😂😂😂😂
Is this Tammanna Chhabra?
Why we using varchar instead of using int in phone number column
I think u forgot truncate command
Can I get notes
Today is computrr 's exam