Foundations of Schema Design in CockroachDB


To register for this course please click "Start" below. If you are registering for someone else please check "This is for someone else".

This training is free.



This course represents the first steps of learning about Schema Design with CockroachDB.

There are many ways to organize information in a database. CockroachDB is a distributed SQL database, which brings new capabilities to the world of relational SQL databases. How you organize information through schema design in CockroachDB can have positive or negative impacts on, for example, query performance or inserting new data. In this course, we lay a foundation for best practices in schema design by giving you an overview of the unique CockroachDB schema features available. We then highlight some common design patterns and anti-patterns that are relevant when designing a schema for CockroachDB.

Knowing what's available, and how to use it, will help you build better schema and provide you with the basic vocabulary of CockroachDB.

Before taking this course, you should have some familiarity with SQL. If you’ve never used CockroachDB before, we suggest you take our “Practical First Steps with CockroachDB” course

If you need help, our documentation can be used for reference on concepts and activities like how to create a table or definitions of the different data types.

The CockroachDB Community Slack has a #cockroach-university channel where you can interact with other learners and the Cockroach Labs Training Team directly.

Good luck, and enjoy the course!

Submit feedback


2.7 hours