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
Where to next

Keep going on Sharpen your Cypher.

View the full path
Up next in path

Cypher statement Processing

Start
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