SQL Recipes vs SQL Guide

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.

SQLGuide — Learn SQL, One Chapter at a Time SQLGuide is a modern, lightweight SQL learning app built around short chapters, interactive quizzes, and a practical reference library. It is designed for beginners who want to learn core SQL concepts clearly and build confidence with real query patterns. Learn by doing SQLGuide combines guided reading with quick practice so you can move from understanding → recall → application: - Read a chapter with focused explanations and examples - Practice with multiple quiz formats - Keep a reference library for fast lookups - Bookmark what matters and come back later Guide (SQL Basics) Progress through a structured curriculum that starts from fundamentals and builds up step by step: - Queries: SELECT, DISTINCT, LIMIT - Filtering: WHERE, AND/OR, IN, BETWEEN, LIKE - Sorting and grouping: ORDER BY, GROUP BY, HAVING - Aggregation: COUNT, SUM, AVG, MIN, MAX - Joins: INNER/LEFT/RIGHT, practical join patterns - Data shaping: CASE, COALESCE, NULL handling - Subqueries, CTEs, UNION - Basic DDL/DML concepts: CREATE TABLE, INSERT, UPDATE, DELETE (concepts and patterns) Quiz (with explanations) Practice with short, focused prompts that reinforce both syntax and reasoning: - Clear explanations after each question to help you learn from mistakes - SQL snippets and realistic scenarios that mirror everyday query work - Smooth “continue” flow to keep you moving without friction - Progress tracking that shows what you have mastered and what is next Reference (quick SQL lookup) A curated reference list for frequently used SQL topics, with concise notes and examples to reduce context switching while you learn. Bookmarks and progress - Bookmark chapters and reference topics - Track course progress and quiz completion - Earn badges as you complete milestones Who this is for - Students learning SQL fundamentals - Developers refreshing core SQL skills - Analysts practicing queries and concepts - Anyone preparing for SQL interviews or assessments Privacy and access No account required. No login. No external sign-in at all. Everything is free. Download and get all content immediately.