• Online, Self-Paced
Course Description

This course will support the students understanding of Cassandra and NoSQL, and will highlight the differences between traditional RDBMS (SQL systems)and Cassandra (NoSQL). In addition the course will discuss the benefits of using Cassandra in a distributed framework to provide availability, scalability, and business continuity. The course will cover the mechanics and architecture of Cassandra, the fundamentals of Cassandra data modeling and best practices, and the Cassandra Query Language (CQL). The first course serves as a foundation for course #2.

Learning Objectives

Introducing Cassandra

  • start the course
  • describe Cassandra and its operation characteristics
  • compare Cassandra with traditional SQL RDBMS, and describe the advantages of Cassandra NoSQL in the modern environment
  • discuss the reasons and driver for migrating to Cassandra and considering Cassandra for new application development
  • describe when and why Cassandra might be selected when developing new applications, or when considering the redesign of existing applications

 

Cassandra Architecture

  • describe the component architecture and operational characteristics of the Cassandra framework
  • describe the Cassandra data model, discuss the difference between the Cassandra data model and the traditional relational model. Describe best practices for Cassandra data modeling

 

Cassandra CQL and DDL

  • work with the fundamentals of the CQL syntax
  • describe Cassandra DDL commands and command syntax
  • work with the Cassandra platform
  • work with the Cassandra cqlsh
  • work with Cassandra Keyspaces
  • work with Cassandra Tables (Column Families)
  • work with Partitions

 

Cassandra DML

  • insert records
  • modify records
  • delete records
  • work with the BATCH command

 

Cassandra Query

  • work with Cassandra SELECT
  • work with DISTINCT and COUNT
  • work with aggregates in Cassandra
  • work with the WHERE clause and conjunction and comparison operators
  • work with result set ordering

 

Cassandra Collections

  • work with Cassandra Collection constructs and the Set collection type
  • work with the List collection type
  • work with the Map collection type

 

Cassandra Indexing

  • work with Secondary indexing
  • work with indexes on multiple columns and map collections

 

Practice: Cassandra vs. SQL

  • work with live Cassandra and perform CRUD operations on a Cassandra Database

 

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration