GraphAcademy
Course · Part of Sharpen your Cypher

Cypher Indexes and Constraints

Make your graph more performant with Cypher constraints and indexes

2 hours27 lessons across 5 modules
CypherSharpen your CypherProcessingIntermediate
About this course

In this 2-hour course, you will learn

Build on from the knowledge gained in the Cypher Intermediate Queries course by learning how to create and manage indexes and constraints to make your database more performant.

This course uses the Recommendations dataset which contains Person, Movie, Genre, and User nodes.

Prerequisites

To take this course we recommend that you have taken these courses in GraphAcademy:

  1. Neo4j Fundamentals
  2. Cypher Fundamentals
  3. Graph Data Modeling Fundamentals
  4. Cypher Intermediate Queries

  • Constraints

  • Indexes

  • Full-text indexes and search

  • Index Management

Course content

5 modules, 2 hours.

  1. 2 lessons
    1. Constraints and Indexes in Neo4j5 min
    2. Identifying What Constraints and Indexes to Create5 min
  2. 11 lessons
    1. Constraints in Neo4j5 min
    2. Creating Uniqueness Constraints5 min
    3. Creating Uniqueness Constraints5 min
    4. Creating Existence Constraints for Node Properties5 min
    5. Creating Existence Constraints for Node properties5 min
    6. Creating Existence Constraints on Relationship Properties5 min
    7. Creating Existence Constraints for Relationship Properties5 min
    8. Creating Node Key Constraints5 min
    9. Creating a Node Key Constraint5 min
    10. Managing Constraints in Neo4j5 min
    11. Dropping Constraints5 min
  3. 8 lessons
    1. Indexes in Neo4j5 min
    2. Creating Single Property Indexes5 min
    3. Creating a RANGE Index on a Node Property5 min
    4. Creating a RANGE Index on a Relationship Property5 min
    5. Creating Multi-property Indexes5 min
    6. Creating a Composite Index on a Node Property5 min
    7. Creating TEXT Indexes5 min
    8. Using a TEXT index5 min
  4. 3 lessons
    1. Full-text Indexes in Neo4j5 min
    2. Creating and Using Full-text Indexes5 min
    3. Using a full-text Index on a Relationship Property5 min
  5. 3 lessons
    1. Controlling Index Usage5 min
    2. Using query hints5 min
    3. Getting the Most Out of Indexes5 min
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