Skip to main content
crl: practical-first-steps-with-crdb Practical First Steps with CockroachDB

Practical First Steps with CockroachDB

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

Enroll in Practical First Steps 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