Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

A Guide to SQL (Available Titles Skills Assessment Manager (SAM) - Office 2010) 8th Edition

3.4 out of 5 stars 32 customer reviews
ISBN-13: 978-0324597684
ISBN-10: 0324597681
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $15.98
Learn More
Trade in now
Have one to sell? Sell on Amazon
Try the eTextbook for free On clicking this link, a new layer will be open
$0.00 On clicking this link, a new layer will be open
Rent On clicking this link, a new layer will be open
$23.30 On clicking this link, a new layer will be open
Buy used On clicking this link, a new layer will be open
$35.00 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$106.94 On clicking this link, a new layer will be open
More Buying Choices
22 New from $39.01 40 Used from $26.95

There is a newer edition of this item:

A Guide to SQL
$92.14
(6)
In Stock.
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Save Up to 90% on Textbooks Textbooks
$106.94 FREE Shipping. Only 9 left in stock. Ships from and sold by Amazon.com. Gift-wrap available.

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 more than 75 textbooks and has co-authored three levels of Microsoft Office Access 2013 books for this popular 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, Texas, where she was an Associate Professor and the Director of the Center for Effectiveness in Learning and Teaching. Ms. Last 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. She also authors many instructor resources for database texts.
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 69%). Print edition purchase must be sold by Amazon. Learn more.


China
Engineering & Transportation Books
Discover books for all types of engineers, auto enthusiasts, and much more. Learn more

Product Details

  • Series: Available Titles Skills Assessment Manager (SAM) - Office 2010
  • Paperback: 328 pages
  • Publisher: Course Technology; 8 edition (October 2, 2008)
  • Language: English
  • ISBN-10: 0324597681
  • ISBN-13: 978-0324597684
  • Product Dimensions: 9 x 7.3 x 0.8 inches
  • Shipping Weight: 1.2 pounds (View shipping rates and policies)
  • Average Customer Review: 3.4 out of 5 stars  See all reviews (32 customer reviews)
  • Amazon Best Sellers Rank: #129,151 in Books (See Top 100 in Books)

Important Information

Ingredients
Example Ingredients

Directions
Example Directions

Customer Reviews

Top Customer Reviews

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.
1 Comment 4 of 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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.
1 Comment 3 of 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 2 of 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 2 of 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 2 of 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I'm using this book for a class and it's seriously beyond awful. It provides very little or no detail on how to even give simple instructions on its own questions while these scripts are suppose to be extremely basic! Nearly 80% to 90% of the questions I'm looking up on my own since I haven't done SQL in over 3 years and now getting back into it as a career. This book is so cheaply written that a 30 min youtube video will not only teach it but more. Anyone who even has the nerve to call this book decent clearly has never read it or doesn't know how to find free information as basic as this which will get you nowhere in keeping any job! $86 for such a book like this should criminal behavior for anyone who dares to publish such crap.
Comment 1 of 1 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I haven't used the text yet, so I can't comment about the quality of the content. But then again, I think I'm going to give myself headaches and eye strain if I try to go past the first paragraph. For the price of this book, the print quality is totally unacceptable. The regular paragraph text is very thin, and the charts are almost unreadable. It looks like someone took a book formatted in color then cheaply photocopied it to black and white, scaling it down too. And this isn't some ripoff version, this is the real deal, direct from Amazon, properly paper-bound.
Comment 1 of 1 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
A Guide to SQL (Available Titles Skills Assessment Manager (SAM) - Office 2010)
This item: A Guide to SQL (Available Titles Skills Assessment Manager (SAM) - Office 2010)
Price: $106.94
Ships from and sold by Amazon.com