SQL

Most of the content in this section relates to PostgreSQL, with occasional references and comparisons to MySQL. We find Postgres to be an all-round better database with the main advantages being: adherence to standards; advanced command-line interface; security; consistency; and having many functions not available in competing systems (views, constraints, arrays, date/time and geometric functions to name but a few).

• PostgreSQL Commands
• PostgreSQL SELECT
• PostgreSQL String Functions
• Creating a Lookup Table
• pg_dump Command Builder
• Date/Time Functions
• Postgres vs. MySQL