Concept
Projection (relational algebra)
Related lectures (21)
Large-scale SQL Processing
Introduces data frames as a space-efficient data representation with an extensible SQL-like language.
Query Optimization: Introduction and Equivalences
Explores query optimization fundamentals, heuristics-based optimizers, cost estimation, and decision-making impact on performance and scalability.
Relational Algebra Equivalences: Optimization Techniques
Explores relational algebra equivalences for optimizing query performance through efficient tuple generation and join operations.
Relational Algebra
Introduces relational query languages, focusing on algebra operators and query optimization.
Database Management Systems: Fundamentals
Introduces the fundamentals of database management systems, covering relational model, storage options, data integrity, queries, and data manipulation languages.
DBMS Principles and Operators
Covers the fundamentals of DBMS, relational algebra operators, and their importance in managing large datasets.
Relational Model: Basics
Covers the basics of the relational model in database management systems, including data models, primary and foreign keys.
Sets and Functions
Introduces binary relations, functions, and various types of relations in sets.
Relational Algebra and SQL: Foundations of Database Management
Introduces the relational model and relational algebra, focusing on SQL and its operations for effective database management.
Relational Semantics of Loops
Explores the relational semantics of loops in programs and the mathematical interpretation of loop structures.