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

[@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 😎🤩

[@kapiljoshi970]

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

[@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....

[@tavishiphalodia1451]

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

[@SwatiChawlaofficial]

Thanku... 🙂🙏🏻

[@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...

[@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

[@vanshikagupta7689]

Best teachr for cs

[@SwatiChawlaofficial]

Thanks

[@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...

[@adityanigam4549]

Mam, you are the very best teacher of cs

[@SwatiChawlaofficial]

Thanks a lot

[@shivanihum3431]

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

[@jsrashu7505]

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

[@SwatiChawlaofficial]

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

[@me_zalaya3995]

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

[@SwatiChawlaofficial]

Thanku so much 🙂🙏🏻

[@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

[@kaushalpandey9073]

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

[@priyansusahu4891]

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

[@SwatiChawlaofficial]

Most Welcome

[@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 🤔😅

[@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?

[@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 🔥

[@rizzler145]

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

[@SwatiChawlaofficial]

Thanku so much 🙏🏻🙂

[@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 ..

[@algogoddesshub]

Crystal clear mam Thanku so much mam

[@SwatiChawlaofficial]

Welcome

[@prajyot2021]

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

[@shubhamyadav-kj6pv]

Thanks mam 🙏 and keep improving content.

[@SwatiChawlaofficial]

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

[@itzsilly1264]

Thank you didi 😊❤

[@manvirsingh1245]

🔥🔥Nicely explained 👍🏻👍🏻

[@SwatiChawlaofficial]

Thanks 🙂

[@unnatiesingh4320]

Terrific explanation Thankyou mam

[@SwatiChawlaofficial]

You're welcome! 🎉

[@bhaiyalalsankh4233]

Thanks you mam. You are awesome for me

[@SwatiChawlaofficial]

Welcome

[@anshujais]

Very Thankful to you Mam🤗

[@arnav1798]

legends watching 3 hrs before exam

[@stanlegendz]

lol same

[@happinessallover]

like 4 hrs before exam

[@anushka2078]

All the best guys

[@TanmayChaudhary-lk3ex]

Lol 🤣

[@arnav1798]

@@anushka2078 thx u too

[@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

[@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

[@sanjeevkumar-hx4fx]

crystal clear mam

[@SwatiChawlaofficial]

Great . Thanku

[@amitk802]

Awesome video mam

[@amitk802]

Can you please send ppt of this video ...

[@SwatiChawlaofficial]

Thankuu...🙏🏻😊

[@mallikagoyal2240]

Thank you so much mam ❤❤ all concepts are clr

[@SwatiChawlaofficial]

Most welcome 😊

[@Vish_911]

Thank You maam. One last time🙌🏻

[@aryanshukla1074]

Great video

[@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 🤣

[@vivekraghav8937]

Thanku mam it's very helpful video

[@SwatiChawlaofficial]

My pleasure

[@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 .

[@velocxty2477]

Great explanation ma’am!👍

[@SwatiChawlaofficial]

Thank you! 🙂

[@bharathykumar4814]

Pls do the examples of sumitha arora for joins

[@ramvenkatachalam8153]

Super explanation didi .

[@SwatiChawlaofficial]

Thanks

[@vaishalimargendra1496]

short n superb

[@SwatiChawlaofficial]

Thanku..

[@shiv_gourav]

Shukriya 🙏

[@SwatiChawlaofficial]

🙏🏻🙏🏻

[@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

[@prachijain501]

Thank u ma'am

[@SwatiChawlaofficial]

Most welcome 😊

[@aditisharma3995]

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

[@sheelasingh2419]

Thank you so much ma'am😍🙇

[@SwatiChawlaofficial]

Welcome...🙏🏻😊

[@lens4075]

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

[@priyadarshanm8857]

Equi

[@flexible_brushes4554]

The best vid fr

[@SwatiChawlaofficial]

Thanks

[@kanakjoshi5640]

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

[@bunupaul5449]

awesome explanation ma'am

[@SwatiChawlaofficial]

Thank you! 🙂

[@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..🙏🏻😊

[@innovative2966]

Nice video thanks Ma'am

[@SwatiChawlaofficial]

Most welcome 😊

[@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

[@a17karthiks63]

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

[@sanjeevshukla6227]

Best explanation..

[@SwatiChawlaofficial]

Thanks

[@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...🙏🏻😀

[@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?

[@poonampant7954]

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

[@SwatiChawlaofficial]

Yes

[@anonymous12e8d]

Thank you so much mam 🙏🏻

[@abhidevsp3067]

boards ??

[@thakurgirish1005]

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

[@ashishgoswami8422]

very very nice explanition mam

[@SwatiChawlaofficial]

Thanku so much..

[@preetthorat6562]

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

[@SwatiChawlaofficial]

🙏🏻 Thanks

[@thehitlists5495]

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

[@aspirantaman7187]

Amazing

[@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

[@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....

[@kushal6635]

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

[@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 🤣

[@harshsharma4197]

Nice💥

[@SwatiChawlaofficial]

Thanks

[@rajeshbauskar9091]

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

[@SwatiChawlaofficial]

Follow same procedure to create the table

[@anshulbartwal8145]

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

[@AadityaPradeepan]

mam can you say about inner and outer join

[@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..

[@oceanhappiness7027]

Why didn't you use alias name in front of column name at 14:30 .

[@oceanhappiness7027]

Select e.ename,d.dname from Emp e, Dept d where e.Dno= d.Dno;

[@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

[@shreyansdeshpandeind1638]

ma'am can you upload the ppt s also

[@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 *Class 12 Informatics Practices (065)* • Data Handling using Pandas - I rzp.io/l/nmnrTzf9 • Database Query using SQL rzp.io/l/AN8ZkvY • Computer Networks rzp.io/l/XqTJmO5 • Societal Impacts rzp.io/l/o3eLFe1Q *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.*

[@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

[@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

[@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

[@vishallodhi7096]

Thanks

[@SwatiChawlaofficial]

Welcome

[@kartikay9130]

nice explanation

[@SwatiChawlaofficial]

Thanks

[@rakeshverma9451]

Thankyou mam❤

[@SwatiChawlaofficial]

Most welcome

[@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

[@Sourab_kumar_]

2024 ko kis ka exam ha🎉🎉

[@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❤️❤️👍

[@Uneverknow123]

Mam only equi join and natural join are in syallbus term 2?

[@SwatiChawlaofficial]

Yes

[@sriramshivkumar1721]

What if there is no similarity in both tables?

[@ramji10]

Thankuuuuuu

[@SwatiChawlaofficial]

Welcome

[@randomperson10110]

Thank you

[@SwatiChawlaofficial]

Welcome

[@ayusharyan6825]

Method2 @14:38 Select Ename,Dname from emp natural join dept; Mam correct?

[@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