Back to Catalog

Using the CQL Shell to Execute Keyspace Operations in Cassandra

BeginnerGuided Project

In this guided project, you will use the Cassandra Query Language command line shell and execute keyspace operations in a Cassandra database.

4.6 (15 Reviews)

Language

  • English

Topic

  • Database

Enrollment Count

  • 298

Skills You Will Learn

  • Cassandra

Offered By

  • IBM

Estimated Effort

  • 35 minutes

Platform

  • SkillsNetwork

Last Update

  • March 17, 2026
About this Guided Project
Cassandra is a powerful non-relational database that has its own language, Cassandra Query Language (CQL). The CQL Shell client (cqlsh) is a Python-based command line shell that uses CQL for communicating with a Cassandra database cluster.

In this guided project, you will access a Cassandra server and then use cqlsh to communicate with the server and perform operations on a keyspace in a cluster, which is a collection of nodes. Nodes are layers of systems or storage units.

You will use a development strategy called SimpleStrategy to create the keyspace, a database object that controls replication for its contents. These contents can be tables, materialized views and user-defined types, functions, and aggregates.

As you will explore keyspace behaviors, you will gain experience working with data in Cassandra.

A Look at the Project Ahead
Once you have completed this project, you'll be able to:
  • Access the Cassandra server with cqlsh, the command line interface for using CQL
  • Run simple commands to learn more about the server, session, and available keyspaces
  • Perform operations to create, update, and remove a keyspace
  • Identify the keyspace for the current session and list the tables it contains

What You’ll Need
Just a web browser!

Everything else is provided to you via the IBM Skills Network Labs environment, where you will have access to the Cassandra service that we offer as part of the IBM Skills Network Labs environment. This platform works best with current versions of Chrome, Edge, Firefox, Internet Explorer, or Safari.

Your Instructor
Ramesh Sannareddy