Relational Algebra

Relational algebra

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.

2 courses cover this concept

15-415/615 Database Applications

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 concepts

CS 186 Introduction to Database Systems

UC 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