MySQL Joins | Equi Join | Non Equi Join | Cross Join | In Hindi
Вставка
- Опубліковано 5 жов 2024
- MySQL Joins | Extracting Data from Multiple Tables | Equi Join | In Hindi | Tutorial#15
in this playlist, I am going to start Structured Query Language (SQL). SQL is one of the best database software which is broadly used. It is mainly the syllabus part of 11/12/BCA/BTech student and I have designed this in such a way that it is specially designed for 11/12/BCA/BTech student. In this video, I have explained about joins and its uses. Joins are used to extract data from multiple tables.
Telegram Channel: t.me/codeitupl...
Facebook Group: / 21673. .
Instagram: t.me/codeitupyt
Facebook Group: www.facebook.c...
Facebook Page: / codeitup-104310264625489
Website: codeitup.in
Join this channel to get access to perks:
/ @codeitup
Link to Previous Video: • Aggregate Function in ...
Link to next video: • MySQL Joins | Equi Joi...
Tags Used:
mysql tutorial
sql tutorial
mysql class 12
class 12 sql
class 12 mysql
class 12 python
python class 12
sql class 12
mysql class 12
sql
mysql
mysql functions
introduction to mysql
class xii mysql tutorial hindi
joins
joins in dbms
types of joins in dbms
dbms joins in gate
need of joins
joins example
join vs subquery
types of joins
best channel for dbms
ugc net cse
gate 2020 dbms
sql
introduction to join in sql
mysql joins
extracting data from multiple tables
equi join
sql join statements
sql joins examples
sql joins explained
database join types
#codeitup
#sql
#cbse
@CBSE
@CBSE INDIA
@Unacademy CBSE Science 11 & 12
@CBSE Udaan XI
@Ncert Solutions CBSE ncerthelp.com
You have got some amazing teaching skills, truly appreciate your videos, everything is lucidly explained, Thank you so much 🙏
Thanks & most welcome Satyam, God bless you!
Anyone here Revising for 2024 boards ?
yep
Yes 😅
Yup
Yaar bhai yeh playlist sufficient hai board ke liye.... Maine kuch ni padha plz reply bhai
Yes
you've actually covered up every single topic in book with extra information.
OMG I can't believe it's an underrated channel... This is called quality content 🔥🔥🔥
Thanks a lot Sir ji ❤️
Most welcome Jagannath & thank you so much for your precious comment😊
Sir Thank You very much for this tutorial . From a very long time I was in a state of confusion regarding SQL but after this tutorial now I am very much happy as I have covered each and every concept of SQL from your tutuorial.
May god bless you sir and keep teaching on youtube for students like me because they need teachers like you
Most welcome dear & thank you so much for your precious comment😊
In how much tym?
Sir u help me more...to understand the concept completely...now i am full confident...on join querry🥰
Great 👍
pahli baar sql padh rha hunn waao etne mja aarha h aapse padh ke thnk u so much sir
😊👍
Sir plz bring advance levels videos as well. So that working professionals can also learn😊. It’s my humble request.
Thank you very much sir i couldn't understand this topic for the whole year you explained it very well sir 🙏🙏
Really doing a great work. Your explanation is so simple to understand which comprises example too.
Thanks Rajat!
Cartersion product multiplication of matrices k jaisa lag raha tha😅.
Btw thank u so much sir 🙏🏻
Kal Computer ka boards hai aap ki videos bahut kaam aa rahi hai thank u sir 🙏
Can't express in words,,, your way of teaching is awesome:)
Thanks a lot Ramkumar 😊
Sir your videos are always helpful...
Thank you sir for your efforts 🙏🏻
So nice of you!
sir mana 5 ,6 teacher ki video dekhi jo pc pe samja rahe the pr muja samaj ma nahi aya pr
apki video puri dekhi bikul clear samaj ma aya
Sir apne bahut hii padaya saara doubt clear ho gya ab aache se exam de payenge ❤❤
👍
Amazing sir thank you very much for helping us
Most Welcome Sonal. Happy to see that even without watching the video, I have so many "thanks" comment.
Congratulations sir....
14k journey completed ...👍👍👍👍😎😎😎😎😎😎😎
Yup, thanks a lot dear😊
Amazing sir ❤ it is very easy to understand everything by your explanation🎉 plz make one shot of all chaptersss
You helps a lot i will be always obliged to you❤
Excellent videos sir👍👍 love your efforts
Without watching, you have given comment... So confident about the video??
Previous videos sir
U explained very nicely Sir...........My doubts got cleared.......Thanks
Thanks & most welcome Deepak!
this is absolutely amazing am glad for your videos. Pls keep teaching must needed 🙏🙏❤
Thank you very much sir ji ❤️
Always welcome Abhiman!
Thank you so much sir loving your SQL seriesz 🙏❤️❤️
Most welcome dear😊
@@codeitup sir aapne practical kraya nhi h kya paid m to karaoge Yhan bhi kra dete....... Agr MN h to
thanks sirrrrrrrrr helped me a lot 🙏🙏🙏
Glad to help you Narendra!
Thank u sir
Love from Sainik school Kapurthala
🙂
I want to know that has he covered Having clause, Group By and Order by Clause in his video?
30:41 sir u have used hod instead of d.hod becoz hod exists only in department table.But why have you given column alias name 'd' for department table??
BEST TEACHER
Sir! Is the concept of identical column only for restricted join?why it is not for cartesian product 🤔??
sir group by , having clause, order by cover nhi kiya aapne?
Great sir
Thanks shraddha!
sir aapne is vdo me btaya hai ki jo emp code hai wo repeat hota hai to aisa hoga. per join to foreign key k base pr hota hai or wo primary key se lete hai to sir primary key me repeat to hota hi nahi hai unique hota hai. ye kaise mere ko plz reply de.
Thank you so much for this video ❤
You are welcome!
Thanks a lot sir 👍
You're welcome 😊
wonderfull explaination sir thanks
Thanks & most welcome Neil 😊
very Good Teacher. Thanks #Ask
Thanks
Sir you are amazing.
Thanks!
@@codeitup Your Wlcm sir🥰🥰
CARTESIAN PRODUCT IS LIKE MATRIX
Sirji notes chahiye tha...
Iss video ka...🥲🥲
Thank you so much sir
Most welcome dear😊
Thank you sir
Welcome!
Sir why don't you get side and let us see something on the board even for a sec . Kindly let us take ss or pause and write the notes ..
Sir, DBMS ki tayrii kalye lec khan sa lun mera mtlb koi tarteeb
Sir ish chapter Tak kitna percent hk jaega SQL ka slabus
90% Saurav !
Thanks sir
What r u asking I can't understand??
Nice sir 👍👍👍
Thanks Harsh!
Sir par (-3.54min) me pahle thi uski salary 15000 thi par print karte time 17000 kaisi hui
Ek employee ke 2 salary kaise hi sakti hai ??
I can't understand 🥺@codeitup
skip kar ke dekhoge toh kay samjaj aae ga😑😑
Tomorrow is my practicals 👀
How was??
@@codeitup awesome because of your video love you sir😍❤️
Very well explained sir
Thanks a ton Meena!
Sir, is MySQL join is in syllabus of ip 2023?
No, but for safer side you need to learn this..
@@codeitup Thank you Sir for Replying.
Sir ye intro tune kis song ki he kaafi acchi he
😊
😅😅
Sir order by kaha hai
Sir interface python with my sql
Stack queue
🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Very Soon Yogendra !
Equi join start 12:50
Or kitte parts bache hain....plz reply sir
2 or 3. We are to finish this.
@@codeitup sir par ( 27.19 min ) me uski salary 15000 thi par output me 17000 print hui !!
Ek hi employee ki 2 salary kaise hi sakti hai ??
I can't understand!!🥺
Cbse term 2 😭
All the best bro 👍
Aur bhai sab ho gaya
@@nostalgic.0288 tumhara ho gay sab ….all the best bruh
@@technicalhubbo884 nahi bhai 😅
@@jasmandhillon6370 padhte raho phir badiya
MCA student... Anyone 😐
That ohh😂
Equi join start at 12:52
Sir plz bring advance levels videos as well. So that working professionals can also learn😊.
It’s my humble request sir 🙂.
thank u so much sir
You're welcome Raju!
Thanks sir
Always welcome Faizal!