GraphAcademy
Course · Part of Sharpen your Cypher

Intermediate Cypher Queries

Continue your learning journey with Cypher queries

1 hour57 lessons across 7 modules
CypherSharpen your CypherIntermediate
About this course

In this 1-hour course, you will learn

Build on the knowledge gained in the Cypher Fundamentals course with more complex patterns and the more advanced features of Cypher.

In this course, we will look deeper into more advanced uses of Cypher for querying. This course uses the Recommendations dataset containing Person, Movie, Genre, and User nodes.

Prerequisites

We recommend that you take these beginner courses in GraphAcademy:

  1. Neo4j Fundamentals
  2. Cypher Fundamentals
  3. Graph Data Modeling Fundamentals

  • Filtering queries

  • Controlling results returned

  • Working with Cypher data

  • Graph traversal

  • Pipelining queries

  • Subqueries

  • Using parameters

Course content

7 modules, 1 hour.

  1. 15 lessons
    1. Basic Cypher Queries5 min
    2. Testing Equality5 min
    3. Querying for Null Values5 min
    4. Checking for values5 min
    5. Range Query5 min
    6. Testing List Inclusion5 min
    7. Testing Strings5 min
    8. Case Insensitive Search5 min
    9. Using the CONTAINS Predicate5 min
    10. Query Patterns and Performance5 min
    11. Testing Patterns5 min
    12. Profiling5 min
    13. Multiple MATCH Clauses5 min
    14. Retrieve Movies and Reviewers5 min
    15. OPTIONAL MATCH5 min
  2. 10 lessons
    1. Ordering Returned Results5 min
    2. Ordering Results5 min
    3. Viewing the Ordered Results5 min
    4. Ordering Multiple Values5 min
    5. Limiting or Counting Results Returned5 min
    6. Limiting Results5 min
    7. Eliminating Duplicates5 min
    8. Map Projections to Return Data5 min
    9. Changing Results Returned5 min
    10. Conditionally Returning Data5 min
  3. 7 lessons
    1. Aggregating Data5 min
    2. Counting Results5 min
    3. Creating Lists5 min
    4. Counting Movie Actors5 min
    5. Working with Dates and Times5 min
    6. Duration5 min
    7. Duration in Minutes5 min
  4. 7 lessons
    1. Graph Traversal5 min
    2. Traversing the Graph5 min
    3. Relationships Traversed5 min
    4. Varying Length Traversal5 min
    5. Actors 2 Hops Away5 min
    6. Actors 4 Hops Away5 min
    7. Actors Up to 4 Hops Away5 min
  5. 11 lessons
    1. Scoping Variables5 min
    2. Tom Hanks Movies5 min
    3. Highest Revenue Movies5 min
    4. Top Movies5 min
    5. Adding Genres5 min
    6. Pipelining Queries5 min
    7. Highest Rated Tom Hanks Movie5 min
    8. Highest Average Rating5 min
    9. Unwinding Lists5 min
    10. UK Movies5 min
    11. Switzerland Movies5 min
  6. 3 lessons
    1. Subqueries5 min
    2. Using Subqueries5 min
    3. Combining Results5 min
  7. 4 lessons
    1. Parameters in Cypher5 min
    2. Setting Parameters5 min
    3. Using Parameters5 min
    4. Application Examples Using Parameters5 min
Where to next

Keep going on Sharpen your Cypher.

View the full path
Up next in path

Cypher Aggregations

1 hourStart
Later 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