# Relational Algebra & Calculus

Beginner
• 11 videos | 1h 2m 2s
• Includes Assessment
Rating 4.6 of 142 users (142)
Storing data is important, but it's equally important to be able to manipulate and analyze it using a query language like SQL. Explore relational algebra and calculus, developed by Dr. Edgar Codd for his theory for the relational database.

## WHAT YOU WILL LEARN

• Describe relational algebra, what is achieves in a database and the basic operations
Describe the relational algebra union and intersection set operations
Describe the relational algebra difference and cartesian product set operations
Describe the native relational algebra selection operation
Describe the native relational algebra projection operation
Describe the native relational algebra theta, equi, natural, semi join operations
• Describe the native relational algebra outer joins
Describe the native relational algebra division operation
Describe relational calculus for a relational database
Identify what tuple relational calculus is
Identify what domain relational calculus is

## IN THIS COURSE

• After completing this video, you will be able to describe relational algebra, what it achieves in a database and the basic operations.
• Upon completion of this video, you will be able to describe the relational algebra union and intersection set operations.
• 3.  Relational Algebra Difference and Product
After completing this video, you will be able to describe the difference between relational algebra and the Cartesian product set operations.
• 4.  Relational Algebra Selection
After completing this video, you will be able to describe the selection operation in native relational algebra.
• 5.  Relational Algebra Projection
After completing this video, you will be able to describe the projection operation in native relational algebra.
• 6.  Relational Algebra Joins
After completing this video, you will be able to describe the native relational algebra operations: theta, equi, natural, semi join.
• 7.  Relational Algebra Outer Joins
Upon completion of this video, you will be able to describe outer joins in native relational algebra.
• 8.  Relational Algebra Division
After completing this video, you will be able to describe the native relational algebra division operation.
• 9.  Introduction to Relational Calculus
Upon completion of this video, you will be able to describe relational calculus for a relational database.
• 10.  Tuple Relational Calculus
Learn how to identify what tuple relational calculus is.
• 11.  Domain Relational Calculus
In this video, you will learn how to identify what domain relational calculus is, and how it works.

## EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

## YOU MIGHT ALSO LIKE

Rating 5.0 of 1 users (1)
Rating 4.5 of 141 users (141)

## PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.9 of 7 users (7)
Rating 4.6 of 153 users (153)