Python Recipes vs SQL Guide

An everyday Python reference, from strings and collections to threading and design patterns. Every example comes with an explanation, and most of them run. The construct is on the tip of your tongue, but the exact syntax slips away: • How do you sort a dictionary by value? • How do you serialize a class to JSON and read it back? • How do you start a thread and wait for the result? The app answers with a working example; all that is left is to fit it to your task. • 22 sections: basic types, arrays and collections, classes, files, serialization, functions and lambdas, exceptions, regular expressions, threading, databases, algorithms, design patterns. • Run in the app: the example actually runs and the output appears under the code. Needs an internet connection. • What changed in new versions: 8 sections from Python 3.0 to 3.13, with the old and the new code side by side. • Keyword and function reference: over 200 articles, open in full, with no daily limit. • SQL alongside: over 200 queries against a live practice database (JOIN, GROUP BY, subqueries, data types). • Edit examples and add your own; they stay in the app and are always at hand. • Search looks inside the code itself, not just the titles: remember a fragment and you will find the example. • Everything except running works offline. No account needed. WHAT THE FREE VERSION INCLUDES 12 runs and 12 edits a day; the counter resets every morning. The keyword reference is open without limits. Up to 5 examples of your own. The full version unlocks every example, lifts the daily limits and raises the run limit to 30 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.