COURSE 1

Introduction to CockroachDB and Distributed SQL

This course introduces the core concepts behind distributed SQL databases and describes how CockroachDB fits into this landscape.

Level: Introductory

Audience: Anyone (non-technical roles included)

Summary:

  • Key functionality that brings people to CockroachDB

  • Seamless horizontal scalability

  • Distributed transactions with strict ACID guarantees

  • Ability to survive a node and even data center failure with minimal disruption

  • A familiar (and feature-rich) SQL API with an extensive driver ecosystem

  • How CockroachDB ensures availability and resiliency of your data

Prerequisites: None

Duration: 1-1.5 hr

COURSE 2

Practical First Steps with
CockroachDB

This course provides you with practical tools to start using CockroachDB. It contains a series of hands-on lessons and labs.

Level: Introductory

Audience: Anyone (will require hands-on work)

Summary:

  • Spin up single node and a multi node CockroachDB clusters

  • Connect with both the SQL shell and an example application

  • Monitor cluster status and activity with the built-in Admin UI

Prerequisites: Basic experience with SQL and familiarity with bash (Mac/Linux systems) and Powershell (Windows)

Duration: 1-1.5 hr

COURSE 3A

Fundamentals of CockroachDB For Python Developers

This developer course walks students through how to build a full-stack vehicle-sharing application in Python using the popular SQLAlchemy ORM.

Level: Intermediate

Audience: Python Developers

Summary:

  • Deploy a free CockroachDB cluster on CockroachCloud
  • Design your CockroachDB schema in SQL
  • Model your data’s schema in Python
  • Perform transactions such as adding, removing, and updating rows

Prerequisites: Experience with Python and application development

Duration: 2 hrs

COURSE 3B

Fundamentals of CockroachDB For Java Developers

This developer course walks students through how to build a full-stack vehicle-sharing application in Java using the popular Spring Data JPA framework with Spring Boot.

Level: Intermediate

Audience: Java Developers

Summary:

  • Deploy a free CockroachDB cluster on CockroachCloud
  • Design your CockroachDB schema in SQL
  • Model your data's schema in Spring Data JPA
  • Perform transactions such as adding, removing, and updating rows

Prerequisites: Experience with Java and application development

Duration: 2 hrs

COURSE 3C

Fundamentals of CockroachDB For Node.js Developers

This developer course walks you through how to build a full-stack vehicle-sharing application in JavaScript using Node.js with TypeORM.

Level: Intermediate

Audience: Node.js Developers

Summary:

  • Deploy a free CockroachDB cluster on CockroachCloud
  • Design your schema in SQL & model your data’s schema in TypeORM
  • Perform transactions such as adding, removing, and updating rows

Prerequisites: Experience with Node.js and application development

Duration: 2 hrs

Course 4

CockroachDB Query Performance Basics for Developers

This course introduces students to key CockroachDB features to improve their applications’ performance and functionality.

Level: Intermediate

Audience: Developers

Summary:

  • Analyze a query execution plan
  • Add indexes to avoid expensive full table scans
  • Improve sorting performance
  • Efficiently query fields in JSON records

Prerequisites: Experience with application development

Duration: 2 hrs

Course 5

Foundations of Schema Design in CockroachDB

This course will cover schema design best practices and discuss CockroachDB’s unique schema features.

Level: Intermediate

Audience: Developers

Summary:

  • Learn common schema design patterns and anti-patterns
  • Understand CockroachDB’s unique schema design features
  • Create and alter tables with (and without) primary keys

Prerequisites: Experience with SQL and CockroachDB

Duration: 2 hrs

Certificate of Completion

Each of the courses has its own industry-recognized Certificate of Completion. Once you pass the final exam, we will send you the certificate that you can add to LinkedIn!