Index

A

ADD CONSTRAINT keyword, The Foreign Key Must Reference a Key
aggregate, Out of Many, One
aggregate function, The GROUP BY and HAVING Clauses
aggregate functions, Out of Many, One, Columns with Certain Large Data Types, Functions, Aggregate Functions, COUNT(*)
COUNT (*), COUNT(*), COUNT(*)
COUNT (DISTINCT), COUNT(DISTINCT), COUNT(DISTINCT)
ignore NULLs, Aggregate Functions Ignore NULLs, Aggregate Functions Ignore NULLs
without GROUP BY, Aggregate Functions without GROUP BY, Aggregate Functions without GROUP BY
aggregate functions and GROUP BY clause, Group Rows
aggregate row, Out of Many, One
aggregation, The GROUP BY and HAVING Clauses
ALTER statement, CREATE, ALTER, and DROP, The ALTER Statements, The ALTER Statements
AND and OR
combining, Combining AND and OR, Combining AND and OR
compound conditions with, Compound Conditions with AND and OR
use parentheses when mixing, Combining AND and OR
ASC (keyword), The ORDER BY Clause
ASC and ORDER BY clause, ASC and DESC, ASC and DESC
attributes (data modelling), Entities and Attributes, Entity–Relationship Diagrams
autonumbers (surrogate key), Autonumbers, Autonumbers

B

BETWEEN operators, The BETWEEN Operator, BETWEEN: It haz a flavr
BIGINT (data type), Integers, Conversions in Numeric Calculations
Binary Large Objects (BLOBs), Columns with Certain Large Data Types
BLOB column, CLOB and BLOB, CLOB and BLOB

C

cardinality, Entity–Relationship Diagrams
cart_id, Grouping is More than Sequencing
cartitems table, Grouping is More than Sequencing, The cartitems Table, The cartitems Table
carts table, The carts Table, The carts Table
carts.id, Out of Many, One, How ORDER BY Works
CASE function, The CASE Function, The NULLIF Function
case-sensitivity, The CREATE Statement
CAST function, The CAST Function, The CAST Function
categories table, Real World Joins, The categories Table, The categories Table
full outer join, Full Outer Join: Categories and Entries, UNION Queries
inner join, Inner Join: Categories and Entries, Table Aliases
left outer join, Left Outer Join: Categories and Entries, Right Outer Join: Entries and Categories
one-to-many relationships, Inner Join: Categories and Entries
right outer join, Right Outer Join: Categories and Entries, Right Outer Join: Categories and Entries
category column, Real World Joins, Joining a Table to Itself
CHAR column, CHAR, CHAR
CHAR_LENGTH, CHAR_LENGTH, CHAR_LENGTH
CHARACTER column, CHAR
character data types, Character Data Types, String Functions
CHAR, Character Data Types, CHAR, CHAR, CHAR
CLOB and BLOB, CLOB and BLOB, CLOB and BLOB
NCHAR and NVARCHAR, NCHAR and NVARCHAR, NCHAR and NVARCHAR
numeric or character, Numeric or Character?, Numeric or Character?
string functions, String Functions, String Functions
VARCHAR, VARCHAR, VARCHAR
Character Large Objects (CLOBs), Columns with Certain Large Data Types
CHECK constraints, CHECK Constraints, CHECK Constraints
clauses, Clauses, Clauses, The SELECT Retrieves Data, The SELECT Statement Produces a Tabular Result Set
CLOB column, CLOB and BLOB, CLOB and BLOB
COALESCE function, The COALESCE Function, The COALESCE Function
code highlighting, Front-end Applications
coding style, Clauses
Collations, Comparison Operators, Comparison Operators
column, Keywords, Identifiers, and Constants, The CREATE Statement
column alias, The GROUP BY and HAVING Clauses, Joining a Table to Itself, Joining a Table to Itself
column alias or aggregate expression, HAVING Filters Group Rows, HAVING Filters Group Rows
column constraints, data types (SQL), Column Constraints, CHECK Constraints
CHECK constraints, CHECK Constraints, CHECK Constraints
DEFAULT, DEFAULT, DEFAULT
NULL or NOT NULL, NULL or NOT NULL, NULL or NOT NULL
column name, Keywords, Identifiers, and Constants
column names
qualifying, Qualifying Column Names, Qualifying Column Names
columns, The entries Table, The WHERE Clause, Wrapping Up: the SELECT Statement, SQL Data Types
grouping, Group Rows
numeric data type, An Overview of Data Types
selecting, Which Columns Can Be Selected?, Group Rows
columns with certain large data types, Columns with Certain Large Data Types, Columns with Certain Large Data Types
columns, order of, The CREATE Statement
comments table, The comments Table, The comments Table
Common Era calendar, DATE
comparison operators, Comparison Operators, Comparison Operators
composite key, Primary Keys
compound condition, When “Not True” is Preferable
compound conditions with AND and OR, Compound Conditions with AND and OR, Combining AND and OR
combining AND and OR, Combining AND and OR, Combining AND and OR
truth tables, Truth Tables, Truth Tables
concatenation operator, The Concatenation Operator, The Concatenation Operator
condition (WHERE clause), The WHERE Clause
conference (column), The CREATE Statement
Constants, Keywords, Identifiers, and Constants, The INSERT Statement
CONSTRAINT keyword, UNIQUE Constraints
Content Management System (CMS), The SELECT and FROM Clauses, Content Management System, The entries Table, Real World Joins, Columns with Certain Large Data Types, Entity–Relationship Diagrams, Sample Applications, Content Management System, Content Management System, Content Management System, The entrykeywords Table
contents table, The contents Table, The contents Table
contents.content (TEXT column), Columns with Certain Large Data Types
conversions in numeric calculations
numeric data types, Conversions in Numeric Calculations, Conversions in Numeric Calculations
correlated subqueries, Correlated Subqueries, Correlated Subqueries
correlated subquery, EXISTS Conditions
correlation, Correlated Subqueries
COUNT (DISTINCT), COUNT(DISTINCT), COUNT(DISTINCT)
COUNT function, Columns with Certain Large Data Types, Aggregate Functions Ignore NULLs, COUNT(*)
COUNT(*), The GROUP BY and HAVING Clauses, COUNT(*), COUNT(*)
COUNT(entry_id) aggregate function, Columns with Certain Large Data Types
COUNT(items.name), Group Rows
CREATE statement, CREATE, ALTER, and DROP, The CREATE Statement, Data Manipulation Language, Data Manipulation Language
CREATE TABLE statement, The CREATE Statement, SQL Data Types
cross join, Types of Join, The Cross Join, The Cross Join
current/previous logic, ASC and DESC
CURRENT_DATE (keyword), BETWEEN: It haz a flavr
CURRENT_DATE (time function), Date Functions
CURRENT_DATE - INTERVAL 5 DAY, BETWEEN: It haz a flavr
CURRENT_TIME (time function), Date Functions
CURRENT_TIMESTAMP (time function), Date Functions
customer table, Compound Conditions with AND and OR
customers table, The customers Table, The customers Table
customers.name, Out of Many, One
customers.name column, Group Rows

D

data, Syntax
Data Definition Language (DDL), Syntax, Data Definition Language, Starting Over, Wrapping Up: an Introduction to SQL
ALTER statement, CREATE, ALTER, and DROP, The ALTER Statements, The ALTER Statements
CREATE statement, CREATE, ALTER, and DROP, The CREATE Statement, Data Manipulation Language, Data Manipulation Language
DROP statement, CREATE, ALTER, and DROP, The DROP Statement, The DROP Statement
starting over, Starting Over, Starting Over
Data Manipulation Language (DML), Syntax, Data Manipulation Language, The SELECT Statement Produces a Tabular Result Set, Wrapping Up: an Introduction to SQL
DELETE statement, The DELETE Statement, The DELETE Statement
INSERT statement, The INSERT Statement, The INSERT Statement
SELECT statement, The SELECT Statement
UPDATE statement, The UPDATE Statement, The UPDATE Statement
data model diagrams, Data Model Diagrams, Data Model Diagrams
data modelling, Data Modelling, Entity–Relationship Diagrams
entities and attributes, Entities and Attributes, Example: Forums, Threads, Posts, and Members
entities and relationships, Entities and Relationships, Entity–Relationship Diagrams
data retrieval, SQL Statement Overview, The SELECT Retrieves Data, The SELECT Retrieves Data
data types, ORDER BY with UNION Queries
data types (SQL), SQL Data Types, Wrapping Up: SQL Data Types
character data types, Character Data Types, String Functions
column constraints, Column Constraints, CHECK Constraints
numeric data types, Numeric Data Types, Numeric Functions
overview, An Overview of Data Types, An Overview of Data Types
pros and cons of non-standard data types, Integers, Integers
temporal data types, Temporal Data Types, Date Functions
wrapping up, Wrapping Up: SQL Data Types, Wrapping Up: SQL Data Types
database design, SQL Statement Overview, Relational Integrity
database designer, Entities and Relationships
database development, Starting Over
database environments, SQL Statement Overview
database objects, Syntax, Data Definition Language
database optimizer, WHERE Clause Performance
database structure, Syntax
database system, Decimals
database system software, Download Your Database System Software, Download Your Database System Software
database system, connecting to the, Connect to the Database System, Front-end Applications
database systems, Read The Fine Manual, Times as Duration
DATE, TIMESTAMP
DATE (keyword), DATE
DATE (temporal data types), DATE, Input Format, Storage Format, and Display Format
input format, storage format and display format, Input Format, Storage Format, and Display Format, Input Format, Storage Format, and Display Format
date arithmetic, BETWEEN: It haz a flavr
DATE data type, Temporal Data Types
date functions (temporal data types), Date Functions, Date Functions
date values, inserting, Input Format, Storage Format, and Display Format, Input Format, Storage Format, and Display Format
DATETIME, Sample Scripts
DB2, Data Definition Language, The INSERT Statement, Read The Fine Manual, Temporal Operators, Integers, Download Your Database System Software, Bookmark or Download the SQL Reference
DECIMAL, Decimals, Decimals
decimal data type
latitude and longitude, Example: Latitude and Longitude, Example: Latitude and Longitude
precision, scale and accuracy, Decimals, Decimals
decimals
numeric data types, Decimals, Example: Latitude and Longitude
DEFAULT (column constraints), DEFAULT, DEFAULT
DELETE statement, The DELETE Statement, The DELETE Statement
deprecated (data type), Decimals
derived tables, Subqueries and Derived Tables, Subqueries and Derived Tables
DESC (keyword), The ORDER BY Clause
DESC and ORDER BY clause, ASC and DESC, ASC and DESC
designated database administrators (DBAs), The CREATE Statement
detail query, Grouping is More than Sequencing
detail rows, Grouping is More than Sequencing, Detail Rows, Detail Rows
Discussion Forum application, The Discussion Forum Application, The posts Table
forums table, The forums Table, The forums Table
members table, The members Table, The members Table
posts table, The posts Table, The posts Table
threads table, The threads Table, The threads Table
Discussion Forums, Group Rows
Discussion Forums application, Example: Forums, Threads, Posts, and Members, Entity–Relationship Diagrams, UNIQUE Constraints, Foreign Keys, Discussion Forums, Discussion Forums, Discussion Forums, The posts Table
forums table, The forums Table, The forums Table
members table, The members Table, The members Table
posts table, The posts Table, The posts Table
threads table, The threads Table, The threads Table
Display Estimated Execution Plan, Obtaining the Execution Plan
displaying query results on a Web Page, The entries Table
DISTINCT (keyword), COUNT(DISTINCT)
dot notation, Inner Join: Categories and Entries, Qualifying Column Names
drill-down SQL, Drill-down SQL, Drill-down SQL
DROP statement, CREATE, ALTER, and DROP, The DROP Statement

E

entities (data modelling), Entities and Attributes, Entity–Relationship Diagrams
entities and relationships (data modelling), Entities and Relationships, Entity–Relationship Diagrams
entity-relationship (ER) diagram, Entity–Relationship Diagrams, Entity–Relationship Diagrams
entity-relationship (ER) modelling tools, Entity–Relationship Diagrams, Entity–Relationship Diagrams
entries table, The entries Table, The entries Table, The entries Table, The entries Table
full outer join, Full Outer Join: Categories and Entries, UNION Queries
inner join, Inner Join: Categories and Entries, Table Aliases
left outer join, Left Outer Join: Categories and Entries, Right Outer Join: Entries and Categories
one-to-many relationships, Inner Join: Categories and Entries
right outer join, Right Outer Join: Categories and Entries, Right Outer Join: Categories and Entries
some of it is hidden, Inner Join: Categories and Entries
entries_with_category view, The entries_with_category View, The entries_with_category View
entrykeywords table, Implementing a Many-to-many Relationship: Keywords, Content Management System, The entrykeywords Table, The entrykeywords Table
equals sign = (keyword), Keywords, Identifiers, and Constants
error
full outer join, Full Outer Join: Categories and Entries
execution plan for a query, Obtaining the Execution Plan
EXISTS conditions, EXISTS Conditions, A Left Outer Join with an IS NULL Test
exponent, Floating-point Numbers
EXTRACT, EXTRACT, EXTRACT

F

floating-point data type, FLOAT, REAL, and DOUBLE PRECISION, FLOAT, REAL, and DOUBLE PRECISION
floating-point numbers
numeric data types, Floating-point Numbers, FLOAT, REAL, and DOUBLE PRECISION
FOREIGN KEY keyword, The Foreign Key Must Reference a Key
foreign keys (relational integrity), Foreign Keys, ON DELETE and ON UPDATE
declaring, The Foreign Key Must Reference a Key, The Foreign Key Must Reference a Key
how they work, How Foreign Keys Work, How Foreign Keys Work
must reference a key, The Foreign Key Must Reference a Key, The Foreign Key Must Reference a Key
NULL, Foreign Keys May Be NULL, Foreign Keys May Be NULL
ON DELETE and ON UPDATE, ON DELETE and ON UPDATE, ON DELETE and ON UPDATE
using, Using Foreign Keys, ON DELETE and ON UPDATE
forums Table, The forums Table, The forums Table
forums table, The forums Table, The forums Table
FROM (keyword), Keywords, Identifiers, and Constants
FROM clause, SQL Statement Overview, The SELECT Retrieves Data, The SELECT Retrieves Data, The SELECT and FROM Clauses, The entries Table, Wrapping Up: the SELECT Statement, GROUP BY in Context, Group Rows, The SELECT Clause, SELECT in the Sequence of Execution, ORDER BY with UNION Queries, Wrapping Up: the ORDER BY Clause
derived tables, Subqueries and Derived Tables, Subqueries and Derived Tables
more than one table using JOINS, FROM More than One Table Using JOINs, The Cross Join
one table, FROM One Table, FROM One Table
real world joins, Real World Joins, UNION Queries
result set, The WHERE Clause
subqueries, Subqueries and Derived Tables, Subqueries and Derived Tables
testing, Grouping is More than Sequencing
views, Views, Views in Web Development
Why start with?, Why Start with the FROM Clause?, Parsing an SQL Statement
wrapping up, Wrapping Up: the FROM Clause, Wrapping Up: the FROM Clause
front-end applications, Front-end Applications, Front-end Applications
full outer join, Types of Join, The Full Outer Join, The Full Outer Join
categories and entries, Full Outer Join: Categories and Entries, UNION Queries
union queries, UNION Queries, UNION Queries
FULL OUTER JOIN (keyword), Full Outer Join: Categories and Entries

G

games table, Joining to a Table Twice, The games Table, The games Table
granularity, Group Rows
GROUP BY
using ORDER BY with, Using ORDER BY with GROUP BY, Using ORDER BY with GROUP BY
GROUP BY clause, The SELECT Retrieves Data, The GROUP BY and HAVING Clauses, The GROUP BY and HAVING Clauses, Wrapping Up: the SELECT Statement, The GROUP BY Clause, Wrapping Up: the GROUP BY, The SELECT Clause, Which Columns Can Be Selected?, Detail Rows, Wrapping Up: the SELECT Clause, How ORDER BY Works, ASC and DESC, Wrapping Up: the ORDER BY Clause
and aggregate functions, Group Rows
columns with certain large data types, Columns with Certain Large Data Types
group rows, HAVING Filters Group Rows, HAVING Filters Group Rows
HAVING without a, HAVING without a GROUP BY Clause, Are Thresholds Database or Application Logic?
how it works, How GROUP BY Works, Group Rows
in context, GROUP BY in Context, GROUP BY in Context
rules for, Rules for GROUP BY, Columns with Certain Large Data Types
subquery, Columns with Certain Large Data Types
wrapping up, Wrapping Up: the GROUP BY, Wrapping Up: the GROUP BY
GROUP BY queries, Grouping is More than Sequencing
group condition, HAVING Filters Group Rows
group row, Out of Many, One
group rows, The GROUP BY and HAVING Clauses, Grouping is More than Sequencing, Group Rows, Group Rows, Group Rows, Group Rows
GROUP_CONCAT, Implementing a Many-to-many Relationship: Keywords
Grouping, Grouping is More than Sequencing
grouping columns, Group Rows

H

HAVING clause, The SELECT Retrieves Data, The GROUP BY and HAVING Clauses, The GROUP BY and HAVING Clauses, Wrapping Up: the SELECT Statement, The HAVING Clause, Wrapping Up: the HAVING Clause, The SELECT Clause, SELECT in the Sequence of Execution, Wrapping Up: the ORDER BY Clause
Are thresholds database or application logic?, Are Thresholds Database or Application Logic?, Are Thresholds Database or Application Logic?
use of common aliases in the, Are Thresholds Database or Application Logic?, Are Thresholds Database or Application Logic?
wrapping up, Wrapping Up: the HAVING Clause, Wrapping Up: the HAVING Clause
HAVING filters group rows, HAVING Filters Group Rows, Are Thresholds Database or Application Logic?
HAVING without a GROUP BY clause, HAVING without a GROUP BY Clause, Are Thresholds Database or Application Logic?
threshold alert, Threshold Alert, Are Thresholds Database or Application Logic?
help, SQL, Performance Problems and Obtaining Help, Indexing

I

IBM DB2, Bookmark or Download the SQL Reference, Front-end Applications
IBM DB2 Express-C, Download Your Database System Software
id (column), The CREATE Statement
id (identifier), Keywords, Identifiers, and Constants
ID number, The entries Table
Identifiers, Keywords, Identifiers, and Constants
case-sensitivity, The CREATE Statement
identity (relational integrity), Identity, Identity, Wrapping Up: Relational Integrity
primary keys, Primary Keys, Primary Keys
IN conditions, IN Conditions, IN with Subqueries
with subqueries, IN with Subqueries, IN with Subqueries
indexed retrieval, Indexes
indexes
WHERE clause performance, Indexes, Indexes
Indexing, Indexing
inner join, Types of Join, The Inner Join
all columns are available after a join, All Columns Are Available after a Join, All Columns Are Available after a Join
categories and entries, Inner Join: Categories and Entries, Table Aliases
difference between outer join, The Full Outer Join
qualifying column names, Qualifying Column Names, Qualifying Column Names
table aliases, Table Aliases, Table Aliases
when a join is executed in a query, When a Join is Executed in a Query, When a Join is Executed in a Query
INSERT statement, The INSERT Statement, The INSERT Statement
INTEGER, The CREATE Statement
integers
numeric data types, Integers, Integers
intervals (temporal data types), Intervals, Intervals
IS NULL test, A Left Outer Join with an IS NULL Test, WHERE Clause Performance
items table, Shopping Carts, Grouping is More than Sequencing, The items Table, The items Table
items.name, How ORDER BY Works

J

JavaScript, ORDER BY Clause Performance
join condition, Types of Join
joined tables, FROM More than One Table Using JOINs, UNION Queries
all columns are available after a join, All Columns Are Available after a Join, All Columns Are Available after a Join
cross, The Cross Join, The Cross Join
difference between inner and outer joins, The Full Outer Join
full outer, Full Outer Join: Categories and Entries, UNION Queries
inner, The Inner Join, The Inner Join
joining a table to itself, Joining a Table to Itself, Joining a Table to Itself
joining to a table twice, Joining to a Table Twice, Joining to a Table Twice
left outer, Left Outer Join: Categories and Entries, Right Outer Join: Entries and Categories
outer, Outer Joins, The Full Outer Join
query, Qualifying Column Names
real world, Real World Joins, Table Aliases
right outer, Right Outer Join: Categories and Entries, Right Outer Join: Categories and Entries
types of, Types of Join, Types of Join
when a join is executed in a query, When a Join is Executed in a Query, When a Join is Executed in a Query

K

keys (see foreign keys (relational integrity);natural keys (relational integrity);primary keys (data modelling)surrogate keys (relational integrity))
keywords, Keywords, Identifiers, and Constants, Implementing a Many-to-many Relationship: Keywords, Implementing a Many-to-many Relationship: Keywords, Content Management System, SQL Keywords, SQL Keywords

L

left outer join, Types of Join, The Left Outer Join, The Left Outer Join
categories and entries, Left Outer Join: Categories and Entries, Right Outer Join: Entries and Categories
LEFT OUTER JOIN, A Left Outer Join with an IS NULL Test, WHERE Clause Performance
avoid using COUNT(*), COUNT(*)
LIKE operator, The LIKE Operator, The LIKE Operator

M

major-to-minor sequencing
ORDER BY clause, How ORDER BY Works
mantissa, Floating-point Numbers
manuals, database, Read The Fine Manual, Read The Fine Manual
many-to-many relationship, Entity–Relationship Diagrams, The Foreign Key Goes in the Many Table, Implementing a Many-to-many Relationship: Keywords, Implementing a Many-to-many Relationship: Keywords, Content Management System, Shopping Carts
many-to-one relationship, Entity–Relationship Diagrams
mastering SQL, SQL Statement Overview
MEDIUMINT, Integers
members table, The members Table, The members Table, The members Table, The members Table
Microsoft SQL Server, Bookmark or Download the SQL Reference, Front-end Applications
Microsoft SQL Server Express, Download Your Database System Software
MONEY (data type), Decimals
multiple row constructors, The INSERT Statement, The INSERT Statement
MySQL, Data Definition Language, Read The Fine Manual, Full Outer Join: Categories and Entries, When “Not True” is Preferable, Temporal Operators, Integers, DATE, Times as Duration, The Foreign Key Must Reference a Key, Implementing a Many-to-many Relationship: Keywords, Implementing a Many-to-many Relationship: Keywords, Bookmark or Download the SQL Reference, Front-end Applications
CONCAT function, The Concatenation Operator, The Concatenation Operator
SUBSTRING_INDEX, The Concatenation Operator, The Concatenation Operator
MySQL Community Server, Download Your Database System Software
MySQL DDL, Entity–Relationship Diagrams

N

name (column), The CREATE Statement
name (identifier), Keywords, Identifiers, and Constants
natural keys (relational integrity), Natural versus Surrogate Keys, Autonumbers
autonumbers, Autonumbers, Autonumbers
using, Natural versus Surrogate Keys, Natural versus Surrogate Keys
NCHAR column, NCHAR and NVARCHAR, NCHAR and NVARCHAR
non-standard data types, Integers, Integers
NOT (keyword), When “Not True” is Preferable
NOT EXIST condition, NOT IN or NOT EXISTS?, NOT IN or NOT EXISTS?
NOT IN condition, NOT IN or NOT EXISTS?, NOT IN or NOT EXISTS?
NOT NULL (column), NULL or NOT NULL, NULL or NOT NULL
NOT NULL (name column), The CREATE Statement
NULL, The CREATE Statement, Shopping Carts
NULL (column), NULL or NOT NULL, NULL or NOT NULL
NULL (outer joins), Outer Joins Produce NULLs, Outer Joins Produce NULLs
NULL or NOT NULL (column constraints), NULL or NOT NULL, NULL or NOT NULL
NULL value, Primary Keys
NULL values, NULLs Usually Sort First, NULLs Usually Sort First, ORDER BY with UNION Queries
NULLIF function, The NULLIF Function, The NULLIF Function
NULLs by design, Aggregate Functions Ignore NULLs
NUMERIC (decimal data type), Decimals, Decimals
numeric data types, Numeric Data Types, Numeric Functions
conversions in numeric calculations, Conversions in Numeric Calculations, Conversions in Numeric Calculations
decimals, Decimals, Example: Latitude and Longitude
floating-point numbers, Floating-point Numbers, FLOAT, REAL, and DOUBLE PRECISION
integers, Integers, Integers
numeric functions, Numeric Functions, Numeric Functions
numeric functions
numeric data types, Numeric Functions, Numeric Functions
numeric identifiers, Identity
numeric operators, Numeric Operators, Numeric Operators
NVARCHAR column, NCHAR and NVARCHAR, NCHAR and NVARCHAR

O

“One-to-Zero-or-Many” relationships, Grouping is More than Sequencing
ON clause, The Inner Join
ON DELETE clause, ON DELETE and ON UPDATE
ON UPDATE clause, ON DELETE and ON UPDATE
one-to-many relationship, Inner Join: Categories and Entries, Entity–Relationship Diagrams, The Foreign Key Goes in the Many Table, Joining a Table to Itself
one-to-many relationships, Implementing a Many-to-many Relationship: Keywords, Content Management System
one-to-many table relationships, Implementing a Many-to-many Relationship: Keywords
one-to-one relationship, Entity–Relationship Diagrams
online SQL reference manuals, Read The Fine Manual
operator (keyword), Keywords, Identifiers, and Constants
operators
BETWEEN, The BETWEEN Operator, BETWEEN: It haz a flavr
comparison, Comparison Operators, Comparison Operators
concatenation operator, The Concatenation Operator, The Concatenation Operator
LIKE, The LIKE Operator, The LIKE Operator
numeric, Numeric Operators, Numeric Operators
SELECT clause, Operators, Temporal Operators
temporal, Temporal Operators, Temporal Operators
operators (WHERE clause), Operators, BETWEEN: It haz a flavr
Oracle, Data Definition Language, Read The Fine Manual, Temporal Operators, Bookmark or Download the SQL Reference, Front-end Applications
Oracle Database Express Edition, Download Your Database System Software
ORDER BY clause, The SELECT Retrieves Data, The ORDER BY Clause, The ORDER BY Clause, Wrapping Up: the SELECT Statement, Grouping is More than Sequencing, The ORDER BY Clause, Wrapping Up: the ORDER BY Clause
ASC and DESC, ASC and DESC, ASC and DESC
dealing with problems, The Sequence of Values, The Sequence of Values
detecting groupings in applications, ASC and DESC, ASC and DESC
expressions, ORDER BY Expressions, ORDER BY Expressions
how it works, How ORDER BY Works, NULLs Usually Sort First
major-to-minor sequencing, How ORDER BY Works
performance, ORDER BY Clause Performance, When ORDER BY Seems Unnecessary
scope of, The Scope of ORDER BY, ORDER BY with UNION Queries
sequence of values, The Sequence of Values, The Sequence of Values
special sequencing, Special Sequencing, Special Sequencing
syntax, ORDER BY Syntax, ORDER BY Syntax
using with GROUP BY, Using ORDER BY with GROUP BY, Using ORDER BY with GROUP BY
when it seems unnecessary, When ORDER BY Seems Unnecessary, When ORDER BY Seems Unnecessary
with UNION queries, ORDER BY with UNION Queries, ORDER BY with UNION Queries
wrapping up, Wrapping Up: the ORDER BY Clause, Wrapping Up: the ORDER BY Clause
ORDER BY expressions, ORDER BY Expressions, ORDER BY Expressions
ORDER BY syntax, ORDER BY Syntax, ORDER BY Syntax
outer join, Outer Joins, The Right Outer Join, The Full Outer Join
(see also full outer join)
(see also left outer join)
(see also right outer join)
difference between inner join, The Full Outer Join
produce nulls, Outer Joins Produce NULLs, Outer Joins Produce NULLs
OUTER JOIN (keyword), The Left Outer Join
outer table, Right Outer Join: Entries and Categories

P

parsing an SQL statement, Parsing an SQL Statement, Parsing an SQL Statement
pattern matching, The LIKE Operator
performance problems, SQL, Performance Problems and Obtaining Help, Indexing
PostgreSQL, Data Definition Language, The INSERT Statement, Read The Fine Manual, Integers, Download Your Database System Software, Bookmark or Download the SQL Reference, Front-end Applications
posts table, The posts Table, The posts Table, The posts Table, The posts Table
precision (decimals), Decimals
primary keys (data modelling), Primary Keys, Primary Keys

Q

qualifying column names, Qualifying Column Names, Qualifying Column Names
queries
correlated subqueries, Correlated Subqueries, Correlated Subqueries
execution plan, Obtaining the Execution Plan, Obtaining the Execution Plan
GROUP BY, Grouping is More than Sequencing
subqueries, IN with Subqueries, IN with Subqueries
UNION, ORDER BY with UNION Queries, ORDER BY with UNION Queries
queries, union, UNION Queries, UNION Queries
query
SQL (Structured Query Language), WHERE Clause Performance, Performance Problems and Obtaining Help
query results on a web page, The entries Table
query, join, Qualifying Column Names
query, when a join is executed in a, When a Join is Executed in a Query

R

range test, The BETWEEN Operator
real world joins, Real World Joins, UNION Queries
REFERENCES keyword, The Foreign Key Must Reference a Key
referential integrity, The Foreign Key Must Reference a Key
reflexive relationship, Joining a Table to Itself
relational integrity, Relational Integrity, Wrapping Up: Relational Integrity, The Foreign Key Must Reference a Key
data modelling, Data Modelling, Entity–Relationship Diagrams
foreign keys, Foreign Keys, ON DELETE and ON UPDATE
identity, Identity, Identity
natural versus surrogate keys, Natural versus Surrogate Keys, Autonumbers
primary keys, Primary Keys, Primary Keys
UNIQUE constraints, UNIQUE Constraints, UNIQUE Constraints
wrapping up, Wrapping Up: Relational Integrity, Wrapping Up: Relational Integrity
result set, The SELECT Statement Produces a Tabular Result Set
right outer join, Types of Join, The Right Outer Join, The Right Outer Join
categories and entries, Right Outer Join: Entries and Categories, Right Outer Join: Entries and Categories, Right Outer Join: Categories and Entries, Right Outer Join: Categories and Entries
row, The CREATE Statement, The INSERT Statement
row constructor, The INSERT Statement, The INSERT Statement
row constructors, Sample Scripts
rows
detail, Detail Rows, Detail Rows
group, Group Rows, Group Rows

S

sample applications, SQL, Sample Applications, Shopping Carts
scalar functions, Functions, Scalar Functions, The NULLIF Function
scale (decimals), Decimals
script, Starting Over
SELECT (keyword), Keywords, Identifiers, and Constants, SELECT DISTINCT
SELECT *, The Dreaded, Evil Select Star, The Dreaded, Evil Select Star
SELECT * (keyword), Grouping is More than Sequencing
SELECT clause, Syntax, The SELECT Retrieves Data, The SELECT Retrieves Data, The SELECT and FROM Clauses, The entries Table, Wrapping Up: the SELECT Statement, Grouping is More than Sequencing, Columns with Certain Large Data Types, The SELECT Clause, Wrapping Up: the SELECT Clause, Joining to a Table Twice
Discussion Forum application, The Discussion Forum Application, The posts Table
functions, Functions, The NULLIF Function
operators, Operators, Temporal Operators
SELECT *, The Dreaded, Evil Select Star, The Dreaded, Evil Select Star
SELECT DISTINCT, SELECT DISTINCT, SELECT DISTINCT
sequence in execution, SELECT in the Sequence of Execution, SELECT in the Sequence of Execution
Which columns can be selected?, Which Columns Can Be Selected?, Group Rows
wrapping up, Wrapping Up: the SELECT Clause, Wrapping Up: the SELECT Clause
SELECT DISTINCT, SELECT DISTINCT, SELECT DISTINCT
SELECT SQL statement, The ORDER BY Clause
select star (*), Grouping is More than Sequencing
SELECT statement, SQL Statement Overview, The SELECT Statement, The SELECT Statement Produces a Tabular Result Set, The SELECT Statement, The SELECT Statement, Wrapping Up: the SELECT Statement, The SELECT Clause, Which Columns Can Be Selected?, SQL Data Types
clauses, The SELECT Retrieves Data, The SELECT Statement Produces a Tabular Result Set
data retrieval, The SELECT Retrieves Data, The SELECT Retrieves Data
tabular structure, The SELECT Statement Produces a Tabular Result Set, The SELECT Statement Produces a Tabular Result Set
self-documenting, Qualifying Column Names
semantics, Syntax
sequence of values
ORDER BY clause, The Sequence of Values, NULLs Usually Sort First
Sequencing, Grouping is More than Sequencing
Shopping Cart, Grouping is More than Sequencing
shopping carts, Shopping Carts, Conditions that Evaluate as UNKNOWN, Shopping Carts, Shopping Carts, Shopping Carts, The vendors Table
cartitems table, The cartitems Table, The cartitems Table
carts table, The carts Table, The carts Table
customers table, The customers Table, The customers Table
items table, The items Table, The items Table
vendors table, The vendors Table, The vendors Table
sitemap
application for left outer joins, Left Outer Join: Categories and Entries, Left Outer Join: Categories and Entries
SMALLINT, Integers
SMALLINT column, Column Constraints
SMALLINT values, Times as Duration
special sequencing
ORDER BY clause, Special Sequencing, Special Sequencing
special structures, Special Structures, Wrapping Up: Special Structures
implementing a many-to-many relationship, Implementing a Many-to-many Relationship: Keywords, Implementing a Many-to-many Relationship: Keywords
joinging a table to itself, Joining a Table to Itself, Joining a Table to Itself
joining to a table twice, Joining to a Table Twice, Joining to a Table Twice
wrapping up, Wrapping Up: Special Structures, Wrapping Up: Special Structures
splittime column, Times as Duration
SQL (Structured Query Language), An Introduction to SQL
aggregate functions, Aggregate Functions, COUNT(*)
functions, Functions, The NULLIF Function
help, Performance Problems and Obtaining Help, Indexing
keywords, SQL Keywords, SQL Keywords
language, SQL Statement Overview
online reference manuals, Read The Fine Manual
performanve problems, Performance Problems and Obtaining Help, Indexing
query, SQL Statement Overview, WHERE Clause Performance, Performance Problems and Obtaining Help
sample applications, Sample Applications, Shopping Carts
scalar functions, Scalar Functions, The NULLIF Function
script, Starting Over
standards, SQL Statement Overview, Standard SQL, Read The Fine Manual
structure, SQL Statement Overview
syntax, Data Definition Language
tabular structures, SQL Statement Overview, The CREATE Statement, The INSERT Statement, The SELECT Retrieves Data, The SELECT Statement Produces a Tabular Result Set
testing environment, Testing Environment, Indexing
trying out the sample, The SELECT Statement
trying out your, Data Definition Language
types of statements, SQL Statement Overview
SQL data types (see data types (SQL))
SQL or Sequel, SQL Statement Overview
SQL reference, Bookmark or Download the SQL Reference, Bookmark or Download the SQL Reference
SQL reference manual, Input Format, Storage Format, and Display Format, Obtaining the Execution Plan, SQL Keywords
SQL scalar functions
commonly available in all database systems, Scalar Functions, The NULLIF Function
SQL script library, SQL Script Library, SQL Script Library
SQL Server, Data Definition Language, Read The Fine Manual, Integers, DATE
SQL Server 2008 Express with Tools, Front-end Applications
SQL standard, NCHAR and NVARCHAR, DATE
SQL statement, parsing an, Parsing an SQL Statement, Parsing an SQL Statement
SQL statements, An Introduction to SQL, Data Definition Language, Wrapping Up: an Introduction to SQL, The SELECT Clause, The ORDER BY Clause
clauses, Clauses, Clauses
Data Definition Language (DDL), Syntax
Data Manipulation Language (DML), Syntax
keywords, identifiers and constants, Keywords, Identifiers, and Constants, Keywords, Identifiers, and Constants
overview, SQL Statement Overview, Syntax
script, Starting Over
syntax, Syntax, Syntax
types of, SQL Statement Overview
SQL, drill-down, Drill-down SQL, Drill-down SQL
SQL-1999, Integers
SQL-2003 standard, Integers
standards, SQL, SQL Statement Overview, Standard SQL, Read The Fine Manual
starting over, Starting Over, Starting Over
string functions (character data types), String Functions, String Functions
strings, The INSERT Statement
structure, SQL, SQL Statement Overview
Structured Query Language (SQL), An Introduction to SQL
subqueries, Subqueries and Derived Tables, Subqueries and Derived Tables
subquery, GROUP BY clause, Columns with Certain Large Data Types
subselects (union queries), UNION Queries
SUBSTRING function, The SUBSTRING Function, The SUBSTRING Function
surrogate keys (relational integrity), Natural versus Surrogate Keys, Autonumbers
and redundancy, Natural versus Surrogate Keys, Natural versus Surrogate Keys
autonumbers, Autonumbers, Autonumbers
UNIQUE constraint, Autonumbers, Autonumbers
syntax, Syntax, Syntax

T

table, Keywords, Identifiers, and Constants
table aliases, Table Aliases, Table Aliases, Joining a Table to Itself, Joining a Table to Itself
table name, Keywords, Identifiers, and Constants
table scan, Indexes
tables, Wrapping Up: the FROM Clause
(see also joined tables)
creating, Types of Join
single, FROM One Table, FROM One Table
tables, multiple, FROM More than One Table Using JOINs
tables, single
FROM clause, FROM One Table, FROM One Table
tabular structure, SQL Statement Overview, The CREATE Statement, The INSERT Statement, The SELECT Retrieves Data, The SELECT Statement Produces a Tabular Result Set, The WHERE Clause, Grouping is More than Sequencing
tags, Implementing a Many-to-many Relationship: Keywords
teams (identifier), Keywords, Identifiers, and Constants
Teams and Games application, Teams and Games, The games Table
teams and games data model, Teams and Games, Teams and Games
teams table, The CREATE Statement, Joining to a Table Twice, The teams Table, The teams Table
temporal data types, An Overview of Data Types, Temporal Data Types, Date Functions
DATE, DATE, Input Format, Storage Format, and Display Format
date functions, Date Functions, Date Functions
intervals, Intervals, Intervals
TIME, TIME, Times as Points in Time
TIMESTAMP, TIMESTAMP, TIMESTAMP
temporal operators, Temporal Operators, Temporal Operators
temporary table, Group Rows
testing environment, SQL, Testing Environment, Indexing
TEXT column, The WHERE Clause
threads table, The threads Table, The threads Table, The threads Table, The threads Table
threshold alert, Threshold Alert, Are Thresholds Database or Application Logic?
thresholds, database or application logic, Are Thresholds Database or Application Logic?, Are Thresholds Database or Application Logic?
TIME, TIMESTAMP
TIME (temporal data types), TIME, Times as Points in Time
times as duration, Times as Duration, Times as Duration
times as point in time, Times as Points in Time, Times as Points in Time
time as duration, Times as Duration
TIME data type, Temporal Data Types
TIME values, Times as Duration
times as points in time, Times as Points in Time
TIMESTAMP, Sample Scripts
timestamp (temporal data types), An Overview of Data Types
TIMESTAMP (temporal data types), TIMESTAMP, TIMESTAMP
TINYINT, Integers
TINYINT values, Times as Duration
truth tables, Truth Tables, Truth Tables

U

UNION (keyword), UNION Queries
UNION ALL, UNION Queries
union queries
full outer join, UNION Queries, UNION Queries
UNION Queries
ORDER BY with, ORDER BY with UNION Queries, ORDER BY with UNION Queries
UNIQUE constraint
NULL, Foreign Keys May Be NULL, Foreign Keys May Be NULL
UNIQUE constraints (relational integrity), UNIQUE Constraints, UNIQUE Constraints, Autonumbers, Autonumbers
dealing with keys in application code, UNIQUE Constraints, UNIQUE Constraints
UNKNOWN (WHERE clause), When “Not True” is Preferable, Conditions that Evaluate as UNKNOWN, Conditions that Evaluate as UNKNOWN, Truth Tables
UPDATE statement, The UPDATE Statement, The UPDATE Statement

V

VARCHAR, The CREATE Statement
VARCHAR column, VARCHAR, VARCHAR
vendors table, The vendors Table, The vendors Table
Views, Views, Views in Web Development

W

web development
views, Views in Web Development, Views in Web Development
WEEKDAY (date function), Date Functions
WHERE (keyword), Keywords, Identifiers, and Constants
WHERE clause, The SELECT Retrieves Data, The WHERE Clause, The WHERE Clause, Wrapping Up: the SELECT Statement, GROUP BY in Context, Group Rows, The SELECT Clause, SELECT in the Sequence of Execution, When ORDER BY Seems Unnecessary, Wrapping Up: the ORDER BY Clause
compound conditions with AND and OR, Compound Conditions with AND and OR, IN with Subqueries
conditions, Conditions, When “Not True” is Preferable
correlated subqueries, Correlated Subqueries, Correlated Subqueries
EXIST conditions, EXISTS Conditions, A Left Outer Join with an IS NULL Test
operators, Operators, BETWEEN: It haz a flavr
performance, WHERE Clause Performance, Indexes
shopping carts, Shopping Carts, Conditions that Evaluate as UNKNOWN
wrapping up, Wrapping Up: the WHERE Clause, Wrapping Up: the WHERE Clause
WHERE condition, Conditions, When “Not True” is Preferable
conditions that are true, Conditions that are True, Conditions that are True
when 'Not True" is preferable, When “Not True” is Preferable, When “Not True” is Preferable
wildcard characters, The LIKE Operator
Wordpress, The SELECT and FROM Clauses

Y

YYYY-MM-DD format, Input Format, Storage Format, and Display Format
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset