GraphAcademy
Course

Intermediate Cypher Queries

57 lessons across 7 modules
IntermediateCore DatabaseSharpen your CypherCypher
About this course

In this course, you will learn

  • Filtering queries

  • Controlling results

  • Graph traversal

  • Pipelining queries

  • Subqueries

Course content

7 modules, 57 lessons.

  1. 15 lessons
    1. Basic Cypher Queries
    2. Testing Equality
    3. Querying for Null Values
    4. Checking for values
    5. Range Query
    6. Testing List Inclusion
    7. Testing Strings
    8. Case Insensitive Search
    9. Using the CONTAINS Predicate
    10. Query Patterns and Performance
    11. Testing Patterns
    12. Profiling
    13. Multiple MATCH Clauses
    14. Retrieve Movies and Reviewers
    15. OPTIONAL MATCH
  2. 10 lessons
    1. Ordering Returned Results
    2. Ordering Results
    3. Viewing the Ordered Results
    4. Ordering Multiple Values
    5. Limiting or Counting Results Returned
    6. Limiting Results
    7. Eliminating Duplicates
    8. Map Projections to Return Data
    9. Changing Results Returned
    10. Conditionally Returning Data
  3. 7 lessons
    1. Aggregating Data
    2. Counting Results
    3. Creating Lists
    4. Counting Movie Actors
    5. Working with Dates and Times
    6. Duration
    7. Duration in Minutes
  4. 7 lessons
    1. Graph Traversal
    2. Traversing the Graph
    3. Relationships Traversed
    4. Varying Length Traversal
    5. Actors 2 Hops Away
    6. Actors 4 Hops Away
    7. Actors Up to 4 Hops Away
  5. 11 lessons
    1. Scoping Variables
    2. Tom Hanks Movies
    3. Highest Revenue Movies
    4. Top Movies
    5. Adding Genres
    6. Pipelining Queries
    7. Highest Rated Tom Hanks Movie
    8. Highest Average Rating
    9. Unwinding Lists
    10. UK Movies
    11. Switzerland Movies
  6. 3 lessons
    1. Subqueries
    2. Using Subqueries
    3. Combining Results
  7. 4 lessons
    1. Parameters in Cypher
    2. Setting Parameters
    3. Using Parameters
    4. Application Examples Using Parameters