SQL programming

By Nacho Cabanes Latest change: 14-Ago-2007 /   Versión en Español 
Latest changes...
  • 14-Ago-2007: First english version


What is SQL?

SQL (Structured Query Language) is a standard language for accessing databases.

It is very useful because most database management systems, no matter how they are built internally and how they store their data, allow using SQL to query about the information they contain. 

(Back to top)

Tutorials on SQL

  • (None available yet)

(Back to top)

SQL databases

  • MySQL is a powerful, free, database management system, used in many web servers, and which can be downloaded at dev.mysql.com/downloads (near 40 MB).
  • PostgreSQL is a relational and object-oriented database management system (ORDBMS), very scalable, which uses SQL92 and SQL99. Near 25 MB in size; can be downloaded in www.postgresql.org.
  • Berkeley DB is a database engine, with a good performance, very scalable, which can be included in any application. You can get it at www.oracle.com/database/berkeley-db (near 15 MB).
  • Oracle is a well-known database management system, which has commercial versions but also a "Lite" version: www.oracle.com/database/lite_edition.html
  • Firebird is a relational database management system which offers many of the features in ANSI SQL-92. It started from the free Interbase version which was released by Borland in 2000. Its site is www.firebirdsql.org, and its size is near 4 Mb.
  • SQLCommand focuses on SQL learning. It allows the creation of databases, the execution of SQL commands, and surfind the database as if it were a web site. Near 8 Mb, available at  sqlcommand.sourceforge.net.
  • WinSQL Lite can be downloaded at www.synametrics.com/ SynametricsWebApp/Download.jsp (free, but the registration is required to get the serial number).

(Back to top)

SQL sources

  • (None available yet)

(Back to top)

Other links on SQL

  • (No hay ninguno incluido por ahora)

(Back to top)

Changes in this page

14/August/2007 First english version of this page.

(Back to top)