SQL practice in SQL Analytics

Browse the rooms before signing in. All rooms are free with an account. Practice does not issue certificates.

• First Query on Deck

  Data analyst answering the VP of Sales before a call.

  querying-data. Free with an account.

• Product Catalog Snapshot

  Data analyst pulling a pricing snapshot for a design slide.

  querying-data. Free with an account.

• Region Filter

  Data analyst extracting EMEA orders before a standup.

  querying-data. Free with an account.

• Signup Surge Check

  Data analyst counting daily signups before the all-hands.

  querying-data. Free with an account.

• Customer Order Crosswalk

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

  joins. Free with an account.

• Rep Performance Lookup

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

  joins. Free with an account.

• Top Spenders by Segment

  Data analyst ranking Enterprise customers for a QBR deck.

  joins. Free with an account.

• Unmatched Accounts Alert

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

  joins. Free with an account.

• Churned Revenue Estimate

  Data analyst estimating ARR churn for the CEO.

  subqueries. Free with an account.

• Cohort Retention Snapshot

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

  window-functions. Free with an account.

• Duplicate Order Audit

  Data analyst hunting duplicate order IDs for the finance lead.

  data-cleaning. Free with an account.

• Rolling 7-Day Revenue

  Data analyst reproducing a revenue sparkline for the dashboard.

  window-functions. Free with an account.

• Conversion Funnel Drop-Off

  Data analyst computing funnel conversion rates for the growth team.

  funnels. Free with an account.

• Segment Revenue Share with UNION

  Data analyst blending direct and partner revenue for finance.

  set-operations. Free with an account.

• Trial-to-Paid Attribution

  Data analyst computing trial conversion rate for the CFO.

  funnels. Free with an account.

• Year-over-Year Revenue Comparison

  Data analyst computing YoY revenue change for a board slide.

  time-series. Free with an account.

• Cohort Lifetime Value Projection

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

  capstone-project. Free with an account.

• Customer Health Score Ranking

  Data analyst building a CS health score before Monday outreach.

  advanced-patterns. Free with an account.

• Executive Dashboard Rescue

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

  capstone-project, subqueries, time-series, window-functions. Free with an account.

• Late-Arriving Data Reconciliation

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

  data-cleaning. Free with an account.