CockroachDB Query Performance for Developers
Introductory
Level
08-01-2021
Released on
2 hours
Estimated Time
Certificate

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

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.

WHAT YOU WILL LEARN
Analyze a query execution plan
Improve sorting performance
Add indexes to avoid expensive full table scans
Efficiently query fields in JSON records
Presented by
Crossman Wilkins
Senior Curriculum Developer
Cockroach Labs
Alex Yarosh, PhD
Senior Curriculum Developer
Cockroach Labs
Will Cross, PhD
Staff Curriculum Developer
Cockroach Labs
Outline
Welcome to the course!
Welcome to the course!
Getting started
Set up your environment
Serializable isolation
Statement plans
Working with indexes
Secondary indexes
Composite indexes and index prefixes
Sorting and indexes
Covered queries
Working with JSON
Using JSON Data
Inverted indexes
Computed columns
Final exam
Final exam
Course survey
Course survey
Frequently Asked Questions