📚 GCSE WJEC Computer Science: Mastering SQL | GCSE WJEC 计算机：SQL 考点精讲
Understanding SQL is essential for any GCSE WJEC Computer Science student because it forms the backbone of working with databases. This article breaks down every key concept you need to know, from retrieving data with SELECT to manipulating records with INSERT, UPDATE and DELETE. You will also learn how to filter results using WHERE, sort them with ORDER BY, and link tables using simple joins, all with clear examples and exam-focused explanations.
对于每一位 GCSE WJEC 计算机科学的学生而言，掌握 SQL 是操作数据库的核心基础。本文会逐一解析每个关键知识点，从使用 SELECT 检索数据，到用 INSERT、UPDATE 和 DELETE 操控记录。你还会学到如何用 WHERE 筛选结果，用 ORDER BY 排序，以及通过简单的连接关联多张表，所有内容都配有清晰的示例和贴近考试的讲解。
1. What Is SQL and Why Do We Need It? | 什么是 SQL？为什么需要它？
SQL stands for Structured Query Language. It is the standard language used to communicate with relational databases. In the WJEC Computer Science specification, you are expected to write SQL statements to define, manipulate and query data. Databases store information in tables made up of rows and columns, and SQL gives you the tools to ask precise questions and get back exactly the data you need.
SQL 是结构化查询语言的缩写，是与关系型数据库交互的标准语言。在 WJEC 计算机科学大纲中，你需要会编写 SQL 语句来定义、操作和查询数据。数据库以表的形式存储信息，表由行和列构成，而 SQL 则为你提供了工具，让你可以提出精确的问题，并精确地取回所需的数据。
Without SQL, retrieving specific information from a large database would be slow and error-prone. For example, finding all customers who live in Cardiff and have placed an order in the last month would require manual searching. SQL automates this by letting you write a short statement that does the work in milliseconds. As a GCSE student, you need to understand how to construct these statements correctly and efficiently.
如果没有 SQL，从大型数据库中检索特定信息会既缓慢又容易出错。例如，要找出所有住在卡迪夫且上个月下过订单的客户，就需要手动搜索。而 SQL 让这一切自动化，你只需写一条简短的语句，就能在毫秒内完成这项工作。作为 GCSE 考生，你需要懂得如何正确且高效地构建这些语句。
2. The SELECT Statement and the Basic Structure | SELECT 语句与基本结构
The most fundamental SQL command is SELECT. It allows you to retrieve data from one or more columns in a table. The simplest form is:
SELECT column1, column2 FROM table_name;
This will return all rows for the specified columns. You can also use an asterisk (*) to select all columns at once:
SELECT * FROM Students;
最基本的 SQL 命令就是 SELECT。它可以从表中检索一个或多个列的数据。最简单的形式是：
SELECT 列名1, 列名2 FROM 表名;
这样会返回所有行在指定列上的值。你也可以用星号（*）一次性选中所有列：
SELECT * FROM Students;
In WJEC exams, you will often be asked to write a SELECT statement that retrieves specific information. For instance, “Write an SQL statement to display the first name and date of birth of all students.” The answer would be:
SELECT FirstName, DateOfBirth FROM Students;
Always remember to end the statement with a semicolon, though some mark schemes are lenient about it. Keywords like SELECT and FROM are conventionally written in uppercase for readability, but SQL is not case-sensitive.
在 WJEC 考试中，你常会被要求编写 SELECT 语句来提取特定信息。比如，“请编写一条 SQL 语句，显示所有学生的名字和出生日期。” 答案将是：
SELECT FirstName, DateOfBirth FROM Students;
请始终记得在语句末尾加上分号，尽管部分评分标准对此要求不那么严格。习惯上，SELECT 和 FROM 等关键字会用大写以提高可读性，但 SQL 本身对大小写不敏感。
3. Filtering with WHERE | 使用 WHERE 筛选数据
The WHERE clause is used to filter records. It comes after the FROM clause and specifies a condition that must be true for a row to be included. For example:
SELECT Name, City FROM Customers WHERE City = ‘Cardiff’;
This returns only customers based in Cardiff. The condition can use comparison operators such as =, <, >, <=, >=, and <> (not equal).
WHERE 子句用来筛选记录。它紧跟在 FROM 子句之后，并指定一个条件，只有满足该条件的行才会被包含进来。例如：
SELECT Name, City FROM Customers WHERE City = ‘Cardiff’;
这条语句只返回城市为 Cardiff 的客户。条件中可以使用比较运算符，如 =、<、>、<=、>= 和 <>（不等于）。
You can combine multiple conditions using AND and OR. For instance:
SELECT * FROM Products WHERE Price < 10 AND StockLevel > 0;
This would show products that are both cheap and in stock. When mixing AND and OR, use parentheses to make the logic clear, exactly as you would in Boolean expressions. Exam questions often test your ability to translate a written problem into a correct WHERE clause.
你可以用 AND 和 OR 组合多个条件。例如：
SELECT * FROM Products WHERE Price < 10 AND StockLevel > 0;
这样会显示既便宜又有库存的产品。当混合使用 AND 和 OR 时，务必用括号明确逻辑顺序，就像处理布尔表达式一样。考试题目常会考查你将一段文字描述转化为正确的 WHERE 子句的能力。
4. Using LIKE for Pattern Matching | 使用 LIKE 进行模式匹配
Sometimes you need to search for a pattern rather than an exact match. SQL provides the LIKE operator for this purpose. The percent sign (%) represents zero or more characters, and the underscore (_) represents a single character. For example:
SELECT Title FROM Films WHERE Title LIKE ‘Star%’;
This finds all film titles that start with “Star”, such as Star Wars or Stardust.
有时候你需要搜索特定模式而非精确匹配，SQL 为此提供了 LIKE 运算符。百分号（%）代表零或多个字符，下划线（_）代表单个字符。例如：
SELECT Title FROM Films WHERE Title LIKE ‘Star%’;
这条语句会找出所有以 “Star” 开头的电影名，比如 Star Wars 或 Stardust。
In a WJEC context, you might need to find all students whose surname begins with “Mc” or contains “son” anywhere. The corresponding statements would use LIKE ‘Mc%’ and LIKE ‘%son%’ respectively. Note that pattern matching with LIKE is case-insensitive in many database systems, but you should write the pattern as shown. Always put the pattern inside single quotes.
在 WJEC 的语境中，你可能需要找出所有姓氏以 “Mc” 开头或包含 “son” 的学生。对应的语句会分别使用 LIKE ‘Mc%’ 和 LIKE ‘%son%’。要注意，很多数据库系统中 LIKE 模式匹配不区分大小写，但你书写时应保持模式如同所示。总是将模式放在单引号内。
5. Sorting Results with ORDER BY | 使用 ORDER BY 排序结果
The ORDER BY clause controls the order in which rows are returned. It is usually placed at the end of a SELECT statement. By default, sorting is done in ascending order (A to Z, smallest to largest). For example:
SELECT Name, Score FROM Results ORDER BY Score;
This lists students from the lowest score to the highest.
ORDER BY 子句控制返回行的顺序。它通常位于 SELECT 语句的末尾。默认情况下，排序是按升序进行（A 到 Z，从小到大的顺序）。例如：
SELECT Name, Score FROM Results ORDER BY Score;
这条语句会将学生按分数从低到高列出。
To sort in descending order, add the keyword DESC after the column name:
SELECT Name, Score FROM Results ORDER BY Score DESC;
You can also sort by multiple columns. For instance, ORDER BY Surname, FirstName would sort primarily by surname, and then by first name for those with the same surname. This is a common exam requirement when a question says “list in alphabetical order of surname and then first name”.
要按降序排序，可以在列名后添加关键字 DESC：
SELECT Name, Score FROM Results ORDER BY Score DESC;
你也可以按多列排序。例如，ORDER BY Surname, FirstName 会先按姓氏排序，在姓氏相同的情况下再按名字排序。当考题要求“按姓氏字母顺序、再按名字字母顺序列出”时，这就是一个常见的考点。
6. Inserting New Data with INSERT INTO | 使用 INSERT INTO 插入新数据
INSERT INTO adds new rows to a table. The basic syntax is:
INSERT INTO TableName (column1, column2) VALUES (value1, value2);
You must list the columns you are providing values for, and then supply the corresponding values in the same order. String and date values must be enclosed in single quotes, while numbers are written without quotes.
INSERT INTO 用于向表中添加新行。基本语法是：
INSERT INTO 表名 (列1, 列2) VALUES (值1, 值2);
你必须列出你要提供值的列，然后按相同顺序给出对应的值。字符串和日期值必须用单引号括起来，数字则不加引号。
If you are inserting values for every column in the exact order they appear in the table, you can omit the column list:
INSERT INTO Students VALUES (101, ‘Ella’, ‘Jones’, ’12/05/2007′);
However, it is safer to always specify the columns, as this avoids errors if the table structure changes. In WJEC exams, you might be given a table schema and asked to write an INSERT statement to add a specific record.
如果你要按表中列的出现顺序为每一列插入值，可以省略列名列表：
INSERT INTO Students VALUES (101, ‘Ella’, ‘Jones’, ’12/05/2007′);
不过，始终指定列名会更加安全，这样即使表结构发生改变也不会出错。在 WJEC 考试中，你可能会看到一张表结构的描述，然后被要求写一条 INSERT 语句来添加某条特定记录。
7. Modifying Records with UPDATE | 使用 UPDATE 修改记录
UPDATE changes existing data in one or more rows. It must be used carefully because it affects all rows that satisfy the condition – and if you omit the WHERE clause, it updates every row. The syntax is:
UPDATE TableName SET column1 = value1, column2 = value2 WHERE condition;
For example:
UPDATE Products SET Price = Price * 1.1 WHERE Category = ‘Electronics’;
This increases the price of all electronic products by 10%.
UPDATE 用来修改一行或多行中已有的数据。使用时必须格外谨慎，因为它会影响所有满足条件的行——若省略 WHERE 子句，就会更新每一行。语法是：
UPDATE 表名 SET 列1 = 值1, 列2 = 值2 WHERE 条件;
例如：
UPDATE Products SET Price = Price * 1.1 WHERE Category = ‘Electronics’;
这条语句将所有电子产品类别的价格提高 10%。
In a school database scenario, you might be asked to change a student’s tutor group or update a teacher’s email address. The statement would look like:
UPDATE Students SET TutorGroup = ’10B’ WHERE StudentID = 2048;
Always double-check your WHERE clause to avoid accidentally changing the wrong records. Many exam mark schemes award marks specifically for getting the SET and WHERE parts correct.
在学校数据库的情境中，你可能会被要求更改学生的导师小组或更新教师的电子邮件地址。相应的语句就像：
UPDATE Students SET TutorGroup = ’10B’ WHERE StudentID = 2048;
始终要复查你的 WHERE 子句，以免不小心修改了不该修改的记录。许多考试的评分方案都会为正确写出 SET 和 WHERE 部分而专门给分。
8. Deleting Data with DELETE | 使用 DELETE 删除数据
DELETE removes one or more rows from a table. Like UPDATE, it relies heavily on the WHERE clause to target the correct records. The syntax is:
DELETE FROM TableName WHERE condition;
If you miss the WHERE clause, you will delete all rows, so extreme caution is necessary.
DELETE 从表中删除一行或多行。与 UPDATE 类似，它极度依赖 WHERE 子句来定位正确的记录。语法是：
DELETE FROM 表名 WHERE 条件;
如果你遗漏了 WHERE 子句，就会删除表中所有行，因此必须万分小心。
For example, to remove a specific student who has left the school, you would write:
DELETE FROM Students WHERE StudentID = 3056;
Always use a unique identifier (a primary key) in the WHERE clause whenever possible to ensure you delete exactly one record. In WJEC exam questions, DELETE is usually tested alongside the other data manipulation commands, so make sure you can distinguish between them and use the correct keyword.
例如，要删除一位已经离校的特定学生，你应当写：
DELETE FROM Students WHERE StudentID = 3056;
只要有可能，就尽量在 WHERE 子句中使用唯一标识符（主键），以确保只删除确切的一条记录。在 WJEC 的考题中，DELETE 通常与其他数据操控命令一同考查，所以务必能区分它们并写出正确的关键字。
9. Creating Tables with CREATE TABLE | 使用 CREATE TABLE 创建表
The CREATE TABLE statement defines a new table, specifying the column names and their data types. While WJEC does not require deep knowledge of every data type, you should be familiar with common ones: INTEGER (or INT) for whole numbers, VARCHAR(n) for variable-length text up to n characters, DATE for dates, and DECIMAL for numbers with a fixed number of decimal places. Example:
CREATE TABLE Books (BookID INTEGER PRIMARY KEY, Title VARCHAR(100), Author VARCHAR(50), Price DECIMAL(5,2));
CREATE TABLE 语句用来定义一张新表，指定列名及其数据类型。虽然 WJEC 不要求对每种数据类型都深入了解，但你应该熟悉常见的几种：INTEGER（或 INT）表示整数，VARCHAR(n) 表示最多 n 个字符的可变长度文本，DATE 表示日期，DECIMAL 表示具有固定小数位数的数字。例如：
CREATE TABLE Books (BookID INTEGER PRIMARY KEY, Title VARCHAR(100), Author VARCHAR(50), Price DECIMAL(5,2));
Notice the use of PRIMARY KEY to uniquely identify each row. You may also see NOT NULL to indicate that a column cannot be left empty. In an exam, you could be given a description of a table and asked to write the CREATE TABLE statement. Make sure you can translate a simple data dictionary into SQL, choosing appropriate data types and including a primary key where needed.
请注意使用 PRIMARY KEY 来唯一标识每一行。你还会见到 NOT NULL，用来表示某列不能留空。在考试中，你可能会拿到一张表的描述，并被要求写出相应的 CREATE TABLE 语句。务必能将一个简单的数据字典转写成 SQL，选择合适的类型，并在需要的地方加入主键。
10. Introduction to Joins: Linking Two Tables | 连接简介：关联两张表
Real databases rarely consist of a single table. Data is spread across multiple tables linked by foreign keys. To retrieve related information from two tables, you use a JOIN. The most common type is the INNER JOIN. It returns only rows where there is a match in both tables. The general form:
SELECT table1.column, table2.column FROM table1 INNER JOIN table2 ON table1.common_field = table2.common_field;
真实世界的数据库很少只包含单张表。数据往往分散在通过外键关联的多张表中。要从两张表中检索相关信息，需要用到 JOIN。最常见的类型是 INNER JOIN，它只返回两张表中均存在匹配的行。通用格式为：
SELECT 表1.列, 表2.列 FROM 表1 INNER JOIN 表2 ON 表1.公共字段 = 表2.公共字段;
For example, suppose you have an Orders table with a CustomerID column, and a Customers table with a CustomerID primary key. To list each order along with the customer’s name, you write:
SELECT Orders.OrderID, Customers.Name FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;
This is a key skill for WJEC because it demonstrates an understanding of relational database concepts. You might be asked to write a query that combines information from two or more tables, so practice using the ON keyword to specify the link.
例如，假设你有一张 Orders 表，内含 CustomerID 列，而 Customers 表以 CustomerID 作为主键。要列出每笔订单及其对应的客户姓名，可以写：
SELECT Orders.OrderID, Customers.Name FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;
这是 WJEC 中的一项关键技能，因为它体现了对关系型数据库概念的理解。你可能会被要求编写查询来合并两张或更多张表的信息，所以务必练习用 ON 关键字来指定关联关系。
11. Avoiding Common Mistakes in SQL Exams | 在 SQL 考试中避免常见错误
Even well-prepared students can lose marks by making small, careless errors. The most frequent mistakes include: forgetting the semicolon (though not always penalised), missing single quotes around text and date values, using double equals (==) instead of a single = for comparison, and confusing INSERT with UPDATE. Another common pitfall is writing a WHERE clause that accidentally updates or deletes more rows than intended.
即便是准备充分的学生，也会因粗心的小错误而丢分。最常见的错误包括：忘记分号（虽然不一定会被扣分）、文本和日期值遗漏了单引号、在比较时使用了双等号（==）而不是单个等号（=）、以及混淆 INSERT 和 UPDATE。另一个常见的陷阱是写出的 WHERE 子句不经意间更新或删除了比预期更多的行。
When working with joins, a typical mistake is not qualifying column names with the table name, leading to “ambiguous column” errors. For example, if both tables have a Name column, you must write Customers.Name rather than just Name. Also, in ORDER BY, students sometimes write the wrong direction keyword (ASC/DESC) or forget it entirely. To avoid these pitfalls, always read the question carefully and imagine the result set before finalising your answer.
在处理连接时，一个典型的错误是没有用表名来限定列名，从而导致“列名模糊”的错误。例如，若两张表都含有 Name 列，你就必须写成 Customers.Name 而不仅仅是 Name。此外，在 ORDER BY 中，学生有时会写错方向关键字（ASC/DESC）或者完全忘记写。要避开这些陷阱，务必仔细读题，并在敲定答案前先在脑海中想象一下结果集。
Time pressure can also cause students to mix up DELETE, DROP, and TRUNCATE. Remember, DELETE removes rows, DROP removes an entire table, and TRUNCATE quickly removes all rows but not the table itself—focus on DELETE for row removal at GCSE. Keep your statements neat, logically structured, and double-check them against the question’s requirements.
时间压力也会导致学生混淆 DELETE、DROP 和 TRUNCATE。请记住，DELETE 删除的是行，DROP 删除整张表，而 TRUNCATE 则快速移除所有行但保留表结构——GCSE 阶段重点掌握用 DELETE 来删除行。保持你的语句整洁、逻辑清晰，并针对题目要求再次检查。
12. SQL Best Practices for GCSE Success | GCSE 考试胜出的 SQL 最佳实践
To consistently score high marks, adopt a few simple habits. Always write keywords in uppercase (SELECT, FROM, WHERE) and user-defined names in mixed case or lower case for clarity. Indent the clauses to make your code readable, especially when using joins or multiple conditions. Practice writing SQL by hand, since many WJEC exams are still paper-based, and you won’t have autocomplete to help you.
要想稳定地拿到高分，请养成几个简单的习惯。始终将关键字用大写书写（SELECT, FROM, WHERE），而用户自定义的名称则用大小写混合或纯小写，以求清晰。对各子句进行缩进可提升代码可读性，尤其是在使用连接或多重条件时。要多用手写方式练习 SQL，因为许多 WJEC 考试仍是纸笔形式，你不会有自动补全来辅助。
Another best practice is to build your query in stages in your mind or on scrap paper. Start by identifying the target columns, then the main table, then the filters and ordering. If a join is needed, decide on the join condition. Finally, review whether you need any grouping or aggregate functions (though these appear less frequently at GCSE). This step-by-step method reduces errors and ensures you don’t miss any part of the question.
另一个最佳实践是在脑海或草稿纸上分阶段构筑你的查询。首先确定目标列，然后是主表，接着是筛选条件和排序。如果需要连接，就确定连接条件。最后，检视一下你是否需要分组或聚合函数（虽然这些在 GCSE 阶段出现频率较低）。这种按部就班的方法可以减少错误，并确保你不会遗漏题目中的任何一部分。
Lastly, learn to interpret the feedback from practice questions. If you missed a mark, was it because you forgot the quotes, used the wrong comparison operator, or didn’t join correctly? Fix that specific weakness. Over time, you’ll develop a solid, exam-ready command of SQL that covers all the WJEC requirements with confidence.
最后，学会解读练习题中的反馈。如果你丢了一分，是因为忘了引号、用错了比较运算符，还是连接方式不正确？有针对性地弥补那个弱项。假以时日，你就会建立起扎实的、足以应试的 SQL 功底，自信地覆盖 WJEC 大纳的所有要求。
Published by TutorHao | GCSE WJEC Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导