Relational database
No License Required
What is free to use/public domain?
TEXT
What is a string of characters?
Single "ordinary" file on disk
What is entire database?
SELECT Clause
What is used to retrieve data from tables?
Integer or string values
What is no date/timestamp type?
Compact
What is self-contained and serverless?
INTEGER
What is a value that is a signed 64-bit integer?
Database changes
What is write access to file and directory?
SELECT DISTINCT
CurrentColumnName1 AS 'NewNameofmychoice1',
CurrentColumnName2 AS 'NewNameofmychoice2'
FROM TableName
What is Aliasing or changing a Column name?
SELECT datetime (time_column/1000, 'unixepoch');
What is converting Unix Epoch Timestamps?
Small footprint
What is a 500KB library?
REAL
What is a floating point/decimal value?
Located anywhere
What is easily moved?
SELECT CompanyName, CustomerName,
CASE
WHEN State = ‘OR’ THEN ‘Oregon’
WHEN State = ‘CA’ THEN ‘California’
WHEN State = ‘AK’ THEN ‘Alaska’
ELSE
'Unknown State'
END AS State
FROM Customer
What is Expression to Enumerate Values?
SELECT
datetime (time_column + 978307200,
'unixepoch', 'localtime');
What is converting Mac Absolute Timestamps?
Cross-platform
What is utilized by Windows, Linux, OS X, Android, iOS?
BLOB
What is Binary Large Object value?
Dominate data storage medium
What is utilized by numerous mobile apps as well as desk apps?
Select Id, ShipName, Freight
from [Order]
where Freight > 48 OR ShipName like '%rattlesnake%'
What is filtering with the Where clause?
SELECT
datatime ((time_column/1000000) - 11644473600, 'unixepoch');
What is converting Chrome/Webkit Timestamps?