INLS161-001 Fall 2021

Tools for Information Literacy




Structured Query Language


Structured Query Language is the standard means of manipulating and querying data in relational databases.

What is SQL?

Just as ...

what is SQL? what can SQL do? SQL practice

back to top

What Can SQL do?

SQL is a Standard - BUT....

Although SQL is an ANSI/ISO standard, there are different versions of the SQL language.

However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.

what is SQL? what can SQL do? SQL practice

back to top

Before SQL comes into play ...

One will have designed multiple entity classes and populated them with records to creat entity sets

Then, SQL may be used to retrieve needed data from the entity sets

We have used SQL terminology in describing Excel filters, but now we will try to work with SQL itself

Let's use the W3Schools SQL tutorial

what is SQL? what can SQL do? SQL practice

back to top

Copyright © R.E. Bergquist 2014- | Last Updated on | Powered by w3.css