JOINS IN MYSQL | EQUI JOIN | NATURAL JOIN | CBSE CLASS 12 | COMPUTER SCIENCE

[@मेराभाईमेराभाई]

Physics legend : physics wallah sir Chemistry legend: Arvind arora sir and Paras sir Maths legend : sammer sir Computer science legend : Swati mam

[@SwatiChawlaofficial]

Thankuu so much beta... God bless you..🙏🏻😀

[@muralidharabhat3967]

same ,swati mam is best computer teacher

[@SwatiChawlaofficial]

Thanku so much...🙏🏻😊

[@pranjalsrivastava3343]

cs definitely 💯

[@swyamgupta2004]

chemistry legend : pankaj sir

[@Adhixxyy]

My board exam is tomorrow and am watching all your videos rn to get the conceptual understanding. Thank you so much ma’am ❤

[@harshitchauhan6834]

Legend come today

[@xarioedits9532]

Excellent work maam. The most concise and best content for boards.

[@SwatiChawlaofficial]

Thanks and welcome

[@tavishiphalodia1451]

The best thing about the mam is that she replies to the each and every student just like our school teachers

[@SwatiChawlaofficial]

Thanku... 🙂🙏🏻

[@kartikkumarmishra7867]

Maam yeh toh bohot asan tha faltu ka mien confuse tha ....... Thanks maam aram se clear ho gaya ...... Aur practical kiya jab apne tab toh pura syntax yaad ho gaya

[@SwatiChawlaofficial]

Glad it was helpful!!! Thanku so much...🙏🏻😊 Keep watching 👍🏻

[@kartikkumarmishra7867]

@@SwatiChawlaofficial maam C.S. board ke paper ke pehle kya aap"" how to write in C.S. exam"" ke vedio laa sakte ho please jismien yeh guidance dijiyega ki kaunsa section pehla karna chahiye

[@Merachannelnumberone]

Who watch one day before exam 😂

[@Anjusingh12378]

Me 😂💀

[@AnshSharma-wm1yu]

good luck guys 😭😭🤞

[@Monalisa-du1xb]

👁️👅👁️🤚🏻

[@AnshSharma-wm1yu]

@@Monalisa-du1xb bhai teri pfp 👌🤣🤣

[@jisang7808]

Me😅 ✋️... All the best everyone 👍😊.... After tomorrow we can enjoy and rock 😎🤩

[@yugrajsingh5370]

You are going to be the best teacher of cs on youtube just wait N watch and keep helping us as usual🙏🙏

[@SwatiChawlaofficial]

Thanks a ton.... Sure...will try my level best....

[@jsrashu7505]

guys you can't understand with definition , watch mam's example 🔥🔥 she explains 👍🏻👍🏻

[@SwatiChawlaofficial]

Yes...Thanku so much...🙏🏻🙂

[@gayathrianand789]

your classes are good mam :)) 😃 it is so easy to understand by watching your classes😀

[@SwatiChawlaofficial]

Glad to hear that Thank you so much... Keep watching...

[@kapiljoshi970]

Finally find a excellent teacher mam you are so good 👍👍👍

[@Teenu]

mam thanks i watched complete playlist of mysql and finding cs quite easy because of you. very very thanks mam......

[@SwatiChawlaofficial]

You are most welcome Keep Watching...

[@Boy.23]

Kendriya Vidyalaya students LIKE❤

[@ssn8817]

Which kv u r in

[@Boy.23]

Kv palakkad, kerala

[@ssn8817]

@@Boy.23 do u understand Hindi

[@Boy.23]

@ssn8817 some what bro

[@ssn8817]

@@Boy.23 kbfc logo bro 🔥

[@adityanigam4549]

Mam, you are the very best teacher of cs

[@SwatiChawlaofficial]

Thanks a lot

[@vanshikagupta7689]

Best teachr for cs

[@SwatiChawlaofficial]

Thanks

[@Vintheair]

Thank you so much ma'am.......I was dying to understand SQL joins clearly.....it helped a lot...

[@Vikku569]

Hi

[@Vikku569]

Are you having computer exam 2maro

[@arnav1798]

legends watching 3 hrs before exam

[@stan_legends946]

lol same

[@happinessallover]

like 4 hrs before exam

[@anushka2078]

All the best guys

[@TanmayChaudhary-lk3ex]

Lol 🤣

[@arnav1798]

@@anushka2078 thx u too

[@shivanihum3431]

YOUR TEACHING IS EXREMELY GOOD...THANK YOU VERY MUCH MAM🥰

[@Ganesh__yadav__12___]

She always helps me a lot . Thanks very much mam

[@SwatiChawlaofficial]

Welcome

[@SantoshSharma-iu1zd]

Really this explaination becomes very helpful for me..

[@SwatiChawlaofficial]

Thanku... Keep watching

[@TheSaneInternational-SNI]

Mam foreign key syllabus me hai? How to use it practically to join tables? Will such types of questions be asked in exam?

[@TheBrave22]

Very very very very awesome lecture,😊🌻,Mam but tell me one thing that how do u erase text from right to left becoz using backspace erase left to right....

[@SwatiChawlaofficial]

Thanku... Delete key is used to erase text from right to left ..

[@me_zalaya3995]

You're the best 🤧 We need more teachers like you

[@SwatiChawlaofficial]

Thanku so much 🙂🙏🏻

[@kaushalpandey9073]

Mam video content was amazing. Superb explanation.thank you so much mam.🙏❤️

[@itzsilly1264]

Thank you didi 😊❤

[@bhaiyalalsankh4233]

Thanks you mam. You are awesome for me

[@SwatiChawlaofficial]

Welcome

[@prajyot2021]

Can we use natural join in last query to extract required data ???

[@priyansusahu4891]

I was searching this vedio only...thank you maam

[@SwatiChawlaofficial]

Most Welcome

[@algogoddesshub]

Crystal clear mam Thanku so much mam

[@SwatiChawlaofficial]

Welcome

[@rizzler145]

thank u sm this was v v v v helpful god bless yew and ur family dear

[@SwatiChawlaofficial]

Thanku so much 🙏🏻🙂

[@THETECHHARMER]

Thanks ma'am kal apke bharose exam dene jaoonga 😁😁

[@anno3028]

Bah re sab ekhan thekei padhe Lilis Naaki?

[@THETECHHARMER]

@@anno3028 k Bhai Ya baby you got right baby 🤣

[@AtifShahab_-c_ROLL]

Excellent video ma'am. Also you have a funny and unique voice which helps in remembring whatever you say😂.

[@SwatiChawlaofficial]

Thanku... Is it a compliment or something else 🤔😅

[@prachijain501]

Thank u ma'am

[@SwatiChawlaofficial]

Most welcome 😊

[@anshujais]

Very Thankful to you Mam🤗

[@sanjeevkumar-hx4fx]

crystal clear mam

[@SwatiChawlaofficial]

Great . Thanku

[@shiv_gourav]

Shukriya 🙏

[@SwatiChawlaofficial]

🙏🏻🙏🏻

[@aishanasim1900]

Mam mera kl preboard h computer science ke paper ka I need your best wishes 😊

[@SwatiChawlaofficial]

Teachers blessings are always with their students.. God bless u beta...Put ur efforts 100% ..u will get ur result above expectations...

[@aishanasim1900]

Really mam aap se padhne ke Baad mujhe cs bhut accha n easy lagne lga

[@aishanasim1900]

Mam mera paper bhut accha gya aap jo padhaii h uske bahr se koi n tha........ thanku so muchhhhhh mam❤️❤️❤️❤️❤️❤️❤️💐

[@SwatiChawlaofficial]

@@aishanasim1900 My pleasure..🙏🏻😊

[@shubhamyadav-kj6pv]

Thanks mam 🙏 and keep improving content.

[@SwatiChawlaofficial]

Welcome......Sure.....🙏🏻

[@mallikagoyal2240]

Thank you so much mam ❤❤ all concepts are clr

[@SwatiChawlaofficial]

Most welcome 😊

[@bharathykumar4814]

Pls do the examples of sumitha arora for joins

[@fun_with_smita4681]

Swati maam ur simply superbbb, your explanation is so perfect, I really like ur series, I want to talk you.😇😇

[@SwatiChawlaofficial]

Thanku

[@rajadurai3157]

Thank u so much mam

[@SwatiChawlaofficial]

Most welcome 😊

[@satyamgupta2805]

Ma'am need your blessing so that i can score a perfect 100 in my boards cs and also in jee

[@SwatiChawlaofficial]

All the very best... God bless you 🙂😇 May you get all the happiness and success in your life God bless you beta...🙏🏻😀

[@debasishgoswami1791]

Maam one doubt please solve it , will question related to do Cartesian product between two tables come in exam or the main theory and applied logic is sufficient

[@vivekraghav8937]

Thanku mam it's very helpful video

[@SwatiChawlaofficial]

My pleasure

[@yashgoswami7212]

Maam aap hamare liye bhagwaan ho ..

[@SwatiChawlaofficial]

Just trying to provide quality education and following my passion...

[@vishnuvinod9678]

@@SwatiChawlaofficial mam can u pls help me by providing your ppt please. it will help me to revise.

[@SwatiChawlaofficial]

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

[@thakurgirish1005]

Can we use natural join over equi join in board exam?

[@sheelasingh2419]

Thank you so much ma'am😍🙇

[@SwatiChawlaofficial]

Welcome...🙏🏻😊

[@manvirsingh1245]

🔥🔥Nicely explained 👍🏻👍🏻

[@SwatiChawlaofficial]

Thanks 🙂

[@amitk802]

Awesome video mam

[@amitk802]

Can you please send ppt of this video ...

[@SwatiChawlaofficial]

Thankuu...🙏🏻😊

[@aditisharma3995]

Mam what is inner join?? And thanks I get maximum things 😊

[@innovative2966]

Nice video thanks Ma'am

[@SwatiChawlaofficial]

Most welcome 😊

[@vaishalimargendra1496]

short n superb

[@SwatiChawlaofficial]

Thanku..

[@Vish_911]

Thank You maam. One last time🙌🏻

[@bunupaul5449]

awesome explanation ma'am

[@SwatiChawlaofficial]

Thank you! 🙂

[@anonymous12e8d]

Thank you so much mam 🙏🏻

[@abhidevsp3067]

boards ??

[@aryanshukla1074]

Great video

[@velocxty2477]

Great explanation ma’am!👍

[@SwatiChawlaofficial]

Thank you! 🙂

[@panshulgupta6355]

I am here two days before my CS board 😂

[@vismayayuvi203]

Me too😅

[@varshan3218]

Now 😂😂

[@abhidevsp3067]

I just started lol xd

[@panshulgupta6355]

@@abhidevsp3067 if tomorrow = "CS Board": print ("Lol")

[@priyadarshanm8857]

@@panshulgupta6355 Syntax error 🤣

[@kushal6635]

Mam pls ek new video bana dijiye full concept of join plz mam bas isme dikkat hai baki aagya samjh!!! 👍😀

[@ramvenkatachalam8153]

Super explanation didi .

[@SwatiChawlaofficial]

Thanks

[@manishkachawla5718]

maam what if we have two colums which are same in two tables which we are joining using natural join? what will happen in such a condition?

[@sagarswaraj9703]

We can join through any of the one column .

[@sagarswaraj9703]

Actually you have two choices to use join .

[@ashishgoswami8422]

very very nice explanition mam

[@SwatiChawlaofficial]

Thanku so much..

[@captainaditya7662]

Maam aapne kal mere viva ke liye mujhe ache se prepare karwa diya. Thaks a lot and I wish ki aapka channel bohot grow kare.

[@SwatiChawlaofficial]

kzbin.info/www/bejne/hnSsdHSmeLyhqdE

[@kanakjoshi5640]

ma'am In the last question, Natural join method can also be used right?? Syntax:- Select Ename, Dname from Emp Natural Join Dept;

[@roaringfederation]

Thank you mam, ab feel agaya

[@SwatiChawlaofficial]

Great 👍

[@iitjee9824]

CHI

[@iitjee9824]

TERI KOI IJAT NHI HAI SHAYAD SOCIETY ME BUT ITS OKAY

[@arxalier2956]

​@@iitjee9824bro jee nikla tumhara?

[@lens4075]

If they ask us to join tables in exam, is it preferred to use equi join or natural join?

[@priyadarshanm8857]

Equi

[@vishallodhi7096]

Thanks

[@SwatiChawlaofficial]

Welcome

[@AadityaPradeepan]

mam can you say about inner and outer join

[@poonampant7954]

Excuse me ma'am please reply........do we have this topic in this year's syllabus

[@SwatiChawlaofficial]

Yes

[@flexible_brushes4554]

The best vid fr

[@gouthamkrishnakumar5921]

ma'am can you please make a blueprint video of computer science like physics galaxy's ashish arora sir did for physics and mathematics please?

[@SwatiChawlaofficial]

Plz check out these 2 links... kzbin.info/www/bejne/d16Ydo1nq9h5msk kzbin.info/www/bejne/pJbdf2anjbJ7g9k

[@gouthamkrishnakumar5921]

@@SwatiChawlaofficial Thank you ma'am

[@imangarcha9657]

mam i am new in class12 and i am literally new in cs python i dont know about computer science i wanna learn this subject from zero please tell how i prepare for upcoming exam mam plz guide me

[@SwatiChawlaofficial]

Make Command in Python topics covered in Class 11. Clear the concepts . Then start for class 12. U can check my playlist..and start from the Functions chapter.. U will definitely score good..

[@thehitlists5495]

Mam on doing natural join its showing empty set and not returning table...,...,what to do now??

[@sanjeevshukla6227]

Best explanation..

[@devarshagarwal5747]

Hello mam 1 doubt tha casterian product kare bina Hum log equi join ya natural join use kar sakte hai ki nhi??

[@devarshagarwal5747]

Mam paper ke phele bta dijiyega please🙏🙏

[@JatinS-yt]

@@devarshagarwal5747 cartesian karne ki zarurat nhi hai

[@randomperson10110]

Thank you

[@SwatiChawlaofficial]

Welcome

[@ramji10]

Thankuuuuuu

[@SwatiChawlaofficial]

Welcome

[@aspirantaman7187]

Amazing

[@a17karthiks63]

Ma'am in second table if 10 ka 2 values hoga tho natural join mei kya hoga???

[@vaishalimargendra1496]

Thankyou mam

[@SwatiChawlaofficial]

Most welcome 😊

[@rakeshverma9451]

Thankyou mam❤

[@SwatiChawlaofficial]

Most welcome

[@sriramshivkumar1721]

What if there is no similarity in both tables?

[@utpalm9453]

Is there any way or query to change the name of the database?

[@SwatiChawlaofficial]

In MySQL there is no support for database renaming. In order to rename a MySQL database you can do one of the following: Create new database and rename all tables in the old database to be in the new database: CREATE database new_db_name; RENAME TABLE db_name.table1 TO new_db_name, db_name.table2 TO new_db_name; DROP database db_name;

[@utpalm9453]

@@SwatiChawlaofficial ok ma'am....

[@AbhishekKumar-ij1ut]

Batch 2024-25

[@preetthorat6562]

Brain cell 1: Boards????? 😰😰 Brain cell 2: Chill !!!!! Swati mam👩‍🏫 is here🔥🔥 Lots of ❤️❤️

[@SwatiChawlaofficial]

🙏🏻 Thanks

[@AmitDas-nw6ux]

Interface of python with an sql database Mam please this topic one video

[@SwatiChawlaofficial]

Interface Python with MYSQL: kzbin.info/aero/PL5Raijva2y4QBzhQw5OWIn9Dopl_M_NEE

[@anshulbartwal8145]

Ok means natural join is same like cross join but diff in not giving same values , that's it ?

[@priyanjali6646]

Just wow

[@SwatiChawlaofficial]

Thanku

[@mohammedafzal993]

Mam it was good but it took lil time to understand bcz the table was large instead of that small tables would be more easier to understand only for the joins lecture

[@SwatiChawlaofficial]

Yes .. you are right

[@kartikay9130]

nice explanation

[@SwatiChawlaofficial]

Thanks

[@oldsongsexpress3072]

Ma'am what is the difference between outer join and inner join? Kindly resolve.

[@SwatiChawlaofficial]

(INNER) JOIN: Returns records that have matching values in both tables LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table FULL (OUTER) JOIN: Returns all records when there is a match in either left or right table

[@rajeshbauskar9091]

How to make 2 tables in my sql ? Ma'am plz reply

[@SwatiChawlaofficial]

Follow same procedure to create the table

[@anshikagrover2322]

Mam You have used aliasing command without AS but aliasing is always with AS then what should be done now ?

[@SwatiChawlaofficial]

It will work both way

[@anshikagrover2322]

@@SwatiChawlaofficial Is it necessary to use aliasing in equi join and natural join ??

[@SwatiChawlaofficial]

No

[@lakshikasheoran359]

mam is natural join there in the syllabus my school teacher has not taught this topic?

[@SwatiChawlaofficial]

Yes ...it's there... u can check the curriculum also. cbseacademic.nic.in/web_material/CurriculumMain21/revisedsyllabi/SrSecondary/REVISEDComputer_Science_Sr.Sec_2020-21.pdf

[@priyadarsiniswain5946]

How to join more than two tables ?

[@neha2763]

Mam ,I want ur help as in11th I was not good in python but I want to learn it again so that my basics should be clear and have no problem in class 12 .so ,can u suggest me what lectures should I watch

[@SwatiChawlaofficial]

u can start from python revision tour....and gradually cover all concepts.... Still, u r having time..If u will study smartly..definitely , u will score good..

[@neha2763]

Thankyou mam

[@koushikram9842]

Mam could u make video on case study Q's for board exams?🙏🙏🙏

[@SwatiChawlaofficial]

plz check the playlist...already uploaded...

[@koushikram9842]

@@SwatiChawlaofficial thank u mam❤️❤️👍

[@MGeethanjalithA]

mam how to create a csv file

[@Study-sh4ih]

Open kra do write mode mein along with importing the CSV module.

[@thanmaykandakuri2782]

tmrw my rev xam mam

[@SwatiChawlaofficial]

All the best 🙂 👍