Cassandra for Users

Note: For additional questions and clarification, you may reach Bill Ramirez at bill@dynamicsedge.com or on his following contact details: Office- (510) 804-3600 & Cell- (415) 200-6969

COURSE OVERVIEW:

This Cassandra training 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 as design best practices. At the core of the course is an iteratively-developed understanding of the vast difference in storage architecture; SQL to CQL are compared and contrasted and exercises are used to solidify the similarities and differences between the two query languages. Training also covers the use of compound keys, clustering, collections, column expiration, counters, indexing and a range of additional CQL topics.

PREREQUISITES:

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

AGENDA TOPICS:

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 Cassandra Query Language (CQL) query language. Learning modules include:

• NoSQL overview and concepts
• Cassandra architecture
• CQL and the CQL shell (cqlsh)
• Designing keyspaces, tables and columns

Data operations: querying, adding, removing, modifying