SQL Recipes Pro

SQL trainer with a database

1,99 €

201 SQL queries with explanations, all sections unlocked. More than half of them run right in the app and show the result table. 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; the practice database allows 80 runs a day. • 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: queries, search, favorites. • Light and dark themes, font and size, line numbers, soft wrapping. Every query example is drawn from trusted sources and thoroughly tested. Built by a developer for developers. In active development since 2015.

  • This app has not received enough ratings or reviews to display an overview.

• Supports iOS 17 and macOS 14.

The developer, Fedor Obraztsov, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy .

  • Data Not Collected

    The developer does not collect any data from this app.

    Privacy practices may vary based, for example, on the features you use or your age. Learn More

    The developer has not yet indicated which accessibility features this app supports. Learn More

    Size
    • 4.9 MB
    Category
    • Developer Tools
    Compatibility
    Requires iOS 17.0 or later.
    • iPhone
      Requires iOS 17.0 or later.
    • iPad
      Requires iPadOS 17.0 or later.
    • Mac
      Requires macOS 15.0 or later.
    Languages
    English and 14 more
    • English, Arabic, French, German, Hebrew, Indonesian, Italian, Japanese, Korean, Portuguese, Russian, Simplified Chinese, Spanish, Turkish, Vietnamese
    Age Rating
    4+
    Provider
    Fedor Obraztsov
    • Fedor Obraztsov has not identified itself as a trader for this app. If you are a consumer in the European Economic Area, consumer rights do not apply to agreements between you and the provider.
    Copyright
    • © Obraztsov Fedor Alexandrovich