Neo4j: GraphDB Foundations with Cypher

Filter by properties teaches you to narrow search results by node and relationship properties, use labels to refine matches, and perform multi-property exact, case-sensitive filters.

Explore boolean operators in Cypher to refine queries with and, or, in, and not, enabling complex filtering by birth year and range criteria.

Use boolean operators on paths within where clauses to find people involved in a movie like Unforgiven who did not direct it, by applying and not with the directed relation.

Find Tom Hanks actor contacts born in 1960 or later who earned over ten million dollars from a single movie, and return their name, birth year, and earnings.

Query a graph database to find Tom Hanks' actor contacts born in 1960 or later who earned more than 10 million from a movie, returning name, birth year, and earnings.

Learn how to remove duplicate results with the distinct keyword by aggregating query results that span actors and earnings in movies, returning unique actor names.

Explore Cypher math functions, including floor, ceil, round, and haversin for spherical distances, and learn practical usage with an example computing average earnings from ACTED_IN relationships.

Identify the top earning actor by computing the highest average earnings per movie using the ACTED_IN relationship. Return the actor's name in uppercase and the rounded average.

Create Zoe Bell in cypher, connect her to Quentin Tarantino as a contact and to the movie The Hateful Eight via ACTED_IN, including earnings on the relationship.

Learn to delete nodes and relationships in Neo4j by matching all nodes, deleting related relationships first, then deleting any remaining nodes, with repopulation to illustrate alternatives.

Delete all has_contact relationships to Tom Hanks, then match and return Tom Hanks to verify no has_contact relationships remain.

Revert the work from the previous exercise by removing the 'Rich' label and the 'total_earnings' property on those actors.

Remove the Rich label and total_earnings property from actors who also have the Person label, and verify the changes across nodes and query results.

Use MERGE with ON CREATE SET and ON MATCH SET to manage node properties, updating created_at, created_by on create and updated_at on matches, and incrementing update_count on each update.

Learn to model a viewed relationship in Neo4j between Keanu Reeves and the Top Gun movie, using a count that initializes on create and increments on each run.