Home Schedule
Canvas Syllabus Contact Options Last Updated on

Tools for Information Literacy ⑭ Relational databases

Practice with SQL queries

These are not to be graded, but will be a good exercise to introduce you to Structured Query Language

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.

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
  2. select all the names from tblPublisher where the city is like Berlin and include both the name and the country in the result
  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
back to top