The Cassandra Distributed Database : From 0 to 1

About course

• Has your data gotten huge, unwieldy and hard to manage with a traditional database? Is your data unstructured with an expanding list of attributes? Do you want to ensure your data is always available even with server crashes? Look beyond Hadoop - the Cassandra distributed database is the solution to your problems.

   

  • Huge, unwieldy data: This course helps your set up a cluster with multiple nodes to distribute data across machines
  • Unstructured: Cassandra is a columnar store. There are no empty cells or space wasted when you store data with variable and expanding attributes
  • Always available: Cassandra uses partitioning and replication to ensure that your data is available even when nodes in a cluster go down

   

What included in this Course?

• • The Cassandra Cluster Manager (CCM) to set up and manage your cluster
  •  The Cassandra Query Language (CQL) to create keyspaces, column families, perform CRUD operations on column families and other administrative tasks
  • Designing primary keys and secondary indexes, partitioning and clusteringkeys
  • Restrictions on queries based on primary and secondary key design
  • Tunable consistency using quorum and local quorum. Read and write consistency in a node
  • Architecture and Storage components: Commit Log, MemTable, SSTables, Bloom Filters, Index File, Summary File and Data File
  • A real world project: A Miniature Catalog Management System using the Cassandra Java driver
  • Set up a cluster, keyspaces, column families and manage them
  • Run queries using the CQL command shell
  • Design primary keys and secondary indexes with partitioning and clustering considerations
  • Use the Cassandra Java driver to connect and run queries on the cluster

Covered topics

• Section 1: You, This Course and Us
  	Lecture 1	You, This Course and Us Preview	01:45
  Section 2: Introduction: Cassandra as a distributed, decentralized, columnar store
  	Lecture 2	A Column-Oriented Database Preview	10:39
  	Lecture 3	Requirements For A Product Catalog System	08:07
  	Lecture 4	What Is Cassandra?	08:33
  	Lecture 5	Cassandra Vs HBase	04:37
  Section 3: Install And Set Up
  	Lecture 6	Install Cassandra (Mac and Unix based systems)	04:34
  	Lecture 7	Install the Cassandra Cluster Manager (Mac and Unix)	02:20
  	Lecture 8	Install Maven On Your Machine	02:20
  Section 4: The Cassandra Cluster Manager
  	Lecture 9	Create A Cassandra Cluster On Your Local Machine Preview	11:54
  	Lecture 10	Basic CCM Commands	07:04
  Section 5: The Cassandra Data Model
  	Lecture 11	Columns And Column Families Preview	08:02
  	Lecture 12	Super Column Family And Keyspace	07:17
  	Lecture 13	Comparing Cassandra With A Relational Database	04:19
  Section 6: Shell Commands
  	Lecture 14	Connect To Cassandra And Create A Keyspace Preview	06:54
  	Lecture 15	Column Families And Their Properties	12:02
  	Lecture 16	Modify Column Families	02:42
  	Lecture 17	Insert Data Into A Column Family	06:52
  	Lecture 18	Advanced Data Types: Collections And Counters	10:56
  	Lecture 19	Update Simple And Collection Data Types	15:54
  	Lecture 20	Manage Cluster Roles	05:01
  Section 7: Keys And Indexes: Primary Keys, Partition Keys, Clustering Key, Secondary Indexe
  	Lecture 21	Partition Keys: Distributing Data Across Cluster Nodes	12:14
  	Lecture 22	Partition Keys: Properties Preview	05:08
  	Lecture 23	Clustering Keys: Data Layout On A Node	03:36
  	Lecture 24	Restrictions On Partition Keys	14:38
  	Lecture 25	Restrictions On Clustering Keys	09:12
  	Lecture 26	Secondary Indexes	08:32
  	Lecture 27	Restrictions On Secondary Indexes	08:52
  	Lecture 28	Allow Filtering	02:27
  Section 8: Tunable Consistency
  	Lecture 29	Write Consistency Levels And Hinted Handoff	12:18
  	Lecture 30	Read Consistency Levels Preview	11:18
  	Lecture 31	Replication Factors And Quorum Value	08:14
  Section 9: Storage Systems
  	Lecture 32	Overview Of Cassandra Storage Components	06:38
  	Lecture 33	The SSTable And Its Components	09:44
  	Lecture 34	Row Cache And Key Cache Preview	03:14
  	Lecture 35	Anatomy Of A Write Request	08:32
  	Lecture 36	Anatomy Of A Read Request And The Gossip Protocol	07:25
  Section 10: A Mini-Project: A Miniature Catalog Management System In Java
  	Lecture 37	Overview And Basic Setup Preview	04:28
  	Lecture 38	Create A Session And Execute Our First Query	07:39
  	Lecture 39	Create A Column Family	03:27
  	Lecture 40	Check If A Column Family Has Been Created	04:59
  	Lecture 41	Insert Data Into The Listings Column Family Preview	09:13
  	Lecture 42	Insert Data Into The Products Column Family	09:59
  	Lecture 43	Search For Products	13:32
  	Lecture 44	Delete A Listing	04:17
  	Lecture 45	Update Mulitple Column Families Using Logged Batch	14:42

Who should buy this course?

• • The basics of SQL and traditional relational databases
  • The basics of Java in order to use the Cassandra Java library
  • Engineers and analysts who understand traditional, relational databases and want to move to big data storage systems
  • Students who are just starting out understanding databases and have no prior experience with one