9.1.2 Structured Query Language-Database

SQL-IGCSE CS

1. Databases SQL 9.1

2. Candidates should be able to: Learning Objective Read, understand and complete structured query language (SQL) scripts to query data stored in a single database table

3. Define a single-table database from given data storage requirements STUDENT STUDENT-TEACHER

4. Retrieval of data from a database - the SELECT Statement The SELECT statement is the simplest of SQL statements and is used to find information within a database. A SELECT statement comes in four main parts:

5. Cross Table Query When you want to return data from more than one table there are two ways it can be done. The original method is to use a WHERE statement but the more modern method is to use a JOIN statement. For the purposes of the examinations it will not matter which method pupils use in their answers.

6. Original Method

7. The Modern Method