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 are aggregations — computing values over groups of rows
  2. Aggregate functions: COUNT, SUM, AVG, MIN, MAX
  3. Using aggregates without GROUP BY (whole table)
  4. GROUP BY — grouping rows by one or more columns
  5. HAVING — filtering groups (vs WHERE which filters rows)
  6. Combining aggregations with joins
  7. Ordering aggregated results
  8. Exercise: write aggregation queries on existing tables

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.