Description
In this course, you will learn:
- About the architecture of this popular database, and discover how to design Cassandra data models that support scalable applications.
- Differences between Cassandra and relational databases discusses the Cassandra Query Language (CQL), and shows techniques for modeling based on application query requirements.
- Cassandra Architecture
- Cassandra query language data
- Designing Cassandra tables
Syllabus :
- Welcome
- What you should know
- Exercise files
1. Cassandra Architecture
- Cassandra and relational databases
- Keyspaces, tables, and columns
- Primary keys, partitions, and secondary indexes
- Cassandra clusters
- Installing Java
- Installing Cassandra
- Creating a keyspace in tables
- Chapter Quiz
2. Cassandra Query Language Data Types
- Numeric data types
- String, date, and unique types
- Collection data types
- Tuple data types
- Chapter Quiz
3. Designing Cassandra Tables
- Queries drive design
- Denormalizing: Joining or sorting
- Tuning tables to optimize queries
- Data modeling for time series: Part 1
- Data modeling for time series: Part 2
- Time series exercise
- When to use secondary indexes
- When to use materialized views
- UUID and delete exercise
- Chapter Quiz
4. Physical Data Modeling and Distributing Data
- Estimating data size 1: The formulas
- Estimating data size 2: An example
- Replication in Cassandra
- Understanding consistency levels
- Chapter Quiz
5. Cassandra Architecture and Its Impact on Data Modeling
- Understanding the query process
- Understanding commit writes
- Bloom filters and query processing
- Understand deletes and tombstones
- Understand compaction
- Chapter Quiz