From the course: Advanced SQL: High Performance Relational Divisions

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Relational algebra

Relational algebra - SQL Tutorial

From the course: Advanced SQL: High Performance Relational Divisions

Start my 1-month free trial

Relational algebra

“

- [Instructor] Relational algebra is the basis for all relational operations. The word, algebra, originates from the Arabic, al-jabr, which means the restoring of broken parts. The mathematical sense comes from an early 19th century book titled, (speaking Arabic) "The Science of Restoring and Balancing," by the Persian mathematician and astronomer, Abu Ja'far Muhammad ibn Musa, known as al-Khwarizmi. He is also responsible for the term, algorithm. Relational algebra was introduced by Dr. Codd as the foundation for relational database query languages, SQL being chief among them. Before that relational algebra was an obscure field which was used by few theoretical mathematicians. Think of relational algebra the same way you think of numeric algebra, also known as arithmetic. Arithmetic deals with numbers while relational algebra deals with relations. an arithmetic operation takes one or more numbers and results in a number.…

Contents