Week 6

Aggregations

Transactions

Indexes

Integrating with APIs

Integration Testing

Practice

Assignment

Back end Track

Under construction

<aside> 🚧

This page is currently under construction. Please check back later.

</aside>

Implementation plan:

  1. What is an index — analogy to a book index
  2. How indexes speed up reads
  3. Creating an index: CREATE INDEX
  4. Single column vs composite indexes
  5. When to create indexes: frequently queried columns, foreign keys
  6. The cost of indexes: slower writes, storage overhead
  7. EXPLAIN / EXPLAIN ANALYZE — seeing query plans (brief)
  8. Exercise: add indexes and observe query performance

The HackYourFuture curriculum is licensed under CC BY-NC-SA 4.0

CC BY-NC-SA 4.0 Icons

*https://hackyourfuture.net/*

Found a mistake or have a suggestion? Let us know in the feedback form.