Learning SQL: A Step-by-Step Guide Using Access [Paperback]

Sikha Bagui (Author), Richard Earp (Author)

Book Description

ISBN-10: 0321119045 | ISBN-13: 978-0321119049 | Publication Date: February 20, 2003 | Edition: US ed

Learning SQL: A Step-By-Step Guide Using Access is a brief, hands-on tutorial covering the basics of using SQL, as well as using the Access database engine with SQL. It assumes no previous knowledge of programming or databases. The book focuses on providing an introduction to beginning SQL tasks. Throughout the chapters, readers are taken through various beginning aspects of SQL. At the end of each chapter, a series of exercises is provided to facilitate the practice of these newly learned skills. Throughout the book, common pitfalls and style tips are called out in margin boxes. With this book, readers learn not only the basics, but also gain insight into how these are used by professional Access SQL programmers.

Product Details

• Paperback: 336 pages
• Publisher: Addison Wesley; US ed edition (February 20, 2003)
• Language: English
• ISBN-10: 0321119045
• ISBN-13: 978-0321119049
• Product Dimensions: 9.2 x 7.9 x 0.7 inches
• Shipping Weight: 1.3 pounds
• Average Customer Review: 3.0 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #1,163,402 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

16 of 16 people found the following review helpful:

2.0 out of 5 stars An "okay" book but it has numerous errors, October 31, 2004

By 

Brian Kopinsky (Denver, CO) - See all my reviews
(REAL NAME)   

This review is from: Learning SQL: A Step-by-Step Guide Using Access (Paperback)

The pace is very slow for the really basic stuff while more sophisticated techniques, such as correlated sub-queries, are not explained well enough.

There are numerous errors in the book which suggest the authors don't really know Microsoft Access. Clearly, some of the worked problems were only tried on paper and not through Access itself. Significant errors appear in the discussion of data types (pp. 58 - 81), joins (p. 105), calculations with dates (p. 145), null constraints (p. 282) and referential integrity (p. 288). The downloadable example database does not comply with modern database design protocols.

For a much better book, try "SQL Queries for Mere Mortals" by Hernandez & Viescas.

15 of 15 people found the following review helpful:

2.0 out of 5 stars Use only if desperate to find an SQL book for Access, November 26, 2003

By A Customer

This review is from: Learning SQL: A Step-by-Step Guide Using Access (Paperback)

I know the pickings are slim for finding a book to learn SQL using Access, but PLEASE can't someone who knows how to teach and cares about getting their information correct write one? First off, this book has many errors including some statements that work OPPOSITE to the statements. Ex: On page 105 the description for "Nested LEFT and RIGHT OUTER JOINs" reads "In Access, A LEFT JOIN or a RIGHT JOIN can be nested inside an INNER JOIN, but an INNER JOIN cannot be nested inside a LEFT JOIN or a RIGHT JOIN." NO. NO. NO. It works in the opposite way.

The tables to be used in the book tutorials often bear no relationship at all to the fields or to the data and some of the naming produces run errors-- creating a frustrating experience for a student. This was obviously no labor of love for the authors, but a slapdash method to pump out a book. It is a crime that there was no quality assurance on this book. That alone would have caught the worst of it. For shame to all associated with its publication.

I generously gave it two stars just because it is probably better than nothing, but not much better. Again, here's a call to all of you SQL trainers out there: your market is wide open.

2 of 5 people found the following review helpful:

5.0 out of 5 stars Excellent book to use to TEACH SQL (using Access), December 15, 2003

By A Customer

This review is from: Learning SQL: A Step-by-Step Guide Using Access (Paperback)

This is an excellent book to use to teach students SQL in a very inexpensive way -- using Access. Although the book may not be in-depth enough for professionals, the authors do a great job of presenting the material in a very user friendly and systematic way for beginner students.