Cassandra - Completely Basic Hands on

Name: Cassandra - Completely Basic Hands on
Rating: 4.1 (107 reviews)

Learn and understand the base things of cassandra

Created byMustafa Aksoy

Last updated 6/2020

English

English [Auto],

What you'll learn

Reach to intermediate level of cassandra structure
Install cassandra and use it, completely basic. Not theoretical
How to apply to your machine Cassandra Environment basically
Import Complex file into cassandra data store and manage it
How to select from a data store in Cassandra
Using Filter, Insert, update, delete, drop, Truncate

Course content

5 sections • 17 lectures • 1h 59m total length

Introduction4:03
Install and configure Cassandra, connect via a SQL client, and practice DDL and DML with text, integers, and double data types, primary and complex keys, key spaces, and import/export workflows.

Create your own Keyspace9:37
How to create a keyspace and which types they are
Using/Dropping Keyspaces3:14
How to use Keyspaces
Changing Keyspace
Drop a keyspace with "IF EXIST" block
Basic Logic of Keyspaces15:24
Why keyspaces need to be used in cassandra
Real Scenario description for using keyspaces
create table/data store3:40
create a table
Primary key features
Import data from a file6:07
How to import data from csv file
insert/delete new row to/from a table7:42
insert new rows to a table
delete rows from table with filter
Export to csv file from cassandra table4:37
Export data from cassandra table to csv/txt files

Using Filter3:14
How to use filter in cqlsh over primary key and without primary KEY
Create and drop Index4:06
Why indexes are used.
creating and dropping index on cqlsh
Update Delete command8:41
Update and Delete command
will be deleted column on which method should be address for cassandra
Complex Files and Compound Keys14:11
How to manage Complex Files
Compound/Clustering Keys
Importing a file to a table which have composit keys
Creating Materialized Views5:58
Why Materialized Views used in Databases
How to Create and Drop MV
Which points are important when writing the mv creation script

Requirements

Basic sql but not mandatory

Description

This course is designed for anyone who wants to learn Apache Cassandra through practical and hands-on experience rather than only theoretical explanations. During the course, you will install Cassandra on your local machine and learn how to configure and use it step by step in a real working environment.

The course explains Cassandra architecture and database structure in a simple and understandable way, helping you understand how distributed data management works in Cassandra systems. Every lesson is created to allow you to practice directly on your own computer while learning the concepts.

You will learn how to install Cassandra, configure the environment, and work with Cassandra using cqlsh. The course also includes DDL and DML scripting, creating keyspaces and tables, inserting and querying data, and managing Cassandra objects efficiently.

In addition, you will perform file operations such as importing and exporting data between Cassandra and external files. Advanced topics such as creating functions, aggregating values, and working with Cassandra queries in real scenarios are also covered.

By the end of the course, you will have strong practical knowledge of Cassandra and be able to confidently use, manage, and develop Cassandra databases in your own projects and environments. finally you will be able understand and practice nosql world.

Who this course is for:

Students of Information technology
Developers
Analysts
Who is interested in Big Data technologies

Cassandra - Completely Basic Hands on

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 4min

Preparing the Environment3 lectures • 27min

How to Develop Jobs7 lectures • 50min

General Cassandra Commands5 lectures • 36min

Summary1 lecture • 1min

Requirements

Description

Who this course is for: