SQL Recipes vs Learn MySQL

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.

Learn MySQL from the ground up with a focused, practical course for beginners, students, developers, and anyone preparing for database or SQL interviews.Build a solid foundation in relational databases, then progress to writing and understanding real MySQL queries. Explore SELECT statements, filtering, sorting, CRUD, joins, aggregation, transactions, indexes, data definition, administration, data modeling, normalization, ER diagrams, and database security. WHAT YOU GET : - 150+ guided lessons across MySQL, SQL foundations, DBMS, and data modeling - A quiz with every lesson to reinforce concepts and check your understanding - MySQL cheat sheets for basics, queries, joins and aggregates, transactions, indexes and performance, data definition, and administration - Bite-sized tips for quick review - A MySQL code playground with support for Bash, Python, JavaScript, and PHP - Search, bookmarks, notes, progress tracking, streaks, achievements, and daily learning tips - Premium learning paths for Python with SQLAlchemy and Node.js ORMs with Sequelize and TypeORM - Optional AI learning tools on supported devices for explanations, summaries, and lesson translation LEARN TOPICS LIKE : - MySQL basics and syntax - SQL queries, CRUD, joins, grouping, and aggregates - ACID transactions, locking, isolation, and safe rollbacks - Indexes, query performance, and practical database design - DBMS architecture, normalization, ER modeling, and security - Connecting applications to MySQL with Python and Node.js ORMs STUDY YOUR WAY : Read a lesson, test yourself, save notes, revisit key ideas with cheat sheets, and practice code as you learn. Build a steady study habit with progress tracking and streaks. Whether you are learning SQL for the first time or refreshing MySQL for your next project, Learn MySQL gives you a clear path from database fundamentals to practical backend skills. Learn MySQL and start building stronger SQL skills today.