Structured Query Language (SQL) is the most widely used database query language in the world.
In this investigation we look at:
• the basic syntax of SQL
• selecting columns and rows from a table
• special operators: IN, BETWEEN, LIKE, etc.
• updating an SQL database
• subqueries and diagramming subqueries
• processing of data in queries: arithmetic operators, functions, sorting, grouping
• joining tables, including same-table joins
• relational algebra terminology.
This unit includes six classroom tested activities involving over 100 query questions (with answers) to reinforce the concepts learnt. The three databases used are avaialble as a free download on the title page.