Please enable JavaScript to use CodeHS

Cyber Glossary

Flashcards

Course:

Module:

Lesson:

Search:

WHERE Clause General

A SQL condition that filters results from a `SELECT` query

Comparison Operators General

Symbols used in conditions (`=`, `!=`, `>`, `<`, `>=`, `<=`)

Condition General

A logical expression that restricts what data is returned

Filter General

To narrow down a set of results based on rules

AND General

A logical operator that requires multiple conditions to be true

BETWEEN General

A SQL operator used to filter results within a range (inclusive)

LIKE General

A SQL operator used for pattern matching in text data

IN General

A SQL operator that checks if a value matches any value in a given list

Compound Condition General

A condition that uses multiple filters together

ORDER BY General

A SQL clause that sorts the returned query results by one or more columns

ASC General

Ascending order; the default sort direction

DESC General

Descending order; used to reverse the default sorting

JOIN General

A SQL operation that combines rows from two or more tables based on a related column.

Cross Join General

A join where each row in one table is paired with every row in another.

Foreign Key General

A field in one table that refers to the primary key in another table.

Alias General

A temporary name assigned to a column or table using the `AS` keyword in SQL

AS General

A SQL keyword used to rename fields or tables in the query result

Database General

An organized collection of data stored electronically and accessed using a database management system (DBMS)

SQL General

Structured Query Language, used to retrieve and manipulate data in a database

PII (Personally Identifiable Information) General

Information that can be used to identify, contact, or locate a single person

Query General

A request for data or information from a database

Table General

A collection of related data entries organized in rows and columns

Row General

A single record in a table

Column General

A category of data stored in a table

INSERT INTO General

SQL command used to add new records to a table

SELECT General

SQL command used to retrieve data from a table