+612 9045 4394
 
CHECKOUT
SQL : Practical Guide for Developers - Michael J. Donahoo

SQL

Practical Guide for Developers

Paperback Published: 1st March 2005
ISBN: 9780122205316
Number Of Pages: 272

Share This Book:

Paperback

$89.95
or 4 easy payments of $22.49 with Learn more
Ships in 10 to 15 business days

Would the basics of SQL querying be useful to you, but you don't want to start at the very beginning? Do you wish you had an easy way to ramp up quickly to get a basic understanding of key features and capability? Then you need this book Without a ton of conceptual information or general programming basics you already know, this book is a quick guide for computing professionals and programmers to learn the basics--and more--in an easily digestible way.
+ Provides tutorial-based instruction for the main features of SQL for programmers and other technical professionals in need of a brief but really good introduction to SQL.
+ The approach is vendor-neutral-so very adaptable and flexible-but the book's Web site includes information about DBMS-specific peculiarities.
+ The focus is on teaching concepts by walking through concrete examples and explanations, and self-review exercises are included at the end of each chapter.
+ Coverage is on the key features of the language that are required to understand SQL and begin using it effectively.
+ SQL 2003-compliant.

"This book is not just another SQL text. The author's use of simple yet clear examples to illustrate difficult concepts throughout the text makes this a perfect book for use in an introductory database systems class as a supplement or as an introductory reference for the novice practitioner." - Paul Fortier, University of Massachusetts, Dartmouth "The book lives up to its title: it is a very practical guide. The authors clearly know their SQL and manage to write about the language in a step-by-step style that progresses smoothly from the simple to the more difficult aspects of the language. The profuse use of examples, each with an accompanying motivation and explanation of the results, lets the reader follow even complex topics without a constant struggle. The authors have even included examples that illustrate common errors programmers make, explaining the right way to perform the task. It doesn't hurt that the sample application is based on something everybody uses every day: food." - Jim Melton, Oracle Corporation "This book's authors recognize the vast majority of work done with a database is data retrieval (rather than storage) and have focused on this area." - Australian Personal Computer, March 2006

Databasicsp. 1
Tablesp. 3
Data Typesp. 4
Character Stringp. 4
Numericp. 5
Temporalp. 6
Binaryp. 7
Booleanp. 8
Other Data Typesp. 8
NULLp. 8
Primary Keyp. 9
Table Relationshipsp. 9
Foreign Keyp. 10
Relationship Typesp. 11
Schemasp. 14
Restaurant Databasep. 15
Wrap Upp. 21
Retrieval: Basic SELECTionp. 27
Simple SELECTp. 27
Selecting Rowsp. 30
Standard Comparison Operatorsp. 30
String Comparisonsp. 31
Matching String Patterns with LIKEp. 33
Getting What We Haven't Got with NOTp. 34
Combining Conditions with AND and ORp. 35
Selecting a Range of Values with BETWEENp. 37
Selecting a Set of Values Using INp. 38
IS NULL: Exploring the Unknownp. 38
ANDs, ORs, NOTs with NULLs: Three-Valued Logicp. 41
Three-Valued Logic and the IN Operatorp. 42
How WHERE Determines What's In and Outp. 43
Wrap Upp. 43
Reshaping Resultsp. 47
AS: Naming Result Table Columnsp. 47
DISTINCT and ALL: Dealing with Duplicatesp. 48
Derived Attributesp. 50
Numericp. 50
Character Stringp. 52
Temporalp. 57
Binaryp. 59
Computation in the WHERE Clausep. 60
ORDER BY: Ordering Result Table Traversalp. 61
CAST: Data Type Conversionp. 64
CASE, COALESCE, and NULLIF: Conditional Expressionsp. 66
CASE: Value Listp. 66
CASE: Conditional Listp. 67
NULLIFp. 69
COALESCEp. 70
Wrap Upp. 70
Aggregating Resultsp. 75
Aggregation Functionsp. 75
AVG and SUMp. 75
MIN and MAXp. 76
COUNTp. 77
Removing Rows before Aggregation with WHEREp. 78
Removing Repeating Data with DISTINCT before Aggregationp. 79
Mixing Attributes, Aggregates, and Literalsp. 79
Group Aggregation Using GROUP BYp. 80
Removing Rows before Grouping with WHEREp. 82
Sorting Groups with ORDER BYp. 83
Removing Groups with HAVINGp. 83
Aggregates over Expressionsp. 85
Wrap Upp. 87
Joinsp. 91
Two Table Joins with WHEREp. 91
Table Aliasesp. 94
Joins Needing More Than Two Tablesp. 95
Self-Join: Joining a Table with Itselfp. 97
Example Joinsp. 97
How Does a Join Really Work?p. 99
Theta Joins: Generalizing Join Predicatesp. 101
JOIN Operatorp. 104
Inner Joinp. 104
Outer Joinp. 106
Natural Joinp. 109
Cross Joinp. 111
Join Strategiesp. 111
Wrap Upp. 112
Set Queries: UNION, INTERSECT, and EXCEPTp. 117
Unionp. 117
Intersectp. 120
Exceptp. 121
Wrap Upp. 124
Subqueriesp. 127
What Are Subqueries?p. 127
Multilevel Subquery Nestingp. 132
Subqueries Using NOT INp. 134
Subqueries with Empty Resultsp. 136
Combining JOIN and Subqueriesp. 137
Standard Comparison Operators with Lists Using ANY, SOME, or ALLp. 138
ANY or SOMEp. 139
Allp. 142
Correlated Subqueriesp. 144
Existsp. 146
Derived Relations-Subqueries in the FROM Clausep. 148
Subqueries in the HAVING Clausep. 150
Subset Queriesp. 151
Subset Using EXISTS and EXCEPTp. 152
Subset Using Set Cardinalityp. 155
Comparing Set Cardinality and Subsetsp. 156
Subqueries in the SELECT Clausep. 157
Wrap Upp. 159
Modifying Datap. 165
INSERT: Adding New Rowsp. 165
INSERTing a Row with VALUESp. 165
INSERTing Multiple Rows with SELECTp. 168
DELETE: Removing Rowsp. 169
UPDATE: Changing Row Valuesp. 171
Testing Your DELETE and UPDATE WHERE Conditionsp. 174
Living within Constraintsp. 174
Wrap Upp. 176
Creating, Deleting, and Altering Tablesp. 179
Creating Simple Tablesp. 179
DEFAULT Valuesp. 180
Constraintsp. 181
Not Nullp. 181
Uniquep. 182
Primary Keyp. 183
Foreign Keyp. 184
Checkp. 185
Naming Constraintsp. 186
Creating a Table from Tablesp. 187
Create Domainp. 188
Referential Actions: The Autopilot of Foreign Key Maintenancep. 189
Indexesp. 190
Create Indexp. 191
Drop Indexp. 192
Indexes Are NOT in SQL 2003p. 192
Drop Tablep. 192
Alter Tablep. 193
Generated Valuesp. 195
Sequencesp. 195
Global and Local Temporary Tablesp. 197
Creating a Databasep. 198
Wrap Upp. 199
Viewsp. 205
Why Views?p. 206
Querying Viewsp. 207
Updating Viewsp. 209
Drop Viewp. 211
Wrap Upp. 211
Transactionsp. 215
Ending a Transaction-COMMIT and ROLLBACKp. 217
Starting a Transaction-START TRANSACTIONp. 217
Auto-Commitp. 218
SAVEPOINTsp. 218
Immediate or Deferred Constraintsp. 219
Testing Changes with Transactionsp. 221
Transaction Characteristicsp. 222
Locking Issuesp. 223
Wrap Upp. 223
Database Privilegesp. 227
Grantp. 228
Revokep. 230
Publicp. 230
Creating a Set of Privileges Using ROLEsp. 231
Using Privileges and Viewsp. 232
Wrap Upp. 233
Introduction to Cursors, Embedded SQL, Stored Procedures, and Triggersp. 237
CURSORsp. 237
Programming with SQLp. 239
Stored Proceduresp. 239
Executing SQL in Other Programming Languagesp. 240
Triggersp. 243
Create Triggerp. 243
Trigger Firing Rulesp. 245
Drop Triggerp. 245
Using Triggersp. 245
Wrap Upp. 246
Indexp. 249
Table of Contents provided by Ingram. All Rights Reserved.

ISBN: 9780122205316
ISBN-10: 0122205316
Series: The Practical Guides
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 272
Published: 1st March 2005
Publisher: Elsevier Science & Technology
Country of Publication: US
Dimensions (cm): 23.5 x 19.1  x 1.5
Weight (kg): 0.54