SILS iSchool

week of 20 April 2021

VLOOKUP | SQL creation



Value Added | daily

Class Schedule

Basics | sessions 01-03
  1. 19 Jan intro and clients | lecture | labs
  2. 26 Jan servers and command line | lecture | labs
  3. 02 Feb networks and protocols | lecture | labs
Web Development | sessions 04-08

  1. 09 Feb structural layer | lecture | labs
  2. 16 Feb presentational layer | lecture | labs
  3. 23 Feb using a structure | lecture | labs
  4. 02 Mar behavioral layer | lecture | labs
  5. 09 Mar design thoughts | lecture | labs
Dealing with Markup | sessions 09-10
  1. 16 Mar control objects and display | lecture | labs
  2. 23 Mar tools that read markup | lecture | labs
Working with data | sessions 11-14
  1. 30 Mar formulas, functions, vectors | lecture | labs
  2. 06 Apr data display | lecture | labs
  3. 13 Apr manipulate data sets | lecture | labs
  4. 20 Apr relational data bases | lecture | labs
Presentations | sessions 15-16
  1. 27 Apr designing a presentation | lecture | labs
  2. 04 May 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 (SQL) is the standard means of manipulating and querying data in relational databases.
You may have practiced with W3Schools SQL tutorial, but now let's use Mr. Jones' Practice SQL tool to create a few queries.
You don't have to do this for a grade,
but it would not hurt to try it out and get comfortable with SQL syntax

Create three SQL queries

  1. select all the titles from tblBook where the language is German and include both the titles and the language in the result
    if your query is successful, paste a copy of the query in cell N1 on your 05-Summary worksheet
  2. select all the names from tblPublisher where the city is like Berlin and include both the name and the country in the result
    if your query is successful, paste a copy of the query in cell N2 on your 05-Summary worksheet
  3. select all the titles from tblBook where the topic includes the word Virginia and include both the titles and the topic in the result, sorted by the title
    if your query is successful, paste a copy of the query in cell N3 on your 05-Summary worksheet

back to top

week of 20 April labs | VLOOKUP | SQL creation