SILS iSchool

05 November 2020

preps | erm | entities | relationships | sql



Value Added | daily

Class Schedule

Basics | sessions 01-03
  1. 13 Aug intro and clients | lecture | labs
  2. 20 Aug servers and command line | lecture | labs
  3. 27 Aug networks and protocols | lecture | labs
Web Development | sessions 04-07

  1. 03 Sep structural layer | lecture | labs
  2. 10 Sep presentational layer | lecture | labs
  3. 17 Sep using a structure | lecture | labs
  4. 24 Sep behavioral layer | lecture | labs
Dealing with Markup | sessions 08-09
  1. 01 Oct control objects and display | lecture | labs
  2. 08 Oct tools that read markup | lecture | labs
Working with Data | sessions 10-13
  1. 15 Oct formulas, functions, vectors | lecture | labs
  2. 22 Oct data display | lecture | labs
  3. 29 Oct manipulate data sets | lecture | labs
  4. 05 Nov relational data bases | lecture | labs
Presentation | session 14
  1. 12 Nov designing and delivering a presentation | lecture | labs


Creative Commons License
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

05 November lecture | preps | erm | entities | relationships | sql