Beginning SQL Queries: From Novice to Professional, Second Edition

Index

A, B, C

1. Aggregate operations

   1. AVG() function

      1. duplicates

      2. Nulls

   2. COUNT() function

      1. duplicates

      2. Nulls

   3. MAX() function

   4. MIN() function

   5. nested queries

   6. ROUND() function

   7. SUM() function

D

1. Database design

   1. combining tables

   2. foreign key constraints

   3. inconsistent data

   4. inconsistent spelling

   5. numeric values

   6. primary key

   7. SQL implementation

2. Difference

3. Division

E

1. EXISTS keyword

F

1. Frames

G, H

1. Golf club database

2. Grouping function

   1. DISTINCT keyword

   2. HAVING keyword

I

1. Intersection

J, K, L, M

1. Join

   1. diagrammatic interfaces

   2. equi-join

   3. inner join

   4. natural

   5. order

   6. outcome approach

   7. outer

   8. process approach

      1. Cartesian product

      2. inner join

   9. techniques

      1. merge join

      2. nested loops

   10. SQL Server

N

1. Nested queries

2. Normalization

O

1. Outcome approach

2. OVER() function

P, Q

1. Project

2. Process approach

See. Relational algebra

1. Cartesian product

2. inner join

R

1. Referential integrity ...