SQL Primer 3.0

1970 E.F. Codd has started a revolution with his paper ‘A relational model of data for large shared data banks, Communications of the ACM, Volume 13, Issue 6 (June 1970)’ that finally led to the today’s omnipresent database query language SQL.

This little app shows some primitive and derived operations with the following information:

  • SQL92 and SQL86/89 sample queries
  • the results of the queries and
  • appropriate descriptions.

Furthermore, the SQL test script that has been used for the calculation of the samples can be displayed.

The app is interesting for the first contact with the database subject and for all who are using SQL86/89 queries for over two decades now and finally want to change to SQL92 also 😉

Free forever, no ads and no subscriptions

Changelog

  • Version 3.0

    • Supports new screen sizes
    • Updated design (UI, Graphics, etc.)
    • Dark Mode support
    • Support for Spotlight search
    • Supports multiple windows (iPadOS)

  • Version 2.1

    • SQL keyword highlighting
    • Added support for Dynamic Type
    • Added support for landscape mode

  • Version 2.0

    • Reimplementation in Swift for iOS 8.0+

  • Version 1.0.1

    • Further simplification of the descriptions.
    • The SQL test script has been added to this website.

  • Version 1.0

    • Initial release.