Slide 7.1: Introduction to databases
Slide 7.3: SQL syntax
Home

SQL (Structured Query Language)

What Is SQL? What Can SQL Do? SQL Is a Standard—BUT....
Although SQL is an ANSI standard, there are many different versions of the SQL language. To be compliant with the ANSI standard, they all support at least the major commands in a similar manner, but most of the SQL databases also have their own proprietary extensions.

The SQL View of Microsoft Access Database

To enter SQL commands at the Access, pick the following options:
  1. Click on the CREATE menu.
  2. Click on Query Design.
  3. Close the Show Table popup window.
  4. Click on SQL View.


Demonstration
The following is an SQL test area from W3Schools, which uses the well-known Northwind sample database and the tables are for read only.
For security reasons, the following demonstration may only work in Chrome.

SQL Statement:

Edit the SQL statement and click     to see the result, or    

Result:

Click “Run SQL” to execute the SQL statement above.
W3Schools has created an SQL database in your browser.
The menu to the right displays the database, and will reflect any changes.
Feel free to experiment with any SQL statement.
You can restore the database at any time.
The Database includes:
The Database includes:

TablenamesRecords
Customers91
Categories8
Employees10
OrderDetails518
Orders196
Products77
Shippers3
Suppliers29