Database Structure

If you have ever been to a sandwich shop, you have seen a long counter with containers of various lengths and sizes. Each of these containers has a specific purpose— some hold meat, others hold cheese, and others hold vegetables; there are even containers for the...

ANSI Standard

Because there are several different database vendors, there are a set of standards that must exist across the database platforms. ISO (the International Organization for Standardization) is a worldwide federation of national standards bodies (ISO member bodies) and...

Syntax

Syntax is the technical requirement the query must have to return the results you want. If the query is not properly formed, a result cannot be given. Think of proper sentence structure—should a question not end with a question mark? Syntax is similar to grammar...

What is SQL?

Running Example All of the examples on this site, use the following database structure.  Yes, we will look at some complex situations, but in the beginning, we will look at these three...