Python Recipes vs SQL Guide

An everyday Python reference, from strings and collections to threading and design patterns. Tricky parts of the examples are explained in comments. You know what you need, but the exact syntax escapes you: • How do I sort a dict by value? • How do I serialize an object to JSON and back? • How do I start a thread and wait for it to finish? Each has a working example here, ready to adapt to your code. • 22 sections, including classes, functions and lambdas, files, serialization, exceptions, regular expressions, databases and algorithms. • Language changes by version, Python 3.0 to 3.13: the walrus operator, match statements, dataclasses, free-threading and more, with before-and-after code. • Keyword and function reference: over 200 entries. Browse, search, or tap a word in the code to look it up. • SQL included: JOIN, GROUP BY, subqueries, data types; more than half of the queries run on a real practice database. • No IDE or local Python needed: over 90% of examples run in the app, with the output right below the code. • Search covers the code itself, not just titles: type a fragment you remember and find the example. • Edit examples or add your own; changes are saved in the app. • Everything except running code works offline. No account needed. Examples are curated from professional sources and checked before release: the code works and is easy to follow. FREE VERSION • 12 runs (examples and SQL combined) and 12 edits a day • Keyword and function reference with no limits • Up to 5 examples of your own The full version unlocks every example and query, removes the limits on edits and on your own examples, and raises the daily run limits to 30 for examples and 80 for SQL. One-time purchase, no subscription. Built by a developer for developers. The project behind it has been 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.