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.