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.
Course Number
cockroachdb-query-performance-for-devsSelf-Paced
Estimated Effort
2 hours/week
About This Course
This course will introduce you to key CockroachDB features to improve the performance and functionality of your applications.
You'll learn how to:
- Analyze a query execution plan
- Add indexes to avoid expensive full table scans
- Improve sorting performance
- ...and more!
Requirements
Before taking this course, you should have some familiarity with SQL. If you've never used CockroachDB before, we suggest you take our "Introduction to Serverless Databases and CockroachDB Serverless" course first.
Detailed course outline
- Introduction
- Set up your environment
- Install cockroachdb
- Set up a serverless cockroachdb cluster
- Set up the database
- Serializable isolation
- Statement plans
- Working with indexes
- Secondary indexes
- Composite Indexes and Index Prefixes
- Lab: Create a Composite Index
- Sorting and indexes
- Lab: Sorting an Indexed Table
- Covered Queries
- Lab: Use an Index to Cover a Query
- Finding and Removing Unused Indexes
- Quiz: Unused Indexes
- Working with JSON
- Using JSON Data
- Lab: Define a JSON Column
- Inverted Indexes
- Computed Columns
- Lab: Define a Computed Column
- Final Exam