Cassandra for Users

Course Details
Code: CN1-Cass
Tuition (USD): $1,600.00 • Classroom (2 days)

This course provides an architectural introduction to NoSQL systems and the Cassandra database in particular. Students will learn the principles behind the Cassandra partitioned row store and how its characteristics impact the design and use of Cassandra as a database platform. Students will spend much of the course learning version 3 of the Cassandra Query Language. The course covers table creation and the significance of keys as well and design best practices. The course compares and contrasts SQL to CQL and uses various exercises to solidify the similarities and differences between the two query languages. The course also covers the use of compound keys, clustering, collections, column expiration, counters, indexing and a range of additional CQL topics. At the core of the course is an iteratively developed understanding of the vast difference in storage architecture between the cluster native Cassandra system and typical Relational Databases.

Skills Gained

  • This two day hands on course is designed to provide working application developers and technology professionals with a hands on introduction to Cassandra and CQL. Attendees should leave with a clear understanding of the basic architecture of the Cassandra database, how to design effective Cassandra keyspaces and a detailed understanding of the CQL query language.

Who Can Benefit

  • Developers, IT and QA Staff, Technical Managers, DevOps and Build personnel

Prerequisites

  • Each attendee will require the ability to run a 64 bit virtual machine (provided with the course). Basic Linux command line skills are valuable but not required.

Course Details

Cassandra for Users

  • Day 1 - Cassandra Overview
  1. NoSQL Overview and Concepts
  2. Cassandra Architecture
  3. Introduction to CQL & cqlsh
  • Day 2 - CQL
  1. Designing keyspaces, tables and columns
  2. Querying data in depth
  3. Adding, removing and modifying data