SQL Flashcards

OCR GCSE J277 Computer Science specification

SQL

Structured Query Language used to manage and query data in databases.

1 / 10
GenieCreated by Genie
10 Cards

Ready to master these flashcards?

Sign in to study with spaced repetition and track your progress.

Sign In to Track Progress

Terms in this set (10)

1

SQL

Structured Query Language used to manage and query data in databases.

2

SELECT

SQL command used to retrieve specific data from a database.

3

FROM

SQL keyword used to specify the table from which data is retrieved.

4

WHERE

SQL clause used to filter records based on specific conditions.

5

* in SQL

Wildcard used to select all columns in a table.

6

AND in SQL

Logical operator used in the WHERE clause to combine multiple conditions.

7

OR in SQL

Logical operator used in the WHERE clause to specify alternative conditions.

8

NOT in SQL

Logical operator used in the WHERE clause to exclude records that meet a condition.

9

Purpose of SQL

To query, manipulate, and manage data stored in relational databases.

10

SQL example: SELECT * FROM table_name

Retrieves all columns from the specified table.

Genie

Want to Learn More?

Get personalised lessons, quizzes, and instant feedback from your AI tutor.

Start Learning