Explore example queries in the relational model and learn about the outer join operation in this 39-minute lecture from NPTEL-NOC IITM. Dive into topics such as the complete set of operators, transitive closure queries, and various types of outer joins including left and full outer joins. Gain practical insights through multiple example queries and understand how to work with instance data for real-world applications.
Example Queries in Relational Model and Outer Join Operations
Overview
Syllabus
Intro
Complete Set of Operators
More Example Queries
Another Example Query
Transitive Closure Queries
Outer Join Operation (1/2)
Instance Data for Examples
Left outer join
Full outer join
Taught by
NPTEL-NOC IITM
