Database Design and Development Using SQL

Comprehensive vocabulary flashcards covering SQL concepts, IDEs, data types, DDL/DML statements, clauses, aggregate functions, and pattern matching operators.

SQL (Structured Query Language)

A database computer language designed for storing, manipulating, and retrieving data stored in a relational database, serving as the standard language for relational database systems.

RDBMS (Relational Database Management System)

Database systems—such as MySQL, MS Access, Oracle, Sybase, Informix, Postgres, and SQL Server—that utilize SQL as their standard database management language.

MySQL Workbench

The official IDE from MySQL that offers SQL development, data modeling, server administration, and other database features.

SQL Server Management Studio (SSMS)

The official Microsoft tool used for managing SQL Server databases and executing SQL queries.

MongoDB Compass

The official GUI and IDE for the MongoDB NoSQL database used for database exploration and query execution.

SQL Data Type

An attribute specifying the type of data of any object, column, variable, or expression in SQL (categorized into numeric, date and time, character and string, boolean, and currency).

CREATE TABLE Statement

An SQL statement used to define and create a new table in a database by establishing column names, data types, data sizes, and constraints.

INSERT INTO Statement

An SQL statement used to insert new records into a table, written either by specifying target columns and values or by supplying values for all columns in table order.

SELECT Statement

An SQL statement used to fetch data from a database table and return the requested records in the form of a table.

Result-set

The tabular format of data returned by an SQL SELECT clause after fetching records from a database table.

WHERE Clause

An SQL clause used to filter records and extract only those entries that fulfill a specified condition.

(INNER) JOIN

A JOIN clause that returns records having matching values in both joined tables based on a related column.

LEFT (OUTER) JOIN

A JOIN clause that returns all records from the left table along with the matched records from the right table.

RIGHT (OUTER) JOIN

A JOIN clause that returns all records from the right table along with the matched records from the left table.

FULL (OUTER) JOIN

A JOIN clause that returns all records when there is a match in either the left table or the right table.

ORDER BY Keyword

An SQL keyword used to sort the retrieved result-set in ascending or descending order.

GROUP BY Statement

An SQL statement that groups rows sharing identical values into summary rows, typically utilized alongside aggregate functions.

COUNT() Function

An SQL aggregate function that returns the total number of rows that match a specified criterion.

AVG() Function

An SQL aggregate function that computes and returns the average value of a numeric column.

SUM() Function

An SQL aggregate function that returns the total sum of all values in a numeric column.

MIN() Function

An SQL aggregate function that evaluates a specified column and returns the smallest value.

MAX() Function

An SQL aggregate function that evaluates a specified column and returns the largest value.

ALTER TABLE Statement

An SQL statement used to add, delete, or modify columns, as well as apply or drop constraints on an existing table.

UPDATE Statement

An SQL statement used to modify existing column values in table records based on a specified condition.

DELETE Command

An SQL command used to remove rows from a database table based on conditions, or delete all records while retaining the table structure.

BETWEEN Operator

An SQL operator used in a WHERE clause to select values within an inclusive range containing the specified begin and end values.

LIKE Operator

An SQL operator used in a WHERE clause to search for a specified pattern in a column using wildcards.

Percent Sign Wildcard (%)

A wildcard character used with the SQL LIKE operator that represents zero, one, or multiple characters (represented by an asterisk $*$ in MS Access).

Underscore Wildcard (_)

A wildcard character used with the SQL LIKE operator that represents a single character (represented by a question mark $?$ in MS Access).