Table of Contents

Preface

Part 1: Cypher Introduction

1

Introduction to Neo4j and Cypher

Technical requirements

Introducing Neo4j and graph database concepts

Understanding nodes in graphs

Understanding relationships in graphs

Cypher

Installing Neo4j Desktop

Downloading Neo4j Desktop

A visual tour of Neo4j Desktop

Projects menu

DBMSs menu

Graph applications

Help menu

Settings menu

Using Neo4j Desktop

Creating a local DBMS

Managing a local DBMS instance

Working with a local DBMS

Starting the instance

Opening the browser

Working with the browser’s UI

Working with additional options to manage local DBMS

Summary

2

Components of Cypher

Technical requirements

Graph storage in Neo4j

Using the Cypher syntax

Property types

Structural types

Composite types

Using the nodes syntax

Using the relationships syntax

Working with Cypher keywords

Using MATCH and OPTIONAL MATCH

Using CREATE and DELETE

SET and REMOVE

Using WHERE, SKIP, LIMIT, and ORDER BY

Using MERGE

Using FOREACH

Using UNWIND

Using UNION and UNION ALL

Using indexes and constraints

Summary

Part 2: Working with Cypher

3

Loading Data with Cypher

Before loading the data

Graph data modeling

Loading data with LOAD CSV

LOAD CSV without headers

LOAD CSV with headers

Loading data with LOAD CSV using batching

USING PERIODIC COMMIT

CALL IN TRANSACTIONS

Loading data using client drivers

URI schemes

Neo4j sessions

Mapping the source data to graph

Loading the patient data

Loading the encounter data

Loading provider data

Loading organization data

Loading medication data

Loading condition, procedure, and allergy data

Loading care plan data

Using client drivers

Summary

4

Querying Graph

Exploring the data in Graph

Querying the nodes

Querying the paths

Summary

5

Filtering, Sorting, and Aggregations

Filtering with node labels and relationship types

Filtering with WHERE and WITH clauses

Sorting data using the ORDER BY clause

Working with aggregations

Summary

6

List Expressions, UNION, and Subqueries

Working with list expressions

Working with the range function

Working with the head function

Working with the tail function

Working with the last function

Working with the size function

Working with the reverse function

Working with the reduce function

Working with list comprehensions

Working with UNION in Cypher

Working with subqueries

Working with returning subqueries

Working with unit subqueries

Summary

Part 3: Advanced Cypher Concepts

7

Working with Lists and Maps

Working with lists

Working with basic list capabilities

Working with list operators

Revisiting the list functions

Working with COLLECT and UNWIND

Working with maps

Working with map projections

Combining lists and maps

Summary

8

Advanced Query Patterns

Working with the WITH clause

Introducing variables at the start

Working with the CASE clause

Working with simple CASE expressions

Working with generic CASE expressions

Working with the FOREACH clause

Working with the UNWIND clause

Working with count stores

Summary

9

Query Tuning

Working with EXPLAIN

Working with PROFILE

Reviewing plan operators

Using index hints

Summary

10

Using APOC Utilities

Installing APOC

Working with data import and export

Importing CSV data

Importing JSON data

Viewing database schema

Executing dynamic Cypher

Working with advanced path finding

Connecting to other databases

Using other useful methods

Summary

11

Cypher Ecosystem

Using Neo4j extensions

Using visualization tools

Using Kafka and Spark connectors

Using Graph Data Science

Using Neo4j Workspace

Summary

12

Tips and Tricks

Understanding the internals of Neo4j

Understanding the node store

Understanding the relationship store

Understanding the property store

Understanding Neo4j memory usage

Reviewing querying patterns

Troubleshooting a few common issues

Reviewing the new 5.0 changes

Summary

Index

Other Books You May Enjoy