SQL Recipes vs SQL Practice

200+ SQL queries with explanations, 120+ of them free. Tap Run and see the result table right in the app. An everyday SQL cheat sheet, from your first SELECT to window functions. • 39 sections, including filtering, sorting, calculated fields, functions, GROUP BY, window functions, subqueries, JOIN, UNION, INSERT and UPDATE, data types, tables, views. • Changes by standard: 7 sections from SQL-92 to SQL:2023, with before-and-after queries. • Keyword and function reference: over 180 articles. Browse, search, or tap a word in a query to open its article. • Dialects compared: MySQL, PostgreSQL, SQLite, SQL Server, Oracle, Firebird, Access. Where they differ, the dialect-specific variants are shown. • Practice database: the classic MySQL “world” sample (countries, cities, spoken languages); its tables are described in the app. • Run in the app: more than half of the queries execute against the practice database, and the result table appears directly below the query. Requires an internet connection. • Search covers the queries themselves, not just titles: type a fragment you remember and find the query. • Edit queries and rerun the runnable ones; one tap brings the original back. • Add your own queries; they are saved in the app. • Everything except running queries works offline. No account needed. Queries are curated from professional sources and checked before release: the code works and is easy to follow. FREE VERSION • 12 runs and 12 edits a day • Full keyword and function reference; tap a word in a query for up to 12 articles a day • Up to 5 queries of your own The full version unlocks every query, removes the limits on edits and on your own queries, and raises the daily run limit to 80. One-time purchase, no subscription. Built by a developer for developers. The CodePro project has been in active development since 2015. WHAT'S NEW • Improved support for foldable phones and large screens.

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