SQL Recipes vs SQL Practice

An everyday SQL reference, from your first SELECT to window functions. Every query comes with an explanation, and most of them run. • 39 sections: filtering, sorting, calculated fields, functions, GROUP BY, window functions, subqueries, JOIN, UNION, INSERT and UPDATE, data types, tables, views. • Run in the app: more than half of the queries execute against a live practice database, and the result table appears below the query. Needs an internet connection. • Changes in new versions: 7 sections from SQL-92 to SQL:2023, showing what each standard added, with the old and the new query side by side. • Dialects compared: MySQL, PostgreSQL, SQLite, MS SQL Server, Oracle, Firebird, Access. Where they differ, each one is shown separately. • The practice database is the classic MySQL world sample database: countries, cities, languages. The tables are described in the app. • Edit any query and run it again; one tap brings the original back. • Add your own queries; they stay in the app and are always at hand. • Search by section name or by a fragment of a query. • Everything except running works offline. No account needed. WHAT THE FREE VERSION INCLUDES 12 runs and 12 edits a day; the limit resets every morning. The keyword reference is unlocked, with no limits. Up to 5 queries of your own. The full version unlocks every section, lifts the daily limits and raises the run limit to 80 a day. One purchase, no subscription. Built by a developer for developers. In active development since 2015.

Learn SQL in 15-minute daily sessions — on your phone, anywhere. SQL Practice turns idle moments into practical data skills. With interactive exercises, realistic datasets, and instant feedback, you’ll build SQL confidence from beginner fundamentals to interview-ready skills. Who it’s for: - Career changers entering tech - Professionals adding SQL to their toolkit - Students preparing for technical interviews - Anyone curious about data and databases Why it’s different: - Learn by doing: write and run real SQL queries - SQL Patterns (Pro): understand reusable approaches instead of memorizing answers - Database Bits (Pro): build intuition with short, visual lessons - Smarter feedback (Pro): see why your result differs from the expected output - Progressive curriculum: start with the fundamentals and advance at your own pace - Mobile-first design: practice whenever you have a few spare minutes When you get stuck: With Pro, SQL Practice helps you move forward without immediately giving away the answer. Use progressive hints, compare your results with the expected output, and explore SQL X-Ray explanations that break queries into understandable steps. What you’ll learn: - SELECT, WHERE, ORDER BY, and filtering - JOINs and relationships between tables - COUNT, SUM, AVG, GROUP BY, and HAVING - Subqueries and advanced query techniques - Reusable SQL patterns (Pro) - Core database concepts, indexes, and data design (Pro) Practice your way: - Guided SQL lessons - Easy, medium, and hard exercises - Quick drills - Short visual database lessons (Pro) - Daily practice challenges - Streaks, XP, achievements, and progress tracking - Hardcore mode: turn off the advanced SQL keyboard and solve the toughest challenges without assistance—the highest level of SQL practice. Free and Pro: Core SQL lessons, exercises, drills, streaks, and basic progress tracking are free. An optional auto-renewing Pro subscription unlocks SQL Patterns, Database Bits, progressive hints, detailed result comparisons, and SQL X-Ray step-by-step explanations. Available plans, billing periods, trial eligibility, and localized prices are shown before purchase. No purchase is required to use the core learning and practice features. Start your data journey today — no prior coding experience required, just 15 minutes of curiosity. Privacy Policy: https://martongreber.github.io/mvp/privacy.html Terms of Use: https://martongreber.github.io/mvp/terms.html