Table of Contents

1. Challenge

   Connect to the Database and Create a New Keyspace

   Note: The version of Cassandra has been updated to 3.11.8.

   Start the Cassandra Query Language shell:

   /home/cloud_user/apache-cassandra-3.11.8/bin/cqlsh
   

   Create a new keyspace named demo with a SimpleStrategy replication and 1 node:

   CREATE KEYSPACE demo WITH replication = {'class':'SimpleStrategy', 'replication_factor' : 1};
   

   Note This replication configuration is for demonstration only and is not recommended for production use.

2. Challenge

   Create a Table

   Create a table named users in the demo keyspace:

   USE demo;
   

   CREATE TABLE users (ID int PRIMARY KEY, Name text, Department text, ExpenseCode int);
   

   DESCRIBE users;
   

3. Challenge

   Insert Some Data

   INSERT INTO users (ID, Name, Department, ExpenseCode) values (0, 'David', 'Engineering', 200);
   

   then

   INSERT INTO users (ID, Name, Department, ExpenseCode) values (1, 'Clay', 'HR', 100);
   

   then

   INSERT INTO users (ID, Name, Department, ExpenseCode) values (2, 'Sue', 'Sales', 300);
   

   then

   INSERT INTO users (ID, Name, Department, ExpenseCode) values (3, 'Betty', 'Marketing', 400);
   

   once you have inserted the above information, run a query to see the data entered into the table with SELECT * from users;

4. Challenge

   Query the Data

   Query the database and print only the name and department for all users:

   SELECT Name, Department from users;