SQL
Practical Guide for Developers
By- Michael Donahoo, Baylor University, Waco, TX, USA
- Gregory Speegle, Baylor University, Waco, TX
Would the basics of SQL querying be useful to you, but you dont 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.
Audience
Novice developers, programmers, and database administrators. Students in database courses, business courses, and IT-related courses.
Paperback, 272 Pages
Published: August 2005
Imprint: Morgan Kaufmann
ISBN: 978-0-12-220531-6
Reviews
-
This book is not just another SQL text. The authors 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 doesnt hurt that the sample application is based on something everybody uses every day: food. Jim Melton, Oracle Corporation This books 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
Contents
- 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

