Graph Database : Neo4j with Spring Boot

Explore how graph databases model data as nodes and relationships. See why Neo4j enables fast queries with complex relationships, compared with relational databases.

Discover nodes, labels, and directed relationships in a graph database, using examples of students, subjects, and departments to illustrate learning and belongs-to connections.

Learn how nodes and relationships in Neo4j carry properties with flexible schemas, including strings, numbers, booleans, time, and lists for nodes; relationship properties exist but lists are not allowed.

download and install Neo4j desktop for your operating system, enter the activation key, and review privacy settings as the default project with a movie database is created.

Create your first project, add and start a local dbms for Neo4j, configure a password, and use the browser interface on port 7474 to write and run queries.

Learn to open the neo4j browser, write and execute cypher queries for nodes and relationships, and manage databases from the desktop or localhost.

Create and drop databases in the new 4G browser, starting with the student database, noting the two defaults: Neophilia default and the system database, and use it to run queries.

Find nodes by property in Neo4j using match with a student label, filter by name equals John, and limit results or combine multiple properties with and operators.

Learn to build and query with a where clause using and conditions in Neo4j, filtering by multiple properties such as name equals John and bertier equals 1990.

Learn to write or and in queries in Cypher for Neo4j with Spring Boot, using name and properties to match values such as John or Peter, 1990 or 1991.

learn to find a node by its id using the id() function in neo4j, with or without a label like student; remember id is managed by neo4j.

Learn how to update a node's properties in Neo4j, including changing existing values and adding new properties such as country, and how to add a new label to the node.

Remove a label and properties in Neo4j using Cypher, showing how to drop the person label and attributes like Bertier and country, possibly in one query.

Delete a node in Neo4j when it has no relationships, using delete queries with optional label filters; learn how to delete individual nodes and all nodes by label.

Create relationships between nodes in neo4j by specifying a direction and a relationship type, such as a student learning a subject. Merge to avoid duplicates and optionally connect to department.

Fetch a node's relationships in a Neo4j graph using match clauses, returning related nodes with their relationships and types like learning or belongs to.

Learn to add, update, and delete properties on a specific relationship in Neo4j, such as updating marks to 80 and adding progress to 50 percent, while targeting the correct relationship.

Learn to delete a specific 'is learning' relationship between two nodes in a Neo4j graph using delete with an alias, verify the removal, and optionally return the related relationship.

This lecture shows how to update a relationship type by creating a new relationship with the desired type, copying properties (for example mark 70), and deleting the old relationship.

Delete a node with its relationships in Neo4j by first removing all related relationships, then the node. Learn to delete nodes with no relationships to clear the database.

Delete all nodes and relationships in a Neo4j graph with a single query using optional match or detach delete.

Explore constraints in Neo4j, including unique constraints, property existence constraints (not null), and node constraints such as composite keys, with guidance on listing and dropping them.

Create a unique constraint on the subject label's subject property in Neo4j using Cypher, with an optional name, enforcing uniqueness across all subject nodes while allowing null values.

Learn how to implement property existence constraints in Neo4j for both nodes and relationships, ensuring node names and relationship marks are never null.

Learn how node key constraints in Neo4j combine unique and existence rules to enforce a unique, non-null student_id, and how to define composite key constraints across multiple properties.

Learn how to drop a constraint in Neo4j by listing existing constraints, identifying their names and types (property existence, uniqueness), then dropping the chosen one and re-listing to confirm.

Learn how to write contains queries in Neo4j to find nodes where a name contains a substring, and use to lower or to upper for case-insensitive matches.

Execute a starts with query in neo4j to find student nodes whose name starts with John, exploring case sensitivity options and applying the query in the browser UI.

Write count queries in Neo4j to tally students by country, using match and return with count on the country property and proper aliasing.

Learn how to write a sum query in Neo4j to aggregate the marks property on the is learning relationship, and return each student's name with the total marks.

Discover how to obtain unique names from the graph by applying distinct on the name property in a match query and returning the names.

Explore pagination in Neo4j by applying skip and limit to return finalists across pages; set page size, navigate first, second, and third pages with total nodes.

Sort student nodes in Neo4j using order by to arrange by name in ascending or descending order, and extend to multiple properties such as name and country.

Set up the Neo4j with Spring Boot environment by installing the JDK, choosing Maven or Gradle, and selecting an IDE such as Eclipse, Springle Shield, or Interleaved Idea.

Set up a Spring Boot application with Neo4j data integration, create controller, service, repository, and entity classes for student, and configure local Neo4j connection in application properties.

Map identity classes to neo4j nodes with spring data neo4j, using a student label and properties like id, name, country; annotate id with generated value and map keys to property.

Map relationships in Neo4j with Spring Data, defining an outgoing belongs to relationship from student to department and exploring one-to-one, one-to-many, and learning relationships with or without properties.

Define relationships with properties in Spring Data Neo4j by creating a relationship properties class for learning with marks and annotating it with @RelationshipProperties and @TargetNode between student and subject.

Define and use neo4j repositories in a spring boot app by creating student, subject, and department repositories that extend neo4j repository and enable them in the main class.