Offered By: IBM
Performing Table and CRUD Operations with Cassandra
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.
Continue readingGuided Project
Database
133 Enrolled4.7
At a Glance
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.
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:
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
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