Sign up now
to enroll in courses, follow best educators, interact with the community and track your progress.
Download
Course Overview (in Hindi)
1,503 plays

More
This course will cover Joins topic in SQL. I will describe type of joins in this course with important examples.

Sweta Kumari
YouTuber (channel : GATE NoteBook) | Verified Educator | 2+ year Online Teaching Experience

Unacademy user
Thanku sir please upload more videos with more practise ques
Deepak poonia
9 months ago
very soon but you please don't forget to recommend the lesson and rate the course...give ur feedback...it matters a lot
Monika Chauhan
9 months ago
Yes sir i will definately share this..it would be very helpful for everyone..
  1. educator WELCOME unacademy LEARNERS INDIA'S LARGEST LEARNING PLATFORM unacadem)y


  2. COMPUTER ABOUT ME ENGINEER EDUCATOR@ Sweta Kumari UNACADEMY CONTENT WRITER DOUBT RESOLVER HOME TUTOR QUORA WRITER GOOD ADVISOR Sweta Kumari Learning is Earning The more you learn, The more you Earn. FOLLOW ME FOLLhttps//unacademy.com/user/hellosonuo1


  3. GATE (CS/IT) - DBMS SQL JOINS TABLE 1 TABLE 2


  4. TARGET AUDIENCE GATE (CS/IT)


  5. COURSE OVERVIEW


  6. SQL JOINS COMBINE 2 OR MORE TABLES 1 TABLE 1 TABLE 2


  7. TYPES OF JOINS 1.INNER JOIN 2. CROSS JOIN 3.LEFT OUTER JOIN 4. RIGHT OUTER JOIN 5. FULL OUTER JOIN


  8. In the process of Joining, rows of both tables are combined in a single table.


  9. TABLE TABLE 2 NEW TABLE


  10. Why SQL JOIN is used? o If you want to access more than one table through a select o If you want to combine two or more table then SQL JOIN statement o It combines rows of that tables in one table and one can retrieve o The joining of two or more tables is based on common field o SQL INNER JOIN also known as simple join is the most common type statement. is used the information by a SELECT statement. between them. of join.