JOINS SHORT NOTES (It veryusefull for beginners) 1. LEFT JOIN = All rows from left and matching from right. 2.RIGHT JOIN = All rows from right and matching from left. 3.INNER JOIN = Only matching rows. 4.FULL JOIN = All rows from both matching and not matching.
@@kanishkaakarthigayan8376 the query is used FROM (left table) and used the JOIN (right table) , Mostly the table which has foreign key is always (left table)
Hi I am from Non It background , your video is extremely helpful and easy to understand.I am planning to study all basics of Mysql from your videos Thanks for sharing your videos.
hello mam iam recently watching your sql playlist ,its very usefull for me. Your teaching is short and sweet explanation.thank you so much fro your free to eduacte for ALL. KEEP DOING MAM.GOD BLESS YOU AND YOUR FAMILY🙂
00:17 Foreign key in SQL 02:57 Joins in MySQL explained 03:44 Understanding joins in MySQL 10:27 Explaining Joins in MySQL 14:06 Joins in SQL 14:13 Joins in MySQL 14:27 Condition for joining with EQUAL TO operator 15:55 Explaining Foreign and Union in SQL
hey sister, thank you so much for this video, absolutely great to understand the joins. Right time I got this at place. I'm happy to give this feedback. Keep it up your good work ! thanks again.
Hi mam ... I also got placed in Zensar Technologies mam by studying basics of c and java from your videos 🤗 Thank You mam When can we expect sequences topics from SQL ?
Then can u please tell us about TCL commands (or) about single row function and it's 5 types (or) Flashback,Purge something like this can u please explain in your video mam it will be very much use full even if u cover all those topics mam ✨
Hi mam... Enaku join la oru question ketanga athuku epadi answer varumnu konjam sollunga mam 2 tables are there 1 is A table 2nd is B table. In A table column name is C1 values are 1 1 1 null total 4 rows . B table has column name is C2 values are 1 1 1 null. Question is how many records will come in inner join, left join, right join, full outer join and cross join. Please reply with answer mam. Thank you!
JOINS SHORT NOTES (It veryusefull for beginners)
1. LEFT JOIN = All rows from left and matching from right.
2.RIGHT JOIN = All rows from right and matching from left.
3.INNER JOIN = Only matching rows.
4.FULL JOIN = All rows from both matching and not matching.
Here which is left table & which is right table?
@@kanishkaakarthigayan8376Left table is first table which u created right table is second table which u created
@@kanishkaakarthigayan8376 the query is used FROM (left table) and used the JOIN (right table) , Mostly the table which has foreign key is always (left table)
Hi madam I have cleared interview and got offer by learning from your videos great keep it up!
Your teaching skills is awesome so easier to understand for all topics
Hi I am from Non It background , your video is extremely helpful and easy to understand.I am planning to study all basics of Mysql from your videos Thanks for sharing your videos.
i'm very happy to watch this videos, teaching style clear voice quality video all are great that you so much
i came to only for knowing joins but thinking of going thru entire sql . You explained well .Please keep doing.
Neenga teach pannathu superaa purinthathu mam , thankyou
hello mam
iam recently watching your sql playlist ,its very usefull for me. Your teaching is short and sweet explanation.thank you so much fro your free to eduacte for ALL. KEEP DOING MAM.GOD BLESS YOU AND YOUR FAMILY🙂
Today is my examination day of dbms...thank you so much...finally I got a clear explanation b4 my examination
00:17 Foreign key in SQL
02:57 Joins in MySQL explained
03:44 Understanding joins in MySQL
10:27 Explaining Joins in MySQL
14:06 Joins in SQL
14:13 Joins in MySQL
14:27 Condition for joining with EQUAL TO operator
15:55 Explaining Foreign and Union in SQL
Seriously from one video I have learnt a lot...Clear explanation...👍😍
Clear voice 🙌
Your teaching is worth it continue your teaching
Super akka nalla puriuthu , Stored procedure pls teach pannunga.
Your videos are really very useful. Thanks for sharing your knowledge with us 🙂
Thank you so much! I'm studying in RMIT Melbourne I clearly understood the concept only after watching your video in tamil keep the good work
Seriously wonderfull explanation Mam. many thanks to you...
very helpful,clear voice and explanation mam.. thank you
Initially i was hesitated to click watch, but it's worth watching.
hey sister, thank you so much for this video, absolutely great to understand the joins. Right time I got this at place. I'm happy to give this feedback. Keep it up your good work ! thanks again.
Akka unga tutorials lam Vera Level
Thanks madam Love from Jaffna 🥰
Thank u mam, Very good explanation in ur all videos... Thank u
Hi mam I'm asking to select as Infosys still learning this video very useful
Clear explanation.... Thanks
Mam, first time, I've seen an awesome video, grateful to you
Way of teaching ❤❤
Thanks Sister, Very clear explanation
Great effort. Please keep it up. You are helping many beginners.
Thanks a ton!. You are a superstar
Even without going to college classes, now i can learn easily and instantly. Becoz of "Logic First Tamil". Such a clear and superb teaching 💯😍❤
pls share with ur friends Vishnu
🙏🙏🙏🙏🙏🙏🙏🙏🙏 nalla irunga deivame .. nantri....
🎉super explanation sql.for data analysis nu oru playlist create pannunga mam
Thank you so much for such a use full video, mam.
Thanks for sharing us 🙏 god bless you 🙏
Very useful for beginners
very helpfull for me ....means a lot
Great video sister ✔️
Crystal clear akka
Very well explained
Nice explanation👌
Well explained mam...Thank you so much👏🔥
Thanks !! for Explanation!
9.05 good explanation 🎉
9:12 good one kaa🎉
Thank you for your class maam
Thank you Sis..
8:57 perfect
Clear explanation 👌
Informative
thanks for your video.
Hi mam ... I also got placed in Zensar Technologies mam by studying basics of c and java from your videos 🤗 Thank You mam
When can we expect sequences topics from SQL ?
Congrats! I am planning to cover just three more lessons in sql and windup. I have plans for other topics. Will try to add more in future.
Then can u please tell us about TCL commands (or) about single row function and it's 5 types (or) Flashback,Purge something like this can u please explain in your video mam it will be very much use full even if u cover all those topics mam ✨
Hi mam.. nice explanation please try to upload videos related to normalization
thank you mam...
I got placed mam thankyou
Thank you
Mam please make a video of outerjoin, Self join and Equivjoin
Superb mam
Really usefull
subscribed 👍
Thanks
which is faster between using join keyword or where clause condition
supper
MAM WE CAN USE LEFT JOIN QUERY UNION RIGHT JOIN QUERY FOR FULL JOIN IN MYSQL.
Akkka left Anti join right anti join ah pathi oru video potunga ka plzzz
😑😓😬😬🥺🥺
List down the employees who's reporting to them including president idha eppadi query pandradhu madam
Hi mam... Enaku join la oru question ketanga athuku epadi answer varumnu konjam sollunga mam
2 tables are there 1 is A table 2nd is B table.
In A table column name is C1 values are 1 1 1 null total 4 rows . B table has column name is C2 values are 1 1 1 null.
Question is how many records will come in inner join, left join, right join, full outer join and cross join.
Please reply with answer mam. Thank you!
How to contact you mam .. present i am preparing informatica powercenter...i have some doubts to ask you madam
MAM PLEASE POST VODEO ABOUT ER DIAGRAM AND RELATIONAL ALGEBRA QUERIES .....PLS PLS
I REFER MORE VIDEO I CANNOT UNDER STAND PLS MAKE VIDEO AND POST
In joining can we use * to get all data
I have a doubt in the when then statement.
Mam what is self join??😢
♥️🙏
Text konjam perusa kattumga pls
Akka data science soli kundunga
mam where can i get the data mam for me to practice
Get data from kaggle
💙
Inner join purila
U missed UNION ALL
Super Akka nice...
Thank you Mam