Catalog

This course will teach you the core concepts behind distributed databases and give you all the tools you need to get started with CockroachDB.

During the course, you will learn how to:

Spin up a cluster on your computer

Observe the cluster healing itself during node failure

Perform transactions with strict ACID guarantees

Use our Admin UI and SQL shell to solve a set of hands-on exercises

And much more!

The course has approximately 80 minutes of video and includes quizzes along the way to ensure that you are learning the concepts from each section. At the end of the course, there will be a final exam. If you pass, you will receive a certificate of completion. If you fail, we invite you to restart the course and try again. Get started today!

In this course, you will build a full-stack ride-sharing application in Python using the popular SQLAlchemy ORM. You will start with a simple version that manages a fleet of scooters and their current positions. You will add features one by one as the course progresses until you have a highly functional application that is ready to track multiple vehicle types and users at scale.

Along the way, you will learn how to:

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

Take advantage of CockroachDB's rich data types

Optimize your queries with indexes for efficient filtering and sorting

Before taking this course, you should have experience with Python 3 and application development. It is helpful but not required to be familiar with SQL. If you’ve never used CockroachDB before, we would also suggest taking our “Getting Started with CockroachDB” course first.