Programming Books C Java PHP Python Learn more Browse Programming Books
  • List Price: $105.95
  • Save: $57.44(54%)
Rented from RentU
To Rent, select Shipping State from options above
Due Date: Dec 21, 2014
FREE return shipping at the end of the semester. Access codes and supplements are not guaranteed with rentals.
Qty:1
  • List Price: $105.95
  • Save: $21.39 (20%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $50.75
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

A Guide to SQL Paperback – October 2, 2008

ISBN-13: 978-0324597684 ISBN-10: 0324597681 Edition: 8th

Buy New
Price: $84.56
Rent
Price: $26.48 - $48.51
22 New from $84.56 51 Used from $78.01
Rent from Amazon Price New from Used from
Kindle
"Please retry"
$31.49
Paperback
"Please retry"
$26.48
$84.56
$84.56 $78.01

There is a newer edition of this item:

A Guide to SQL
$92.61
This title has not yet been released.

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student



Frequently Bought Together

A Guide to SQL + Concepts of Database Management
Price for both: $178.26

Buy the selected items together

Customers Who Bought This Item Also Bought

If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle edition for only $9.99 (Save 86%). Print edition purchase must be sold by Amazon. Learn more.

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 328 pages
  • Publisher: Cengage Learning; 8 edition (October 2, 2008)
  • Language: English
  • ISBN-10: 0324597681
  • ISBN-13: 978-0324597684
  • Product Dimensions: 9.1 x 7.5 x 0.8 inches
  • Shipping Weight: 1.2 pounds (View shipping rates and policies)
  • Average Customer Review: 3.7 out of 5 stars  See all reviews (19 customer reviews)
  • Amazon Best Sellers Rank: #16,512 in Books (See Top 100 in Books)

Editorial Reviews

Review

1. An Introduction to Premiere Products, Henry Books, and Alexamara Marina Group. 2. Database Design Fundamentals. 3. An Introduction to SQL. 4. Single-Table Queries. 5. Multiple-Table Queries. 6. Updating Data. 7. Database Administration. 8. SQL Functions and Procedures. Appendix A: SQL Reference. Appendix B: "How do I" Reference. Appendix C: Answers to Odd-Numbered Review Questions.

About the Author

Philip J. Pratt is Professor Emeritus of Mathematics and Computer Science at Grand Valley State University, where he taught for 33 years. His teaching interests include database management, systems analysis, complex analysis, and discrete mathematics. He has authored over 75 textbooks, including coauthoring three levels of Microsoft Office Access 2013 books for the Shelly Cashman Series and A Guide to SQL.

Mary Z. Last has taught computer information systems since 1984. She retired from the University of Mary Hardin-Baylor, Belton, TX where she was an Associate Professor and the Director of the Center for Effectiveness in Learning and Teaching. Mary is actively involved in the Computing Educator's Oral History Project that encourages young women to pursue careers in math and science. She has been a contributing author to the Shelly Cashman Series since 1992 and also authors many instructor resources for database texts.

Customer Reviews

3.7 out of 5 stars
5 star
7
4 star
4
3 star
6
2 star
0
1 star
2
See all 19 customer reviews
It is very helpful and make SQL coding easy.
TextBookBuyer
The book assumes the reader either understands database theory or is taking a database concepts course and is required to also learn SQL.
J. Guthrie
It is not very long and the pages look like the publisher went printed them on a copier at the local public library.
lwright22

Most Helpful Customer Reviews

4 of 4 people found the following review helpful By J. Guthrie on January 9, 2009
Format: Paperback
My comments are about the 6th and 7th editions of the book. It was the required text for a college course about Structured Query Language. The school offered other courses about database theory and design. The book only covers SQL. It is not about database theory or database design. The book assumes the reader either understands database theory or is taking a database concepts course and is required to also learn SQL.

In the first chapter it presents 2 (6th) or 3 (7th) databases that are used throughout the book to teach SQL. The chapters are relatively short but are packed with material and have summaries, lists of key terms, review questions and plenty of exercises (for each database). We were required to work through all the end-of-chapter sections.

I believe you can best learn sql by using it and the chapter exercises allow you to do that. The database we used was MS Access and the sample databases were already set up for us. The book comments on differences in SQL syntax between various popular databases.

I was surprised to read some of the negative comments made by other posters although some of them were about earlier editions. Don't buy this book expecting to learn database theory or design; it has a narrow focus, as the title suggests: SQL.

I still refer back to this book, among others, when I have a question about SQL syntax.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Joshua Karpen on October 16, 2012
Format: Paperback Verified Purchase
This book is great for a beginner learning SQL programming. It was assigned in my Intro to SQL Class. I think having an instructor guiding you is important, but this book could still teach someone learning on their own. They walk you through the fundamentals of using SQL - creating tables, altering data, running basic to intermediate queries, creating indexes and views... and in the last chapter they start talking about more advanced stuff like Stored Procedures, cursors, and some specifics of T-SQL.

This book was designed as a true basic guide to SQL, so they give you the most fundamental way of doing something, then explain how that would look different in various DBMS's like Oracle, Access, SQL Sever. Some people will probably be confused by the different rules of each DBMS - I would say focus on the one(s) you are actually using or able to use. At work I use SQL Server, but at home (where I was doing my homework) I was only able to use Access. So I focused on those two. Would I be slower if I tried to jump into Oracle tomorrow? Yes, but I have a good enough understanding of the basics of using SQL that I know I could get started in Oracle, and be able to solve simple syntax problems by referencing back to this book or going online. And if I wanted to be an Oracle expert, I would take an Oracle specific course, of which there are many.

Last thought - especially if you are tackling this book on your own, you must do the exercises at the back of each chapter, at least for 2 of the 3 example databases. As our instructor explained it, repetition is key. Just like sports - someone can tell you how to shoot a jump ball, but you need to go out and do it a few hundred times to actually be decent at it. The exercises in the book provide the repetition you need to master these concepts. Some of it may seem menial at first, but they will make working in SQL second nature for you.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By S. Jackson on November 16, 2013
Format: Paperback Verified Purchase
This book was an optional text in a database class I am taking. The professor said it was one of the best books he came across for those just learning SQL. Since I'm new to SQL and database design in general I ended up picking this book up.

Aside from another book that I have related to database design, this is the only other database that I own that covers SQL commands. I don't really have any other point of reference to compare this book to in terms other SQL books, but I have to say that I am satisfied with the content of this one. The examples are clear and easy to understand for someone with no experience. If someone is new to SQL I would recommend this book.

I knock one star off the book due to the page and print quality. It doesn't feel like a high quality printing. Comes off as kind of cheaply done.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Eric @ UCSD Student on May 30, 2013
Format: Paperback Verified Purchase
This book is easy to reference and place sticky notes for referencing. It made my class effortless and worth keeping on your bookshelf.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By stacyb314 on January 8, 2013
Format: Paperback Verified Purchase
I had to buy this book for my database class at UMSL. It was an easy read and you didn't feel like you were going to fall asleep the entire time you read it. My class used Oracle so that also helped alot.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 3 people found the following review helpful By James True on August 8, 2010
Format: Paperback Verified Purchase
This is a complete and clear introductory text book. It covers the basics throughly. The material is presented logically and is easy to follow and understand. My one complaint is the use of gray boxes for impotent notes and additional information. The gray background screening is so dark that I could only read it in a brightly lit room. It appears the text was originally designed to be printed in color but went to production in B&W without any formatting adjustments. As with all college texts, it is seriously over priced, but what can you do?
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
By Desire Nyathi on March 11, 2014
Format: Paperback Verified Purchase
Worked perfect and I love the product. I am happy and will buy more if need be. Keep it up
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback Verified Purchase
I tended to skim through the chapters since it had so much content. It constantly asked this questions about the three databases at the beginning when I just wanted the information which it does have
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Most Recent Customer Reviews

Search

What Other Items Do Customers Buy After Viewing This Item?