SQL: Structured Query Language

These flashcards cover key vocabulary terms and definitions related to SQL, as discussed in the lecture on database management.

SQL

Structured Query Language, which is the language used to create, manipulate, and maintain a relational database.

DDL

Data Definition Language, commands that define a database, including creating, altering, and dropping tables.

DCL

Data Control Language, commands that control a database, including administering privileges and committing data.

DML

Data Manipulation Language, commands that maintain and query a database.

JOIN

An operation that combines data from different tables based on a related column.

DISTINCT

A keyword used in SQL to eliminate duplicate rows from the result set.

Aggregation

Operations that summarize or group data, such as COUNT, SUM, AVG, MAX, MIN, etc.

GROUP BY

A SQL clause that groups rows that have the same values in specified columns into aggregate data.

HAVING

A clause used to filter groups based on specific conditions, typically used with GROUP BY.

Subquery

A query nested within another query that provides data to the outer query.