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
    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 SQL Databases Using SQLAlchemy: Manipulating Data
Likes 0 Likes 0  
COURSE Traditional Data Architectures: Relational Databases
Likes 0 Likes 0  
COURSE Data Engineering on Microsoft Azure: Logical Data Structures
Likes 0 Likes 0  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Normalization Concepts
Likes 27 Likes 27  
COURSE SQL Views
Likes 60 Likes 60  
COURSE Architecture Concepts
Likes 30 Likes 30