Working with Apache Cassandra: Partitioning & Clustering Keys

Apache Cassandra 4.0    |    Expert
  • 14 videos | 1h 42m 19s
  • Includes Assessment
  • Earns a Badge
Primary keys play a special role in Apache Cassandra. Not only are they used to uniquely identify a row in a table, they are also used to decide where and how data is stored in the underlying cluster. Begin by creating tables with different combinations of partitioning and clustering key columns, querying the tables, and confirming the keys were taking effect. Then, explore the exact semantics of queries on partition and clustering key columns. Finally, learn how to use the nodetool and grep utilities to view properties of partitions and to verify how rows are mapped to partitions on the basis of token ranges assigned to each partition. Upon completion, you will be able to contrast primary keys in Cassandra with those in other data technologies, differentiate between clustering and partition keys, and identify types of queries that are and are not allowed in Cassandra.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    describe partitioning and clustering keys
    recall how data is modeled in Cassandra
    describe speciic features of Cassandra, such as token ranges and vnodes
    recall how partitioning and clustering keys work
    view the partitions in tables
    use partitioning and clustering keys
  • partition and cluster data
    create tables with multiple partition columns
    insert rows in tables with partition and clustering keys
    order rows in tables with partitions
    query tables with primary and clustering keys
    access partition tokens
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 3s
    UP NEXT
  • Playable
    2. 
    Partitioning Data
    10m 23s
  • Locked
    3. 
    Data Modeling in Apache Cassandra
    9m 38s
  • Locked
    4. 
    Features of Apache Cassandra
    11m 13s
  • Locked
    5. 
    Understanding Partitioning and Clustering Keys
    9m
  • Locked
    6. 
    Viewing the Partitions in Tables
    9m 39s
  • Locked
    7. 
    Using Partitioning and Clustering Keys
    6m 45s
  • Locked
    8. 
    Partitioning and Clustering Data
    5m 26s
  • Locked
    9. 
    Using Multiple Partition Keys
    5m 9s
  • Locked
    10. 
    Adding Rows to Tables with Primary Keys
    4m 35s
  • Locked
    11. 
    Performing ORDER BY Operations
    10m 6s
  • Locked
    12. 
    Querying Tables with Primary and Clustering Keys
    7m 4s
  • Locked
    13. 
    Querying Tables with Primary Keys
    8m 51s
  • Locked
    14. 
    Course Summary
    3m 28s

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.