Learn about Apache Cassandra and its key scalable and reliable data management features.

cassandra.tar.gz

Apache Cassandra is an open-source, distributed NoSQL database recognized for its scalability, reliability, and continuous availability. The course explores the core concepts that drive these features, including distributed architecture, data modeling, CQL, table design, data types, tunable consistency, and the read/write path. 

Lessons combine theoretical insights with hands-on exercises, allowing you to execute CQL queries directly in your browser and view real-time results with no setup required. Additionally, each module concludes with a quiz to test your understanding of the material. 

By the end of this course, you’ll be equipped with the skills needed to use Cassandra for high-performance data management.

Introduction to Apache Cassandra

**(True or False)** A table’s primary key *can* be updated post table creation.


(True or False) A table’s primary key can be updated post table creation.

Which column(s) values *must* be specified in the `WHERE` clause to run a `CQL` query on a table?


Which column(s) values must be specified in the <code>WHERE</code> clause to run a <code>CQL</code> query on a table?

A table’s primary key is defined as: 
```
PRIMARY KEY(a, b, c)
```
What is the partition key for the table?


A table’s primary key is defined as:
<pre><code>PRIMARY KEY(a, b, c)
</code></pre>
What is the partition key for the table?

A table’s primary key is defined as: 
```
PRIMARY KEY(a, b, c)
``` 
What are the clustering columns for the table?

A table’s primary key is defined as:
<pre><code>PRIMARY KEY(a, b, c)
</code></pre>
What are the clustering columns for the table?

How many clustering columns does the  table with the primary key defined below have? 
```
PRIMARY KEY((a, b, c)) 
```



How many clustering columns does the table with the primary key defined below have?
<pre><code>PRIMARY KEY((a, b, c)) 
</code></pre>

Data in column1 is tombstoned only while the rest of the row remains.

Data in all columns with `WRITETIME` <= `TIMESTAMP` will be tombstoned, while data in columns with `WRITETIME` > `TIMESTAMP` will remain.

If a Cassandra row has data in three columns with different `WRITETIME`s. What happens if a `DELETE` statement for the entire row is issued `USING TIMESTAMP` specifying `WRITETIME` for `column1`?
   


If a Cassandra row has data in three columns with different <code>WRITETIME</code>s. What happens if a <code>DELETE</code> statement for the entire row is issued <code>USING TIMESTAMP</code> specifying <code>WRITETIME</code> for <code>column1</code>?

**(True or False)** The table option `CLUSTERING ORDER` *cannot* be altered post table creation.

(True or False) The table option <code>CLUSTERING ORDER</code> cannot be altered post table creation.

A row is inserted with data specified in the `UPDATE` statement.


What happens if an `UPDATE` statement for a non-existent row is made?

What happens if an <code>UPDATE</code> statement for a non-existent row is made?

**(Fill in the blank.)** Values of ________ columns are shared among rows of a partition.

(Fill in the blank.) Values of ________ columns are shared among rows of a partition.

Test your understanding of DDL, DML, Primary Keys, Static Columns, Secondary Indexes, and Denormalization in Apache Cassandra tables.

Getting Started

Apache Cassandra Overview

Apache Cassandra Architecture

Apache Cassandra Data Modeling

Apache Cassandra Table

Apache Cassandra Data Types

Tunable Consistency

Apache Cassandra Read and Write Path

Wrap Up

Quiz: Apache Cassandra Table