Important Questions of MYSQL | MYSQL Commands | Class 12 Computer Science Python

[@thinkoutofbox7985]

Thank u so much best computer teacher ever seen ....🙏

[@SwatiChawlaofficial]

Glad to hear this... Most welcome

[@joemamas_girlfriend]

you're the best tbh wow what an explanation !!

[@SwatiChawlaofficial]

Thanks a lot 😊

[@sudhirchandra1085]

Thank you ma'am I was able to solve all the questions myself.... It was all possible because of your lectures which included detailed explanation and concept clarification 🙏🏼

[@nitankotwal7693]

mam you are the best computer teacher ...................😘😘

[@SwatiChawlaofficial]

Thanku so much...🙏🏻😊

[@aishanasim1900]

Thanku mam...😊....Mam you are so much consistent about your work.... I like it mam👍

[@SwatiChawlaofficial]

Thanku beta...

[@aishanasim1900]

Welcome mam😊

[@nitikanegi6092]

Thank you so much mam...u r the best🤗🤗

[@SwatiChawlaofficial]

Most welcome 😊

[@iamsashanksahil]

Dhanaywad mam🙏 I was having doubts related to DDL and DML... Now all clear🔥 Mam ek last doubt hai... Mam date format YYYY/MM/DD hai na? Because at 14:02 the StartDate column of resort table format is YY/M/DD and M is in name... So if this format is there then what is the clause/statement for it?

[@SwatiChawlaofficial]

Both methods are correct... check out this..it will help u..to understand the concept better. mysql> create table DS -> (NNAME varchar(12), -> DOB date); Query OK, 0 rows affected (1.14 sec) mysql> insert into DS values('aaa','1990-8-8'); Query OK, 1 row affected (0.21 sec) mysql> select * from ds; +-------+------------+ | NNAME | DOB | +-------+------------+ | aaa | 1990-08-08 | +-------+------------+ 1 row in set (0.00 sec) mysql> insert into DS values('aaa','1991/7/8'); Query OK, 1 row affected (0.17 sec) mysql> select * from ds; +-------+------------+ | NNAME | DOB | +-------+------------+ | aaa | 1990-08-08 | | aaa | 1991-07-08 | +-------+------------+ 2 rows in set (0.00 sec) mysql> insert into DS values('aaa','99-8-9'); Query OK, 1 row affected (0.16 sec) mysql> select * from ds; +-------+------------+ | NNAME | DOB | +-------+------------+ | aaa | 1990-08-08 | | aaa | 1991-07-08 | | aaa | 1999-08-09 | +-------+------------+ 3 rows in set (0.00 sec) mysql> insert into DS values('aaa','20-8-9'); Query OK, 1 row affected (0.18 sec) mysql> select * from ds; +-------+------------+ | NNAME | DOB | +-------+------------+ | aaa | 1990-08-08 | | aaa | 1991-07-08 | | aaa | 1999-08-09 | | aaa | 2020-08-09 | +-------+------------+ 4 rows in set (0.00 sec) mysql> insert into DS values('aaa','22-8-9'); Query OK, 1 row affected (0.06 sec) mysql> select * from ds; +-------+------------+ | NNAME | DOB | +-------+------------+ | aaa | 1990-08-08 | | aaa | 1991-07-08 | | aaa | 1999-08-09 | | aaa | 2020-08-09 | | aaa | 2022-08-09 | +-------+------------+ 5 rows in set (0.00 sec)

[@iamsashanksahil]

@@SwatiChawlaofficial ok mam... Thank You mam🙏

[@utpalm9453]

@@SwatiChawlaofficial words are short to describe your contribution .....👏

[@viraltrendz9378]

Mam I have seen you have replied each and every comment. Hatts off to you mam 🙏🙏

[@SwatiChawlaofficial]

Thanku so much...

[@abhijith7359]

I am for sure that you will reach '100' sub "dream" on 2nd April when we write CS board exam❤❤❤

[@neh95]

Thank u soo much mam loved it

[@SwatiChawlaofficial]

Most Welcome

[@draunzer8429]

Mam in the resort and ownedby table's question in its part 1 can we write" where type like 5 star" instead of "where type = 5 star"????

[@jayashree5537]

Mam by your videos I can easily understand the computer science chapters😊.

[@SwatiChawlaofficial]

Great....Thank u... Keep watching...

[@VardhanMittal]

@@SwatiChawlaofficial yes mam

[@SwatiChawlaofficial]

Thanku...🙏🏻😊

[@Arpitaasharnaa]

Aap ke pass computer thi class 12 me agr thi to plz batana computer me acha score kese kre ...plz I really need help

[@unicorn-cv1ex]

Best teaching style

[@SwatiChawlaofficial]

Thanku...🙏🏻😊

[@muneerpathan9301]

I like your video before starting 👍

[@SwatiChawlaofficial]

Thank you so much 😀

[@aayushjoshi3079]

Thank you ma'am for making such Amazing Videos only these helped me to understand the concepts

[@ashishathakur5977]

Thanks Swati maa'm🙂👍🏻

[@SwatiChawlaofficial]

Welcome

[@chandrakumarsahare5989]

Mam please tell me that:- count (*) will be given in ,count (*), Like this only yes!.... So my question is......... For which column we will count the values I cant able to understand this only Butttt other alll superb mam, U are tooo great, Teaching very nicely👍👍👍👍👍👍 I used to see only your videos for computer science It helps me too much....... Only please clear my doubt🙇🙇

[@SwatiChawlaofficial]

Thanku for appreciating... If only count(*) will be given.. Like Select count(*) from tablename; It will count the total number of rows in that table.

[@chandrakumarsahare5989]

I understand that mam But if it asked Like Select Doc,Count (*),Name from Document; then.... We shall count that haw many have same document and we will count same document..... Yes?

[@chandrakumarsahare5989]

Or we will count the same name???

[@SwatiChawlaofficial]

then also....count(*) column will display value of total number of rows..

[@chandrakumarsahare5989]

Mam but as U have taught in this lecture, no personal count (*) coulumn is there then.......

[@khushaldahiya9717]

First comment..... Best teacher ♥️😎

[@aishanasim1900]

Yes sure best teacher ❤️

[@SwatiChawlaofficial]

Thank you so much 😀

[@AjmiraRehman]

best content 💞

[@SwatiChawlaofficial]

Thanks

[@treasure_life]

Mam you are doing great work for us thank you so much🥺🙏🏻

[@SwatiChawlaofficial]

Most Welcome..🙏🏻😊 Keep Watching 👍🏻

[@aryantyagi5480]

Mam 20 min 20 sec p jo question h last part wala usme hm query - "select type,owner from resort,owned by where resort place equal owned by.place and resort.type equal 5 star." aise bhi likh skte h

[@Tech12345]

Awsm maam 🙏

[@SwatiChawlaofficial]

Thanku.... Keep watching..

[@harshbhandari733]

U R SUPERB MAM

[@SwatiChawlaofficial]

thanku...

[@saurabhkumarsingh7516]

Thank You Ma'am 😊

[@SwatiChawlaofficial]

Welcome

[@BlaBla-ol8cm]

Thanks mam its very useful

[@SwatiChawlaofficial]

Welcome 😊 Keep Watching

[@udaykiran9556]

Thanks maam🙏

[@SwatiChawlaofficial]

Welcome

[@sarakalbhor915]

Very helpful

[@SwatiChawlaofficial]

Thanks

[@KhushiBisht-cx1th]

Mam why you not used update command at in part 5 of ques no. Where table given trainer and course.bonus vala ques

[@Brijkirasoi.]

Thank you so much mam

[@SwatiChawlaofficial]

Most welcome 😊

[@HarshitYadav-e5e]

Mam u teaching style and all is good but please provide pdf notes

[@SwatiChawlaofficial]

*Hey, now you can avail all these notes at the discounted rate….* *Class - X Information Technology* * Employability Skills (Notes) - X rzp.io/l/1mcA8UL * Employability Skills (Ques Ans) - X rzp.io/l/2hxw8tY6N * NCERT Solutions of CBSE Class 10 IT 402 rzp.io/l/fKUADxvbv * Unit - 1 Digital Documentation Advanced using LibreOffice rzp.io/l/GUhTNcTpH * Unit - 2 Electronic Spreadsheet Advanced (using LibreOffice) rzp.io/l/PpBEONKRN * Unit - 3 DBMS (based on LibreOffice Base) rzp.io/l/XJrYs2P * Unit - 4 Managing Health and Safety rzp.io/l/TQWvwOa *Class 11 Computer Science (083)* * Python rzp.io/l/cKflR95C *Class 12 Computer Science (083)* * Computational Thinking & Programming - 2 rzp.io/l/wihJhPBO * Computer Networks rzp.io/l/OKWrgua * Database Management rzp.io/l/z0mu2uBVu * Assertion and Reasoning rzp.io/l/TgngGDjb *IMPORTANT : After successful payment, don't refresh or go back (Redirecting...... will be shown on screen) , just wait for a while, and then Click on Request Access button, then you will get access to notes on your G-Mail ID within 24 hours.*

[@anitajangde9612]

THANKS ma'am

[@SwatiChawlaofficial]

Welcome

[@akshaysmathszone9040]

Thank you mam for this video as it really help in my exams.!

[@SwatiChawlaofficial]

Glad to hear that Keep watching..

[@abhithakur245]

Nice way of teaching ..mam ❤️ Please provide the pdf of these lectures...🙏🙏 I shall be highly obliged to you ❤️

[@SwatiChawlaofficial]

Sure... You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@utpalm9453]

U r just awesome

[@SwatiChawlaofficial]

thanku...

[@axomiyapathshala5161]

Thank you very much ma'am

[@SwatiChawlaofficial]

Welcome....🙏🏻😊

[@healthfitness6139]

Mam can u make a marks distribution of each chapter video👀🙏

[@SushilKumar-ex5nl]

Your like to dislike ratio is 🔥🔥🔥

[@SwatiChawlaofficial]

Yes....Noticed just now....Thanks for bringing it into my notice... :)

[@AnuragSingh-fw1gk]

570:12 =285:6

[@rehbarsiddiqui3570]

Mam how many output based questions are asked in boards class 12

[@Aves7]

thanks mam ye sari pdf kaha milegi

[@SwatiChawlaofficial]

Sure..You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@CMD_King_]

Mam aliasing me kahi as lagate hai or kahi sirf " " me likhte hai 🤔🤔

[@SwatiChawlaofficial]

Both are correct

[@CMD_King_]

@@SwatiChawlaofficial ok ma'am. Thank you ma'am 💯

[@nikitakumari5272]

Please upload the link of notes in description box.

[@shiwanisingh8818]

A relation has 45 tuples & 5 attributes, what will be the Degree & Cardinality of that relation? i. Degree 5, Cardinality 45 ii. Degree 45, Cardinality 5 iii. Degree 50, Cardinality 45 iv. Degree 50, Cardinality 2250...mam how to do question like this??

[@SwatiChawlaofficial]

Degree means -- number of columns (or attributes) Cardinality means -- number of rows (or tuples) Ans. Degree - 5, Cardinality - 45

[@utpalm9453]

Ma'am.. where can we get sample papers 2021?

[@onthevicodins]

maam thank you so much for these pyqs, i was feeling tensed abput my board exam on 2nd april and this is helping me gain confidence

[@SwatiChawlaofficial]

Thanks

[@ayushisingh465]

Mam please upload the videos on how to study full marks in computer science..

[@SwatiChawlaofficial]

Yes... definitely...before exams...will upload.. Don't worry

[@raviarya5293]

Ma'am can we use UNIQUE clause in the first question... If not... Why so??

[@SwatiChawlaofficial]

The UNIQUE is a constraint which ensures that all values in a column are different. To fetch unique values from a table, Distinct is used.

[@raviarya5293]

@@SwatiChawlaofficial ooh...okay ma'am thanks a lot.....!

[@raviarya5293]

thanks for making me understand the difference

[@piyushsoni9959]

Your teeth is very good😁

[@ssubhashini6121]

Ma'am, have you also taught the syllabus that was deleted for session 2020-21? For 2021-22, there is no reduction in syllabus, so can the students of 2021-22 batch also refer to the videos?

[@SwatiChawlaofficial]

yes.....students of 2021-22 also can refer my channel and the uploaded videos.. The chapters which were deleted last year...u will find the video on those chapters also.. Plz share this channel with others also..

[@ssubhashini6121]

@@SwatiChawlaofficial OK ma'am, thank you so much.. Your videos are really helpful.. Thanks a lot once again..

[@SwatiChawlaofficial]

Most welcome

[@ssubhashini6121]

@@SwatiChawlaofficial Ma'am, one more doubt.. Is everything given in sumita arora book important from exam point of view? I am getting really confused ma'am.. And should I practise the questions given in it because I am finding some questions which have not been taught..

[@SwatiChawlaofficial]

Do follow sumita Arora also...it will help u to be master in python...but the questions given in that book..some of are not according to exam point of view.. Whereas in my videos..i have covered those questions which are important from exam point of view...

[@SJ-ic4yr]

Ma’am can you provide a link for the official computer science ncert? Can’t find it anywhere. My school uses the one by Sumita Arora

[@SwatiChawlaofficial]

ncert.nic.in/textbook.php This is the link of NCERT books...just fill out the class and subject...But this is not according to ur curriculum... For CS board exams, refer the curriculum and sumita arora is also according to ur syllabus..

[@SJ-ic4yr]

@@SwatiChawlaofficial ok ma’am thank you

[@ssubhashini6121]

@@SwatiChawlaofficial Ma'am are all the things given in sumita arora book there in our syllabus?

[@teenam2127]

mam can i refer this video as i am an ip student

[@SwatiChawlaofficial]

Yes..

[@vikaskanojia8660]

Mam how to download this ppt

[@SwatiChawlaofficial]

Sure..You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@oathkeeper2498]

Mam how to download sql I don't know 🙁

[@SwatiChawlaofficial]

kzbin.info/www/bejne/jnuxfappjJyrm9k Check out this

[@abhinavsingh2413]

Paper aa gye h fatti padi h hmari.... How can u even think we'll getting bored...🙃

[@preetammandal571]

Mam bohoti acha explanation hain..but mam please explaination ke pehle answer maat daliye please..warna akh sida answer ke taraf jah raha hain..question par ne ke pehleyi so mam behtar hoga ap pehle question read kijiye phir students ko time dijiye ya boliye video pasue karne ke liye..and then ans show kijiye..i hope you got it mam..

[@SwatiChawlaofficial]

ya sure... Thanku so much for your valuable suggestion.. Will implement this... Sorry for the inconvenience caused..

[@preetammandal571]

@@SwatiChawlaofficial No mam it's fine no inconvenience has occured...Once again thanks for the service you are doing for the students...

[@SwatiChawlaofficial]

My pleasure...

[@kanak328]

Mam commands ko excute karke dikhaye

[@SwatiChawlaofficial]

Plx check out the complete playlist of MySqL.. There is not even a single command which is not executed..

[@ashis8757]

Please send the PDF or word file

[@SwatiChawlaofficial]

Sure..You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@prajjwalsingh2009]

0 DISLIKES !!!! BOW

[@SwatiChawlaofficial]

Yes...didn't knew about this.. Thanku so much...

[@AmitkumarSingh-gr5rl]

👌

[@amitagajjar2810]

👍👍👍👍

[@SwatiChawlaofficial]

Thanku..

[@muneerpathan9301]

Mam vo smja do round off in SQL wla

[@SwatiChawlaofficial]

actually, it's not in your curriculum... that's why..not covered..

[@kiranrewatkar2850]

query ok

[@RAHUL70286]

😢 mam camputer science me camp. Ah gya to plz most important questions share me 😢❤

[@SwatiChawlaofficial]

Sample Paper for Class 12 Computer Science Sample Paper for Class 10 Information Technology 🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲 *Question Bank for Class 12 Computer Science* 📘 🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲 *🤩Available on:* *✅Notion Press:* notionpress.com/read/question-bank-of-computer-science-with-python *✅Amazon:* amzn.eu/d/g2jVkwg *✅Flipkart:* dl.flipkart.com/s/MJsq63NNNN _If you will buy this from NotionPress Website, no delivery charges will be there._ 🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲 Question Bank of Class 10 Information Technology 🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲🌲 🤩Available On ✅Notion Press notionpress.com/read/question-bank-for-cbse-class-10-information-technology-for-2023-exam ✅Amazon amzn.eu/d/6aU43gZ ✅Flipkart dl.flipkart.com/s/3UgBKDNNNN 🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟🌟 Social Handles.. (Please Subscribe and Follow) 🥏KZbin Channel: kzbin.info 🥏Instagram: www.Instagram.com/Swatichawlaofficial 🥏Facebook: www.Facebook.com/Swatichawlaofficial 🥏Telegram Channel for Class 12 Computer Science: t.me/swatichawla12cs 🥏Telegram Channel for Class 10 Information Technology: t.me/swatichawla10it

[@Arpitaasharnaa]

Aap ke pass computer thi class 12 me agr thi to plz batana computer me acha score kese kre ...plz I really need help

[@divishiaggarwal5887]

mam please provide pdf

[@SwatiChawlaofficial]

Sure..You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@anuvishalmishra4614]

Mam pls provide pdf of these questions plsss

[@SwatiChawlaofficial]

Sure... You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@dineshkumardubey009]

174 like and 0 dislikee Power

[@SwatiChawlaofficial]

Thanks....even i didn't know about this... 😊

[@palakrajesh7958]

now it is 222 likes and still 0 dislikes🙂🙂🙂🤩

[@devanshvarshney9269]

Mam aap pdf kyun nhi dalti

[@myaccount1826]

🔥

[@xyzabc5761]

First

[@SwatiChawlaofficial]

thanku...

[@Auxin11.11]

Mem please please provide pdf

[@SwatiChawlaofficial]

Sure..You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@Auxin11.11]

Mem pdf 😭

[@SwatiChawlaofficial]

Sure..You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@healthfitness6139]

Mam can u make a marks distribution of each chapter video👀🙏

[@SwatiChawlaofficial]

chapter wise marks distribution not released by cbse..

[@healthfitness6139]

@@SwatiChawlaofficial mam by taking assumptions from sample paper🤔