Introduction to CQL and data modeling.

Cassandra Query Language (CQL) enables you to communicate with DataStax Distribution of Apache Cassandra (DDAC) and create database tables, manipulate data, and perform other activities. CQL has a similar syntax to SQL.

In this document, you will perform these tasks:

  • Learn to retrieve data using the CQL SELECT statement.
  • Begin learning about Cassandra data modeling and how it differs from relational database modeling. A data model is used to define the database tables, and the tables are created using CQL.
  • Use CQL statements to create and drop database keyspaces and tables.
  • Insert, retrieve, update, and delete data.
Note: You can use the DataStax Bulk Loader application to load data from CSV or JSON files into the database.