JOINS IN MYSQL | EQUI JOIN | NATURAL JOIN | CBSE CLASS 12 | COMPUTER SCIENCE
HTML-код
- Опубликовано: 5 сен 2024
- In this video, you will understand Cartesian Product , Equi Join and Natural Join.
Channel Link
/ @swatichawlaofficial
MYSQL
Database Concepts: Introduction to database concepts and its need. Relational data model: Concept of domain, relation, tuple, attribute, degree, cardinality, key, primary key, candidate key, alternate key and foreign key.
• Database | Relational ...
Introduction of MYSQL, Features, MYSQL v/s SQL, DDL and DML Commands
• MYSQL | Difference bet...
Download and Install MYSQL Server (Complete Step - by - Step Guide)
• How to Download MySQL ...
MYSQL Commands
Create Database, Use Database, Show Databases, Show Tables, Create Table, char v/s varchar , data types in MYSQL (PART-1)
• MYSQL COMMANDS (Part -...
Desc Command, Insert Into and Select Command (PART-2)
• MYSQL COMMANDS (PART- ...
WHERE Clause, Relational Operators, Logical Operators, Putting Text in Query, Scalar Expressions (PART - 3)
• MYSQL COMMANDS (PART 3...
DISTINCT BETWEEN NOT BETWEEN IS NULL IS NOT NULL LIKE NOT LIKE (PART-4)
• MYSQL COMMANDS (PART-4...
ALTER , UPDATE , DELETE , DROP Commands (PART-5)
• MY SQL COMMANDS (PART-...
Aggregate Functions (PART-6)
• AGGREGATE FUNCTIONS | ...
Order By , Group By , Having Clause (PART-7)
• MYSQL COMMANDS (PART-7...
Playlist Links:
Python Revision Tour
• Python Revision Tour
Functions in Python
• Working with Functions...
random module
• random module
Mathematical and String Functions
• Playlist
Using Python Libraries:
• Using Python Libraries
Data Structures: Stack and Queue
• Data Structures : Line...
File Handling:
• File Handling
Recursion
• Recursion
Idea of Algorithmic Efficiency
www.youtube.co...
Interface Python with MYSQL:
• Interface Python with ...
MYSQL
• MYSQL
Programming Corner:
• Programming Corner
Physics legend : physics wallah sir
Chemistry legend: Arvind arora sir and Paras sir
Maths legend : sammer sir
Computer science legend : Swati mam
Thankuu so much beta...
God bless you..🙏🏻😀
same ,swati mam is best computer teacher
Thanku so much...🙏🏻😊
cs definitely 💯
chemistry legend : pankaj sir
My board exam is tomorrow and am watching all your videos rn to get the conceptual understanding. Thank you so much ma’am ❤
Legend come today
Who watch one day before exam 😂
Me 😂💀
good luck guys 😭😭🤞
👁️👅👁️🤚🏻
@@Monalisa-du1xb bhai teri pfp 👌🤣🤣
Me😅 ✋️...
All the best everyone 👍😊....
After tomorrow we can enjoy and rock 😎🤩
Excellent work maam. The most concise and best content for boards.
Thanks and welcome
The best thing about the mam is that she replies to the each and every student just like our school teachers
Thanku... 🙂🙏🏻
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
Glad it was helpful!!!
Thanku so much...🙏🏻😊
Keep watching 👍🏻
@@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
Kendriya Vidyalaya students LIKE❤
Which kv u r in
Kv palakkad, kerala
@@Boy.23 do u understand Hindi
@ssn8817 some what bro
@@Boy.23 kbfc logo bro 🔥
guys you can't understand with definition ,
watch mam's example 🔥🔥 she explains 👍🏻👍🏻
Yes...Thanku so much...🙏🏻🙂
your classes are good mam :)) 😃 it is so easy to understand by watching your classes😀
Glad to hear that
Thank you so much...
Keep watching...
You are going to be the best teacher of cs on youtube just wait N watch and keep helping us as usual🙏🙏
Thanks a ton....
Sure...will try my level best....
Finally find a excellent teacher mam you are so good 👍👍👍
mam thanks i watched complete playlist of mysql and finding cs quite easy because of you. very very thanks mam......
You are most welcome
Keep Watching...
Thank you so much ma'am.......I was dying to understand SQL joins clearly.....it helped a lot...
Hi
Are you having computer exam 2maro
legends watching 3 hrs before exam
lol same
like 4 hrs before exam
All the best guys
Lol 🤣
@@anushka2078 thx
u too
thank u sm this was v v v v helpful god bless yew and ur family dear
Thanku so much 🙏🏻🙂
Best teachr for cs
Thanks
YOUR TEACHING IS EXREMELY GOOD...THANK YOU VERY MUCH MAM🥰
You're the best 🤧 We need more teachers like you
Thanku so much 🙂🙏🏻
She always helps me a lot .
Thanks very much mam
Welcome
Mam, you are the very best teacher of cs
Thanks a lot
Mam foreign key syllabus me hai?
How to use it practically to join tables? Will such types of questions be asked in exam?
Can we use natural join in last query to extract required data ???
Really this explaination becomes very helpful for me..
Thanku...
Keep watching
Mam video content was amazing. Superb explanation.thank you so much mam.🙏❤️
I was searching this vedio only...thank you maam
Most Welcome
Thanks you mam. You are awesome for me
Welcome
Thank you didi 😊❤
Crystal clear mam
Thanku so much mam
Welcome
Excellent video ma'am. Also you have a funny and unique voice which helps in remembring whatever you say😂.
Thanku...
Is it a compliment or something else 🤔😅
Awesome video mam
Can you please send ppt of this video ...
Thankuu...🙏🏻😊
Thanks ma'am kal apke bharose exam dene jaoonga 😁😁
Bah re sab ekhan thekei padhe Lilis Naaki?
@@anno3028 k Bhai
Ya baby you got right baby 🤣
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....
Thanku...
Delete key is used to erase text from right to left ..
Thank you so much mam ❤❤ all concepts are clr
Most welcome 😊
crystal clear mam
Great .
Thanku
Mam mera kl preboard h computer science ke paper ka
I need your best wishes 😊
Teachers blessings are always with their students..
God bless u beta...Put ur efforts 100% ..u will get ur result above expectations...
Really mam aap se padhne ke Baad mujhe cs bhut accha n easy lagne lga
Mam mera paper bhut accha gya aap jo padhaii h uske bahr se koi n tha........ thanku so muchhhhhh mam❤️❤️❤️❤️❤️❤️❤️💐
@@aishanasim1900 My pleasure..🙏🏻😊
Thanks mam 🙏 and keep improving content.
Welcome......Sure.....🙏🏻
Pls do the examples of sumitha arora for joins
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
Very Thankful to you Mam🤗
Ma'am need your blessing so that i can score a perfect 100 in my boards cs and also in jee
All the very best...
God bless you 🙂😇
May you get all the happiness and success in your life
God bless you beta...🙏🏻😀
I am here two days before my CS board 😂
Me too😅
Now 😂😂
I just started lol xd
@@abhidevsp3067
if tomorrow = "CS Board":
print ("Lol")
@@panshulgupta6355 Syntax error 🤣
Thanku mam it's very helpful video
My pleasure
Thank u ma'am
Most welcome 😊
🔥🔥Nicely explained 👍🏻👍🏻
Thanks 🙂
Great video
Thank you so much ma'am
Swati maam ur simply superbbb, your explanation is so perfect, I really like ur series, I want to talk you.😇😇
Thanku
Thank u so much mam
Most welcome 😊
Great explanation ma’am!👍
Thank you! 🙂
Shukriya 🙏
🙏🏻🙏🏻
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?
We can join through any of the one column .
Actually you have two choices to use join .
23 ko kis kis ka exam h🙋♀️
Mera kuch nhi aata merko bhai
Mera v hai bhai
@@THETECHHARMER he he Navodayan spotted 😁😁
Saale ekdin pehle hi padenge 😂
@Mr. X chill bro everyone studies one night before comp exam
atleast from my school
@@anno3028 bath to sahi kahi
If they ask us to join tables in exam, is it preferred to use equi join or natural join?
Equi
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.
ruclips.net/video/PCICApCWnso/видео.html
very very nice explanition mam
Thanku so much..
Thank You maam. One last time🙌🏻
Thank you mam
Most welcome 😊
Thank you so much ma'am😍🙇
Welcome...🙏🏻😊
Maam aap hamare liye bhagwaan ho
..
Just trying to provide quality education and following my passion...
@@SwatiChawlaofficial mam can u pls help me by providing your ppt please.
it will help me to revise.
Sure..You can enjoy special perks by joining the membership.
Have a look at this.
ruclips.net/channel/UC2vH9rqGh-fJELF8acGfBdwjoin
awesome explanation ma'am
Thank you! 🙂
Can we use natural join over equi join in board exam?
Nice video thanks Ma'am
Most welcome 😊
short n superb
Thanku..
Batch 2024-25
Thank you mam, ab feel agaya
Great 👍
CHI
TERI KOI IJAT NHI HAI SHAYAD SOCIETY ME BUT ITS OKAY
@@iitjee9824bro jee nikla tumhara?
2024 ko kis ka exam ha🎉🎉
Mam pls ek new video bana dijiye full concept of join plz mam bas isme dikkat hai baki aagya samjh!!! 👍😀
ma'am In the last question, Natural join method can also be used right??
Syntax:- Select Ename, Dname from Emp Natural Join Dept;
Amazing
Mam what is inner join??
And thanks I get maximum things 😊
Super explanation didi .
Thanks
Thankuuuuuu
Welcome
nice explanation
Ma'am what is the difference between outer join and inner join?
Kindly resolve.
(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
Best explanation..
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?
Plz check out these 2 links...
ruclips.net/video/A-5EZ1vsFdg/видео.html
ruclips.net/video/nezN3qXMHMw/видео.html
@@SwatiChawlaofficial Thank you ma'am
Ok means natural join is same like cross join but diff in not giving same values , that's it ?
Excuse me ma'am please reply........do we have this topic in this year's syllabus
Yes
Mam on doing natural join its showing empty set and not returning table...,...,what to do now??
Ma'am in second table if 10 ka 2 values hoga tho natural join mei kya hoga???
Is there any way or query to change the name of the database?
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;
@@SwatiChawlaofficial ok ma'am....
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
Yes .. you are right
Mam You have used aliasing command without AS but aliasing is always with AS then what should be done now ?
It will work both way
@@SwatiChawlaofficial Is it necessary to use aliasing in equi join and natural join ??
No
Hello mam
1 doubt tha casterian product kare bina
Hum log equi join ya natural join use kar sakte hai ki nhi??
Mam paper ke phele bta dijiyega please🙏🙏
@@devarshagarwal5747 cartesian karne ki zarurat nhi hai
Thanks
Welcome
How to make 2 tables in my sql ? Ma'am plz reply
Follow same procedure to create the table
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
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..
What if there is no similarity in both tables?
Thanks mam
Welcome..
Just wow
Thanku
Thankyou mam❤
Most welcome
Brain cell 1: Boards????? 😰😰
Brain cell 2: Chill !!!!! Swati mam👩🏫 is here🔥🔥
Lots of ❤️❤️
🙏🏻
Thanks
Thank you
Welcome
Interface of python with an sql database Mam please this topic one video
Interface Python with MYSQL: ruclips.net/p/PL5Raijva2y4QBzhQw5OWIn9Dopl_M_NEE
Why in join query you remov(*)this
If you want to display all the columns, write a star symbol ..
Otherwise write the name of the columns, which you want to display..
Nice💥
Thanks
Those who are for term 2😎😎
Mee
mam how to create a csv file
Open kra do write mode mein along with importing the CSV module.
How to join more than two tables ?