Catalog

This course introduces the core concepts behind distributed SQL databases and describes how CockroachDB fits into this landscape. You will learn what differentiates CockroachDB from both legacy SQL and NoSQL databases, and how CockroachDB ensures consistent transactions without sacrificing scale and resiliency.

The course has 30 minutes of video and includes quizzes along the way.

This course will give you the tools you need to get started with CockroachDB. During the course, you will learn how to spin up a cluster, use the Admin UI to monitor cluster activity, and use SQL shell to solve a set of hands-on exercises.

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

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.

In this course, you will build a full-stack ride-sharing application in Java using Sprint Boot with Spring Data JPA. 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 vehicles and users at scale.

In this course, you will build a full-stack ride-sharing application in TypeScript using Node.js with TypeORM. 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 vehicles and users at scale.

This course will introduce you to key CockroachDB features to improve the performance and functionality of your applications.

In the course you will work with CockroachDB SQL to gain the skills to:

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

You will create your own CockroachDB cluster in the cloud using CockroachCloud Free, then connect to your cluster using the CockroachDB SQL shell installed on your desktop.

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 first.

If you need help, our docs can be used for references on things like installing and using the CockroachDB SQL shell and SQL command syntax.

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!