[HW] Mukesh Yadav

[yadavmukesh]

Name: Mukesh Yadav Email: yadav92mukesh@gmail.com Linkedin Profile: www.linkedin.com/in/learning-eyes-mukesh-yadav

Attach the homework screenshots below for both step II and step III:

Step II Create a table - Output Screenshots (below)

Step 2a. Navigate to the CQL Console and login to the database

Step 2b. Describe keyspaces and USE killrvideo

Step 2c. Create the users_by_city table

Describe keyspace table

Step III Execute CRUD operations - OUTPUT Screenshots (below)

Step 3a. Create a couple more tables

Create 2 tables named, comments_by_user and comments_by_video, Insert data into comments_by_user table

Step 3b. (C)RUD = create = insert data Description: Insert data into comments_by_user table

Insert data into comments_by_video table

Step 3c. C(R)UD = read = read data

Description: Display records of comments_by_user table using SELECT clause

Display records of a specific user ID

Read all data from the comments_by_user table and comments_by_video table

Display the timestamp from the value

Step 3d. CR(U)D = update = update data See the primary key: PRIMARY KEY ((videoid), commentid)

Update the record

Step 3e. CRU(D) = delete = remove data

-----------Added new screenshots below------------

Short course completion screenshot: Cassandra Data Modeling

Short course completion screenshot: Cassandra Query Language

[000]

You may need to attach "Congratulations!" screenshots from https://www.datastax.com/node/3272 and https://www.datastax.com/dev/scenario/try-it-out-cassandra-query-language-cql as well, @yadavmukesh .

[yadavmukesh]

You may need to attach "Congratulations!" screenshots from https://www.datastax.com/node/3272 and https://www.datastax.com/dev/scenario/try-it-out-cassandra-query-language-cql as well, @yadavmukesh .

DONE. Have added the remaining homework screen shots at the end of the previous submission. Thank you.

[yadavmukesh]

You may need to attach "Congratulations!" screenshots from https://www.datastax.com/node/3272 and https://www.datastax.com/dev/scenario/try-it-out-cassandra-query-language-cql as well, @yadavmukesh .

Is there anything else pending from my side? Please let me know... Thanks!

[HadesArchitect]

Hey Mukesh Yadav, great job! Congrats! Here is your badge! https://api.badgr.io/public/assertions/QMXNF07pTZ2cJBLT3zs_Xw

[SonicDMG]

This looks great, nicely done.