Hands-On Learning

<h2 id="hands-on-learning" class="position-relative d-flex align-items-center group"> Hands-On Learning <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="hands-on-learning" aria-haspopup="dialog" aria-label="Share link: Hands-On Learning"> Share link </button> </h2><div id="headingShareModal" class="heading-share-modal" role="dialog" aria-modal="true" aria-labelledby="headingShareTitle" hidden> <div class="hsm-dialog" role="document"> <div class="hsm-header"> <h2 id="headingShareTitle" class="h6 mb-0 fw-bold">Share this section</h2> <button type="button" class="hsm-close" aria-label="Close"> </button> </div> <div class="hsm-body"> <label for="headingShareInput" class="form-label small text-muted mb-1 text-uppercase fw-bold" style="font-size: 0.7rem; letter-spacing: 0.5px;">Permalink</label> <div class="input-group mb-4 hsm-url-group"> <input id="headingShareInput" type="text" class="form-control font-monospace" readonly aria-readonly="true" style="font-size: 0.85rem;" /> <button class="btn btn-primary hsm-copy" type="button" aria-label="Copy" title="Copy"> </button> </div> <div class="small fw-bold mb-2 text-muted text-uppercase" style="font-size: 0.7rem; letter-spacing: 0.5px;">Share via</div> <div class="hsm-share-grid"> <a id="share-twitter" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Twitter </a> <a id="share-linkedin" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> LinkedIn </a> <a id="share-facebook" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Facebook </a> </div> </div> </div> </div> <style> .heading-share-modal { position: fixed; inset: 0; display: flex; justify-content: center; align-items: center; background: rgba(0, 0, 0, 0.6); z-index: 1050; padding: 1rem; backdrop-filter: blur(4px); -webkit-backdrop-filter: blur(4px); } .heading-share-modal[hidden] { display: none !important; } .hsm-dialog { max-width: 420px; width: 100%; background: var(--bs-body-bg, #fff); color: var(--bs-body-color, #212529); border: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); border-radius: 1rem; box-shadow: 0 25px 50px -12px rgba(0, 0, 0, 0.25); overflow: hidden; animation: hsm-fade-in 0.2s ease-out; } @keyframes hsm-fade-in { from { opacity: 0; transform: scale(0.95); } to { opacity: 1; transform: scale(1); } } [data-bs-theme="dark"] .hsm-dialog { background: #1e293b; border-color: rgba(255,255,255,0.1); color: #f8f9fa; } .hsm-header { display: flex; justify-content: space-between; align-items: center; padding: 1rem 1.5rem; border-bottom: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); background: rgba(0,0,0,0.02); } [data-bs-theme="dark"] .hsm-header { background: rgba(255,255,255,0.02); border-color: rgba(255,255,255,0.1); } .hsm-close { background: transparent; border: none; color: inherit; opacity: 0.5; padding: 0.25rem 0.5rem; border-radius: 0.25rem; font-size: 1.2rem; line-height: 1; transition: opacity 0.2s; } .hsm-close:hover { opacity: 1; } .hsm-body { padding: 1.5rem; } .hsm-url-group { display: flex !important; align-items: stretch; } .hsm-url-group .form-control { flex: 1; min-width: 0; margin: 0; background: var(--bs-secondary-bg, #f8f9fa); border-color: var(--bs-border-color, #dee2e6); border-top-right-radius: 0; border-bottom-right-radius: 0; height: 42px; } .hsm-url-group .btn { flex: 0 0 auto; margin: 0; margin-left: -1px; border-top-left-radius: 0; border-bottom-left-radius: 0; height: 42px; display: flex; align-items: center; justify-content: center; padding: 0 1.25rem; z-index: 2; } [data-bs-theme="dark"] .hsm-url-group .form-control { background: #0f172a; border-color: #334155; color: #e2e8f0; } .hsm-share-grid { display: flex; flex-direction: column; gap: 0.5rem; } .hsm-share-grid .btn { display: flex; align-items: center; justify-content: center; font-size: 0.9rem; padding: 0.6rem; border-color: var(--bs-border-color); width: 100%; } [data-bs-theme="dark"] .hsm-share-grid .btn { color: #e2e8f0; border-color: #475569; } [data-bs-theme="dark"] .hsm-share-grid .btn:hover { background: #334155; border-color: #cbd5e1; } </style> <script> (function(){ const modal = document.getElementById('headingShareModal'); if(!modal) return; const input = modal.querySelector('#headingShareInput'); const copyBtn = modal.querySelector('.hsm-copy'); const twitter = modal.querySelector('#share-twitter'); const linkedin = modal.querySelector('#share-linkedin'); const facebook = modal.querySelector('#share-facebook'); const closeBtn = modal.querySelector('.hsm-close'); let lastFocus=null; let trapBound=false; function buildUrl(id){ return window.location.origin + window.location.pathname + '#' + id; } function isOpen(){ return !modal.hasAttribute('hidden'); } function hydrate(id){ const url=buildUrl(id); input.value=url; const enc=encodeURIComponent(url); const text=encodeURIComponent(document.title); if(twitter) twitter.href=`https://twitter.com/intent/tweet?url=${enc}&text=${text}`; if(linkedin) linkedin.href=`https://www.linkedin.com/sharing/share-offsite/?url=${enc}`; if(facebook) facebook.href=`https://www.facebook.com/sharer/sharer.php?u=${enc}`; } function openModal(id){ lastFocus=document.activeElement; hydrate(id); if(!isOpen()){ modal.removeAttribute('hidden'); } requestAnimationFrame(()=>{ input.focus(); }); trapFocus(); } function closeModal(){ if(!isOpen()) return; modal.setAttribute('hidden',''); if(lastFocus && typeof lastFocus.focus==='function') lastFocus.focus(); } function copyCurrent(){ try{ navigator.clipboard.writeText(input.value).then(()=>feedback(true),()=>fallback()); } catch(e){ fallback(); } } function fallback(){ input.select(); try{ document.execCommand('copy'); feedback(true);}catch(e){ feedback(false);} } function feedback(ok){ if(!copyBtn) return; const icon=copyBtn.querySelector('i'); if(!icon) return; const prev=copyBtn.getAttribute('data-prev')||icon.className; if(!copyBtn.getAttribute('data-prev')) copyBtn.setAttribute('data-prev',prev); icon.className= ok ? 'fa-duotone fa-clipboard-check':'fa-duotone fa-circle-exclamation'; setTimeout(()=>{ icon.className=prev; },1800); } function handleShareClick(e){ e.preventDefault(); const btn=e.currentTarget; const id=btn.getAttribute('data-share-target'); if(id) openModal(id); } function bindShareButtons(){ document.querySelectorAll('.h-share').forEach(btn=>{ if(!btn.dataset.hShareBound){ btn.addEventListener('click', handleShareClick); btn.dataset.hShareBound='1'; } }); } bindShareButtons(); if(document.readyState==='loading'){ document.addEventListener('DOMContentLoaded', bindShareButtons); } else { requestAnimationFrame(bindShareButtons); } document.addEventListener('click', function(e){ const shareBtn=e.target.closest && e.target.closest('.h-share'); if(shareBtn && !shareBtn.dataset.hShareBound){ handleShareClick.call(shareBtn, e); } }, true); document.addEventListener('click', e=>{ if(e.target===modal) closeModal(); if(e.target.closest && e.target.closest('.hsm-close')){ e.preventDefault(); closeModal(); } if(copyBtn && (e.target===copyBtn || (e.target.closest && e.target.closest('.hsm-copy')))) { e.preventDefault(); copyCurrent(); } }); document.addEventListener('keydown', e=>{ if(e.key==='Escape' && isOpen()) closeModal(); }); function trapFocus(){ if(trapBound) return; trapBound=true; modal.addEventListener('keydown', f=>{ if(f.key==='Tab' && isOpen()){ const focusable=[...modal.querySelectorAll('a[href],button,input,textarea,select,[tabindex]:not([tabindex="-1"])')].filter(el=>!el.hasAttribute('disabled')); if(!focusable.length) return; const first=focusable[0]; const last=focusable[focusable.length-1]; if(f.shiftKey && document.activeElement===first){ f.preventDefault(); last.focus(); } else if(!f.shiftKey && document.activeElement===last){ f.preventDefault(); first.focus(); } } }); } if(closeBtn) closeBtn.addEventListener('click', e=>{ e.preventDefault(); closeModal(); }); })(); </script>Hands-on learning provides the fastest path to mastering Geode through practical exercises, interactive challenges, and real-world scenarios. Learn by building, not just reading. <h3 id="interactive-learning-philosophy" class="position-relative d-flex align-items-center group"> Interactive Learning Philosophy <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="interactive-learning-philosophy" aria-haspopup="dialog" aria-label="Share link: Interactive Learning Philosophy"> Share link </button> </h3>Active Engagement: Type every query yourself. Copy-paste teaches syntax; typing builds muscle memory and understanding. Immediate Feedback: Execute queries and see results instantly. When something doesn’t work, you learn why and how to fix it. Progressive Challenges: Start simple and increase complexity gradually. Each exercise builds on previous knowledge while introducing new concepts. Real-World Context: Work with realistic datasets and scenarios—social networks, e-commerce systems, knowledge graphs—not toy examples. <h3 id="exercise-1-building-your-first-social-network-30-minutes" class="position-relative d-flex align-items-center group"> Exercise 1: Building Your First Social Network (30 minutes) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="exercise-1-building-your-first-social-network-30-minutes" aria-haspopup="dialog" aria-label="Share link: Exercise 1: Building Your First Social Network (30 minutes)"> Share link </button> </h3> <h4 id="setup" class="position-relative d-flex align-items-center group"> Setup <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="setup" aria-haspopup="dialog" aria-label="Share link: Setup"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Start Geode and connect geode serve --listen localhost:3141 & geode shell </code></pre></div> <h4 id="task-11-create-user-profiles" class="position-relative d-flex align-items-center group"> Task 1.1: Create User Profiles <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="task-11-create-user-profiles" aria-haspopup="dialog" aria-label="Share link: Task 1.1: Create User Profiles"> Share link </button> </h4>Create 5 users with varying ages and locations: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">CREATE (alice:Person {name: 'Alice', age: 30, city: 'New York'}) CREATE (bob:Person {name: 'Bob', age: 25, city: 'San Francisco'}) CREATE (carol:Person {name: 'Carol', age: 28, city: 'New York'}) CREATE (dave:Person {name: 'Dave', age: 35, city: 'Chicago'}) CREATE (eve:Person {name: 'Eve', age: 27, city: 'San Francisco'}) </code></pre></div>Verification: Run <code>MATCH (p:Person) RETURN count(p)</code> - should return 5. <h4 id="task-12-add-friendships" class="position-relative d-flex align-items-center group"> Task 1.2: Add Friendships <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="task-12-add-friendships" aria-haspopup="dialog" aria-label="Share link: Task 1.2: Add Friendships"> Share link </button> </h4>Create relationships between users: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (alice:Person {name: 'Alice'}) MATCH (bob:Person {name: 'Bob'}) CREATE (alice)-[:KNOWS {since: 2020}]->(bob) </code></pre></div>Challenge: Add 6 more friendships forming a connected network. Make some bidirectional by creating relationships in both directions. <h4 id="task-13-query-your-network" class="position-relative d-flex align-items-center group"> Task 1.3: Query Your Network <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="task-13-query-your-network" aria-haspopup="dialog" aria-label="Share link: Task 1.3: Query Your Network"> Share link </button> </h4>Find all of Alice’s friends: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (alice:Person {name: 'Alice'})-[:KNOWS]->(friend) RETURN friend.name, friend.city </code></pre></div>Challenge Questions: <ol> <li>Who lives in the same city as Alice?</li> <li>Who has the most friends?</li> <li>Find all friends-of-friends for Bob who aren’t direct friends</li> </ol> <details> <summary>Solutions</summary> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Same city as Alice MATCH (alice:Person {name: 'Alice'}) MATCH (other:Person {city: alice.city}) WHERE other <> alice RETURN other.name -- Most friends MATCH (p:Person)-[:KNOWS]->(friend) RETURN p.name, COUNT(friend) as friend_count ORDER BY friend_count DESC LIMIT 1 -- Friends of friends MATCH (bob:Person {name: 'Bob'})-[:KNOWS]->(friend)-[:KNOWS]->(fof) WHERE NOT (bob)-[:KNOWS]->(fof) AND bob <> fof RETURN DISTINCT fof.name </code></pre></div></details> <h3 id="exercise-2-e-commerce-recommendation-engine-45-minutes" class="position-relative d-flex align-items-center group"> Exercise 2: E-Commerce Recommendation Engine (45 minutes) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="exercise-2-e-commerce-recommendation-engine-45-minutes" aria-haspopup="dialog" aria-label="Share link: Exercise 2: E-Commerce Recommendation Engine (45 minutes)"> Share link </button> </h3> <h4 id="setup-data" class="position-relative d-flex align-items-center group"> Setup Data <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="setup-data" aria-haspopup="dialog" aria-label="Share link: Setup Data"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create products CREATE (laptop:Product {id: 'p1', name: 'Laptop', price: 999, category: 'Electronics'}) CREATE (mouse:Product {id: 'p2', name: 'Mouse', price: 29, category: 'Electronics'}) CREATE (keyboard:Product {id: 'p3', name: 'Keyboard', price: 79, category: 'Electronics'}) CREATE (desk:Product {id: 'p4', name: 'Desk', price: 299, category: 'Furniture'}) CREATE (chair:Product {id: 'p5', name: 'Chair', price: 199, category: 'Furniture'}) -- Create users CREATE (u1:User {id: 'u1', name: 'Alice'}) CREATE (u2:User {id: 'u2', name: 'Bob'}) CREATE (u3:User {id: 'u3', name: 'Carol'}) -- Purchase history MATCH (u1:User {id: 'u1'}), (laptop:Product {id: 'p1'}) CREATE (u1)-[:PURCHASED {at: '2025-01-01'}]->(laptop) MATCH (u1:User {id: 'u1'}), (mouse:Product {id: 'p2'}) CREATE (u1)-[:PURCHASED {at: '2025-01-02'}]->(mouse) MATCH (u2:User {id: 'u2'}), (laptop:Product {id: 'p1'}) CREATE (u2)-[:PURCHASED {at: '2025-01-03'}]->(laptop) MATCH (u2:User {id: 'u2'}), (keyboard:Product {id: 'p3'}) CREATE (u2)-[:PURCHASED {at: '2025-01-04'}]->(keyboard) </code></pre></div> <h4 id="task-21-basic-recommendations" class="position-relative d-flex align-items-center group"> Task 2.1: Basic Recommendations <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="task-21-basic-recommendations" aria-haspopup="dialog" aria-label="Share link: Task 2.1: Basic Recommendations"> Share link </button> </h4>Write a query that recommends products to Alice based on what users with similar purchases bought: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (alice:User {id: 'u1'})-[:PURCHASED]->(p:Product) <-[:PURCHASED]-(other:User)-[:PURCHASED]->(rec:Product) WHERE NOT (alice)-[:PURCHASED]->(rec) RETURN rec.name, rec.price, COUNT(*) as relevance ORDER BY relevance DESC, rec.price ASC </code></pre></div>Challenge: Modify to only recommend products under $100 in the Electronics category. <h4 id="task-22-product-similarity" class="position-relative d-flex align-items-center group"> Task 2.2: Product Similarity <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="task-22-product-similarity" aria-haspopup="dialog" aria-label="Share link: Task 2.2: Product Similarity"> Share link </button> </h4>Create similarity relationships between products: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (p1:Product), (p2:Product) WHERE p1.category = p2.category AND p1 <> p2 CREATE (p1)-[:SIMILAR_TO {reason: 'same_category'}]->(p2) </code></pre></div>Challenge: Create a query that recommends “frequently bought together” products based on users who bought both. <h4 id="task-23-category-browsing" class="position-relative d-flex align-items-center group"> Task 2.3: Category Browsing <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="task-23-category-browsing" aria-haspopup="dialog" aria-label="Share link: Task 2.3: Category Browsing"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (p:Product {category: 'Electronics'}) RETURN p.name, p.price ORDER BY p.price DESC </code></pre></div>Challenge: Add pagination (SKIP/LIMIT) and price range filtering. <h3 id="exercise-3-knowledge-graph-navigation-45-minutes" class="position-relative d-flex align-items-center group"> Exercise 3: Knowledge Graph Navigation (45 minutes) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="exercise-3-knowledge-graph-navigation-45-minutes" aria-haspopup="dialog" aria-label="Share link: Exercise 3: Knowledge Graph Navigation (45 minutes)"> Share link </button> </h3> <h4 id="setup-hierarchical-data" class="position-relative d-flex align-items-center group"> Setup Hierarchical Data <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="setup-hierarchical-data" aria-haspopup="dialog" aria-label="Share link: Setup Hierarchical Data"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create topic hierarchy CREATE (root:Topic {name: 'Computer Science'}) CREATE (ai:Topic {name: 'Artificial Intelligence'}) CREATE (ml:Topic {name: 'Machine Learning'}) CREATE (dl:Topic {name: 'Deep Learning'}) CREATE (cv:Topic {name: 'Computer Vision'}) CREATE (nlp:Topic {name: 'Natural Language Processing'}) -- Create hierarchy MATCH (root:Topic {name: 'Computer Science'}) MATCH (ai:Topic {name: 'Artificial Intelligence'}) CREATE (ai)-[:SUBTOPIC_OF]->(root) MATCH (ai:Topic {name: 'Artificial Intelligence'}) MATCH (ml:Topic {name: 'Machine Learning'}) CREATE (ml)-[:SUBTOPIC_OF]->(ai) MATCH (ml:Topic {name: 'Machine Learning'}) MATCH (dl:Topic {name: 'Deep Learning'}) CREATE (dl)-[:SUBTOPIC_OF]->(ml) -- Add more connections... </code></pre></div> <h4 id="task-31-tree-traversal" class="position-relative d-flex align-items-center group"> Task 3.1: Tree Traversal <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="task-31-tree-traversal" aria-haspopup="dialog" aria-label="Share link: Task 3.1: Tree Traversal"> Share link </button> </h4>Find all subtopics of a topic at any depth: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (parent:Topic {name: 'Artificial Intelligence'}) <-[:SUBTOPIC_OF*]-(child:Topic) RETURN child.name, length(path) as depth ORDER BY depth, child.name </code></pre></div>Challenge: Find the path from ‘Deep Learning’ to ‘Computer Science’ and list all intermediate topics. <h4 id="task-32-related-concepts" class="position-relative d-flex align-items-center group"> Task 3.2: Related Concepts <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="task-32-related-concepts" aria-haspopup="dialog" aria-label="Share link: Task 3.2: Related Concepts"> Share link </button> </h4>Add cross-cutting relationships: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (cv:Topic {name: 'Computer Vision'}) MATCH (dl:Topic {name: 'Deep Learning'}) CREATE (cv)-[:RELATED_TO {strength: 0.9}]->(dl) </code></pre></div>Challenge: Find all topics within 2 hops of ‘Natural Language Processing’ (ignoring hierarchy). <h3 id="exercise-4-access-control-with-row-level-security-30-minutes" class="position-relative d-flex align-items-center group"> Exercise 4: Access Control with Row-Level Security (30 minutes) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="exercise-4-access-control-with-row-level-security-30-minutes" aria-haspopup="dialog" aria-label="Share link: Exercise 4: Access Control with Row-Level Security (30 minutes)"> Share link </button> </h3> <h4 id="task-41-multi-tenant-data" class="position-relative d-flex align-items-center group"> Task 4.1: Multi-Tenant Data <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="task-41-multi-tenant-data" aria-haspopup="dialog" aria-label="Share link: Task 4.1: Multi-Tenant Data"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create organizations CREATE (orgA:Organization {id: 'org1', name: 'Acme Corp'}) CREATE (orgB:Organization {id: 'org2', name: 'TechStart Inc'}) -- Create users belonging to organizations CREATE (u1:User {id: 'u1', name: 'Alice', org_id: 'org1'}) CREATE (u2:User {id: 'u2', name: 'Bob', org_id: 'org1'}) CREATE (u3:User {id: 'u3', name: 'Carol', org_id: 'org2'}) -- Link users to organizations MATCH (u:User {id: 'u1'}), (org:Organization {id: 'org1'}) CREATE (u)-[:BELONGS_TO]->(org) </code></pre></div> <h4 id="task-42-filtered-queries" class="position-relative d-flex align-items-center group"> Task 4.2: Filtered Queries <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="task-42-filtered-queries" aria-haspopup="dialog" aria-label="Share link: Task 4.2: Filtered Queries"> Share link </button> </h4>Write a query that only returns users from Alice’s organization: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (current:User {id: 'u1'})-[:BELONGS_TO]->(org:Organization) MATCH (coworker:User)-[:BELONGS_TO]->(org) WHERE coworker <> current RETURN coworker.name </code></pre></div>Challenge: Create a view or parameterized query that automatically filters based on the current user’s organization. <h3 id="exercise-5-performance-optimization-45-minutes" class="position-relative d-flex align-items-center group"> Exercise 5: Performance Optimization (45 minutes) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="exercise-5-performance-optimization-45-minutes" aria-haspopup="dialog" aria-label="Share link: Exercise 5: Performance Optimization (45 minutes)"> Share link </button> </h3> <h4 id="task-51-create-sample-data" class="position-relative d-flex align-items-center group"> Task 5.1: Create Sample Data <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="task-51-create-sample-data" aria-haspopup="dialog" aria-label="Share link: Task 5.1: Create Sample Data"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">import asyncio from geode_client import Client async def load_data(): client = Client(host="localhost", port=3141) async with client.connection() as conn: # Create 1000 users for i in range(1000): await conn.execute(""" CREATE (u:User { id: $id, name: $name, email: $email, created_at: $timestamp }) """, id=f"user{i}", name=f"User {i}", email=f"user{i}@example.com", timestamp="2025-01-01T00:00:00Z") asyncio.run(load_data()) </code></pre></div> <h4 id="task-52-profile-slow-query" class="position-relative d-flex align-items-center group"> Task 5.2: Profile Slow Query <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="task-52-profile-slow-query" aria-haspopup="dialog" aria-label="Share link: Task 5.2: Profile Slow Query"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Run this query and note the execution time PROFILE MATCH (u:User {email: 'user500@example.com'}) RETURN u.name, u.created_at </code></pre></div>Challenge: Create an index on email and compare execution time: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">CREATE INDEX ON User(email) -- Re-run the profile query PROFILE MATCH (u:User {email: 'user500@example.com'}) RETURN u.name, u.created_at </code></pre></div> <h4 id="task-53-identify-cartesian-products" class="position-relative d-flex align-items-center group"> Task 5.3: Identify Cartesian Products <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="task-53-identify-cartesian-products" aria-haspopup="dialog" aria-label="Share link: Task 5.3: Identify Cartesian Products"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- This query is inefficient - why? MATCH (u:User), (p:Product) RETURN count(*) </code></pre></div>Challenge: Rewrite using proper relationship patterns. <h3 id="exercise-6-transaction-management-30-minutes" class="position-relative d-flex align-items-center group"> Exercise 6: Transaction Management (30 minutes) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="exercise-6-transaction-management-30-minutes" aria-haspopup="dialog" aria-label="Share link: Exercise 6: Transaction Management (30 minutes)"> Share link </button> </h3> <h4 id="task-61-banking-transfer" class="position-relative d-flex align-items-center group"> Task 6.1: Banking Transfer <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="task-61-banking-transfer" aria-haspopup="dialog" aria-label="Share link: Task 6.1: Banking Transfer"> Share link </button> </h4>Implement an atomic money transfer: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">async def transfer(client, from_id, to_id, amount): async with client.connection() as tx: await tx.begin() # Check sender balance result, _ = await tx.query(""" MATCH (sender:Account {id: $id}) RETURN sender.balance """, id=from_id) row = await result.first() if row['sender.balance'] < amount: raise Exception("Insufficient funds") # Deduct from sender await tx.execute(""" MATCH (sender:Account {id: $id}) SET sender.balance = sender.balance - $amount """, id=from_id, amount=amount) # Add to receiver await tx.execute(""" MATCH (receiver:Account {id: $id}) SET receiver.balance = receiver.balance + $amount """, id=to_id, amount=amount) # Transaction commits automatically if no exceptions </code></pre></div>Challenge: Add rollback handling for various failure scenarios. <h4 id="task-62-savepoints" class="position-relative d-flex align-items-center group"> Task 6.2: Savepoints <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="task-62-savepoints" aria-haspopup="dialog" aria-label="Share link: Task 6.2: Savepoints"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">async def complex_operation(client): async with client.connection() as tx: await tx.begin() await tx.execute("CREATE (u:User {id: 'temp1', name: 'Test'})") sp = await tx.savepoint("checkpoint") try: # Risky operation await tx.execute("CREATE (u:User {id: 'temp1'})") # Duplicate! except Exception: await tx.rollback_to(sp) # Rollback to savepoint await tx.execute("CREATE (u:User {id: 'temp2'})") </code></pre></div>Challenge: Implement a multi-step import process with savepoints after each batch. <h3 id="hands-on-challenges" class="position-relative d-flex align-items-center group"> Hands-On Challenges <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="hands-on-challenges" aria-haspopup="dialog" aria-label="Share link: Hands-On Challenges"> Share link </button> </h3> <h4 id="challenge-1-shortest-path" class="position-relative d-flex align-items-center group"> Challenge 1: Shortest Path <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="challenge-1-shortest-path" aria-haspopup="dialog" aria-label="Share link: Challenge 1: Shortest Path"> Share link </button> </h4>Find the shortest path between any two nodes in your social network. Calculate the degrees of separation. <h4 id="challenge-2-influence-scoring" class="position-relative d-flex align-items-center group"> Challenge 2: Influence Scoring <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="challenge-2-influence-scoring" aria-haspopup="dialog" aria-label="Share link: Challenge 2: Influence Scoring"> Share link </button> </h4>Implement a query that calculates influence scores based on connection count and friend influence (recursive). <h4 id="challenge-3-real-time-feeds" class="position-relative d-flex align-items-center group"> Challenge 3: Real-Time Feeds <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="challenge-3-real-time-feeds" aria-haspopup="dialog" aria-label="Share link: Challenge 3: Real-Time Feeds"> Share link </button> </h4>Build a query that returns the latest posts from friends, ordered by timestamp with pagination. <h4 id="challenge-4-fraud-detection" class="position-relative d-flex align-items-center group"> Challenge 4: Fraud Detection <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="challenge-4-fraud-detection" aria-haspopup="dialog" aria-label="Share link: Challenge 4: Fraud Detection"> Share link </button> </h4>Create a graph of financial transactions and write queries to detect suspicious patterns (circular transfers, velocity rules). <h4 id="challenge-5-recommendation-diversity" class="position-relative d-flex align-items-center group"> Challenge 5: Recommendation Diversity <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="challenge-5-recommendation-diversity" aria-haspopup="dialog" aria-label="Share link: Challenge 5: Recommendation Diversity"> Share link </button> </h4>Modify the recommendation engine to balance relevance with diversity (different categories, price ranges). <h3 id="learning-labs" class="position-relative d-flex align-items-center group"> Learning Labs <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="learning-labs" aria-haspopup="dialog" aria-label="Share link: Learning Labs"> Share link </button> </h3> <h4 id="lab-1-schema-design-workshop" class="position-relative d-flex align-items-center group"> Lab 1: Schema Design Workshop <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="lab-1-schema-design-workshop" aria-haspopup="dialog" aria-label="Share link: Lab 1: Schema Design Workshop"> Share link </button> </h4>Given a business domain (e.g., healthcare, logistics, media), design a complete graph schema. Create sample data and write 10 queries covering common use cases. <h4 id="lab-2-migration-project" class="position-relative d-flex align-items-center group"> Lab 2: Migration Project <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="lab-2-migration-project" aria-haspopup="dialog" aria-label="Share link: Lab 2: Migration Project"> Share link </button> </h4>Take an existing relational database schema and migrate it to Geode. Write queries that demonstrate improved performance for relationship-heavy queries. <h4 id="lab-3-performance-tuning" class="position-relative d-flex align-items-center group"> Lab 3: Performance Tuning <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="lab-3-performance-tuning" aria-haspopup="dialog" aria-label="Share link: Lab 3: Performance Tuning"> Share link </button> </h4>Start with slow queries, profile them, add indexes strategically, and measure improvements. Document your optimization process. <h4 id="lab-4-security-hardening" class="position-relative d-flex align-items-center group"> Lab 4: Security Hardening <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="lab-4-security-hardening" aria-haspopup="dialog" aria-label="Share link: Lab 4: Security Hardening"> Share link </button> </h4>Implement a complete security model with authentication, role-based access, and row-level security for a multi-tenant application. <h3 id="challenge-solutions-and-hints" class="position-relative d-flex align-items-center group"> Challenge Solutions and Hints <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="challenge-solutions-and-hints" aria-haspopup="dialog" aria-label="Share link: Challenge Solutions and Hints"> Share link </button> </h3> <h4 id="shortest-path-challenge-solution" class="position-relative d-flex align-items-center group"> Shortest Path Challenge Solution <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="shortest-path-challenge-solution" aria-haspopup="dialog" aria-label="Share link: Shortest Path Challenge Solution"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find degrees of separation between any two users MATCH path = SHORTEST_PATH((a:User {name: 'Alice'})-[:KNOWS*]-(b:User {name: 'Eve'})) RETURN length(path) AS degrees_of_separation, [node IN nodes(path) | node.name] AS path_names; -- Find all paths within certain degree MATCH path = (a:User {name: 'Alice'})-[:KNOWS*1..3]-(b:User) WHERE a <> b RETURN b.name, length(path) AS degree ORDER BY degree, b.name; </code></pre></div> <h4 id="influence-scoring-challenge-solution" class="position-relative d-flex align-items-center group"> Influence Scoring Challenge Solution <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="influence-scoring-challenge-solution" aria-haspopup="dialog" aria-label="Share link: Influence Scoring Challenge Solution"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Calculate PageRank-style influence WITH collect(DISTINCT n) AS all_users UNWIND all_users AS user MATCH (user:User) OPTIONAL MATCH (user)-[:KNOWS]->(friend:User) WITH user, COUNT(friend) AS direct_influence, COLLECT(friend) AS friends UNWIND friends AS friend OPTIONAL MATCH (friend)-[:KNOWS]->(fof:User) WITH user, direct_influence, AVG(COUNT(fof)) AS avg_friend_influence RETURN user.name, direct_influence, avg_friend_influence, direct_influence + (avg_friend_influence * 0.5) AS total_influence ORDER BY total_influence DESC; </code></pre></div> <h4 id="real-time-feed-challenge-solution" class="position-relative d-flex align-items-center group"> Real-Time Feed Challenge Solution <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="real-time-feed-challenge-solution" aria-haspopup="dialog" aria-label="Share link: Real-Time Feed Challenge Solution"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Latest posts from friends with pagination MATCH (current:User {id: $user_id})-[:FOLLOWS]->(friend:User)-[:POSTED]->(post:Post) RETURN friend.name, post.content, post.timestamp, post.likes_count ORDER BY post.timestamp DESC SKIP $offset LIMIT $page_size; -- With comment count MATCH (current:User {id: $user_id})-[:FOLLOWS]->(friend:User)-[:POSTED]->(post:Post) OPTIONAL MATCH (post)<-[:COMMENTED]-(comment:Comment) WITH friend, post, COUNT(comment) AS comment_count RETURN friend.name, post.content, post.timestamp, post.likes_count, comment_count ORDER BY post.timestamp DESC SKIP $offset LIMIT $page_size; </code></pre></div> <h4 id="fraud-detection-challenge-solution" class="position-relative d-flex align-items-center group"> Fraud Detection Challenge Solution <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="fraud-detection-challenge-solution" aria-haspopup="dialog" aria-label="Share link: Fraud Detection Challenge Solution"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Detect circular payment patterns MATCH path = (a:Account)-[:PAYMENT*3..5]->(a) WHERE ALL(r IN relationships(path) WHERE r.amount > 1000) AND ALL(n IN nodes(path) WHERE SIZE([(n)-[:PAYMENT]->() | 1]) > 5) RETURN path, [r IN relationships(path) | r.amount] AS amounts, REDUCE(total = 0, r IN relationships(path) | total + r.amount) AS total_amount; -- Velocity check: Too many transactions in short time MATCH (a:Account)-[t:PAYMENT]->() WHERE t.timestamp > CURRENT_TIMESTAMP - INTERVAL '1' HOUR WITH a, COUNT(t) AS tx_count, SUM(t.amount) AS total_amount WHERE tx_count > 10 OR total_amount > 50000 RETURN a.id, tx_count, total_amount ORDER BY tx_count DESC; -- Unusual pattern: Receive then immediately send similar amount MATCH (a:Account)<-[r1:PAYMENT]-(sender) WHERE r1.timestamp > CURRENT_TIMESTAMP - INTERVAL '24' HOUR MATCH (a)-[r2:PAYMENT]->(recipient) WHERE r2.timestamp > r1.timestamp AND r2.timestamp < r1.timestamp + INTERVAL '1' HOUR AND ABS(r2.amount - r1.amount) < r1.amount * 0.05 -- Within 5% RETURN a.id, sender.id, recipient.id, r1.amount, r2.amount, DURATION.BETWEEN(r1.timestamp, r2.timestamp).minutes AS minutes_between; </code></pre></div> <h3 id="advanced-hands-on-projects" class="position-relative d-flex align-items-center group"> Advanced Hands-On Projects <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="advanced-hands-on-projects" aria-haspopup="dialog" aria-label="Share link: Advanced Hands-On Projects"> Share link </button> </h3> <h4 id="project-1-build-a-recommendation-system" class="position-relative d-flex align-items-center group"> Project 1: Build a Recommendation System <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="project-1-build-a-recommendation-system" aria-haspopup="dialog" aria-label="Share link: Project 1: Build a Recommendation System"> Share link </button> </h4>Objective: Create a complete recommendation engine with multiple algorithms. Requirements: <ol> <li>Collaborative filtering based on user similarity</li> <li>Content-based recommendations using product attributes</li> <li>Hybrid approach combining both</li> <li>A/B testing framework to compare algorithms</li> <li>Real-time recommendation serving</li> </ol> Starter Code: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">class RecommendationEngine: def __init__(self, client): self.client = client async def collaborative_filtering(self, user_id, limit=10): """Find products liked by similar users""" result, _ = await self.client.query(""" // TODO: Implement collaborative filtering // 1. Find users who bought similar products // 2. Find products those users also bought // 3. Rank by similarity score """, {"user_id": user_id, "limit": limit}) return result async def content_based(self, user_id, limit=10): """Recommend based on product attributes""" result, _ = await self.client.query(""" // TODO: Implement content-based filtering // 1. Find products user has liked // 2. Find similar products by attributes // 3. Rank by attribute similarity """, {"user_id": user_id, "limit": limit}) return result async def hybrid(self, user_id, limit=10): """Combine both approaches""" collab = await self.collaborative_filtering(user_id, limit * 2) content = await self.content_based(user_id, limit * 2) # TODO: Implement ranking combination pass </code></pre></div> <h4 id="project-2-social-network-analytics-dashboard" class="position-relative d-flex align-items-center group"> Project 2: Social Network Analytics Dashboard <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="project-2-social-network-analytics-dashboard" aria-haspopup="dialog" aria-label="Share link: Project 2: Social Network Analytics Dashboard"> Share link </button> </h4>Objective: Build analytics dashboard for social network insights. Features: <ol> <li>User growth metrics (daily/weekly/monthly active users)</li> <li>Engagement metrics (posts, likes, comments per user)</li> <li>Network topology analysis (clusters, influencers)</li> <li>Content virality tracking</li> <li>Retention cohort analysis</li> </ol> Queries to Implement: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Daily active users MATCH (u:User)-[:ACTION]->(a) WHERE a.timestamp >= DATE_TRUNC('day', CURRENT_TIMESTAMP) RETURN DATE(a.timestamp) AS date, COUNT(DISTINCT u) AS daily_active_users; -- Top influencers by engagement MATCH (u:User)-[:POSTED]->(p:Post) OPTIONAL MATCH (p)<-[:LIKED]-(liker) OPTIONAL MATCH (p)<-[:COMMENTED]-(commenter) WITH u, COUNT(DISTINCT p) AS post_count, COUNT(DISTINCT liker) AS total_likes, COUNT(DISTINCT commenter) AS total_comments RETURN u.name, post_count, total_likes, total_comments, (total_likes + total_comments * 2) AS engagement_score ORDER BY engagement_score DESC LIMIT 100; -- Content virality (posts shared most) MATCH (p:Post)<-[:SHARED]-(sharer:User) WITH p, COUNT(sharer) AS share_count WHERE share_count > 5 MATCH (original_poster:User)-[:POSTED]->(p) RETURN original_poster.name, p.content, p.timestamp, share_count, DURATION.BETWEEN(p.timestamp, CURRENT_TIMESTAMP).hours AS hours_since_posted, share_count * 1.0 / DURATION.BETWEEN(p.timestamp, CURRENT_TIMESTAMP).hours AS virality_rate ORDER BY virality_rate DESC; </code></pre></div> <h4 id="project-3-knowledge-graph-query-engine" class="position-relative d-flex align-items-center group"> Project 3: Knowledge Graph Query Engine <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="project-3-knowledge-graph-query-engine" aria-haspopup="dialog" aria-label="Share link: Project 3: Knowledge Graph Query Engine"> Share link </button> </h4>Objective: Build intelligent query engine over knowledge graph. Features: <ol> <li>Natural language to GQL translation</li> <li>Entity recognition and linking</li> <li>Relationship extraction</li> <li>Answer ranking by relevance</li> <li>Explanation generation</li> </ol> Implementation Outline: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">class KnowledgeGraphQueryEngine: def __init__(self, client, nlp_model): self.client = client self.nlp = nlp_model async def query(self, natural_language_question): """Answer question using knowledge graph""" # 1. Extract entities entities = self.extract_entities(natural_language_question) # 2. Generate GQL queries gql_queries = self.generate_queries(entities, natural_language_question) # 3. Execute queries results = [] for query in gql_queries: result, _ = await self.client.query(query) results.append(result) # 4. Rank and format answers answers = self.rank_answers(results, natural_language_question) return answers def extract_entities(self, question): # TODO: Use NLP to extract named entities pass def generate_queries(self, entities, question): # TODO: Generate GQL queries based on question type pass </code></pre></div> <h4 id="project-4-multi-tenant-saas-application" class="position-relative d-flex align-items-center group"> Project 4: Multi-Tenant SaaS Application <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="project-4-multi-tenant-saas-application" aria-haspopup="dialog" aria-label="Share link: Project 4: Multi-Tenant SaaS Application"> Share link </button> </h4>Objective: Build complete multi-tenant application with RLS. Features: <ol> <li>Tenant isolation using RLS policies</li> <li>Per-tenant resource limits</li> <li>Shared schema with tenant-specific data</li> <li>Audit logging per tenant</li> <li>Tenant analytics dashboard</li> </ol> RLS Policy Examples: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create RLS policy for tenant isolation CREATE POLICY tenant_isolation ON User FOR ALL USING (tenant_id = current_tenant_id()); -- Create policy for hierarchical access CREATE POLICY manager_access ON Employee FOR SELECT USING ( employee_id = current_user_id() OR EXISTS { MATCH (current:Employee {id: current_user_id()})-[:MANAGES*]->(emp:Employee) WHERE emp.employee_id = Employee.employee_id } ); -- Row-level encryption policy CREATE POLICY sensitive_data ON Customer FOR SELECT USING ( has_permission(current_user_id(), 'view_pii') OR customer_id = current_user_id() ); </code></pre></div> <h3 id="debugging-exercises" class="position-relative d-flex align-items-center group"> Debugging Exercises <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="debugging-exercises" aria-haspopup="dialog" aria-label="Share link: Debugging Exercises"> Share link </button> </h3> <h4 id="exercise-debug-slow-query" class="position-relative d-flex align-items-center group"> Exercise: Debug Slow Query <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="exercise-debug-slow-query" aria-haspopup="dialog" aria-label="Share link: Exercise: Debug Slow Query"> Share link </button> </h4>Problem: This query is very slow. Fix it. <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Slow query MATCH (u:User) MATCH (p:Product) WHERE EXISTS { MATCH (u)-[:PURCHASED]->(p) } RETURN u.name, p.name; </code></pre></div>Steps: <ol> <li>Run EXPLAIN to see execution plan</li> <li>Identify the problem (hint: Cartesian product)</li> <li>Rewrite to use proper pattern matching</li> <li>Verify with PROFILE</li> </ol> <details> <summary>Solution</summary> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Optimized query MATCH (u:User)-[:PURCHASED]->(p:Product) RETURN u.name, p.name; </code></pre></div>The original creates a Cartesian product of ALL users × ALL products, then filters. The optimized version uses pattern matching directly. </details> <h4 id="exercise-fix-transaction-deadlock" class="position-relative d-flex align-items-center group"> Exercise: Fix Transaction Deadlock <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="exercise-fix-transaction-deadlock" aria-haspopup="dialog" aria-label="Share link: Exercise: Fix Transaction Deadlock"> Share link </button> </h4>Problem: Two concurrent transactions are deadlocking. Transaction 1: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">BEGIN; MATCH (a:Account {id: 1}) SET a.balance = a.balance - 100; -- Pause MATCH (b:Account {id: 2}) SET b.balance = b.balance + 100; COMMIT; </code></pre></div>Transaction 2: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">BEGIN; MATCH (b:Account {id: 2}) SET b.balance = b.balance - 50; -- Pause MATCH (a:Account {id: 1}) SET a.balance = a.balance + 50; COMMIT; </code></pre></div>Task: Identify why deadlock occurs and fix it. <details> <summary>Solution</summary> Deadlock occurs because: <ul> <li>TX1 locks Account 1, then tries to lock Account 2</li> <li>TX2 locks Account 2, then tries to lock Account 1</li> </ul> Fix: Always acquire locks in consistent order: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Both transactions should lock in same order (by ID) BEGIN; MATCH (a:Account {id: 1}), (b:Account {id: 2}) WHERE a.id < b.id SET a.balance = a.balance - 100, b.balance = b.balance + 100; COMMIT; </code></pre></div></details> <h3 id="community-challenges" class="position-relative d-flex align-items-center group"> Community Challenges <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="community-challenges" aria-haspopup="dialog" aria-label="Share link: Community Challenges"> Share link </button> </h3> <h4 id="weekly-challenge-graph-algorithm-implementation" class="position-relative d-flex align-items-center group"> Weekly Challenge: Graph Algorithm Implementation <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="weekly-challenge-graph-algorithm-implementation" aria-haspopup="dialog" aria-label="Share link: Weekly Challenge: Graph Algorithm Implementation"> Share link </button> </h4>Implement these algorithms using only GQL: <ol> <li>Dijkstra’s shortest path with weighted edges</li> <li>Triangle counting for clustering coefficient</li> <li>Graph coloring for conflict-free scheduling</li> <li>Maximum flow in a network</li> <li>Minimum spanning tree for optimization</li> </ol> <h4 id="monthly-project-build-a-full-application" class="position-relative d-flex align-items-center group"> Monthly Project: Build a Full Application <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="monthly-project-build-a-full-application" aria-haspopup="dialog" aria-label="Share link: Monthly Project: Build a Full Application"> Share link </button> </h4>Complete projects that combine multiple concepts: <ol> <li>Twitter Clone: Social graph with posts, likes, retweets, trending topics</li> <li>E-commerce Platform: Products, recommendations, reviews, fraud detection</li> <li>Knowledge Base: Hierarchical documentation with search and recommendations</li> <li>Project Management: Tasks, dependencies, resources, timelines</li> <li>Supply Chain: Logistics network with optimization and tracking</li> </ol> <h3 id="related-topics" class="position-relative d-flex align-items-center group"> Related Topics <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="related-topics" aria-haspopup="dialog" aria-label="Share link: Related Topics"> Share link </button> </h3><ul> <li><a href="/tags/tutorials/" >Tutorials</a> : Structured learning paths with explanations</li> <li><a href="/tags/examples/" >Examples</a> : Copy-paste ready code snippets</li> <li><a href="/tags/getting-started/" >Getting Started</a> : Foundation concepts and setup</li> <li><a href="/tags/developer-guide/" >Developer Guide</a> : Complete API reference</li> <li><a href="/tags/quickstart/" >Quickstart</a> : Fast-track guides for immediate productivity</li> <li><a href="/tags/tutorials/" >Tutorials</a> : Structured learning paths</li> <li><a href="/tags/examples/" >Examples</a> : Ready-to-use code examples</li> </ul> <h3 id="additional-resources" class="position-relative d-flex align-items-center group"> Additional Resources <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="additional-resources" aria-haspopup="dialog" aria-label="Share link: Additional Resources"> Share link </button> </h3><ul> <li>Video Walkthroughs: Watch step-by-step solution videos</li> <li>Community Forums: Discuss solutions and get help</li> <li>Code Templates: Starter code for common patterns</li> <li>Solution Repository: Browse complete working solutions</li> <li>Office Hours: Weekly live coding sessions</li> </ul> Start with Exercise 1 and work your way through. Don’t skip ahead – each exercise builds essential skills for the next!

Popular

Related Articles

Tutorials