Course Outline


About Cassandra

Pre-requisites

  • Participants must have good knowledge of relational databases and NoSQL databases
  • Participants must be comfortable in a Linux environment
  • Knowledge of MVC application development is preferred

Duration

  • 2-3 Days

Lab Setup

  • Hardware Configuration
    • 2GB of free RAM, 20GB of free disk space and full network connectivity
  • Software Configuration
    • Ubuntu 16.04 Desktop Edition

Course Outline for Cassandra

Overview - SQL/NoSQL
  • Datastore design considerations
  • Relational v/s NoSQL stores
  • Entities, Relationships and Database modeling
  • When to use Relational/NoSQL?
  • Categories of NoSQL stores
  • Examples of NoSQL stores
Getting Started with Cassandra
  • Installing Cassandra
  • Configuring Cassandra
  • Inserting and Querying
  • Client Drivers
Architecture
  • Dynamo
  • Gossip
  • Failure Detection
  • Token Ring/Ranges
  • Replication
  • Tunable Consistency
  • Commitlog
  • Memtables
  • SSTable
  • Guarentees
Cassandra Query Language
  • Definitions
  • Data Types
  • Data Definition
  • Data Manipulation
  • Secondary Indexes
  • Materialized Views
  • Security
  • Functions
  • Arithmetic Operators
  • JSON Support
  • Triggers
Operating Cassandra
  • Snitch
  • Adding, replacing, moving and removing nodes
  • Repair
  • Read repair
  • Compaction
  • Bloom Filters
  • Compression
  • Change Data Capture
  • Backups
  • Bulk Loading
  • Monitoring
  • Security
Cassandra Tools
  • cqlsh: the CQL shell
  • Nodetool
  • Cassandra Stress

The classroom training will be provided in Bangalore (Bengaluru), Chennai, Hyderabad or Mumbai and will be conducted in the client's premises. All the necessary hardware/software infrastructure must be provided by the client.