SQL practice in SQL Analytics

Browse the rooms before signing in. Opening a room requires an account and follows your existing access. Practice does not issue certificates.

• First Query on Deck

  Data analyst answering the VP of Sales before a call.

  querying-data. Free room.

• Product Catalog Snapshot

  Data analyst pulling a pricing snapshot for a design slide.

  querying-data. Free room.

• Region Filter

  Data analyst extracting EMEA orders before a standup.

  querying-data. Free room.

• Signup Surge Check

  Data analyst counting daily signups before the all-hands.

  querying-data. Free room.

• Customer Order Crosswalk

  Data analyst attaching customer names to revenue rows for the CFO.

  joins. Account access required.

• Rep Performance Lookup

  Data analyst pulling rep deal counts before a 1-on-1.

  joins. Account access required.

• Top Spenders by Segment

  Data analyst ranking Enterprise customers for a QBR deck.

  joins. Account access required.

• Unmatched Accounts Alert

  Data analyst finding accounts with no orders before a billing audit.

  joins. Account access required.

• Churned Revenue Estimate

  Data analyst estimating ARR churn for the CEO.

  subqueries. Account access required.

• Cohort Retention Snapshot

  Data analyst computing 30-day retention for the head of product.

  window-functions. Account access required.

• Duplicate Order Audit

  Data analyst hunting duplicate order IDs for the finance lead.

  data-cleaning. Account access required.

• Rolling 7-Day Revenue

  Data analyst reproducing a revenue sparkline for the dashboard.

  window-functions. Account access required.

• Conversion Funnel Drop-Off

  Data analyst computing funnel conversion rates for the growth team.

  funnels. Account access required.

• Segment Revenue Share with UNION

  Data analyst blending direct and partner revenue for finance.

  set-operations. Account access required.

• Trial-to-Paid Attribution

  Data analyst computing trial conversion rate for the CFO.

  funnels. Account access required.

• Year-over-Year Revenue Comparison

  Data analyst computing YoY revenue change for a board slide.

  time-series. Account access required.

• Cohort Lifetime Value Projection

  Data analyst building cohort LTV for the CFO's payback targets.

  capstone-project. Account access required.

• Customer Health Score Ranking

  Data analyst building a CS health score before Monday outreach.

  advanced-patterns. Account access required.

• Executive Dashboard Rescue

  Data analyst fixing three broken board deck numbers before auto-publish.

  capstone-project, subqueries, time-series, window-functions. Account access required.

• Late-Arriving Data Reconciliation

  Data analyst reconciling late-loaded orders for the monthly revenue close.

  data-cleaning. Account access required.