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 aggregation is in Cypher 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.

4 min read

TIL: Cypher has a format() function for dates and times

A deprecation warning taught me that Cypher now formats dates, times, and durations natively. No APOC required.

Adam CowleyRead post
5 min read

Replacing your APOC Periodic Iterate with CALL {} IN TRANSACTIONS

apoc.periodic.iterate is deprecated in Cypher 25. Learn how to rewrite your queries with CALL {} IN TRANSACTIONS.

Adam CowleyRead post
4 min read

How Cypher Graph Types Kept Our AI-Generated Queries Honest During a Migration

We rebuilt GraphAcademy against the same Neo4j database. Graph types made sure AI-generated Cypher could not drift from the data model.

Adam CowleyRead post