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 Fundamentals

1 hourStart
Later in path

Graph Data Modeling Fundamentals

2 hoursStart
Later in path

Importing Data Fundamentals

2 hoursStart
Further reading

Posts from the GraphAcademy blog.

5 min read

Cypher Best Practices: Map Projections, List Comprehensions, and COLLECT Subqueries

Three Cypher patterns that make queries cleaner, faster, and safer —map projections for shaped output, list comprehensions for inline transforms, and COLLECT subqueries for nested data without N+1.

Adam CowleyRead post