Font size:


This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Cassandra vs. SQL $74.95
Working with Cassandra $74.95

Bundle Price: $99.00
Total Savings: $50.90

Cassandra vs. SQL

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 Casandra, 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
  • 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
  • Describe the component architecture and operational characteristics of the Cassandra framework
  • Describe the Casandra data model, discuss the difference between the Casandra data model and the traditional relational model. Describe best practices for Cassandra data modelling
  • Work with the fundamentals of the CQL syntax
  • Describe Casandra 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
  • Insert records
  • Modify records
  • Delete records
  • Work with the BATCH command
  • 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
  • Work with Cassandra Collection constructs and the Set collection type
  • Work with the List collection type
  • Work with the Map collection type
  • Work with Secondary indexing
  • Work with indexes on multiple columns and map collections
  • Work with live Cassandra and perform CRUD operations on a Cassandra Database

Working with Cassandra

This course continues on from course #1, and develops the learner's exposure to Cassandra Query Language. The course covers Cassandra support for JSON, user-defined functions, and Cassandra drivers for various development platforms

Learning Objectives
  • Start the course
  • Work with the Cassandra System tables
  • Describe management roles, and access and security control on Cassandra resources (objects)
  • Design user security and access
  • Create and assign roles
  • Revoke roles
  • Design/grant user permissions on resources (objects)
  • Revoke user permissions on resources (objects)
  • Use the LIST keyword to analyze roles and permissions
  • Discuss developmental support of Cassandra, and create UDFs with JavaScript
  • Create UDFs with JavaScript
  • Create UDFs with Java
  • Discuss support for JSON in Cassandra
  • Work with SELECT JSON
  • Work with INSERT JSON
  • Utilize the fromJson() and toJson() functions
  • Configure the Java-Cassandra connection/session
  • Performing CRUD operations using Java
  • Configure the Node.js-Cassandra connection/session
  • Performing CRUD operations using Node.js
  • Configure the Python-Cassandra connection/session
  • Performing CRUD operations using Python
  • Manage Cassandra roles and permissions, work with JSON and user-defined functions, and access Cassandra via a development framework: Java, Node.js, and Python
Register Now
Cassandra for SQL Developers e-learning bundle
  • Course ID:
  • Duration:
  • Price: