Advanced Cypher Queries

Ravindranatha Anthapu, graph database expert and Principal Graph Consultant for Neo4j, answers questions about advanced Cypher queries
The questions are here – https://dev.neo4j.com/3JoDTRn

0:56 Merge Statement
“Could you tell use more about what would be the best way to handle MERGING stuff who can have a empty string value or null value without an error like “”cannot merge null”” or having to delete nodes with an empty string property after while.
Something like MERGE only if not null in cypher would be great knowing that in some rows of as an example a csv file will have null or empty strings values
I just feel that the way to handle this very commun case doesn’t look great in cypher right now. I think a change of bahavior with the null value and MERGE would fixe that”
17:39 Fabric
22:31 Design Cypher queries with Instructions that are executed conditionally
Can you explain what is the best strategy to design Cypher queries with instructions that are executed conditionally? The tricks are out there but they seem a bit clunky and they do not appear to make the queries clear/efficient.
26:45 What do you think is the best way to get count of all nodes and relationships of a graph in a single query?
29:06 Use case: travel by public transport – create a model
48:00 With and match statements. Independent and passed on statements.