Challenge: Create materialized view - Cassandra Tutorial

Contents

• Introduction Introduction

  • Designing data models in Cassandra

    37s
  • What you should know

    53s
  • Exercise files

    32s
• 1. Cassandra Architecture 1. Cassandra Architecture

  • Cassandra and relational databases

    4m 56s
  • (Locked)
    Keyspaces, tables, rows, and columns

    4m 12s
  • (Locked)
    Primary keys and secondary indexes

    4m 40s
  • (Locked)
    Cassandra clusters

    1m 52s
  • (Locked)
    Challenge: Design a table for a mobile app

    33s
  • (Locked)
    Solution: Design a table for a mobile app

    46s
• 2. Installing Cassandra 2. Installing Cassandra

  • (Locked)
    Install Cassandra

    3m 35s
  • (Locked)
    Creating a keyspace and table

    3m 25s
• 3. Cassandra Query Language Data Types 3. Cassandra Query Language Data Types

  • (Locked)
    Numeric data types

    2m 31s
  • (Locked)
    String, date, and unique types

    2m 37s
  • (Locked)
    Collection data types

    1m 29s
  • (Locked)
    Tuple data types

    1m 31s
  • (Locked)
    Working with JSON

    1m 58s
  • (Locked)
    Challenge: Choose the correct data types

    26s
  • (Locked)
    Solution: Choose the correct data types

    28s
• 4. Designing Cassandra Tables 4. Designing Cassandra Tables

  • (Locked)
    Queries drive design

    3m 57s
  • (Locked)
    Denormalizing: Joining or sorting

    3m 49s
  • (Locked)
    Tuning tables to optimize queries

    1m 53s
  • (Locked)
    Data modeling for time series

    1m 16s
  • (Locked)
    Challenge: Define a time series table

    20s
  • (Locked)
    Solution: Define a time series table

    18s
• 5. Additional Table Features 5. Additional Table Features

  • (Locked)
    Secondary indexes

    2m 15s
  • (Locked)
    Materialized views

    2m 6s
  • (Locked)
    Virtual tables

    2m 7s
  • (Locked)
    Challenge: Create materialized view

    22s
  • (Locked)
    Solution: Create materialized view

    44s
• 6. Physical Data Modeling and Distributing Data 6. Physical Data Modeling and Distributing Data

  • (Locked)
    Estimating data size formulas

    3m 12s
  • (Locked)
    Example of estimating data size

    3m 14s
  • (Locked)
    Replication in Cassandra

    1m 48s
  • (Locked)
    Understanding consistency levels

    2m 9s
  • (Locked)
    Challenge: Size a table

    23s
  • (Locked)
    Solution: Size a table

    17s
• 7. Cassandra Architecture and Its Impact on Data Modeling 7. Cassandra Architecture and Its Impact on Data Modeling

  • (Locked)
    Understand the query process

    4m 21s
  • (Locked)
    Understand commit writes

    2m 38s
  • (Locked)
    Bloom filters and query processing

    1m 52s
  • (Locked)
    Understand deletes and tombstones

    1m 46s
  • (Locked)
    Understand compaction

    1m 28s
  • (Locked)
    Challenge: Diagnose performance problem

    18s
  • (Locked)
    Solution: Diagnose performance problem

    22s
• Conclusion Conclusion

  • (Locked)
    Five best practices for Cassandra data modeling

    1m 39s