Relational algebra is a theory used to model data and define queries on it with a well-founded semantics. It is mainly used to provide a theoretical foundation for relational databases, particularly query languages such as SQL. It consists of operators that transform one or more input relations into an output relation, which can be combined to express complex queries. Unary and binary operators are the most common, but more advanced operators can also be included.
Carnegie Mellon University
Fall 2016
This course introduces databases, data models, SQL, database design, query optimization, indexing, and transaction management. It aims to impart understanding of when and how to use database management systems. The course is heavily based on the textbook "Database Management Systems" by Raghu Ramakrishnan and Johannes Gehrke.
No concepts data
+ 20 more conceptsUC Berkeley
Spring 2023
This project-heavy course covers access methods, data models, query languages, database services, and interfaces. It introduces transaction processing and requires CS 61A, CS 61B, and CS 61C as prerequisites/corequisites. It suggests proficiency in Java for project work.
No concepts data
+ 23 more concepts