search for books and compare prices
Tables of Contents for A Visual Introduction to SQL
Chapter/Section Title
Page #
Page Count
Foreword
vii
Preface
ix
Introducing SQL
1
8
Kinds of Database Systems
1
1
Relational Concepts
2
3
Tables, Rows, and Columns
2
2
Keys
4
1
An Example Table
5
1
The Visual Approach
5
4
Elements of the Language
9
14
Ways to Use SQL
9
1
Versions of SQL
10
1
Defining the Language
11
6
Data Types
11
3
The Structure of SQL Statements
14
1
Keywords
15
2
An Example Database
17
4
Organization of the Examples
21
2
Retrieving Data from a Table: The Select Statement
23
38
Selecting Specific Columns in a Table
23
4
Selecting All Columns in a Table
27
3
Selecting Only Some of a Table's Records: The Where Clause
30
1
Comparisons in a Where Clause
30
6
Combining Predicates in a Where Clause
36
8
Using And
36
3
Using Or
39
3
Using Not
42
2
Other Uses of Where
44
17
Between and Not Between
44
4
Like and Not Like
48
5
In and Not In
53
4
Is Null and Is Not Null
57
4
More on Select
61
36
Ordering Selected Data
61
6
Doing Arithmetic with Selected Information
67
3
Using Aggregates
70
15
Finding Maximum and Minimum Values
70
4
Totaling Columns
74
3
Finding Averages
77
2
Counting Records
79
3
Using Distinct
82
3
Grouping Selected Data
85
8
More on Grouping: The Having Clause
93
4
Retrieving Data from Several Tables: Joins
97
50
Qualified Names
97
2
What Is a join?
99
3
Restricting the Results of a Join
102
2
Query Diagrams for Joins
104
3
Joining Tables Using the Join Operator
107
4
Manipulating the Results of a Join
111
4
Aliases
115
5
Joins with Three Tables
120
12
The Visual Approach with More Than Two Tables
120
12
Joins with More Than Three Tables
132
8
Retrieving the Same Information in Different Ways
132
8
Using Group By in a join
140
7
Queries within Queries: Subqueries
147
26
What Is a Subquery?
147
4
Using Comparison Operators with Subqueries
151
4
Using ANY and ALL
155
7
Existence Tests
162
1
Correlated Subqueries
162
11
Using Having with Correlated Subqueries
164
9
Creating and Destroying Tables
173
12
Creating a Table
173
9
Disallowing Null Values
175
1
Requiring Unique Values in a Column
175
7
Destroying (Dropping) Tables
182
3
Adding, Modifying, and Deleting Records
185
20
Adding Records to a Table
185
15
Adding Records with Values Only for Some Columns
187
3
Adding Records Using Select
190
3
Modifying Records in a Table
193
7
Deleting Records from a Table
200
5
Views
205
24
Creating Views
205
9
Creating Views Based on One Table
206
5
Creating Views Based on More Than One Table
211
3
Queries Using Views
214
12
Selecting Records from a View
214
5
Adding Records to a View
219
3
Modifying Records in a View
222
2
Deleting Records from a View
224
2
Destroying (Dropping) Views
226
3
Granting and Revoking Privileges
229
20
Granting Privileges
229
14
Granting Privileges on Views
231
9
Passing Privileges On: The Grant Option
240
3
Revoking Privileges
243
6
Advanced Topics
249
28
Indexes
249
4
Creating Indexes
250
2
When to Create Indexes
252
1
Destroying Indexes
253
1
Using Multiple SQL Statements to Solve a Problem
253
12
Outer Joins
265
6
Unions
271
2
Joining a Table with Itself
273
3
Final Thoughts
276
1
Appendix A The Example Database
277
2
Appendix B List of Examples
279
4
Appendix C The Example Database
283
2
Index
285