Offered By: IBM
Using the CQL Shell to Execute Keyspace Operations in Cassandra
In this guided project, you will use the Cassandra Query Language command line shell and execute keyspace operations in a Cassandra database.
Continue readingGuided Project
Database
112 Enrolled4.3
At a Glance
In this guided project, you will use the Cassandra Query Language command line shell and execute keyspace operations in a Cassandra database.
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:
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