SQL
Subject: Computing
Age range: 14 - 18
Resource type: Unit of work
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.
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.
Get this resource as part of a bundle and save up to 37%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Something went wrong, please try again later.
The databases that are supplied do not match with the class activities.
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£7.00