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.
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
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.
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
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
Ur way of presentation is really excellent u helped me alot thankyou so much
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!
Thank you ma'am....make more such videos ❤😊
Mam really appreciable videos
CRYSTAL Clear, Thank you madam
yah! true.
Hlo
Your video helped me to clear my BTech
madam .excellent madam.amazing .........thank u madam..
❤❤super mam nice understanding 🎉
really you are great teacher thank you more we have earn a lot of knowledge frome you.
thanku maam .....it is very easy language in easy words
Really greate vedio thank u mam
Madam your helpful allah bless you 💖
It is useful.so please continue ur teaching mam
Very clear explaination mam... thankyou
Your explanation is very good
Thank you ma'am. I was able to complete my assignment
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
I love your handwriting. Great tutorial.
Hlo
@@yamunadolu5684 hai
@@abhiramlinga8899 hii
@@yamunadolu5684 wt else
@@abhiramlinga8899 u tamil
Tqq mam .... Tqq so much mam🤗🤗
Hii
I love you so much yamuna dolu 🤗🤗
Madam ur explanation is good.
Would u plz make videos on SAS basic program.
Nice explanation madam
Hi Mam, could you please upload the notes, would be great helpful. Thanks Much
Ss mam
No
you are an amazing teacher thanks a lot, one day if I have a job I will pay for your manicure :)
wonder full teacher love your class ..george
Hlo
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
In introduction of ddl, we don't modify the data but the structure, columns and data type.
studio.th-cam.com/channels/vMmkKL1ZKXWPv1xMEZ1NXw.html
Thank you, you help me soo much
while creating the table we are using int . instead of using int we can use number datatype.......
In SQL we don't use int we use only number data type
Desc also ddl command ... Nice video
Grt work..got information abt sql
Please do not teach wrong. Create table command contains curly braces?
Nice impramiaction mam
In the `Employee` table ,phonenumber should be Integer instead of char!Thankyou❤
instead of using int . you can use number datatype.....
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)
Thank so much mam ji 🙏🙏🙏👌👌👌👌👌🙏🙏🙏🙏🙏
very helpful..really appreciate it
This is so amazing
God bless you, you solved my issues
Really helpful!!!
good Explanimation...medam. where is TCLC Command...
THANK YOU MAM 😊 🙏❤
Good and neat explanation
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.
Mam pls... Adjust camera properly... As the page is not properly visible
Thanks you so much mam
Aapko kinta time laga usko achhe se samjh ne ke liye
Thank u so much mam for this amazing lacture😊
hii
( )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
Describe command explain cheyled mam ddl type
Hii
Hiii
@@yamunadolu5684 hi
I am egyptian and I idore your writing way in explanation
studio.th-cam.com/channels/vMmkKL1ZKXWPv1xMEZ1NXw.html
😂😂😂
clear concept,,,
Mam can you please tell me about how to solve quarries in bbms
Thanks mam
It will help me tomorrow
Me too
Nice it is very helpful for me. Thanks mam.
Mam Coloum ki jagah attribute BHi likh skte h na
Yes
You missing one command TCL- Transaction control Language
😂
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
( ) mam these type of brackets are a better option
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
When we use char and varchar what is deferent between two commands
thank you for this!
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
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.
But in creating table phone number should be int how varchar will come?
Same doubt?
due to curly brackets its giving error......in create command rather it should be a
circular bracket.
Hi mam, can you please suggest any online classes for analog digital electronics and for cosm .
Else please upload those vedios please mam
Thanks 👍
You missing one command TCL-transaction control language
Mam Only 3 commands we have in SQL??!!!
thank you
Primary key is missing in create one i thought
why dont u make it practical mam?
Thanks ma'am
Mam phone number is integer data type no mam u wrote varchar
mam your teaching is very vell but excute syntax in sql software please mam
Nice
Thanks mem
Column name , data types write within a parenthesis ... Not in a braces...
Mam's phone num is int or varchar
What type of datatype use
Tq mam
You're from Kerala??
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
Miru chepedhi notes ga rasuko vacha, dhini examlo raya vacha
Thankyou mam
Tq somuch
over all your lec is good and easy to understand
thank u madam
Structured qUuAaArRiEeye language.. 😇
Mam phone number is not a varchar
Phone number is integer
What about flashback and purge in DDL ..??
Tnx miss
Hii
U tamil
Best
Question kis type ka atta he in this question pe
Where's DQL and TCL it's gone to where 😂😂😂😂😂😂
It is used ful interview also
thanks mam
😘✋ writing