CQL (Cassandra Query Language) is a query language for the DataStax Enterprise database.
CQL data modeling
Basic rules to follow when designing a DataStax Enterprise database.
Data modeling concepts
Uses a Pro cycling example to demonstrate the query drive approach to data modeling.
Data modeling analysis
Analyze the design based on storage, capacity, redundancy, and consistency.
Introduction to CQL commands
Shows the CQL command syntax and rules, and provides instruction on using CQL shell (cqlsh).
Accessing data using CQL
Resources for running CQL commands, including steps to launch the cqlsh utility.
Understanding the CQL command syntax
Provides the basic rules and limitations for writing CQL statements.
Create/drop keyspaces, manage the table replication factor (data availability), and create/drop user-defined types, functions, and aggregates.
Describes database objects defined in a keyspace, including tables, types, functions, and aggregates.
Creating a keyspace is the CQL counterpart to creating an SQL database.
Use the USING TTL N option with INSERT and UPDATE statements to automatically expire data in a column.
About system keyspace tables
Provides details about database objects and cluster configuration in the system keyspace tables.
How to create tables to store data.
Creating a table
How to create CQL tables.
Creating a materialized view
How to create CQL materialized views.
Creating a counter table
A counter is a special column for storing a number that is changed in increments.
Creating a table with COMPACT STORAGE
Create a table that is compatible with the legacy (Thrift) storage engine format.
Table schema collision fix
How to fix schema collision problems.
Altering a table
How to alter a table to add or delete columns or change table properties.
Altering a materialized view
Altering the properties of a materialized view with the ALTER MATERIALIZED VIEW command.
Dropping a table or materialized view
Steps for dropping keyspace, table or materialized view using the DROP command.
How to query data from tables using indexes.
Retrieve data sets from a table using SELECT statements.
About SELECT statements
How to query data from tables.
Setting consistency levels
Set the consistency level to control the accuracy of the data returned by read request.
Writing conditional statements
Scanning partition when the table has more than one clustering column and comparing groups of clustering keys to certain values.
Sorting and limiting results
Using the SELECT command for simple queries.
How to retrieve data from a collection.
Using the SELECT command to return data and apply standard aggregate functions.
Using user-defined functions (UDF)
Using the SELECT command to return data and applying a UDF.
Determining the date/time of a write
Using the WRITETIME function in a SELECT statement to determine when the date/time that the column was written to the database.
Formatting query results as JSON
Using the SELECT command to return JSON data.
How to work with legacy tables.
Inserting and updating data
How to insert data into a table with either regular or JSON data.
Using INSERT and UPDATE commands
Inserting set data with the INSERT command.
Writing to a set type
How to insert or update data into a set.
Writing to a list type
How to insert or update data into a list.
Writing to a map type
How to insert or update data into a map.
Writing to a user-defined type (UDT)
How to insert or update data into a user-defined type (UDT).
Expiring data with time-to-live
Use time-to-live (TTL) to expire data in a column or table.
Use the DELETE command to replace the value in a column with null or to remove an entire row of data.
Batching inserts and updates
Performing multiple writes in the same command.
Batching inserts, updates and deletes
Batching inserts, updates and deletes.
Good use of BATCH statement
How to use a BATCH statement.
Misuse of BATCH statement
How to misuse a BATCH statement.
About using CQL.
CQL data types
Built-in data types for columns.
CQL support functions for transforming one or more column values into a new value.
CQL shell commands
The CQL shell (cqlsh utility) commands.