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

Поделиться
HTML-код
  • Опубликовано: 7 мар 2022
  • 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

  • @karthikasree6384
    @karthikasree6384 2 года назад +125

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

    • @LogicFirstTamil
      @LogicFirstTamil  2 года назад +14

      congrats Minnu. Happy for u :)

    • @sathishraja2406
      @sathishraja2406 2 года назад +3

      Please share your experience in interview

    • @karthikasree6384
      @karthikasree6384 2 года назад +12

      @@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
      @sathishraja2406 2 года назад +1

      @@karthikasree6384 what about Mr round

    • @karthikasree6384
      @karthikasree6384 2 года назад +4

      @@sathishraja2406 strength weakness fav actor actress hobbies

  • @rukesh.m9799
    @rukesh.m9799 Год назад +67

    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.

  • @divyaarul8995
    @divyaarul8995 9 дней назад

    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.

  • @sutharshansrikumar3001
    @sutharshansrikumar3001 2 года назад +2

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

  • @rukesh.m9799
    @rukesh.m9799 Год назад +6

    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🙂

  • @pushpalatha3396
    @pushpalatha3396 Год назад +4

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

  • @aaradhanah5059
    @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
    @deepikatamilarasan Год назад

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

  • @hikutti
    @hikutti 2 года назад +2

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

  • @vijaynarayanan2836
    @vijaynarayanan2836 Год назад

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

  • @aravindkmurugan1743
    @aravindkmurugan1743 7 месяцев назад

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

  • @moulee6284
    @moulee6284 Год назад

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

  • @user-rf2tx4mf8e
    @user-rf2tx4mf8e Год назад +1

    Akka unga tutorials lam Vera Level

  • @asif1673
    @asif1673 Год назад +1

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

  • @prabakaranragu6676
    @prabakaranragu6676 2 года назад +1

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

  • @jayasurya5041
    @jayasurya5041 8 месяцев назад +1

    Clear voice 🙌

  • @Shif1212
    @Shif1212 10 месяцев назад

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

  • @shivaopyt
    @shivaopyt Месяц назад

    Thanks madam Love from Jaffna 🥰

  • @swathiamu5834
    @swathiamu5834 8 месяцев назад

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

  • @vigneshwaran6220
    @vigneshwaran6220 7 месяцев назад

    Your teaching is worth it continue your teaching

  • @ragavendranrajendran1087
    @ragavendranrajendran1087 2 года назад +2

    Super akka nalla puriuthu , Stored procedure pls teach pannunga.

  • @vishnu_murugan
    @vishnu_murugan Год назад +3

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

  • @aravindr4581
    @aravindr4581 Год назад

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

  • @ramkumark1805
    @ramkumark1805 Год назад

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

  • @DharmalingamValaguruitinfo
    @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.

  • @rajeshrajendiran3403
    @rajeshrajendiran3403 2 года назад +1

    Very useful for beginners

  • @sugumarsivanesan5554
    @sugumarsivanesan5554 2 месяца назад

    Thanks a ton!. You are a superstar

  • @carthicksiva
    @carthicksiva Год назад

    Thanks !! for Explanation!

  • @vanniyarajam3768
    @vanniyarajam3768 8 месяцев назад

    Neenga teach pannathu superaa purinthathu mam , thankyou

  • @maruthasankar
    @maruthasankar Год назад

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

  • @varunshankar9749
    @varunshankar9749 Месяц назад

    very helpfull for me ....means a lot

  • @kousikraj4597
    @kousikraj4597 2 года назад +1

    Nice explanation👌

  • @j.k.satheeshkumar1695
    @j.k.satheeshkumar1695 Год назад

    Clear explanation 👌

  • @prasathbala7789
    @prasathbala7789 2 года назад +2

    Crystal clear akka

  • @vishnupriya5044
    @vishnupriya5044 8 месяцев назад

    Thanks for sharing us 🙏 god bless you 🙏

  • @Balajiji4888
    @Balajiji4888 Месяц назад +1

    Thank you Mam

  • @funwithyg5913
    @funwithyg5913 Год назад

    Very well explained

  • @ln2752
    @ln2752 Месяц назад

    thanks for your video.

  • @nagarajans3467
    @nagarajans3467 Год назад

    Thank you for your class maam

  • @vishal5756
    @vishal5756 7 месяцев назад

    Great video sister ✔️

  • @balaroxx2700
    @balaroxx2700 Месяц назад

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

  • @vlog.444
    @vlog.444 Месяц назад

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

  • @arunraju4878
    @arunraju4878 2 года назад

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

  • @lokeshn9833
    @lokeshn9833 6 месяцев назад

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

  • @kathiravank8063
    @kathiravank8063 8 месяцев назад

    Thank you Sis..

  • @sindhusharmi7156
    @sindhusharmi7156 Год назад

    Really usefull

  • @PaulSelvi-cl4gr
    @PaulSelvi-cl4gr Год назад

    Superb mam

  • @sujithaa2793
    @sujithaa2793 Год назад

    I got placed mam thankyou

  • @surya.r3463
    @surya.r3463 5 месяцев назад

    thank you mam...

  • @akaskar
    @akaskar 8 месяцев назад

    Thank you

  • @user-pd1qe8jq1c
    @user-pd1qe8jq1c 4 месяца назад

    Super Akka nice...

  • @thageetanvi1226
    @thageetanvi1226 Год назад

    Thanks

  • @Devasinger-0070
    @Devasinger-0070 10 месяцев назад

    which is faster between using join keyword or where clause condition

  • @ln2752
    @ln2752 Месяц назад

    subscribed 👍

  • @ashuzakir5474
    @ashuzakir5474 Год назад

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

  • @user-ux7kw4ep5p
    @user-ux7kw4ep5p 9 месяцев назад

    9.05 good explanation 🎉

  • @user-ux7kw4ep5p
    @user-ux7kw4ep5p 9 месяцев назад

    8:57 perfect

  • @user-hj4zo1gm4n
    @user-hj4zo1gm4n Год назад

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

  • @miacreations247
    @miacreations247 Год назад

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

  • @ShivaKumar-qb2hc
    @ShivaKumar-qb2hc Год назад

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

  • @suryaprakashsakthivel8277
    @suryaprakashsakthivel8277 2 года назад +1

    ♥️🙏

  • @RajeshKumar-th8pz
    @RajeshKumar-th8pz 5 месяцев назад

    In joining can we use * to get all data

  • @sathishsmartworker1668
    @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!

  • @Smith-zz5dq
    @Smith-zz5dq 7 месяцев назад

    supper

  • @mohamednasik7959
    @mohamednasik7959 Год назад

    I have a doubt in the when then statement.

  • @veerasakthivela1966
    @veerasakthivela1966 2 года назад

    💙

  • @abdulrahmanraziq809
    @abdulrahmanraziq809 28 дней назад

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

  • @uCSSAVARIIRUTHAYARAJ
    @uCSSAVARIIRUTHAYARAJ Год назад

    Akkka left Anti join right anti join ah pathi oru video potunga ka plzzz
    😑😓😬😬🥺🥺

  • @lovelyagi4717
    @lovelyagi4717 Год назад

    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

  • @abishektamilan9733
    @abishektamilan9733 7 месяцев назад

    Akka data science soli kundunga

  • @suriyars5662
    @suriyars5662 2 года назад +8

    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
      @LogicFirstTamil  2 года назад +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
      @suriyars5662 2 года назад +1

      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 ✨

  • @hey_itz_me_divya
    @hey_itz_me_divya 9 месяцев назад

    Text konjam perusa kattumga pls

  • @bharathkumar4502
    @bharathkumar4502 Год назад

    Inner join purila