*T I M E S T A M P S* for the students who have their practicals :D 13:00 creating a table using wizard 22:55 creating a table using design view also, thank you so much ma'am for this really simple and informative video, tomorrow is my practical for IT and it would mean a lot to me if you wished me luck :)
Thankyou mam for this wonderful video 💕Mam one doubt-In how many ways tables can be created? This is a question mentioned after session 2.So we need to write 2 or 3(includes via SQL)
Mam Agar video Sath ke sath hi Dekhe na to maja bahut Aata Hai matlab Ek lecture ke bad Agla lecture I like your videos too much ma'am and I got 23 out of 25 marks in term 1 because of you
mam 's favourite names - neha,nisha,soniya,pooja,priyanka😄but you teaching is very very excellent. feeling immensely grateful to have a great teacher like you
Ma'am I have a doubt. You have used VARCHAR in Neha's address but wrote 'sector 14'. Ma'am how are we able to use numbers in VARCHAR? Ma'am please help me out.
Greetings!! I am in class X 2022-2023..I'll be appearing for boards this year. Since IT 402 has been a very scoring subject (teachers and all senior's they claim this fact) Now,to be specific enough - Part A which is easy to deal with can be done easily and on the other hand part B has 4 chapters but all of them are quite complex but for scoring well we need to do that too. Please tell that what all do ne need to do to score the 100/100 in this subject. In my school " Vaishali Sharma" the fundamentals of Information technology is being used. If we will do the entire back exercises,that consists of (application based q+ fill ups+ true/false+ long and short question answers) And as you had said in your video that you have specially made important questions for all the part B chapters. If we are doing #Back exercises+# imp q Will we crack the exam with full marks? If not than what else to do ...or this much is okay? Pls revert. Regards,
Vasa too... Learn nahi karna... Par app Apni field ko dekh kar pata ka sakto... Hoo 😮which data type is.... Use foe ex- Name - ma Aphabhat ha to text .... Agar mathematics number likna ha to integer... And so on...
Mam you are very special one ....... You have the power to teach i.t. in very easy way that no-one can.......And I want to thank you a lot......What can I say I don't know.....but It's my pleasure to probe your channel since term 1 exam.........💜💜
Good evening mam... ❤️ I want to ask you do we have to remember the further sub types of data types? Like in numeric data type do we have to learn all the sub parts like boolean, interger, smalint etc. Is it asked in the exams? Btw your explanations are superb mam 🔥💕✌️
It is a datatype in SQL which is used to store character string of variable length but a maximum of the set length specified. If the length of the string is less than set or fixed-length then it will store as it is without padded with extra blank spaces. The storage size of the VARCHAR datatype is equal to the actual length of the entered string in bytes. We should use this datatype when we expect the data values in a column are of variable length.
Mam always take ex. Of names like Neha, Nisha, Pooja, Soniya and priyanka those names get set in my mind😜 When I was doing practical I remember only those names😜😂😂
Ma'am,I have a question If i want a field name by using wizard to create table that is not available in available field. Is it possible to create a new field name
Yes, we can do that.. In the first step, after selecting inbuilt fields, click on next button, In step 2, (Set Types and Format) In selected Field option, you will find + and - buttons at the bottom, use + button, to add the field , which is not already available..and fill the field information on the RHS
*T I M E S T A M P S*
for the students who have their practicals :D
13:00 creating a table using wizard
22:55 creating a table using design view
also, thank you so much ma'am for this really simple and informative video, tomorrow is my practical for IT and it would mean a lot to me if you wished me luck :)
Glad it helped...
Best Wishes for your exam..
@@SwatiChawlaofficial
thank you ma'am :D
@@SwatiChawlaofficial ma'am does this steps will come in theory paper also
....??
Thank you for the time stamps dude tomorrow is my IT practical..
@@swaramahadik4573
hope it goes amazing
Best channel for IT.
Thanku
ma'am do we have to learn numeric data types description of it's all types for term 2??
Best teacher i found for IT subject
Thanks
Best explanation in TH-cam with practical
Thanku so much..
A great help u had been provided mam thank you 💐💐💐🙂
Thanks and Welcome..
Ma'am you are awesome , soon your channel will have millions of subscribers.
Thank you so much for your blessings...
Keep watching..
Plz subscribe and share this channel with others too...
Mam thanks for this video.. these video is very helpful for us...☺️
Most welcome 😊
Maam, thanks for this amazing video. It cleared our all doubts..😊
My pleasure 😊
Thankyou mam for this wonderful video 💕Mam one doubt-In how many ways tables can be created? This is a question mentioned after session 2.So we need to write 2 or 3(includes via SQL)
Hi 13:25 it's written that there are 2 WAYS!hope this helps
Mam do we need to learn these all data types like boolean, and for numeric and alphanumeric etc .
Mam please reply if someone wanna score full.!????
Yes
Mam I have suggested this channel to my whole class
Thanku so much 🙏🏻😊
Mam ,I had understood IT first time
Thank you so much ❤
Welcome
I GOT TO LEARN SO MUCHHH THANK YOU FOR TEACHING IS
US*
Most Welcome...
Keep watching
Mam will these steps come in theory paper???
Can come
mam ne paper banaya hai
Who is here for 1st term board exam
Mam Agar video Sath ke sath hi Dekhe na to maja bahut Aata Hai matlab Ek lecture ke bad Agla lecture I like your videos too much ma'am and I got 23 out of 25 marks in term 1 because of you
That's Great..
Thanku..
Congratulations 👏🎉
mam 's favourite names - neha,nisha,soniya,pooja,priyanka😄but you teaching is very very excellent. feeling immensely grateful to have a great teacher like you
Thanks a lot 😊
Yes .. 😀 One more in this group...i.e. Swati..
Or group name : N2P2S2 😀😀
Nice video mam it helped me clear my doubt
Thanks
@@SwatiChawlaofficial welcome mam
Thanks
great job 🙏
Welcome
Thankx Teacher👩🏫👩🏫👩🏫👩🏫👩🏫
Welcome
Thank you So much ma'am
Your videos provide us with great Help😊
It's my pleasure
Thank you mam 😊 thanks a lot , great chapter explanation ✨
Most welcome 😊
Thanks ma'am for the best explanation with practical ❤️
Welcome
Mam ye term 2 ke liye hai na?
Yes
Very helpful 👌
Thanku
Thankyou mam ❤
Welcome
7:40 ROLL NO. IS ALWAYS A NATURAL NUMBER ( 1 TO ♾️) . NOT INTEGER BEACAUSE IT NEVER INCLUDES 0 or -tive numbers.
Poppy
25:57
Mam choose decimal in marks
Is 100 a decimal no. ??
Please tell
Decimal data type have unlimited range
Thankyou So much ❤
You're welcome
Will step based question will be asked in board examination 2024@@SwatiChawlaofficial
Mam NUMERIC and DECIMAL data type
Ki unlimited range hoti hei
Thanku so much mam great explanation 😍😘❤
Ma'am will the question come like write the steps to create table? Matlab kya steps likhne wale ques. Aayenge?
Ha koi batio na
Superb explanation 💯🤟
Thanks 🙂
THANK U SO MUCH DIDI
Most Welcome
Thank you so much mam 🙏🙏
Welcome
Thanks mam 🙏
Welcome
Ma'am I have a doubt. You have used VARCHAR in Neha's address but wrote 'sector 14'. Ma'am how are we able to use numbers in VARCHAR? Ma'am please help me out.
Varchar data type accept all types of characters: alphabets, numbers and even special characters also
@@SwatiChawlaofficial Thanks a lot ma'am for clearing my doubt...
Greetings!!
I am in class X 2022-2023..I'll be appearing for boards this year. Since IT 402 has been a very scoring subject (teachers and all senior's they claim this fact)
Now,to be specific enough -
Part A which is easy to deal with can be done easily and on the other hand part B has 4 chapters but all of them are quite complex but for scoring well we need to do that too.
Please tell that what all do ne need to do to score the 100/100 in this subject.
In my school " Vaishali Sharma" the fundamentals of Information technology is being used.
If we will do the entire back exercises,that consists of
(application based q+ fill ups+ true/false+ long and short question answers)
And as you had said in your video that you have specially made important questions for all the part B chapters.
If we are doing
#Back exercises+# imp q
Will we crack the exam with full marks?
If not than what else to do ...or this much is okay?
Pls revert.
Regards,
th-cam.com/video/ZKbK8VdwSws/w-d-xo.html
Mam in libre office also steps are same to create table or adding queries ?
Before seeing your video the ch was difficult but now it seems to be easy. Thank u so much for such good explanation 😊
Thanks and Welcome
I want tuition from you
Mam pratical phone Mai ho sakta hai
thank u mam
Welcome
Mam will the steps related questions come in our exams ????????
i dont have open office can i use libre office ?
Yes
ma'am does this steps will come in theory paper also??
or this was only for practical?
i hope they won't come
@@manaswinikataria381 same here
@@gudu7928 most important questions are waiting for you
@@goldenfuntime4555 matlab?
@@gudu7928 visit
THANK YOU MAAM
Welcome
18:37 mam u said adm. No and adhar card no would be same for everyone 🤣🤣
It would be different...
Sorry for inconvenience caused
No prob mam 😊
Mam do we also need to learn the description of datatypes for term 2 exams?.....pls tell mam
No....
Vasa too... Learn nahi karna... Par app Apni field ko dekh kar pata ka sakto... Hoo 😮which data type is.... Use foe ex- Name - ma Aphabhat ha to text .... Agar mathematics number likna ha to integer... And so on...
are u from odisha?🤨
Report or Form koi baata do
@@NPS001 mam ki video deklo... Sachi ma bro... Clear ho jaya ga.....
Dhanyavad Didi
Welcome
, a command is a specific order from a user to the computer's operating system or to an application to perform a service
Maam once can you pls explain float
it is used for decimal values.....
52.65 , 75.2 etc..
Thanku Maam
do we have to learn the description of numeric and other data types for examination like boolean varchar nd all??
[please reply i hv my exam tomorrow]
Yes...if possible..just go through it..
Mam you are very special one ....... You have the power to teach i.t. in very easy way that no-one can.......And I want to thank you a lot......What can I say I don't know.....but It's my pleasure to probe your channel since term 1 exam.........💜💜
Thanks and Welcome
25:57
Mam choose decimal in marks
Is 100 a decimal no. ??
Please tell
Mam does these step come in board exams??
Mam iske notes. Provide kar dijiye. Because my school. Examination. Is nearer. Please mam answer kijiye
🙏🙏
Sure..You can enjoy special perks by joining the membership.
Have a look at this.
th-cam.com/channels/2vH9rqGh-fJELF8acGfBdw.htmljoin
Mam date time datatype ko binary ya numeric datatype me include nhi kar sakte
No
Mam is it necessary to add a primary key in the table created in open office when we use wizard to create table ?
Yes
Mam please make videos using sql please 😮
Already Uploaded..
Plz check out this complete playlist..
Database Management System: th-cam.com/play/PL5Raijva2y4QEsOPmhKXuK1__yKzkuc4e.html
@@SwatiChawlaofficial thanks mam I'm very thankful to you 🥰🥰
Welcome
@@SwatiChawlaofficial mam what you have any idea for term 1 result when it is updated 😮
I think...
Mid of Jan..
But no official announcement by CBSE yet..
👍👍🏽👍🏾👍🏿👍🏼👍🏻👍
👍
Mam can we write 'char' data type for any type type of data
Good evening mam... ❤️ I want to ask you do we have to remember the further sub types of data types?
Like in numeric data type do we have to learn all the sub parts like boolean, interger, smalint etc. Is it asked in the exams?
Btw your explanations are superb mam 🔥💕✌️
Yes you do
Please tell why sometimes table created in database is not shown in edit mode.
Mam should we learn these types of datatypes
Yes
Superb vedio
Thanku..
Mam pls do a vdo regarding project
Ok
Yes please, I also have to complete that
ThankU
Welcome
mam can you create a video that what all praticals can come in 10 th
Class 10 IT Practical File and Project: th-cam.com/play/PL5Raijva2y4TQaZGstHVqu5nXjno8Uwoz.html
as the roll no is set as primary key so if we try to repeat a roll number,what will happen?
It will display an error message
Utkarsh shukla are u there bro from satyas school ikauna
ma'am can you please make the video of how to save database
Database Management System: th-cam.com/play/PL5Raijva2y4QEsOPmhKXuK1__yKzkuc4e.html
Ma'am , jo tables hum DESIGN VIEW se create karenge usme AUTO VALUE ka option kaise add hoga
From properties option
Ma am
What is field in DBMS
Please tell
Columbs
How to access connection type in DBMS from edit menu.. Plzz help
13:00
Op explainaction
Thanku
@@SwatiChawlaofficial thanks to you mam🥰🥰
@@SwatiChawlaofficial mam your explanation is really really awesome 🥰🥰
What is VARCHAR IN DATA TYPE
It is a datatype in SQL which is used to store character string of variable length but a maximum of the set length specified. If the length of the string is less than set or fixed-length then it will store as it is without padded with extra blank spaces. The storage size of the VARCHAR datatype is equal to the actual length of the entered string in bytes. We should use this datatype when we expect the data values in a column are of variable length.
Mam please make video using sql command
For which class 10 or 12??
Mam class 10
Pleas
Bas
Database Management System: th-cam.com/play/PL5Raijva2y4QEsOPmhKXuK1__yKzkuc4e.html
13:32
1 hr before pre boards 💀
All the best 😀
Excuse me mam . Just want to ask field option is used to both create file and create file by wizard
Mam I this will work in liberal office
Yes
smash❤🔥❤🔥❤🔥❤🔥❤🔥❤🔥❤🔥❤🔥❤🔥
Mam always take ex. Of
names like Neha, Nisha, Pooja, Soniya and priyanka those names get set in my mind😜
When I was doing practical I remember only those names😜😂😂
Ma'am,I have a question
If i want a field name by using wizard to create table that is not available in available field. Is it possible to create a new field name
Yes, we can do that..
In the first step, after selecting inbuilt fields, click on next button,
In step 2, (Set Types and Format)
In selected Field option, you will find + and - buttons at the bottom, use + button, to add the field , which is not already available..and fill the field information on the RHS
Thank you ma'am for the information
Mam make a vidio on using sql command and supper ,alternet keys for class 10th pleassssssssss
Already uploaded...
Plz check out the playlist
Database Management System: th-cam.com/play/PL5Raijva2y4QEsOPmhKXuK1__yKzkuc4e.html
Mam in this video only using wizard and design view are available
th-cam.com/video/aPVIgOgDHoI/w-d-xo.html
Thank you man thanxxxxxxxxxx
Welcome
Mam please provide notes of these lectures in pdf
Please check out the description of the video
Question Answer kab kaevare ma'am
Soon..
Video recorded..only uploading left..
@@SwatiChawlaofficial ma'am tommorow is my pre-board i haven't study dbms what should I do
@@tejaschaudhary6469 just try to watch all d videos...and understand d concepts
Ma'am please change your music in starting and in intro if topic
But this video only has DESIGN and WIZARD VIEW. where are the SQL commands?
Database Management System: th-cam.com/play/PL5Raijva2y4QEsOPmhKXuK1__yKzkuc4e.html
yay yay whateveer
Ma'am mera kal exam hai mene pdf pdaha lekin firbhi samajh nahi araha :cry:
Where u r having doubt?
@@SwatiChawlaofficial sql commands and reports
Reports topic is easy..
For sql commands..just understand the syntax.. and try to execute practically... It needs practice
can someone tell me the explanation of auto value I don't understand hindi(no offence to mam)
If we set the Auto increment property of any field, then its value will get incremented by one automatically, for each record...
Mam your clothes are more expensive then h&m
😃😃
In my windows 10 there is no open office database wizard
How to open plz help
install it
Me
Will step based question will be asked in board examination 2024 @swatichawla
Thankyou very much mam
Welcome