Index
As this ebook edition doesn't have fixed pagination, the page numbers below are hyperlinked for reference only, based on the printed edition of this book.
A
aggregate functions 187, 188, 219-221
alternate key 12
Alteryx 48
analytical workflow
SQL to business intelligence (BI) 153
analytic function 222
approximate data types
DOUBLE 64
FLOAT 63
average 272
AVG() function 188, 201, 202, 229, 230
B
box plot method 312
used, for outlier detection 306, 307
Boyce-Codd Normal Form (BCNF) 25
C
candidate key 11
cascading actions 15
DELETE CASCADE 15
arguments 78
benefits 122
case scenarios...