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

This scenario is also available on our datastax.com/dev site, where you can find many more resources to help you succeed with Apache Cassandra™.

Did you know?

You can use Cassandra as a service in the cloud. Nothing to install, no credit card required. Sign up and launch your database with a few clicks at astra.datastax.com!

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

Cassandra Query Language

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.