SQL Recipes Pro 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; the practice database allows 80 runs a day. • 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: queries, search, favorites. • Light and dark themes, font and size, line numbers, soft wrapping. Every query example is drawn from trusted sources and thoroughly tested. 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