SQL Recipes vs Learning SQL

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 SQL from beginner to advanced with a practical and structured approach. Aprendendo SQL is designed to help you truly understand databases through hands-on practice, real challenges, and step-by-step lessons. Whether you are starting from scratch or improving your skills, the app guides you with clear explanations and interactive content. What you will learn: Master the core SQL commands such as SELECT, INSERT, UPDATE, and DELETE Work with filters and data organization using WHERE, GROUP BY, HAVING, and ORDER BY Understand table relationships with INNER JOIN, LEFT JOIN, and RIGHT JOIN Explore advanced concepts including Views, Stored Procedures, Triggers, and Indexes Practice with real exercises that reinforce learning and build confidence App features: Interactive lessons with clear explanations Practical SQL challenges to test your knowledge Progressive learning from beginner to advanced Self-paced study, learn anytime Designed for students, developers, and professionals Build real SQL skills that you can apply in projects and jobs Start learning SQL today and take your database skills to the next level.