Foundations of Schema Design in CockroachDB
Beginner
Level
08-01-2021
Released on
2 hours
Estimated Time
Certificate

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!

WHAT YOU WILL LEARN
You'll learn the CockroachDB features that you should keep in mind when developing your schema.
You'll learn the rich data types that are available to you in CockroachDB.
You'll learn about the basic patterns and anti-patterns when designing your schema in CockroachDB.
Presented by
Will Cross
Staff Curriculum Developer
Cockroach Labs
Crossman Wilkins
Senior Curriculum Developer
Cockroach Labs
Outline
Welcome
Welcome
Lab Environment Setup
Lab Environment Setup
Chapter 1: Foundations
Notes on Specialized Data Types
CockroachDB Functions and Special Features
Column Constraints in CockroachDB
JSON, Arrays, Inverted Indexes, and Computed Columns
Chapter 2: Patterns and Anti-Patterns
Anti-Pattern: Auto-Incrementing Primary Key
Creating a Hash-Sharded Table
Foundations of Schema Design Final Exam
Foundations of Schema Design Final Exam
Foundations of Schema Design: Conclusion
Foundations of Schema Design: Conclusion
Frequently Asked Questions