Joins in SQL Server - Part 1 | MSSQL Training Tutorial

Поділитися
Вставка
  • Опубліковано 17 жов 2024
  • ** For Online Training Registration: goo.gl/r6kJbB ? Call: +91-8179191999
    💡Visit Our Website for Classroom Training:
    nareshit.in/sq...
    💡 For Online Training:
    nareshit.com/c...
    #sqlserver #server #programming #course #Tutorials #Training #Videos
    --------------------------
    --------------------------
    💡 About NareshIT:
    "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations
    --------------------------
    💡 Our Online Training Features:
    🎈 Training with Real-Time Experts
    🎈 Industry Specific Scenario’s
    🎈 Flexible Timings
    🎈 Soft Copy of Material
    🎈 Share Videos of each and every session.
    --------------------------
    💡 Please write back to us at
    📧 us.training@nareshit.com/ 📧 online@nareshit.com or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999
    --------------------------
    💡 Check The Below Links
    ► For Course Reg: goo.gl/r6kJbB
    ► Subscribe to Our Channel: goo.gl/q9ozyG
    ► Circle us on G+: plus.google.co...
    ► Like us on Facebook: / nareshit
    ► Follow us on Twitter: / nareshitek
    ► Follow us on Linkedin: goo.gl/CRBZ5F
    ► Follow us on Instagram: goo.gl/3UXYK3

КОМЕНТАРІ • 97

  • @NareshIT
    @NareshIT  5 років тому +4

    Please Comment, Subscribe and Click Bell🔔🔔🔔 Icon for More Updates. To learn software course from our experts please register here for online training: goo.gl/HIB0wL

  • @hestiandfamily5602
    @hestiandfamily5602 3 роки тому +4

    Been struggling both english and understanding the content, but i can easily understand what u've explained, thank you sir, god bless you

  • @MrMoKhalaf
    @MrMoKhalaf 7 років тому +9

    @raj raj who cares the english grammar as far we get the knowledge, Sudhakar Sir thank you so much

  • @8008421625
    @8008421625 4 роки тому +2

    I am really Fidaa the way you are teaching Sudhakar sir. Your teaching was excellent. The way you are teaching was very good and easily understanding for beginners as well. I searched many vidoes about to learn Joins concept but those dint helped me. This video made my day. Thank you Sir .

  • @fullstacktutorials2883
    @fullstacktutorials2883 5 років тому +4

    First video where my doubts about types of joins get clear actually. Thanks Mr. Sudhakar L

  • @raghavendraps518
    @raghavendraps518 6 років тому +4

    Explanation is outstanding...super.. All Naresh IT videos are very Helping

  • @sgurumurty8274
    @sgurumurty8274 6 років тому +3

    I really appreciate, the way you explained as crystal clear...... Salute..

  • @KHTbb740
    @KHTbb740 6 років тому +8

    Very well explained , thank you so much for making my life much easier,

  • @vidhya.jjayakumar4610
    @vidhya.jjayakumar4610 5 років тому +3

    All the vedios on SQL server are out standing learnt many things. Thank you so much.
    Can I kindly know if we have vedio on Indexes in SQL server? If it's not recorded request you to kindly upload the same

  • @libanahmed2812
    @libanahmed2812 6 років тому +4

    From Djibouti. thanks teacher well done thanks alot

  • @princemitra1545
    @princemitra1545 3 роки тому

    Explanation is always best from Naresh it

  • @sateeshmuluguru583
    @sateeshmuluguru583 6 років тому +2

    Awesome explanation like spoon feed thanks much it was very simple clear to understand

  • @pulivinodkumar1476
    @pulivinodkumar1476 3 роки тому

    The way of explanation is very good
    It should like spoon feeding

  • @vijaygusain119
    @vijaygusain119 Рік тому

    Thankyou Sir for all your videos…You are an inspiration!

  • @BalaMurugan-du2yx
    @BalaMurugan-du2yx 5 років тому +1

    THANK YOU SIR I AM EASY TO UNTERSTAND THE JOIN OPERATION

  • @gurbachansohal7310
    @gurbachansohal7310 5 років тому +1

    Did you publish any such book on this subject? If yes, what is the name of the book and where it can be purchased from?

  • @Rjno1only1
    @Rjno1only1 3 роки тому +1

    You are Genius Sir.

  • @geethanampalli3134
    @geethanampalli3134 2 роки тому

    thank you so much ....wow it is like spoon feeding ...any one can understand .....thank you so much

  • @HariKrishnaForYou
    @HariKrishnaForYou 3 роки тому

    Hello sir,
    Instead of what you wrote,
    Can I write like this...
    SELECT * FROM COURSE INNER JOIN STUDENT ON COURSE.COURESEID=STUDENT.COURSEID....

  • @ashi7606
    @ashi7606 3 роки тому

    Clear explanation sir.thanku from beginners.please you can upload classes on informatica real time

  • @monishan1943
    @monishan1943 5 років тому

    Tq sir this will be very useful I understood each and every line.....

  • @sreemalya852
    @sreemalya852 4 роки тому

    Sir , equi join and inner join are performing same operation , is there any difference sir ?

  • @maheshkatagani2199
    @maheshkatagani2199 6 років тому

    wow Clear explanation sir...................

  • @prathapg317
    @prathapg317 6 років тому +3

    YOU ARE EXCELLENT SIR,KEEP IT UP.

  • @Time_Traveller_Dubai
    @Time_Traveller_Dubai 2 роки тому

    Sir is all command same on oracle SQL ?

  • @pingalisaidireddy4138
    @pingalisaidireddy4138 6 років тому +1

    Excellent teaching sir

  • @Chidu-Goudru
    @Chidu-Goudru 2 роки тому

    Amazing explanation sir sprrbbb🌹🌹

  • @gurud3736
    @gurud3736 6 років тому

    very nice explanation iam really enjoyed this video tq you so much sir

  • @seekersofwisdom85
    @seekersofwisdom85 2 роки тому

    I had always heard about the Naresh academy. But I'm so amazed by the content. it's very ordinary guys. Please get out of your comfort zone and explain things with concepts and not bookish knowledge.

  • @yeswanthreddyg3674
    @yeswanthreddyg3674 3 роки тому

    great explanation sir very well understood

  • @RAMAKRISHNAKONDU
    @RAMAKRISHNAKONDU Рік тому

    perfectly understand , thankyou sir

  • @surendrasamasani8246
    @surendrasamasani8246 6 років тому

    Wonderful.......Easily understanding , Much thanks sir.

  • @dawnhuttoe7204
    @dawnhuttoe7204 Рік тому

    Great explanation 👌

  • @andrewericson781
    @andrewericson781 5 років тому

    I am trying to do this with a school system theme. I have two different tables I'm trying to merge:
    one with basic student info and the other table contains their scores. both tables contain the correlating "student_id" but when I do the merge, all the scores show up as "NULL."
    What am I doing wrong?

  • @mohdmuzammil3059
    @mohdmuzammil3059 5 років тому

    Explained beautifully sir

  • @agiledamodharareddy9345
    @agiledamodharareddy9345 Рік тому

    Hi sir will you provide the power bi

  • @virtualreality1705
    @virtualreality1705 6 років тому +1

    Is that common column aka foreign key?

  • @avtarsashia4897
    @avtarsashia4897 5 років тому

    thank u sir....excellent way to teach sir

  • @praneethasakkuru4986
    @praneethasakkuru4986 4 роки тому

    why shouldn't we use Where for ANSI-FORMAT joins?
    can anyone please tell?

  • @NikhilKumar-ys2ji
    @NikhilKumar-ys2ji Рік тому

    In which join primary and foreign key concept are used??
    In this video of Inner join concept I see that there is no primary key and foreign key concept but
    but we take a cmomon column from both the tables as "courseID" as same as primary key and foreign key concept.
    Anyone having a satisfied answer the please share among us . That helps alot😊😊

  • @sowmyanalla2716
    @sowmyanalla2716 6 років тому

    Thank you so much for your valuable video sir, You have explained very clearly

  • @raghavpspk5120
    @raghavpspk5120 2 роки тому

    Nice explanation sir

  • @mantrijagadeesh4372
    @mantrijagadeesh4372 2 роки тому

    God bless you sir
    Thank you sir

  • @satyavaniboddu9987
    @satyavaniboddu9987 3 роки тому

    Thank you sir, clr explanation

  • @rajeshbe2234
    @rajeshbe2234 6 років тому

    Nice explanation sir Thank you very much...

  • @Rjno1only1
    @Rjno1only1 3 роки тому

    Hatts off to you sir..

  • @meghasandesam
    @meghasandesam 6 років тому

    Good voice,nice explanation tq sir

  • @niharikamysoreramakumar7573
    @niharikamysoreramakumar7573 3 роки тому

    thanks a lot. very well explained

  • @damudamodhar6969
    @damudamodhar6969 5 років тому

    Sir no need of primary and foreign keys for joins
    And and joining the two tables

  • @jananis1621
    @jananis1621 6 років тому

    excellent teaching

  • @Akashkumar-qp3yc
    @Akashkumar-qp3yc 5 років тому

    The explanation is good but i to simple and short you should explain something complex including more tables and increase the difficulty

  • @chandinimallidi2516
    @chandinimallidi2516 5 років тому

    Tqqqq very much sirr.......u cleared all my doubts nd xclnt xplntion

  • @karthiky898989
    @karthiky898989 5 років тому

    Nice lecture.

  • @chintusmart6637
    @chintusmart6637 4 роки тому

    hi sir iam student of u r class
    iam a bsc mpc student and i dont know c languages
    but i have computer knowladge
    sir can i learn .net sir?
    and also is it useful to get a job ? with my qualification

  • @manojshivankar
    @manojshivankar 5 років тому

    I am very new to SQL Server. I have one query on this. Can we swap the joining condition? like in this video you mentioned student.courseid=course.courseid so what will impact if I use the course.courseid =student.courseid. I appreciate your help and this video.

    • @NikhilKumar-ys2ji
      @NikhilKumar-ys2ji Рік тому

      just simple bro if you try to drive your car opposite to that lane then what happens accident(crash)
      so here your command crashes and gives error. so try to follow the rules don't make your own😊😊

  • @sangramsingh9487
    @sangramsingh9487 5 років тому

    Hi Sir..i have a interview question can you please upload vedio about what is data souce and what are data set and what type of data source and data sets

  • @nishakicooking1236
    @nishakicooking1236 5 років тому

    I love you.... Sir you are my sql God

  • @venkateshm9066
    @venkateshm9066 7 років тому

    excellent explanation sir...

  • @rajejyothi6629
    @rajejyothi6629 Рік тому

    Red mark didn't display sir how to choose that sir plz explain that

  • @poojakapoor638
    @poojakapoor638 6 років тому

    superb sir

  • @PREMKumar-qt9my
    @PREMKumar-qt9my 7 років тому

    really good explanation sir

  • @kireetiyakkali
    @kireetiyakkali 6 років тому

    Very helpful thank you

  • @roshanibangar5568
    @roshanibangar5568 7 років тому

    excellent explanaion

  • @shashankhosur2001
    @shashankhosur2001 2 роки тому

    Video is super

  • @rakeshyendhe1080
    @rakeshyendhe1080 5 років тому

    Nice Sir....

  • @mohansaivelagapudi929
    @mohansaivelagapudi929 3 роки тому

    Thank you sir

  • @tiwarinitisha
    @tiwarinitisha 5 років тому

    Thank you sir please give some information about pl sql architecture

  • @vanamabhinaytinku6552
    @vanamabhinaytinku6552 4 роки тому

    Tq very much sir

  • @amitthakur528
    @amitthakur528 6 років тому

    So nice thanku..

  • @nishakicooking1236
    @nishakicooking1236 5 років тому

    Thank you.... So much bro........

  • @vickybhoir9536
    @vickybhoir9536 6 років тому

    Thanks for this session... sir

  • @udayrajpatel9048
    @udayrajpatel9048 5 років тому

    Well sir

  • @princenayak6363
    @princenayak6363 7 років тому

    here no videos tutorial on Equi and Non Equi join....plz sir /madam request upload this topics videos

  • @siribn2657
    @siribn2657 3 роки тому

    suggest me some practice excercises for sql server please

  • @manjrulhasan4997
    @manjrulhasan4997 6 років тому

    SIR, DID YOU HAVE ANY .NET MVC TUTORIAL OF YOUR OWN, THEN PLEASE GIVE ME THE LINK. THANKS IN ADVANCE

  • @sklinfo5489
    @sklinfo5489 4 роки тому

    Sir, I want to see sql 12c video master table . From Bangladesh.

  • @pasulapraneethreddy1740
    @pasulapraneethreddy1740 7 років тому

    CAN U UPLOAD THE VIDEO LINK FOR EQUI AND NON EQUI JOINS?

  • @pratiksingh896
    @pratiksingh896 6 років тому

    well video

  • @takeadecisionupwork3772
    @takeadecisionupwork3772 3 роки тому +1

    sir you look like vijay setupathi

  • @Creative3469
    @Creative3469 4 роки тому

    What is the difference between inner join and equi join?

  • @pranitkokne8587
    @pranitkokne8587 6 років тому

    Thanks a lot....!

  • @snehashippurkar9490
    @snehashippurkar9490 Рік тому

    How to install sql server

  • @nagurumarshaik3991
    @nagurumarshaik3991 6 років тому

    sir send view concept how to create all

  • @vadlapudirajesh4183
    @vadlapudirajesh4183 Рік тому

  • @chilloutshow
    @chilloutshow 3 роки тому

    Not so interesting video, Mr Srinivas is best instructor, ask him to teach these chapters too

  • @raghavendraraj776
    @raghavendraraj776 Рік тому

    😎👍🏽

  • @it-mg4ug
    @it-mg4ug 7 років тому

    good knowledge of concepts but very very poor English, tutor grammar is horrible

    • @vasug5140
      @vasug5140 7 років тому +1

      better you attend for English classes..if you need good english

    • @arun466
      @arun466 7 років тому +2

      This channel is for SQL n this guy is damn good at it. If u want english lessons, there r other channels on YT.

    • @nishakicooking1236
      @nishakicooking1236 5 років тому +1

      @@arun466 i agree with you

    • @apoorva3635
      @apoorva3635 4 роки тому +2

      Are you here to learn English?
      By the way, Mr. Grammar Nazi, sentences begin with a capital letter & end with a full stop. Your comment is full of errors. Learn proper English before pointing your fingers at others.

    • @vidyasagarg4214
      @vidyasagarg4214 4 роки тому +1

      @@apoorva3635 Nice 👊

  • @Sureshdayyala456
    @Sureshdayyala456 5 років тому

    Very nice explanation sir. Thank you