Index
A, B, C
Aggregate operations
AVG() function
duplicates
Nulls
COUNT() function
duplicates
Nulls
MAX() function
MIN() function
nested queries
ROUND() function
SUM() function
D
Database design
combining tables
foreign key constraints
inconsistent data
inconsistent spelling
numeric values
primary key
SQL implementation
Difference
Division
E
EXISTS keyword
F
Frames
G, H
Golf club database
Grouping function
DISTINCT keyword
HAVING keyword
I
Intersection
J, K, L, M
Join
diagrammatic interfaces
equi-join
inner join
natural
order
outcome approach
outer
process approach
Cartesian product
inner join
techniques
merge join
nested loops
SQL Server
N
Nested queries
Normalization
O
Outcome approach
OVER() function
P, Q
Project
Process approach
Cartesian product
inner join
R
Referential integrity ...
Get Beginning SQL Queries: From Novice to Professional, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.