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
Cassandra for SQL Developers at Skillsoft Course details
- SQL developers, RDBMS administrators, NoSQL developers, application developers
- 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
- 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