Joins - Inner, Left, Right and Cross | Union | Mysql| SQL in Tamil

Joins - Inner, Left, Right and Cross | Union | Mysql| SQL in Tamil | Logic First Tamil

Рет қаралды 117,012

2 жыл бұрын

Various types of joins and union explained with simple examples.
#SQL #SQLinTamil #MYSQL
notion notes - balanced-quince-db1.notion.si...
Github CodeLink - github.com/LogicFirstTamil
--------------------------------------- courses and playlists -------------------------------------------------
SQL: • SQL
DS and ALGO in C/CPP: • Introduction to Data S...
DS and ALGO in Java: • Introduction to Data S...
Python Full Course with game: • Learn Python in Tamil ...
Java Playlist: • Learn Java in Tamil
Java one video: • Java Full Course in Ta...
C Interview program playlist: • C Interview Programs i...
C programming in one video: • C Programming in Tamil...
C programming playlist: • Introduction to C prog...
C++ Playlist link: • C++ Programming in Tamil
English channel link: / @logicfirst31

Пікірлер: 85

@rukesh.m9799 Жыл бұрын

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 18 күн бұрын

Here which is left table & which is right table?

@karthikasree6384 2 жыл бұрын

Hi mam.. I got selected in Tcs. It happened only because of ur java videos ❤Thank you

@LogicFirstTamil 2 жыл бұрын

congrats Minnu. Happy for u :)

@sathishraja2406 2 жыл бұрын

Please share your experience in interview

@karthikasree6384 2 жыл бұрын

@@sathishraja2406On Saturday I had two rounds tr and mr and monday I got the result as I am shortlisted and hr round yesterday I had. It was an immediate process. In the tr round all the questions was from her Java videos. If u watch all her Java videos then sure you will get a job as Java developer.

@sathishraja2406 2 жыл бұрын

@@karthikasree6384 what about Mr round

@karthikasree6384 2 жыл бұрын

@@sathishraja2406 strength weakness fav actor actress hobbies

@divyaarul8995 2 күн бұрын

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.

@rukesh.m9799 Жыл бұрын

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🙂

@sutharshansrikumar3001 2 жыл бұрын

i'm very happy to watch this videos, teaching style clear voice quality video all are great that you so much

@pushpalatha3396 Жыл бұрын

Your videos are really very useful. Thanks for sharing your knowledge with us 🙂

@aaradhanah5059 Жыл бұрын

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

@deepikatamilarasan Жыл бұрын

Seriously from one video I have learnt a lot...Clear explanation...👍😍

@vijaynarayanan2836 Жыл бұрын

Great effort. Please keep it up. You are helping many beginners.

@hikutti 2 жыл бұрын

Mam, first time, I've seen an awesome video, grateful to you

@aravindkmurugan1743 7 ай бұрын

i came to only for knowing joins but thinking of going thru entire sql . You explained well .Please keep doing.

@moulee6284 Жыл бұрын

Hi madam I have cleared interview and got offer by learning from your videos great keep it up!

@prabakaranragu6676 2 жыл бұрын

Thank u mam, Very good explanation in ur all videos... Thank u

@ragavendranrajendran1087 2 жыл бұрын

Super akka nalla puriuthu , Stored procedure pls teach pannunga.

@Shif1212 10 ай бұрын

Today is my examination day of dbms...thank you so much...finally I got a clear explanation b4 my examination

@asif1673 11 ай бұрын

Seriously wonderfull explanation Mam. many thanks to you...

@vishnu_murugan Жыл бұрын

Even without going to college classes, now i can learn easily and instantly. Becoz of "Logic First Tamil". Such a clear and superb teaching 💯😍❤

@LogicFirstTamil Жыл бұрын

pls share with ur friends Vishnu

@swathiamu5834 8 ай бұрын

very helpful,clear voice and explanation mam.. thank you

@ramkumark1805 Жыл бұрын

Well explained mam...Thank you so much👏🔥

@aravindr4581 Жыл бұрын

Thank you so much for such a use full video, mam.

@balaroxx2700 Ай бұрын

🎉super explanation sql.for data analysis nu oru playlist create pannunga mam

@vanniyarajam3768 8 ай бұрын

Neenga teach pannathu superaa purinthathu mam , thankyou

@DharmalingamValaguruitinfo 4 ай бұрын

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.

@vlog.444 Ай бұрын

Hi mam I'm asking to select as Infosys still learning this video very useful

@vigneshwaran6220 6 ай бұрын

Your teaching is worth it continue your teaching

@arunraju4878 2 жыл бұрын

Hi mam.. nice explanation please try to upload videos related to normalization

@maruthasankar Жыл бұрын

🙏🙏🙏🙏🙏🙏🙏🙏🙏 nalla irunga deivame .. nantri....

@rajeshrajendiran3403 2 жыл бұрын

Very useful for beginners

@sugumarsivanesan5554 2 ай бұрын

Thanks a ton!. You are a superstar

@user-rf2tx4mf8e Жыл бұрын

Akka unga tutorials lam Vera Level

@carthicksiva Жыл бұрын

Thanks !! for Explanation!

@jayasurya5041 8 ай бұрын

Clear voice 🙌

@vishnupriya5044 7 ай бұрын

Thanks for sharing us 🙏 god bless you 🙏

@shivaopyt 26 күн бұрын

Thanks madam Love from Jaffna 🥰

@kousikraj4597 2 жыл бұрын

Nice explanation👌

@j.k.satheeshkumar1695 Жыл бұрын

Clear explanation 👌

@ashuzakir5474 Жыл бұрын

Mam please make a video of outerjoin, Self join and Equivjoin

@varunshankar9749 23 күн бұрын

very helpfull for me ....means a lot

@Devasinger-0070 10 ай бұрын

which is faster between using join keyword or where clause condition

@prasathbala7789 2 жыл бұрын

Crystal clear akka

@nagarajans3467 Жыл бұрын

Thank you for your class maam

@ln2752 24 күн бұрын

thanks for your video.

@lokeshn9833 6 ай бұрын

Initially i was hesitated to click watch, but it's worth watching.

@funwithyg5913 Жыл бұрын

Very well explained

@Balajiji4888 28 күн бұрын

Thank you Mam

@vishal5756 6 ай бұрын

Great video sister ✔️

@miacreations247 Жыл бұрын

List down the employees who's reporting to them including president idha eppadi query pandradhu madam

@kathiravank8063 8 ай бұрын

Thank you Sis..

@user-hj4zo1gm4n Жыл бұрын

MAM WE CAN USE LEFT JOIN QUERY UNION RIGHT JOIN QUERY FOR FULL JOIN IN MYSQL.

@mohamednasik7959 Жыл бұрын

I have a doubt in the when then statement.

@sindhusharmi7156 Жыл бұрын

Really usefull

@PaulSelvi-cl4gr Жыл бұрын

Superb mam

@RajeshKumar-th8pz 4 ай бұрын

In joining can we use * to get all data

@user-pd1qe8jq1c 4 ай бұрын

Super Akka nice...

@sujithaa2793 Жыл бұрын

I got placed mam thankyou

@thageetanvi1226 Жыл бұрын

Thanks

@surya.r3463 4 ай бұрын

thank you mam...

@akaskar 8 ай бұрын

Thank you

@ln2752 24 күн бұрын

subscribed 👍

@ShivaKumar-qb2hc Жыл бұрын

How to contact you mam .. present i am preparing informatica powercenter...i have some doubts to ask you madam

@sathishsmartworker1668 Жыл бұрын

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!

@abdulrahmanraziq809 21 күн бұрын

mam where can i get the data mam for me to practice

@suriyars5662 2 жыл бұрын

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 ?

@LogicFirstTamil 2 жыл бұрын

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.

@suriyars5662 2 жыл бұрын

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 ✨