Apache Cassandra
Cassandra Query Language
Requirements
- Basic Knowledge of Linux
- Basic Knowledge of Databases
Description
If you are an Oracle Database Administrator or you have some knowledge of any RDBMS with Linux operating system, then this is a perfect starting point for you to learn Apache Cassandra.In this course, we will start with introduction to Apache Cassandra.
We will discuss about Vertical Scaling and Horizontal Scaling.
We will discuss about NoSQL databases.
We will discuss about 4 types of NoSQL databases.
We will discuss about apache organization
We will discuss about CAP Theorem and we will try to understand why it is important for Cassandra.
We will try to understand why Cassandra is so popular.
We will try to understand Horizontal Scaling in Cassandra.
We will discuss about Murmur3 tokens and how Cassandra distributes data in the cluster.
We will discuss about data replication in Cassandra.
We will try to understand how Cassandra can support replication in multiple data centers.
We will discuss about what are not possible in Cassandra.
We will discuss about Cassandra software release versions and history.
We will discuss about gossip, partitioners, snitches, sstables, tombstones and compaction.
We will try to understand how Cassandra writes data in memory and stores data in storage.
We will try to understand how Cassandra reads data and returns it to the clients.
We will discuss about what is the role of DataStax in Cassandra world.
We will download and configure DataStax Dev Center to connect to our Cassandra cluster.
We will use Cassandra Query Language shell to connect to our Cassandra cluster.
We will discuss about data modeling in Cassandra.
We will learn about partition keys and clustering columns.
We will learn about how to create and use keyspaces.
We will learn about how to create and use tables along with insert update and delete data.
We will understand how Cassandra marks deleted data with Tombstone markers.
We will learn how to alter table to add and remove columns. we will also discuss about table comments.
We will learn about CQL Collection data types and how to use them.
We will learn about Tuples.
We will discuss about User-Defined Types.
We will learn about Counters and how to use them.
We will discuss about JSON Support in Cassandra.
We will learn about data with Time-To-Live settings.
We will discuss about Light weight Transactions or also called as compare and set option.
We will learn how to handle CQL Scripts.
We will learn how to copy data from files to tables and copy data from tables to files.
We will discuss a lot of scenarios on how to retrieve data stored in tables using select command. this topic is very Important for any administrator to be successful with Cassandra.
We will learn how to use Aggregate Functions.
We will discuss about system keyspaces.
We will learn about secondary indexes.
We will discuss about Tunable Consistency and try to understand the available options for Consistency settings.
We will learn about CQL Batches.
We will learn about user defined functions and user defined aggregates.
We will discuss about different options to secure our Cassandra clusters.
We will discuss about nodetool.
We will learn about the Drivers & Tools provided by DataStax.
We will discuss about what we should learn next after completing this training.
NOTE : Installation and Configuration is not covered in this training, since I have created dedicated training courses for those topics.
Who this course is for:
- Anyone Who Wants to Learn Apache Cassandra
