COMP1850 Lecture 3.1 Relational Databases and SQL

Flashcards covering key vocabulary and concepts from the lecture on Relational Databases and SQL.

SQL (Structured Query Language)

A language used to make, maintain, and extract data from relational databases.

DDL (Data Definition Language)

Part of SQL used to create tables.

DML (Data Manipulation Language)

Part of SQL used to query the tables.

DSL (Domain Specific Language)

A specialized language for relational database creation and queries.

DDL Functionality

Operations generally termed CRUD which include Create, Read, Update, and Delete.

Database Diagram

A visual representation of database tables and relationships.

WHERE

SQL keyword to specify conditions for selecting rows.

LIKE

SQL keyword used for pattern matching in WHERE clauses.

ORDER BY

SQL keyword used to sort query results by a specific column.

LIMIT

SQL keyword used to limit the number of rows returned by a query.

GROUP BY

SQL keyword used to combine rows with the same value in a specified column.

Aggregators

Functions like MIN(), MAX(), AVG(), SUM(), and COUNT() used to perform calculations on data.

AS

SQL keyword used to rename a column in the query output.

HAVING

SQL keyword used to filter grouped rows based on a condition.