Skillsoft
Skillsoft Logo

Cassandra for SQL Developers 

  • Offered bySkillsoft

Cassandra for SQL Developers
 at 
Skillsoft 
Overview

Duration

4 hours

Total fee

8,146

Mode of learning

Online

Difficulty level

Intermediate

Credential

Certificate

Cassandra for SQL Developers
 at 
Skillsoft 
Highlights

  • Certification from Naukri Learning, Content aligned with most Certifying bodies
  • 400mn+ users & used by Professionals in 70% of Fortune 500 companies
Details Icon

Cassandra for SQL Developers
 at 
Skillsoft 
Course details

Who should do this course?
  • SQL developers, RDBMS administrators, NoSQL developers, application developers
What are the course deliverables?
  • Unlimited Access to Online Content for six months
  • Course Completion certificate - renowned globally
  • 400mn+ users, World's No 1 & trained 70% of Fortune 500 companies
  • Career boost for students and professionals
More about this course
  • 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). This course 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

Cassandra for SQL Developers
 at 
Skillsoft 
Curriculum

Cassandra vs. SQL

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

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

Other courses offered by Skillsoft

5.03 K
6 hours
Intermediate
6.01 K
3 hours
Intermediate
6.01 K
3 hours
Intermediate
11.83 K
1 hours
Intermediate
View Other 249 CoursesRight Arrow Icon
qna

Cassandra for SQL Developers
 at 
Skillsoft 

Student Forum

chatAnything you would want to ask experts?
Write here...