Back to Catalog

Performing Table and CRUD Operations with Cassandra

BeginnerGuided Project

In this guided project, you will create a table and perform create, read, update, delete (CRUD) operations in Cassandra using the CQL shell (cqlsh) command line interface.

4.7 (23 Reviews)

Language

  • English

Topic

  • Database

Enrollment Count

  • 178

Skills You Will Learn

  • Cassandra

Offered By

  • IBM

Estimated Effort

  • 25 minutes

Platform

  • SkillsNetwork

Last Update

  • April 30, 2025
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.

You can get a great start with Cassandra by performing create, update, read, and delete (CRUD) operations. In this guided project, you will use the Cassandra Query Language (CQL) Shell client (cqlsh) to explore the non-relational database behavior of a Cassandra keyspace. You will access the Cassandra server and create a keyspace that contains a table. You will learn how to use one command to populate all the rows and columns with data of 1990s movies. Then you will try different ways to work with the table data. Using CRUD, you will add rows, change values, and delete data in the table. You will discover how to display the contents of the entire table and confirm that changes you execute are successful.

Completing this guided project will set you up to execute advanced table operations in the popular Cassandra database.

A Look at the Project Ahead
Once you have completed this project, you'll be able to:
  • Create, alter, and drop a table in a keyspace
  • Extract the details of a table with the DESCRIBE command
  • Perform insert, read, update, and delete operations on a table
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

Instructors

Rav Ahuja

Global Program Director, IBM Skills Network

Rav Ahuja is a Global Program Director at IBM. He leads growth strategy, curriculum creation, and partner programs for the IBM Skills Network. Rav co-founded Cognitive Class, an IBM led initiative to democratize skills for in demand technologies. He is based out of the IBM Canada Lab in Toronto and specializes in instructional solutions for AI, Data, Software Engineering and Cloud. Rav presents at events worldwide and has authored numerous papers, articles, books and courses on subjects in managing and analyzing data. Rav holds B. Eng. from McGill University and MBA from University of Western Ontario.

Read more