Relational Algebra & Calculus

Beginner
  • 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
    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 Traditional Data Architectures: Data Warehousing and ETL Systems
CHANNEL Data Science Core Concepts
Likes 336 Likes 336  
COURSE Analyzing Data in Tableau Desktop
Likes 76 Likes 76  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Logical & Physical Design
Likes 106 Likes 106  
COURSE Database Design
Likes 109 Likes 109  
COURSE SQL & Concurrency Concepts
Likes 108 Likes 108