WAP 2.0 Development

An Introduction to the Structured Query Language

SQL is the language used with most relational databases today. Although the SQL syntax for different databases might differ slightly, the topics covered in this chapter are relevant to most relational databases.

Familiarizing yourself with SQL is important and useful, and it is especially important if you want to continue in the realm of database development.

Viewing Data with the SELECT Statement

One of the main functions of a database is to supply users with data. SQL’s SELECT keyword provides this capability, enabling users to view database data.

The following is an example of the syntax of a SELECT query:

SELECT the records you want 
FROM a table 
WHERE the data meets a certain criteria; ...