Index
Symbols
\COPY command 53, 54
\df command 116
\sf command 116
A
advanced window definitions
using 174
window frame 176-179
window functions 174, 175
WINDOW keyword 175, 176
aggregate functions 146-150
using, to analyze data 150, 151
aggregations 145
American National Standards Institute (ANSI) 14
analytics
fundamental concepts 252
moving, to statistics 252
analytics, fundamental concepts
measures of central tendency 255, 256
measures of variability 256, 257
parameters, versus statistics 254
population, versus samples 252, 253
AND or OR clause 93-95
arrays
sequences, analyzing 226-228
using, to process element collections 222-225
atomicity, consistency, isolation, and durability (ACID) 13
B
bitmap heap scan 197
block 188
Boolean 36
B-tree index 193-195
Business Intelligence (BI) tools 278
C
CASE WHEN function 108, 109
casting function 110
...
