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.

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
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
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