Purchase textbook

SQL,

Edition 1 Practical Guide for Developers

Editors: By Michael J. Donahoo and Gregory D. Speegle

Publication Date: 01 Aug 2005

0 Reviews

Ways Of Reading

This e-publication is accessible to the full extent that the file format and types of content allow, on a specific reading device, by default, without necessarily including any additions such as textual descriptions of images or enhanced navigation.

Navigation

The contents of the PDF have been tagged to permit access by assistive technologies as per PDF-UA-1 standard.
Page breaks included from the original print source

Additional Accessibility Information

All (or substantially all) textual matter is arranged in a single logical reading order (including text that is visually presented as separate from the main text flow, e.g., in boxouts, captions, tables, footnotes, endnotes, citations, etc.). Non-textual content is also linked from within this logical reading order. (Purely decorative non-text content can be ignored).
The language of the text has been specified (e.g., via the HTML or XML lang attribute) to optimise text-to-speech (and other alternative renderings), both at the whole document level and, where appropriate, for individual words, phrases or passages in a different language.

Conformance

The publication was certified on 20250625
Accessibility addendum
For detailed accessibility information, see Elsevier’s website at https://www.elsevier.com/about/accessibility
For queries regarding accessibility information, contact [email protected]

Note

This product relies on 3rd party tooling which may impact the accessibility features visible in inspection copies. All accessibility features mentioned would be present in the purchased version of the title.

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.

Key Features

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.

About the author

By Michael J. Donahoo, Baylor University, Waco, TX, USA and Gregory D. Speegle, Baylor University, Waco, TX

Chapter 1: Databasics • Chapter 2: Single Table Retrieval • Chapter 3: Taming Tables • Chapter 4: Aggregating Results • Chapter 5: Multiple Table Queries using Simple Subqueries • Chapter 6: Multiple Table Queries Using Joins • Chapter 7: Set Based Queries • Chapter 8: Advanced Subqueries • Chapter 9: Creating a Database • Chapter 10: Database Data • Chapter 11: Transaction Management • Chapter 12: Authorization • Chapter 13: Advanced Topics • Chapter 14: SQL Programming

Title 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

ISBN: 9780122205316

Page Count: 272

Retail Price (USD) :

TCP/IP Sockets in C, Donahoo, MK ISBN:1558608265 and 1558606866
The Struts Framework, Spielman, MK ISBN:1558608621 10,800 copies sold
SQL for Smarties, Celko, MK, Oct 99, 550 pages. ISBN 1558605762

SQL,

Editors: By Michael J. Donahoo and Gregory D. Speegle

Description

Key Features

About the author

Title Reviews

Related Titles