Relational Algebra & Calculus

Beginner
  • 11 videos | 1h 2m 2s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 141 users Rating 4.6 of 141 users (141)
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

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

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

Course CompTIA Data+: Data Analytics Tools
Rating 4.3 of 32 users Rating 4.3 of 32 users (32)
Course Database Fundamentals: Getting Started with SQL
Rating 4.5 of 268 users Rating 4.5 of 268 users (268)
Channel R for Data Science

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Software Testing Foundation 2018: Fundamentals
Rating 4.5 of 1210 users Rating 4.5 of 1210 users (1210)
Book Fundamental of Database Management System
Book Relational Database Design and Implementation, Fourth Edition