Difficulty: Beginner
Estimated Time: 15 minutes

In this scenario, you will:

  • Learn about Cassandra Query Language (CQL)
  • Use the CQL shell
  • Execute statements CREATE KEYSPACE, USE and CREATE TABLE
  • Practice using statements INSERT, SELECT, UPDATE and DELETE

In this scenario, you learned about:

  • Cassandra Query Language (CQL)
  • The CQL shell
  • Statements CREATE KEYSPACE, USE and CREATE TABLE
  • Statements INSERT, SELECT, UPDATE and DELETE

One-node Cluster Using Custom Environment

Step 1 of 11

CQL

Cassandra Query Language (CQL) is the primary language for interacting with Apache Cassandra™ databases. CQL data definition and data manipulation statements include:

CQL Data Definition

  • CREATE | ALTER | DROP KEYSPACE
  • USE
  • CREATE | ALTER | DROP | TRUNCATE TABLE

CQL Data Manipulation

  • INSERT (Create)
  • SELECT (Read)
  • UPDATE (Update)
  • DELETE (Delete)

Let's use some of these statements and see how they work.