GCSE > Computer Science > WJEC > GCSE Computer Science > ALGORITHMS AND PROGRAMMING: Programming techniques > Structured Query Language (SQL)
Previous Module
Next Module

COMPUTER SYSTEMS: Encoding and compression

COMPUTER SYSTEMS: Network topologies

COMPUTER SYSTEMS: Wired and wireless networks, protocols, and layers

COMPUTER SYSTEMS: Threats to computer systems and networks

COMPUTER SYSTEMS: Operating systems and utility software

COMPUTER SYSTEMS: Impact of technology on society

ALGORITHMS AND PROGRAMMING: Types of data

ALGORITHMS AND PROGRAMMING: Producing robust programs

ALGORITHMS AND PROGRAMMING: Designing, creating, and refining algorithms

ALGORITHMS AND PROGRAMMING: Programming languages

ALGORITHMS AND PROGRAMMING: Artificial Intelligence (AI)

  • SQL is used to access and manipulate data in a relational database (i.e. tables) made up of rows (records) and columns (fields).
SQL keyword Description Python example
SELECT Choose which fields (columns) to display

SELECT name, age

FROM students

WHERE age > = 16
FROM Choose the table to search
WHERE Set conditions to filter results
  • For example, if we wanted to: “Select all names from the ‘books’ table where genre is ‘Sci-Fi’ in alphabetical order,” then our SQL entry would be as shown on the right

SELECT name

FROM books

WHERE genre = “Sci-Fi”

ORDER BY name DESC

Unlock Structured Query Language (SQL)

Subscribe to SnapRevise+ to get immediate access to the rest of this resource.

Premium accounts get immediate access to this resource.

Previous Module
Next Module