preps | erm | entities | relationships | sql
Class Schedule
This work
is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
home & schedule | syllabus | contact | grades
Structured Query Language is the standard means of manipulating and querying data in relational databases.
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.
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
20 April lecture | preps | erm | entities | relationships | sql