20 April 2021
preps | erm | entities | relationships | sql
Value Added | daily
Class Schedule
Basics | sessions 01-03
- 19 Jan intro and clients | lecture | labs
- 26 Jan servers and command line | lecture | labs
- 02 Feb networks and protocols | lecture | labs
Web Development | sessions 04-08
- 09 Feb structural layer | lecture | labs
- 16 Feb presentational layer | lecture | labs
- 23 Feb using a structure | lecture | labs
- 02 Mar behavioral layer | lecture | labs
- 09 Mar design thoughts | lecture | labs
Dealing with Markup | sessions 09-10
Working with data | sessions 11-14
- 30 Mar formulas, functions, vectors | lecture | labs
- 06 Apr data display | lecture | labs
- 13 Apr manipulate data sets | lecture | labs
- 20 Apr relational data bases | lecture | labs
Presentations | sessions 15-16
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.
What is SQL?
Just as ...
- HTML - Hypertext Markup Language: is a language that uses elements, attributes, and values (markup) to construct and link (hypertext) documents for easy access and display
- SQL - Structured Query Language is a language that uses a particular syntax in order to retrieve needed items from a relational database.
back to top
What Can SQL do?
- SQL can execute queries against a database
- SQL can retrieve data from a database
- SQL can insert records in a database
- SQL can update records in a database
- SQL can delete records from a database
- SQL can create new databases
- SQL can create new tables in a database
- SQL can create stored procedures in a database
- SQL can create views in a database
- SQL can set permissions on tables, procedures, and views
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.
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
back to top
20 April lecture | preps | erm | entities | relationships | sql