Join Dan Sullivan for an in-depth discussion in this video What you should know, part of Cassandra Data Modeling Essential Training.
- [Instructor] For this course, I assume you have some familiarity with basic database concepts like tables and columns. We'll cover specific details of how Cassandra uses these concepts. At some point I'll make comparisons with relational databases. Knowledge of relational data modeling can help at these points, but it's not necessary. For the exercises, I've installed Cassandra from the Apache Project Foundation website and the Java Runtime Environment from the java.com website. I've installed Linux on VirtualBox, which is running on my Mac.
If you're not familiar with installing Linux in VirtualBox, I suggest you view the course, Linux: Overview and Installation. Details for installing Cassandra can be found at the Apache Project Foundation and Documentation. Instructions for installing Java on Linux can be found at java.com. During the exercise videos, I'll use a command line tool called cqlsh to work with Cassandra. If you plan to do the exercises, it helps to have some experience working with command line tools.
Finally, two versions of Cassandra are currently in use, versions two and three. Most of the material in this course applies to both. The section on materialized views, however, applies only to version three.
- Cassandra architecture
- Keyspaces, tables, and columns
- Installing Java and Cassandra
- CQL data types
- Designing Cassandra tables
- Tuning tables to optimize queries
- When to use secondary indexes and materialized views
- Physical data modeling and distributing data
- Cassandra architecture and its impact on data modeling