SQL Flashcards
Structured Query Language
SQL, a programming language used to manipulate and query data in relational databases
Relational database management system
RDBMS, a class of programs that can be use4d to create, update, and administer a relational database
Relational database
a type of database in which the relationships between the data points matter, and that requires a programming language to pull desired data
Field
A column in a database table
CRUD functionality
Ability to Create, Read, Update, Delete
Record
A row in a database table
KPI
Key Performance Indicators
Schema
The structure of database or table, indicating how the data is organized and connected
Aliasing
Temporarily renaming a field with a name that exists only for the duration of the query and doesn’t change the underlying data
Scripts
(within SQL) a series of commands to be executed in a program
Comparison operators
Mathematical symbols that compare two values
logical operators
Operators that test whether a given condition is mett
Primay Key
A field that uniquely identifies the records in a table
Foreign key
A field that refers to the primary key in another table, therby linking two tables together
Parent table
The table that stores the primary key
Child table
a table that uses a foreign key to reference the parent table
one-to-one relationship
A relationship where a single record in one table is related to a single record in another table, and neither column has duplicate records
One-to-many relationship
A relationship where a single record in one table is related to multiple records in anotherr table
Common table expression
CTE, a temporary table or other result set that you can define and reference within a single query
Subquery
A query nested inside of another query, often used for some calculation or conditional logic that provides data to be used in the main part of the query
