Joins and Subqueries
The concepts of Subqueries and Joins. This lesson deals with the several kinds of joins, Subqueries and usage of Pseudocolums like ROWID, LEVEL, and ROWNUM.
• Cartesian Product
• Different Joins
• Equi-Join
• Self Join
• Outer Join
• Non-Equi Join
• Subqueries
• Correlated Subquery
• Pseudocolums