Tools of the Trade: Linux and SQL: Module 4 Flashcards
(16 cards)
Database
A structured place to store information
Date and Time Data
Data that shows a date or time
Exclusive Operator
An operator that does not include the exact value
Filtering
Finding data that matches certain rules
Foreign Key
A column that links to a primary key in another table
Inclusive Operator
An operator that includes the exact value
Log
A record of system activity
Numeric Data
Data made of numbers
Operator
A symbol or word used to compare or calculate
Primary Key
A column with unique values for each row
Query
A way to ask for data from a database
Relational Database
A database with tables that are connected
String Data
Text or letters in order
SQL (Structured Query Language)
A language used to work with databases
Syntax
The rules for writing code correctly
Wildcard
A character that stands for any other character