Discovering SQL: A Hands-On Guide for Beginners

INDEX

Symbols and Numbers

# (hash) sign, 212

_ (underscore) in searches, 74

1NF, 89

2NF, 89–90

3NF, 90

80/20 rule, 233

A

ABS() function, 105, 107

access control, 265

ACID test, 255

AdWords, 320

AGE function, 119

aggregate functions, 121–123

AVG(), 137–138

COUNT(), 139–140

MAX(), 140–141

MIN(), 141

SUM(), 142

syntax, 143

aggregation levels, OLAP, 341

aliases, 56–58, 214–215

as database objects, 215

namespaces, 292

ALL operator, 70

subqueries, 157

ALTER INDEX, 211

ALTER keyword, 267

ALTER statement, 26–28, 49–52

identity columns, 218

ALTER USER statement, 267

ALTER VIEW statement, 198

ALTERROLE statement, 272

Amazon, SimpleDB, 336–337

analog versus digital data, 4–5

analytical databases, 93

OLAP (online analytical processing), 93

AND keyword, 70

AND operator, 74–75

ANSI (American National Standards Institute), 10

ANY operator, subqueries, 157

ANY|SOME operators, 70

Apache Cassandra, 335

Apache Hypertable, 335

API (application programming interface), 333

appendChildXML function, 306

applications

optimization, 236–237

XML document access, 294

approximate numbers, 38–39

architecture, OLAP and, 340

arithmetic operators, 67–68

artificial intelligence, Watson computer, 344–345

ASCII (American Standard Code for Information Interchange), 32

assignment operators, 76

atomic value, 89

Atomicity (ACID test), 255

attributes, 30–31

elements, 289

normalization, 91

audits, 266, 278

authentication, 265, 266

authorization, 265

auto-incremented columns, OpenOffice BASE, 222–223

auto-incremented values, ...