Skip to main content

Practical First Steps with CockroachDB

This course will give you the tools you need to get started with CockroachDB.

  • Course Number

    practical-first-steps-with-crdb
  • Self-Paced

  • Estimated Effort

    2 hrs/week

About This Course

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.

By the time you finish the course, you'll be able to:

  • Spin up a local cluster on your computer
  • Connect to your cluster using the SQL shell
  • Monitor cluster status and activity using the built-in DB Console

Detailed course outline

  • Chapter 1: First Steps with a Single-Node Cluster
      • Introduction to Chapter 1
      • Install Cockroachdb
      • Start an Insecure Single-Node Cluster
        • Starting a Single-Node Cluster (Mac)
        • Start a Single-Node Cluster (Windows)
        • Quiz: Starting a Single-Node Cluster
        • Lab: Start a Single-Node Cluster
      • Use SQL Shell to Create & Modify Tables
        • Connecting with the SQL Shell
        • Quiz: Use the SQL Shell
        • Lab: Use the SQL Shell
      • Creating and Modifying a Table
        • Creating and Modifying a Table
        • Quiz: Create and Modify a Table
        • Lab: Create a Table
      • Introduction to Secondary Indexes
      • Quiz: Introduction to Secondary Indexes
      • Transaction Syntax
      • Quiz: Transaction Syntax
  • Chapter 2: First Steps with a Multi-Node Cluster
      • Introduction to Chapter 2
      • Stopping a Cluster and Starting a New Cluster
        • Stopping and Removing a Local CockroachDB Cluster
        • Spin Up and Scale Out a Local Cluster (Mac)
        • Spin Up and Scale Out a Local Cluster (Windows)
        • Lab: Spin up a Three-Node Cluster
        • The DB Console
      • The Keyspace, Ranges, and Replicas
      • Quiz: The Keyspace, Ranges, and Replicas
      • Fault Tolerance and Automated Recovery
      • Quiz: Fault Tolerance and Automated Recovery
      • Localities
      • Quiz: Localities
      • Multi-Region Applications
      • Quiz: Multi-Region Applications
  • Final Exam
  • Course Conclusion

Course Staff

Lauren Hirata Singh
Lauren Hirata Singh
Manager, Documentation @ Cockroach Labs
Will Cross
Will Cross
Staff Curriculum Developer @ Cockroach Labs

Frequently Asked Questions

What web browser should I use?

The Open edX platform works best with current versions of Chrome, Edge, Firefox, Internet Explorer, or Safari.

See our list of supported browsers for the most up-to-date information.

Enroll