The Morgan Kaufmann Data Management Systems

Practical Guide for Developers

By: Michael J. Donahoo, Gregory D. Speegle

Write A Review

1 August 2005

At a Glance

No. of Pages
272

Dimensions(cm)
23.5 x 19.05 x 1.27

RRP $59.95

$58.75

or 4 interest-free payments of $14.69 with

Ships in 5 to 7 business days

SQL is a solid guide and reference to the key elements of SQL and how to use it effectively. Developed by authors who needed a good resource for students in their database class, this is an ideal supplement for database courses - no matter what main text you use or what flavor of SQL is required.

It features a short and inexpensive introduction to SQL for students who have some programming experience and need to learn the main features of SQL; and suggested shortcuts for learning and practice, depending on the experience of the user.

This book is recommended for novice developers, programmers, and database administrators as well as students in database courses, business courses, and IT-related courses.

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
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.

Industry Reviews

"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

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $0.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Programming & Software Development Database Programming Engineering & Technology Technology in General Databases Programming & Scripting Languages Library & Info Sciences Library

Databasics	p. 1
Tables	p. 3
Data Types	p. 4
Character String	p. 4
Numeric	p. 5
Temporal	p. 6
Binary	p. 7
Boolean	p. 8
Other Data Types	p. 8
NULL	p. 8
Primary Key	p. 9
Table Relationships	p. 9
Foreign Key	p. 10
Relationship Types	p. 11
Schemas	p. 14
Restaurant Database	p. 15
Wrap Up	p. 21
Retrieval: Basic SELECTion	p. 27
Simple SELECT	p. 27
Selecting Rows	p. 30
Standard Comparison Operators	p. 30
String Comparisons	p. 31
Matching String Patterns with LIKE	p. 33
Getting What We Haven't Got with NOT	p. 34
Combining Conditions with AND and OR	p. 35
Selecting a Range of Values with BETWEEN	p. 37
Selecting a Set of Values Using IN	p. 38
IS NULL: Exploring the Unknown	p. 38
ANDs, ORs, NOTs with NULLs: Three-Valued Logic	p. 41
Three-Valued Logic and the IN Operator	p. 42
How WHERE Determines What's In and Out	p. 43
Wrap Up	p. 43
Reshaping Results	p. 47
AS: Naming Result Table Columns	p. 47
DISTINCT and ALL: Dealing with Duplicates	p. 48
Derived Attributes	p. 50
Numeric	p. 50
Character String	p. 52
Temporal	p. 57
Binary	p. 59
Computation in the WHERE Clause	p. 60
ORDER BY: Ordering Result Table Traversal	p. 61
CAST: Data Type Conversion	p. 64
CASE, COALESCE, and NULLIF: Conditional Expressions	p. 66
CASE: Value List	p. 66
CASE: Conditional List	p. 67
NULLIF	p. 69
COALESCE	p. 70
Wrap Up	p. 70
Aggregating Results	p. 75
Aggregation Functions	p. 75
AVG and SUM	p. 75
MIN and MAX	p. 76
COUNT	p. 77
Removing Rows before Aggregation with WHERE	p. 78
Removing Repeating Data with DISTINCT before Aggregation	p. 79
Mixing Attributes, Aggregates, and Literals	p. 79
Group Aggregation Using GROUP BY	p. 80
Removing Rows before Grouping with WHERE	p. 82
Sorting Groups with ORDER BY	p. 83
Removing Groups with HAVING	p. 83
Aggregates over Expressions	p. 85
Wrap Up	p. 87
Joins	p. 91
Two Table Joins with WHERE	p. 91
Table Aliases	p. 94
Joins Needing More Than Two Tables	p. 95
Self-Join: Joining a Table with Itself	p. 97
Example Joins	p. 97
How Does a Join Really Work?	p. 99
Theta Joins: Generalizing Join Predicates	p. 101
JOIN Operator	p. 104
Inner Join	p. 104
Outer Join	p. 106
Natural Join	p. 109
Cross Join	p. 111
Join Strategies	p. 111
Wrap Up	p. 112
Set Queries: UNION, INTERSECT, and EXCEPT	p. 117
Union	p. 117
Intersect	p. 120
Except	p. 121
Wrap Up	p. 124
Subqueries	p. 127
What Are Subqueries?	p. 127
Multilevel Subquery Nesting	p. 132
Subqueries Using NOT IN	p. 134
Subqueries with Empty Results	p. 136
Combining JOIN and Subqueries	p. 137
Standard Comparison Operators with Lists Using ANY, SOME, or ALL	p. 138
ANY or SOME	p. 139
All	p. 142
Correlated Subqueries	p. 144
Exists	p. 146
Derived Relations-Subqueries in the FROM Clause	p. 148
Subqueries in the HAVING Clause	p. 150
Subset Queries	p. 151
Subset Using EXISTS and EXCEPT	p. 152
Subset Using Set Cardinality	p. 155
Comparing Set Cardinality and Subsets	p. 156
Subqueries in the SELECT Clause	p. 157
Wrap Up	p. 159
Modifying Data	p. 165
INSERT: Adding New Rows	p. 165
INSERTing a Row with VALUES	p. 165
INSERTing Multiple Rows with SELECT	p. 168
DELETE: Removing Rows	p. 169
UPDATE: Changing Row Values	p. 171
Testing Your DELETE and UPDATE WHERE Conditions	p. 174
Living within Constraints	p. 174
Wrap Up	p. 176
Creating, Deleting, and Altering Tables	p. 179
Creating Simple Tables	p. 179
DEFAULT Values	p. 180
Constraints	p. 181
Not Null	p. 181
Unique	p. 182
Primary Key	p. 183
Foreign Key	p. 184
Check	p. 185
Naming Constraints	p. 186
Creating a Table from Tables	p. 187
Create Domain	p. 188
Referential Actions: The Autopilot of Foreign Key Maintenance	p. 189
Indexes	p. 190
Create Index	p. 191
Drop Index	p. 192
Indexes Are NOT in SQL 2003	p. 192
Drop Table	p. 192
Alter Table	p. 193
Generated Values	p. 195
Sequences	p. 195
Global and Local Temporary Tables	p. 197
Creating a Database	p. 198
Wrap Up	p. 199
Views	p. 205
Why Views?	p. 206
Querying Views	p. 207
Updating Views	p. 209
Drop View	p. 211
Wrap Up	p. 211
Transactions	p. 215
Ending a Transaction-COMMIT and ROLLBACK	p. 217
Starting a Transaction-START TRANSACTION	p. 217
Auto-Commit	p. 218
SAVEPOINTs	p. 218
Immediate or Deferred Constraints	p. 219
Testing Changes with Transactions	p. 221
Transaction Characteristics	p. 222
Locking Issues	p. 223
Wrap Up	p. 223
Database Privileges	p. 227
Grant	p. 228
Revoke	p. 230
Public	p. 230
Creating a Set of Privileges Using ROLEs	p. 231
Using Privileges and Views	p. 232
Wrap Up	p. 233
Introduction to Cursors, Embedded SQL, Stored Procedures, and Triggers	p. 237
CURSORs	p. 237
Programming with SQL	p. 239
Stored Procedures	p. 239
Executing SQL in Other Programming Languages	p. 240
Triggers	p. 243
Create Trigger	p. 243
Trigger Firing Rules	p. 245
Drop Trigger	p. 245
Using Triggers	p. 245
Wrap Up	p. 246
Index	p. 249
Table of Contents provided by Ingram. All Rights Reserved.

The Morgan Kaufmann Data Management Systems

Practical Guide for Developers

At a Glance

Industry Reviews

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Library

Data Mining and Predictive Analysis

Intelligence Gathering and Crime Analysis

Decolonizing the Public Library

Activities for Evidence-Based Practice in Healthcare

A Practical Guide

Decolonising the Public Library

Empowering Library Staff and Customers

Building a Culture of Teamwork and Trust

Empowering Library Staff and Customers

Building a Culture of Teamwork and Trust

From Chaos to Order

Addressing Cognitive Overload in the Learning Journey

American Association for State and Local History

A Guide for Both Physical and Digital Collections

American Association for State and Local History

A Guide for Both Physical and Digital Collections

Medical Library Association Books

Understanding the Grant Process from Start to Finish

Medical Library Association Books

Understanding the Grant Process from Start to Finish

A Practical Guidebook to Trauma-Informed Archival Practice

Best Practices and Case Studies

A Practical Guidebook to Trauma-Informed Archival Practice

Best Practices and Case Studies

An Archivist's Guide to Copyright

Navigating Risk Management

An Archivist's Guide to Copyright

Navigating Risk Management

AI and Digital Leadership

Transforming Libraries, Archives, and Museums for the Future

Beta Phi Mu Scholars

Beta Phi Mu Scholars Series

Beta Phi Mu Scholars

Beta Phi Mu Scholars Series

Knowledge into Action

Research Methods for Library, Archives, and Museum Professionals

Knowledge Into Action

Research Methods for Library, Archives, and Museum Professionals

50 Library Lessons and Ideas

Public Libraries and Homelessness

A Practical Guide

Primary Research and Writing

People, Places, and Spaces

Primary Research and Writing

People, Places, and Spaces

This product is categorised by