Relational Algebra & Calculus

  • 11 Videos | 1h 7m 32s
  • Includes Assessment
  • Earns a Badge
Likes 16 Likes 16
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

  • Playable
    1. 
    Introduction to Relational Algebra
    4m 26s
    UP NEXT
  • Playable
    2. 
    Relational Algebra Union and Intersection
    4m 20s
  • Locked
    3. 
    Relational Algebra Difference and Product
    5m 42s
  • Locked
    4. 
    Relational Algebra Selection
    5m 48s
  • Locked
    5. 
    Relational Algebra Projection
    5m 33s
  • Locked
    6. 
    Relational Algebra Joins
    9m 1s
  • Locked
    7. 
    Relational Algebra Outer Joins
    6m 58s
  • Locked
    8. 
    Relational Algebra Division
    5m 21s
  • Locked
    9. 
    Introduction to Relational Calculus
    4m 4s
  • Locked
    10. 
    Tuple Relational Calculus
    5m 51s
  • Locked
    11. 
    Domain Relational Calculus
    4m 57s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 27 Likes 27  
COURSE SQL Views
Likes 60 Likes 60  
Likes 30 Likes 30