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

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

Sweta Kumari is teaching live on Unacademy Plus

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

U
Unacademy user
please do a course on Indian politics in brief
  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.