Coursera Bets $100 Million That Andrew Ng Can Do What Coursera Can’t

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

CodeSignal

Indexes and Performance

via CodeSignal

Go to class Write review

Overview

Speed up your queries with indexes and constraints while learning to analyze query performance. Use PROFILE and EXPLAIN to interpret execution plans, create single and compound indexes, and apply optimization best practices in Neo4j.

Syllabus

  • Unit 1: Understanding Query Performance
    • Analyzing Your First Query Profile
    • Writing Queries Two Ways
    • The Cost of Matching Everything
  • Unit 2: Creating Property Indexes
    • Creating Your First Property Index
    • Creating Indexes Independently
    • Viewing All Database Indexes
    • Verifying Your Index Works
    • Diagnosing and Fixing Slow Queries
  • Unit 3: Understanding Compound Indexes
    • Creating a Multi Property Index
    • Creating Indexes with Reversed Properties
    • Querying with Compound Indexes
    • Debugging Compound Index Queries
  • Unit 4: Enforcing Data Integrity
    • Creating Your First Unique Constraint
    • Testing Your First Constraint Violation
    • Discovering Automatic Performance Improvements
  • Unit 5: Writing Efficient Queries
    • Matching Nodes More Efficiently
    • Building an Efficient Query Structure
    • Uncovering Performance Differences with Profile

Reviews

Start your review of Indexes and Performance

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.