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.

9 min read

Writing Cypher Queries That Don't Lose Your Data

The query trap that hides your newest data, and the query shape that brings it back.

Kemi Elizabeth OjogbedeRead post
16 min read

SQL to Cypher - 10 Queries You Already Know

You already know how to write these queries. This article shows you what they look like when the joins go away.

Jeremy MorganRead post
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