Advanced Cypher

Course Overview

This course teaches you some advanced Cypher concepts and syntax. It prepares you to write more efficient Cypher code and how to measure the performance of Cypher queries. You also learn how to write Cypher in a multi-user application.

Course objectives

At the completion of this course, you should be able to:

  • Describe how graphs are traversed at runtime.
  • Write APOC code for graph traversal.
  • Use UNWIND, pattern comprehension and list comprehension in your code.
  • Write Cypher code to combine query results with UNION.
  • Import normalized and denormalized data with and without APOC.
  • Import large datasets.
  • Aggregate data and work with aggregated data.
  • Perform iteration and conditional processing.
  • Describe query planning.
  • Access DB stats and the count store.
  • Perform query tuning.
  • Use indexes effectively, including fulltext schema indexes.
  • Monitor queries.
  • Use the Query Log Analyzer Tool.
  • Describe locking in Neo4j.
  • Monitor locking in Neo4j.

Course Modules

  1. Getting More out Of Cypher
  2. Query Tuning
  3. Using Neo4j with Multiple Clients/Threads

Instructor

Patrick Baumgartner

Patrick Baumgartner

Patrick Baumgartner works as a passionate software craftsman at 42talents and builds software with Java/JEE, Spring Framework, OSGi, NoSQL databases and other open source technologies. Since he got in touch with Neo4j a few years ago, he sees the whole world as one big connected graph and loves to talk about it.

Patrick is a host of the Neo4j Zürich and the Software Craftsmanship Zürich Meetup group and is engaged in the agile community in Switzerland.

Twitter: @patbaumgartner, @42talents