Amazon no longer offers textbook rentals. We do!

A Guide to SQL

by: Pratt, Philip J.

A Guide to SQL

by: Pratt, Philip J.

ISBN 13:
9780619159573
ISBN 10:
061915957X
Edition: 6th
Format: Paperback
Copyright: 12/23/2002
Publisher: Course Technology
Newer Edition

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

A Guide to SQL, Sixth Edition, the essential SQL reference book, illustrates the basics of SQL programming using straightforward instruction. This textbook teaches concepts and techniques with the help of many examples. In addition, a running case, Premiere Products, puts lessons into a real-world context. Although based in Oracle9i, the text calls out information specific to Microsoft Access 2002 and can be used for instruction in any version of SQL. Additional hands-on work at the end of each chapter offers the opportunity to problem solve based on what has been learned. Book jacket.

Preface	p. ix
Introduction to Premiere Products and Henry Books	p. 1
Objectives	p. 1
Introduction	p. 2
The Premiere Products Database	p. 2
Introduction to the Henry Books Database Case	p. 8
Summary	p. 15
Exercises (Premiere Products)	p. 15
Exercises (Henry Books)	p. 16
An Introduction to SQL	p. 17
Objectives	p. 17
Introduction	p. 18
Relational Databases	p. 18
Entities, Attributes, and Relationships	p. 20
Database Creation	p. 23
Running SQL Commands	p. 25
Editing SQL Commands	p. 27
Dropping a Table	p. 29
Data Types	p. 29
Nulls	p. 30
Implementation of Nulls	p. 31
Loading a Table with Data	p. 31
The INSERT Command	p. 31
The INSERT Command with Nulls	p. 34
Viewing Table Data	p. 35
Correcting Errors in the Database	p. 36
Saving SQL Commands	p. 38
Creating the Remaining Database Tables	p. 38
Describing a Table	p. 42
Summary	p. 44
Key Terms	p. 45
Review Questions	p. 45
Exercises (Premiere Products)	p. 46
Exercises (Henry Books)	p. 47
Single-Table Queries	p. 49
Objectives	p. 49
Introduction	p. 50
Constructing Simple Queries	p. 50
Retrieving Certain Columns and All Rows	p. 51
Retrieving All Columns and All Rows	p. 52
Using a WHERE Clause	p. 52
Using Compound Conditions	p. 54
Using the BETWEEN Operator	p. 56
Using Computed Columns	p. 57
Using the LIKE Operator	p. 59
Using the IN Operator	p. 60
Sorting	p. 61
Using the ORDER BY Clause	p. 61
Additional Sorting Options	p. 62
Using Functions	p. 63
Using the COUNT Function	p. 63
Using the SUM Function	p. 64
Using the DISTINCT Operator	p. 65
Nesting Queries	p. 67
Subqueries	p. 68
Grouping	p. 69
Using the GROUP BY Clause	p. 70
Using a HAVING Clause	p. 71
HAVING vs. WHERE	p. 71
Nulls	p. 73
Summary	p. 74
Key Terms	p. 75
Review Questions	p. 76
Exercises (Premiere Products)	p. 76
Exercises (Henry Books)	p. 77
Multiple-Table Queries	p. 79
Objectives	p. 79
Introduction	p. 80
Querying Multiple Tables	p. 80
Joining Two Tables	p. 80
Comparing JOIN, IN, and EXISTS	p. 83
Using IN	p. 83
Using EXISTS	p. 84
Using a Subquery within a Subquery	p. 85
A Comprehensive Example	p. 87
Using an Alias	p. 88
Joining a Table to Itself	p. 89
Joining Several Tables	p. 91
Set Operations	p. 94
ALL and ANY	p. 97
Special Operations	p. 99
Inner Join	p. 100
Outer Join	p. 101
Product	p. 102
Summary	p. 104
Key Terms	p. 105
Review Questions	p. 105
Exercises (Premiere Products)	p. 106
Exercises (Henry Books)	p. 107
Updating Data	p. 109
Objectives	p. 109
Introduction	p. 110
Creating a New Table from an Existing Table	p. 110
Changing Existing Data in a Table	p. 111
Adding New Rows to an Existing Table	p. 113
Commit and Rollback	p. 114
Transactions	p. 115
Deleting Existing Rows from a Table	p. 116
Executing a Rollback	p. 117
Changing a Value in a Column to Null	p. 117
Changing Table Structures	p. 118
Making Complex Changes	p. 122
Dropping a Table	p. 122
Summary	p. 123
Key Terms	p. 124
Review Questions	p. 124
Exercises (Premiere Products)	p. 125
Exercises (Henry Books)	p. 126
Database Administration	p. 127
Objectives	p. 127
Introduction	p. 128
Views	p. 128
Row-and-Column Subsets	p. 134
Joins	p. 135
Statistics	p. 138
Dropping a View	p. 138
Security	p. 138
Indexes	p. 141
Creating an Index	p. 144
Dropping an Index	p. 145
Unique Indexes	p. 146
System Catalog	p. 146
Integrity Rules in SQL	p. 149
Summary	p. 152
Key Terms	p. 153
Review Questions	p. 154
Exercises (Premiere Products)	p. 155
Exercises (Henry Books)	p. 156
Reports	p. 159
Objectives	p. 159
Introduction	p. 160
Concatenating Columns	p. 160
Creating and Using Scripts	p. 161
Running the Query for the Report	p. 162
Creating the Data for the Report	p. 163
Changing Column Headings	p. 165
Changing Column Formats in a Report	p. 166
Adding a Title to a Report	p. 168
Grouping Data in a Report	p. 170
Including Totals an Subtotals in a Report	p. 171
Sending the Report to a File	p. 173
Completing the Script to Produce the Report	p. 175
Summary	p. 178
Key Terms	p. 179
Review Questions	p. 180
Exercises (Premiere Products)	p. 180
Exercises (Henry Books)	p. 183
Embedded SQL	p. 187
Objectives	p. 187
Introduction	p. 188
Using Prompt Variables	p. 189
PL/SQL Programs	p. 190
Retrieving a Single Row and Column	p. 190
Using the %TYPE Attribute	p. 192
Retrieving a Single Row from a Join	p. 192
Inserting a Row into a Table	p. 193
Changing a Single Row in a Table	p. 195
Deleting Rows from a Table	p. 195
Deleting Rows from Multiple Tables	p. 196
Multiple-Row Select	p. 197
Using Cursors	p. 197
Opening a Cursor	p. 198
Fetching Rows from a Cursor	p. 199
Closing a Cursor	p. 201
Complete Program Using a Cursor	p. 201
More Complex Cursors	p. 202
Advantages of Cursors	p. 204
Updating Cursors	p. 205
Error Handling	p. 207
Using SQL in Microsoft Access Programs	p. 207
Deleting Rows	p. 208
Running the Code	p. 209
Updating Rows	p. 210
Inserting Rows	p. 211
Finding Rows	p. 211
Summary	p. 213
Key Terms	p. 214
Review Questions	p. 214
Exercises (Premiere Products)	p. 215
Exercises (Henry Books)	p. 216
SQL Reference	p. 217
Aliases	p. 218
Alter Table	p. 218
Column or Expression List (Select Clause)	p. 218
Computed Columns	p. 219
The Distinct Operator	p. 219
Functions	p. 219
Commit	p. 219
Conditions	p. 220
Simple Conditions	p. 220
Compound Conditions	p. 220
Between Conditions	p. 221
Like Conditions	p. 221
In Conditions	p. 221
Exists Conditions	p. 222
All and Any	p. 222
Create Index	p. 222
Create Table	p. 223
Create View	p. 223
Data Types	p. 224
Delete Rows	p. 225
Drop Index	p. 225
Drop Table	p. 225
Drop View	p. 226
Grant	p. 226
Insert Into (Query)	p. 227
Insert Into (Values)	p. 227
Integrity	p. 228
Revoke	p. 228
Rollback	p. 229
Select	p. 229
Subqueries	p. 230
Union, Intersect, and Minus	p. 230
Update	p. 232
"How do I" Reference	p. 233
Answers to Odd-Numbered Review Questions	p. 237
Chapter 1--Introduction to Premiere Products and Henry Books	p. 238
Chapter 2--An Introduction to SQL	p. 238
Chapter 3--Single-Table Queries	p. 239
Chapter 4--Multiple-Table Queries	p. 239
Chapter 5--Updating Data	p. 240
Chapter 6--Database Administration	p. 240
Chapter 7--Reports	p. 241
Chapter 8--Embedded SQL	p. 241
Index	p. 243
Table of Contents provided by Ingram. All Rights Reserved.

Amazon no longer offers textbook rentals. We do!

A Guide to SQL

A Guide to SQL

9780619159573

061915957X

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

A Guide to SQL

A Guide to SQL

9780619159573

061915957X

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products