GraphAcademy
Course · Part of Sharpen your Cypher

Cypher Aggregations

Learn how Cypher aggregation works and how to use list and aggregate functions effectively.

1 hour26 lessons across 3 modules
CypherFoundationalBeginnerSharpen your Cypher
About this course

In this 1-hour course, you will learn

In this course you will learn what Full definition for aggregation (opens in a new tab)Grouping rows and computing a value over each group. In Cypher the grouping keys are whatever expressions in the same clause are not aggregated. is in Full definition for Cypher (opens in a new tab)Neo4j's implementation of GQL, the ISO standard query language for graph databases. It is declarative: you describe the pattern to find, and the database decides how to find it. and how it behaves at runtime. You will also review and learn more about the Cypher syntax and functions for working with lists. You will see and run example code that uses the most widely-used aggregation and list functions in Cypher.

  • Profile and explain how aggregation works at runtime

  • Work with lists

  • Use aggregating functions

Course content

3 modules, 1 hour.

  1. 6 lessons
    1. Creating Lists5 min
    2. Creating and Working with Lists5 min
    3. Using Aggregation to Count5 min
    4. Counting Nodes5 min
    5. Using Pattern Comprehension5 min
    6. Using Pattern Comprehension5 min
  2. 12 lessons
    1. Scalar List Functions5 min
    2. Finding the Oldest Actor5 min
    3. Calculating Total Votes5 min
    4. Functions that Return Lists5 min
    5. Finding Latest Review5 min
    6. Finding Common Reviewers5 min
    7. Functions to Transform Element Types5 min
    8. Transforming Movie Reviews5 min
    9. Testing Lists with Predicate Functions5 min
    10. Filtering Tom Hanks Movies5 min
    11. Using List Comprehension to Aggregate5 min
    12. Calculating Actor Ages5 min
  3. 8 lessons
    1. Adding Values5 min
    2. Calculating Years Since Review5 min
    3. Averaging Values5 min
    4. Calculating Average Reviews5 min
    5. Calculating Min/Max Values5 min
    6. Finding Lowest Ratings5 min
    7. Working with Percentages and Percentiles5 min
    8. Calculating Actor Percentiles5 min
Where to next

Keep going on Sharpen your Cypher.

View the full path
Up next in path

Cypher Indexes and Constraints

2 hoursStart
Further reading

Posts from the GraphAcademy blog.

5 min read

My five favorite cards in Aura Dashboards

When Dashboards first became available in Aura, I started to move my reporting away from custom tools. Here are the five cards I use the most, and a Cypher statement behind them.

Adam CowleyRead post
16 min read

SQL to Cypher - 10 Queries You Already Know

You already know how to write these queries. This article shows you what they look like when the joins go away.

Jeremy MorganRead post
9 min read

Writing Cypher Queries That Don't Lose Your Data

The query trap that hides your newest data, and the query shape that brings it back.

Kemi Elizabeth OjogbedeRead post