search for books and compare prices
Tables of Contents for SQL Weekend Crash Course
Chapter/Section Title
Page #
Page Count
Preface
viii
Acknowledgments
xii
FRIDAY
2
2
Part I---Friday Evening
4
46
Introduction to Databases and SQL
5
8
Retrieving Data
13
12
Data Types
25
12
Representing Data Values
37
13
Friday Evening Part Review
49
1
SATURDAY
50
2
Part II---Saturday Morning
52
50
Retrieving Specific Data
53
8
Retrieving Not-So-Specific Data
61
6
Retrieving Data Based on What Exists
67
10
Retrieving Data Based on How It Matches Other Data
77
8
Advanced Value Expressions
85
8
Grouping and Ordering of Retrieved Data
93
9
Saturday Morning Part Review
100
2
Part III---Saturday Afternoon
102
50
Retrieving Data from Multiple Tables with Relational Operators
103
6
Retrieving Data from Multiple Tables Using Joins
109
8
Nested Queries
117
8
Adding, Updating, and Deleting Data
125
8
Using SQL within an Application
133
8
Using SQL: 1999 Flow of Control Structures within an Application
141
11
Saturday Afternoon Part Review
150
2
Part IV---Saturday Evening
152
42
Connecting to a Remote Database
153
12
Stored Procedures and Triggers
165
10
Database Structure
175
8
Database Design
183
11
Saturday Evening Part Review
193
1
SUNDAY
194
2
Part V---Sunday Morning
196
60
Integrity and Constraints
197
10
Designing High-Integrity Databases
207
8
Controlling Access to a Database
215
10
Protecting the Contents of a Database
225
10
Performance Tuning
235
10
Accessing Databases over the Internet
245
11
Sunday Morning Part Review
253
3
Part VI---Sunday Afternoon
256
37
Cursors
257
8
SQL in Common Development Environments
265
8
Error Handling
273
8
Dynamic SQL
281
12
Sunday Afternoon Part Review
291
2
Appendix A-Answers to the Part Reviews
293
6
Appendix B-What's on the CD
299
16
Index
315
19
End-User License Agreement
334