Free Online Cassandra course

27/09/2015 15:57

Option 01:
https://www.planetcassandra.org/try-cassandra/


Option 02:
https://academy.datastax.com/


Tutorial:
https://docs.datastax.com/en/archived/cassandra/1.1/docs/#use-cql


Basic commands:

--// List of databases
Desc keyspaces;


--// Create a database
CREATE KEYSPACE demodb WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 3};


--// Use the database
use demodb;


--// Create a Table
CREATE TABLE onyxdb."tbGoogle" (
 id int,
 "Latitude" varchar,
 "Lon" varchar,
 suburb varchar,
 "typeOfSale" varchar,
 category text,
 PRIMARY KEY (id)
);


--// Insert
insert into "tbGoogle" (id, "Latitude", "Lon", category, suburb, "typeOfSale") values (5,'-36.846,174.751', '174.750816','XXxxxx', 'Xxxxxx','Full Version');