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 CockroachDB Dedicated
  • 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 CockroachDB Dedicated
  • 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 CockroachDB Dedicated
  • 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

Course 6

Introduction to Serverless Databases and CockroachDB Serverless

This course introduces you to the core concepts behind serverless databases and gives you the tools you need to get started with CockroachDB Serverless.

Level: Beginner

Audience: Developers

Summary:

  • Learn about serverless databases and CockroachDB Serverless
  • Set up and use a CockroachDB Serverless cluster
  • See how a serverless database works

Prerequisites: Familiarity with database concepts

Duration: 2 hrs

Course 7

Event-Driven Architecture for Java Developers

This course will introduce you to some best practices when building an Event-Driven system, and show you specific CockroachDB features that can help.

Level: Intermediate

Audience: Developers

Summary:

  • Learn how updating a message queue and a database can lead to the "Dual-Write problem".
  • Implement a Transactional Outbox to avoid the Dual-Write problem.
  • Connect CockroachDBs Change Data Capture to automatically publish events to Kafka.

Prerequisites: Experience developing Java Spring Boot applications.

Course 8

Getting Started with SQL

This course will help you feel confident taking your own simple entities, mapping them to your relational database, and performing basic queries.

Level: Introductory

Audience: Developers

Summary:

  • Learn basic, single-table SQL operations.
  • Translate a simple entity/object into a corresponding database table.
  • Populate your table with data and retrieve it after.

Prerequisites: Basic Programming Concepts (Objects, Fields, Data Types, Boolean Logic, etc)

Course 9

Modeling Object Relationships in SQL

This course teaches you how to map your business critical data from your application code to a SQL database and describes key SQL features that help minimize application complexity.

Level: Intermediate

Audience: Developers

Summary:

  • Combine data from multiple data sources using joins.
  • Model one-to-many object relationships in a relational database.
  • Use foreign key constraints to ensure referential integrity
  • Model many-to-many relationships in a relational database
  • Model object inheritance in a relational database

Prerequisites: Getting Started with SQL for Application Developers

Get free swag!

Once you complete the course and pass the final exam for the Introduction to Serverless Databases and CockroachDB Serverless course, we’ll mail you some exclusive Cockroach University swag. * **

Swag is only available for Cockroach University users in North America and the EU who have completed the Introduction to Serverless Databases and CockroachDB Serverless course at this time. We hope to expand in the future.

**Once you've completed the Introduction to Serverless Databases and CockroachDB Serverless course, you must complete of the following steps: 1) post your Certificate of Completion to your LinkedIn or Twitter accounts, 2) provide us with a screenshot of your social media post, and fill out your size and shipping information

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!