CART

(0) items

A Guide to SQL,9780619159573
This item qualifies for
FREE SHIPPING!

FREE SHIPPING OVER $59!

Your order must be $59 or more, you must select US Postal Service Shipping as your shipping preference, and the "Group my items into as few shipments as possible" option when you place your order.

Bulk sales, PO's, Marketplace Items, eBooks, Apparel, and DVDs not included.

A Guide to SQL

by
Edition:
6th
ISBN13:

9780619159573

ISBN10:
061915957X
Format:
Paperback
Pub. Date:
12/23/2002
Publisher(s):
Course Technology
List Price: $64.00
More New and Used
from Private Sellers
Starting at $0.99
See Prices

Rent Textbook

We're Sorry
Sold Out

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

New Textbook

We're Sorry
Sold Out

Related Products


  • A Guide To Sql
    A Guide To Sql
  • A Guide to SQL
    A Guide to SQL
  • A Guide to SQL
    A Guide to SQL
  • A Guide to SQL, 8th Edition
    A Guide to SQL, 8th Edition
  • Guide to SQL
    Guide to SQL




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.

Table of Contents

Prefacep. ix
Introduction to Premiere Products and Henry Booksp. 1
Objectivesp. 1
Introductionp. 2
The Premiere Products Databasep. 2
Introduction to the Henry Books Database Casep. 8
Summaryp. 15
Exercises (Premiere Products)p. 15
Exercises (Henry Books)p. 16
An Introduction to SQLp. 17
Objectivesp. 17
Introductionp. 18
Relational Databasesp. 18
Entities, Attributes, and Relationshipsp. 20
Database Creationp. 23
Running SQL Commandsp. 25
Editing SQL Commandsp. 27
Dropping a Tablep. 29
Data Typesp. 29
Nullsp. 30
Implementation of Nullsp. 31
Loading a Table with Datap. 31
The INSERT Commandp. 31
The INSERT Command with Nullsp. 34
Viewing Table Datap. 35
Correcting Errors in the Databasep. 36
Saving SQL Commandsp. 38
Creating the Remaining Database Tablesp. 38
Describing a Tablep. 42
Summaryp. 44
Key Termsp. 45
Review Questionsp. 45
Exercises (Premiere Products)p. 46
Exercises (Henry Books)p. 47
Single-Table Queriesp. 49
Objectivesp. 49
Introductionp. 50
Constructing Simple Queriesp. 50
Retrieving Certain Columns and All Rowsp. 51
Retrieving All Columns and All Rowsp. 52
Using a WHERE Clausep. 52
Using Compound Conditionsp. 54
Using the BETWEEN Operatorp. 56
Using Computed Columnsp. 57
Using the LIKE Operatorp. 59
Using the IN Operatorp. 60
Sortingp. 61
Using the ORDER BY Clausep. 61
Additional Sorting Optionsp. 62
Using Functionsp. 63
Using the COUNT Functionp. 63
Using the SUM Functionp. 64
Using the DISTINCT Operatorp. 65
Nesting Queriesp. 67
Subqueriesp. 68
Groupingp. 69
Using the GROUP BY Clausep. 70
Using a HAVING Clausep. 71
HAVING vs. WHEREp. 71
Nullsp. 73
Summaryp. 74
Key Termsp. 75
Review Questionsp. 76
Exercises (Premiere Products)p. 76
Exercises (Henry Books)p. 77
Multiple-Table Queriesp. 79
Objectivesp. 79
Introductionp. 80
Querying Multiple Tablesp. 80
Joining Two Tablesp. 80
Comparing JOIN, IN, and EXISTSp. 83
Using INp. 83
Using EXISTSp. 84
Using a Subquery within a Subqueryp. 85
A Comprehensive Examplep. 87
Using an Aliasp. 88
Joining a Table to Itselfp. 89
Joining Several Tablesp. 91
Set Operationsp. 94
ALL and ANYp. 97
Special Operationsp. 99
Inner Joinp. 100
Outer Joinp. 101
Productp. 102
Summaryp. 104
Key Termsp. 105
Review Questionsp. 105
Exercises (Premiere Products)p. 106
Exercises (Henry Books)p. 107
Updating Datap. 109
Objectivesp. 109
Introductionp. 110
Creating a New Table from an Existing Tablep. 110
Changing Existing Data in a Tablep. 111
Adding New Rows to an Existing Tablep. 113
Commit and Rollbackp. 114
Transactionsp. 115
Deleting Existing Rows from a Tablep. 116
Executing a Rollbackp. 117
Changing a Value in a Column to Nullp. 117
Changing Table Structuresp. 118
Making Complex Changesp. 122
Dropping a Tablep. 122
Summaryp. 123
Key Termsp. 124
Review Questionsp. 124
Exercises (Premiere Products)p. 125
Exercises (Henry Books)p. 126
Database Administrationp. 127
Objectivesp. 127
Introductionp. 128
Viewsp. 128
Row-and-Column Subsetsp. 134
Joinsp. 135
Statisticsp. 138
Dropping a Viewp. 138
Securityp. 138
Indexesp. 141
Creating an Indexp. 144
Dropping an Indexp. 145
Unique Indexesp. 146
System Catalogp. 146
Integrity Rules in SQLp. 149
Summaryp. 152
Key Termsp. 153
Review Questionsp. 154
Exercises (Premiere Products)p. 155
Exercises (Henry Books)p. 156
Reportsp. 159
Objectivesp. 159
Introductionp. 160
Concatenating Columnsp. 160
Creating and Using Scriptsp. 161
Running the Query for the Reportp. 162
Creating the Data for the Reportp. 163
Changing Column Headingsp. 165
Changing Column Formats in a Reportp. 166
Adding a Title to a Reportp. 168
Grouping Data in a Reportp. 170
Including Totals an Subtotals in a Reportp. 171
Sending the Report to a Filep. 173
Completing the Script to Produce the Reportp. 175
Summaryp. 178
Key Termsp. 179
Review Questionsp. 180
Exercises (Premiere Products)p. 180
Exercises (Henry Books)p. 183
Embedded SQLp. 187
Objectivesp. 187
Introductionp. 188
Using Prompt Variablesp. 189
PL/SQL Programsp. 190
Retrieving a Single Row and Columnp. 190
Using the %TYPE Attributep. 192
Retrieving a Single Row from a Joinp. 192
Inserting a Row into a Tablep. 193
Changing a Single Row in a Tablep. 195
Deleting Rows from a Tablep. 195
Deleting Rows from Multiple Tablesp. 196
Multiple-Row Selectp. 197
Using Cursorsp. 197
Opening a Cursorp. 198
Fetching Rows from a Cursorp. 199
Closing a Cursorp. 201
Complete Program Using a Cursorp. 201
More Complex Cursorsp. 202
Advantages of Cursorsp. 204
Updating Cursorsp. 205
Error Handlingp. 207
Using SQL in Microsoft Access Programsp. 207
Deleting Rowsp. 208
Running the Codep. 209
Updating Rowsp. 210
Inserting Rowsp. 211
Finding Rowsp. 211
Summaryp. 213
Key Termsp. 214
Review Questionsp. 214
Exercises (Premiere Products)p. 215
Exercises (Henry Books)p. 216
SQL Referencep. 217
Aliasesp. 218
Alter Tablep. 218
Column or Expression List (Select Clause)p. 218
Computed Columnsp. 219
The Distinct Operatorp. 219
Functionsp. 219
Commitp. 219
Conditionsp. 220
Simple Conditionsp. 220
Compound Conditionsp. 220
Between Conditionsp. 221
Like Conditionsp. 221
In Conditionsp. 221
Exists Conditionsp. 222
All and Anyp. 222
Create Indexp. 222
Create Tablep. 223
Create Viewp. 223
Data Typesp. 224
Delete Rowsp. 225
Drop Indexp. 225
Drop Tablep. 225
Drop Viewp. 226
Grantp. 226
Insert Into (Query)p. 227
Insert Into (Values)p. 227
Integrityp. 228
Revokep. 228
Rollbackp. 229
Selectp. 229
Subqueriesp. 230
Union, Intersect, and Minusp. 230
Updatep. 232
"How do I" Referencep. 233
Answers to Odd-Numbered Review Questionsp. 237
Chapter 1--Introduction to Premiere Products and Henry Booksp. 238
Chapter 2--An Introduction to SQLp. 238
Chapter 3--Single-Table Queriesp. 239
Chapter 4--Multiple-Table Queriesp. 239
Chapter 5--Updating Datap. 240
Chapter 6--Database Administrationp. 240
Chapter 7--Reportsp. 241
Chapter 8--Embedded SQLp. 241
Indexp. 243
Table of Contents provided by Ingram. All Rights Reserved.


Please wait while the item is added to your cart...