The Apache Cassandra course at starts with the fundamental concepts of using a highly-scalable, column-oriented database to implement appropriate use cases. It will cover topics like Cassandra Data models, Cassandra Architecture, Differences between RDBMS and Cassandra to name a few. There will be many challenging, practical and focused hands-on exercises for the learners during this course.

After the completion of this training, you should be able to:

• Learn about Cassandra and NoSQL domain
• Create Cassandra cluster for various kinds of applications
• Understand Apache Cassandra Architecture
• Design and model Applications for Cassandra Port existing application from RDBMS to Cassandra
• Learn Cassandra admin operations for managing a cluster

Cassandra training helps you master NoSQL database known for Scalability and High Availability without compromising on Performance. You'll gain expertise in Cassandra Data Model, Data Modelling, Architecture, Cassandra Hadoop Integration, CQL with real-life industry use-cases.

• A developer working with large-scale, high-volume websites.
• An application architect or data architect who needs to understand the available options for high-performance, decentralized, elastic data stores.
• A database administrator or database developer currently working with standard relational database systems who needs to understand how to implement a fault-tolerant, eventually consistent data store.
• A manager who wants to understand the advantages (and disadvantages) of Cassandra and related columnar databases to help make decisions about technology strategy.
• A student, analyst, or researcher who is designing a project related to Cassandra or other non-relational data store options.

This course assumes no prior knowledge of Apache Cassandra or any other NoSQL database. Though some familiarity with Linux command line is essential, minimal exposure to Java, database or data-warehouse concepts is required

Your system should have a 4GB RAM, a processor i3 and above and 64 bit operating system. In case, your system falls short of these requirements, we can provide you Remote Access to our Cluster.

For your practical work, we will help you set up a Virtual Machine in your system and install Cassandra in it. This will be a Local access for you.

Objectives:

· Create a Java web application that simulates the functionality of an online music service.

· Demonstrate ability to implement the concepts learnt during the course on a real-life problem. Create Cassandra databases and tables.

· Create database using CQLSH tool as well as latest Java driver API.

· Access the data using the Datastax java drivers.

Tasks/Activities to be performed:

· Create application data model using Cassandra Query Language

· Create online music service web application using Datastax java driver.

Objectives:

• Understanding the limitations of RDBMS solution 

• What is 3V – Volume, Variety and Velocity

• Understanding the term NOSQL 

• Learning common characteristics of NoSQL databases.

• Understanding CAP theorem

• What is Cassandra 

• History of Cassandra 

• Features of Cassandra

Topics:

• Limitations of RDMS solutions.

• NOSQL databases.

• Common characteristics of NoSQL databases.

• CAP theorem.

• What is Cassandra?

• History of Cassandra.

• Features of Cassandra.

• Downloading Apache Cassandra distribution

• Preparing the environment – Installing Java , Configuring ports

• Installing Cassandra using package and tarball installation

• What are the main configuration files in Cassandra

• Understanding required directory permissions

• Starting Cassandra and checking status

• Accessing Cassandra log files

Topics: 

• Downloading Cassandra distribution.

• Prepare the Environment

o Ensuring Oracle Java 7 Is Installed – Cassandra 2.x

o Ensuring Oracle Java 8 Is Installed – Cassandra 3.x

o Configuring the ports.

• Installing Cassandra.

o Package Installation.

o Tarball installation.

• Viewing the main Configuration files.

• Providing Cassandra with Permission to directories.

• Starting Cassandra.

• Checking Status.

Objectives:

• Understanding what a database model is and why it is important

• Understanding the analogy between RDBMS and Cassandra data model

• Understanding the key database elements in Cassandra

• Difference between static and dynamic tables and their use-cases

• What is a primary key

• How to create a static and dynamic table using primary key

• Understanding the concept of clustering columns to sort data with in a partition

Topics: 

• Understanding what a database model is

• Understanding the analogy between RDBMS and Cassandra data model

• Understanding following database elements

a. Cluster

b. Keyspace

c. Column Family/table

d. Column

• Understanding Static and dynamic tables

• Understanding the primary key

• Understanding compound primary keys and clustering.

Objectives:

• Understanding that Cassandra is a distributed database 

• Understanding key Cassandra elements

• Learn how Cassandra replicates data 

• Learning Gossip protocol – Detecting failures

• Understanding the purpose of Snitch

• Understating virtual nodes

• Cassandra write path

• Cassandra read path

• Understanding repair , read repair 

• Understanding Incremental repair and its benefits

Topics: 

• Understanding That Cassandra Is A Distributed Database

• Key Cassandra elements

a. Memtable

b. Commit log

c. SSTables

• Learn how Cassandra replicates data 

• Learning Gossip protocol – Detecting failures

• Learning What Snitch Is For

• Learning What Gossip Is For

• Learning How Data Gets Distributed

• Learning About Virtual Nodes

• Understanding Write path 

• Understanding read path

• Understanding Replication Factor

• Understanding consistency level

• Understanding repair 

• Understanding incremental repair

Objectives:

• What is a keyspace in Cassandra

• What is the attributes of a keyspace

• What is replication factor

• What is replication strategy

Topics:

• Defining a keyspace

• Deleting a keyspace

• Understanding Replication Factor

• Understanding Replication Strategy

Hands ON/Demo

• Create a keyspace, specify the replication factor and replication strategy while creating keyspace using CQLSH

Objectives:

• What is a table in Cassandra database

• What data types Cassandra supports

• How to define columns 

• Understanding the concept of primary key, composite primary key, partition key 

• Understanding clustering columns

Topics:

• Creating a table

• Defining columns and data types

• Defining a partition key

• Recognizing a partition key

• Specifying a descending clustering order

Hands ON/Demo

• Create a table. Specify the primary key. Create clustering columns

Objectives:

• Inserting data in Cassandra using INSERT INTO command

• Using COPY command to insert data in Cassandra

Topics:

• Using INSERT INTO command

• Using COPY command

Hands ON/Demo

• Use INSERT INTO command to insert data in table. Use COPY command to insert data.

Objectives:

• Understanding that updates and deletes are also INSERT in Cassandra

• Updating data in Cassandra

• Understanding tombstones in Cassandra

• Expiring columns

Topics:

• Update and delete are also inserts

• Updating data

• Understanding tombstones

• Deleting data

• Using TTL

• Updating a TTL

Hands ON/Demo

• Use UPDATE command to update data. Use DELETE command to delete data. Create expiring columns with TTL.

Objectives:

• How to choose appropriate hardware

• Selecting the right balance of the following resources: memory, CPU, disks, number of nodes, and network.

Topics:

• Understanding hardware choices.

• RAM and CPU recommendations.

• Selecting storage.

• Types of Storage to Avoid.

• Deploying in the cloud.

Objectives:

• Understanding Cassandra nodes

• Understanding seed nodes

• How to configure seed nodes using cassandra.yaml file

• How to add/bootstrap a node in a cluster

• Add a new node to a cluster in Lab.

Topics:

• Understanding Cassandra nodes.

• Specifying seed nodes.

• Bootstrapping a node.

• Adding a node in Cluster.

Hands ON/Demo

• Create a cluster containing one node. Bootstrap a new node in the cluster.