CockroachDB Complete Guide

Video Description

Master the CockroachDB database in this comprehensive course taught by database expert Vijay Raghavan. There are ten topics within this video series:

  • Introducing CockroachDB. Be able to explain CockroachDB in this first topic in the CockroachDB Complete Guide. From Cockroach Labs’ website: CockroachDB delivers an always-on and highly available database designed so that any loss of nodes is consumed without impact to availability. It creates, manages, and distributes replicas of your data to ensure reliability. CockroachDB is ACID compliant, and is an open source database similar to Google Spanner.
  • CockroachDB Benefits and Architecture. Be able to articulate the benefits and architecture of CockroachDB in this second topic in the CockroachDB Complete Guide. Know the history of the database, from primitive databases to SQL databases to NoSQL databases to distributed NoSQL databases. Witness the drawbacks of SQL and NoSQL databases, and the important niche that distributed NoSQL databases such as CockroachDB fills. CockroachCB’s architecture is built upon a key-value (KV) database structure. Know the three states of nodes and the process of maintaining data across multiple nodes. Learn about log replication and leader election.
  • Installing CockroachDB. Install CockroachDB in this third topic in the CockroachDB Complete Guide. Become aware of the three different plans available for CockroachDB.
  • Working with the CockroachDB CLI. Practice working with the CockroachDB interface via CLI in this fourth topic in the CockroachDB Complete Guide. Follow along with Vijay and start multiple nodes and practice interacting with the nodes via CockroachDB CLI.
  • Monitoring CockroachDB through the Admin User Interface (UI). Monitor the CockroachDB Admin User Interface (UI) during this fifth topic in the CockroachDB Complete Guide.
  • Using SQL in CockroachDB. Use SQL in CockroachDB during this sixth topic in the CockroachDB Complete Guide. Follow along with Vijay and apply all of the major SQL commands in CockroachDB.
  • Creating views in CockroachDB. Practice creating and querying materialized views in CockroachDB during this seventh topic in the CockroachDB Complete Guide.
  • Backing up and Restoring Data in CockroachDB. Backup and restore data in CockroachDB during this eighth topic in the CockroachDB Complete Guide.
  • Importing Data into CockroachDB. Import data from other databases or even from a csv file into CockroachDB during this ninth topic in the CockroachDB Complete Guide.
  • Building a Web Application using CockroachDB and Python. Build a Web application using CockroachDB and Python during this tenth topic in the CockroachDB Complete Guide. Follow along with Vijay and practice applying all of the techniques used during this course.

Product Information

  • Title: CockroachDB Complete Guide
  • Author(s): Vijay Raghavan
  • Release date: December 2019
  • Publisher(s): Technics Publications
  • ISBN: None