SQL Data Types

SQL Data Types Overview In SQL, as in many other programming languages, every piece of data has a particular type. For example, 11 is an integer, and GǣWall StreetGǥ is a text string. The SQL standar...

SQL Perl/PL Overview

Procedural languages provide the fundamental method for programming within an SQL database. In other articles in this series, we have covered the SQL-based procedural languages, but those are general...

SQL Functions

SQL Programming Overview In the article SQL Programming, we discussed creating the “Hello, World!” function in PostgreSQL, MySQL, and Oracle. In this article, we take “Hello, World!...

SQL Programming

SQL Programming Overview Anybody who has done something for a long time has probably wanted to change how things work at some point or another. A worker at a mill might have found a more efficient wa...

SQL Keys

SQL Keys Overview In SQL, keys are used to maintain referential integrity among relations. Put simply, this means keys allow tables to reference each other, and each reference will be GǣcorrectGǥ eve...

SQL Table Commands

SQL Table Commands Overview As mentioned previously in this series of SQL articles, databases are primarily composed of tables. The Gǣcolumns and rowsGǥ structure of the table allows data to be effic...

SQL Overview

SQL Overview The SELECT command in SQL provides a robust means for retrieving data from a database. More specifically, SELECT returns a result set of zero or more rows from the database, and this res...

SQL Standardization

SQL standardization Like any technology that strives to be interoperable among different implementations, SQL has been standardized. The first SQL standard was adopted and published by the American N...

What is SQL

The Structured Query Language (SQL) is the computer language in which a user or an application communicates with an SQL-capable database system. SQL database systems include PostgreSQL, MySQL, Oracle...