Relational Algebra & Calculus

Beginner
  • 11 Videos | 1h 2m 2s
  • Includes Assessment
  • Earns a Badge
Likes 41 Likes 41
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
    FREE ACCESS
  • Locked
    4. 
    Relational Algebra Selection
    5m 48s
    FREE ACCESS
  • Locked
    5. 
    Relational Algebra Projection
    5m 33s
    FREE ACCESS
  • Locked
    6. 
    Relational Algebra Joins
    9m 1s
    FREE ACCESS
  • Locked
    7. 
    Relational Algebra Outer Joins
    6m 58s
    FREE ACCESS
  • Locked
    8. 
    Relational Algebra Division
    5m 21s
    FREE ACCESS
  • Locked
    9. 
    Introduction to Relational Calculus
    4m 4s
    FREE ACCESS
  • Locked
    10. 
    Tuple Relational Calculus
    5m 51s
    FREE ACCESS
  • Locked
    11. 
    Domain Relational Calculus
    4m 57s
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Database Fundamentals: Getting Started with SQL
CHANNEL Database Core Concepts
Likes 139 Likes 139  
JOURNEY Essential Math for Data Science
Likes 98 Likes 98  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Logical Design
Likes 148 Likes 148  
COURSE Normalization Concepts
Likes 45 Likes 45  
COURSE Linear Algebra and Probability: Fundamentals of Linear Algebra
Likes 33 Likes 33