O'Reilly logo

Discovering SQL: A Hands-On Guide for Beginners by Alex Kriegel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

INDEX

Symbols and Numbers

# (hash) sign, 212

_ (underscore) in searches, 74

1NF, 89

2NF, 8990

3NF, 90

80/20 rule, 233

A

ABS() function, 105, 107

access control, 265

ACID test, 255

AdWords, 320

AGE function, 119

aggregate functions, 121123

AVG(), 137138

COUNT(), 139140

MAX(), 140141

MIN(), 141

SUM(), 142

syntax, 143

aggregation levels, OLAP, 341

aliases, 5658, 214215

as database objects, 215

namespaces, 292

ALL operator, 70

subqueries, 157

ALTER INDEX, 211

ALTER keyword, 267

ALTER statement, 2628, 4952

identity columns, 218

ALTER USER statement, 267

ALTER VIEW statement, 198

ALTERROLE statement, 272

Amazon, SimpleDB, 336337

analog versus digital data, 45

analytical databases, 93

OLAP (online analytical processing), 93

AND keyword, 70

AND operator, 7475

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, 236237

XML document access, 294

approximate numbers, 3839

architecture, OLAP and, 340

arithmetic operators, 6768

artificial intelligence, Watson computer, 344345

ASCII (American Standard Code for Information Interchange), 32

assignment operators, 76

atomic value, 89

Atomicity (ACID test), 255

attributes, 3031

elements, 289

normalization, 91

audits, 266, 278

authentication, 265, 266

authorization, 265

auto-incremented columns, OpenOffice BASE, 222223

auto-incremented values, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required