Industrial-Sized Deals Shop all Back to School Shop Men's Hightops Learn more nav_sap_plcc_6M_fly_beacon Cecile McLorin Salvant $5 Off Fire TV Stick Shop Popular Services hog hog hog  Amazon Echo Starting at $99 Kindle Voyage Nintendo Digital Games Gear Up for Football Deal of the Day
SQL All-in-One For Dummies and over one million other books are available for Amazon Kindle. Learn more
+ $3.99 shipping
Used: Good | Details
Condition: Used: Good
Comment: Book shows minor use. Cover and Binding have minimal wear, and the pages have only minimal creases. Free State Books. Never settle for less.
Access codes and supplements are not guaranteed with used items.
Qty:1
  • List Price: $39.99
  • Save: $11.26 (28%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
SQL All-in-One For Dummie... has been added to your Cart
Sell yours for a Gift Card
We'll buy it for $10.91
Learn More
Trade in now
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 all 2 images

SQL All-in-One For Dummies Paperback – April 5, 2011

31 customer reviews
ISBN-13: 978-0470929964 ISBN-10: 0470929960 Edition: 2nd

Buy New
Price: $28.73
45 New from $22.43 21 Used from $21.19
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$28.73
$22.43 $21.19
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


InterDesign Brand Store Awareness Rent Textbooks
$28.73 FREE Shipping on orders over $35. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

SQL All-in-One For Dummies + Sql Guide (Quick Study: Sql) + SQL in 10 Minutes, Sams Teach Yourself (4th Edition)
Price for all three: $55.90

Buy the selected items together

Editorial Reviews

From the Back Cover

Want to be a database diva or the office's information oracle? Do it with SQL — here's how!

SQL does one thing, and it does that better than any other language: it handles data in relational databases. SQL lets you create databases, manipulate the data in them, retrieve information, control who has access, and much more. Whether you're new to SQL or an old hand who wants to supercharge your database, find help in one of these minibooks!

  • The overview — Books I and II give you the nitty-gritty about SQL, relational databases, and the System Development Life Cycle

  • If you have queries — learn the fine points of making SQL retrieve exactly what you want from the database and no more

  • Safety first — discover the tools SQL provides to protect your vital data and handle any errors that occur

  • Integrating SQL with other languages — understand how SQL works with Visual Basic, Java, C++, and XML

  • Turbocharge your database — fine-tune and optimize your databases to keep them performing optimally

Visit the companion Web site at www.dummies.com/go/sqlaiofd2e to download a zip file that contains all the sample code used in this book

Open the book and find:

  • Details of how SQL works

  • SQL data types

  • Why the System Development Life Cycle matters

  • Directions for structuring SQL queries

  • Tips for protecting your database from user errors

  • Sample applications you can use

  • Ways to track down and eliminate bottlenecks

  • Definitions of common SQL terms

8 Books in 1

  • SQL Concepts

  • Relational Database Development

  • SQL Queries

  • Data Security

  • SQL and Programming

  • SQL and XML

  • Database Tuning Overview

  • Appendices

About the Author

Allen G. Taylor is a 30-year veteran of the computer industry and the author of 30 books, including Cruise for Free, SQL For Dummies, 8th Edition, Crystal Reports 2008 For Dummies, Database Development For Dummies, Access Power Programming with VBA, and SQL All-In-One For Dummies, Second Edition. He lectures internationally on astronomy, databases, innovation, and entrepreneurship. He also teaches database development and Crystal Reports through a leading online education. For the latest news on Allen's activities, check out DatabaseCentral.Info or his blog at moontube.wordpress.com.

NO_CONTENT_IN_FEATURE

Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

Product Details

  • Paperback: 744 pages
  • Publisher: For Dummies; 2 edition (April 5, 2011)
  • Language: English
  • ISBN-10: 0470929960
  • ISBN-13: 978-0470929964
  • Product Dimensions: 7.4 x 1.4 x 9.3 inches
  • Shipping Weight: 1.9 pounds (View shipping rates and policies)
  • Average Customer Review: 4.1 out of 5 stars  See all reviews (31 customer reviews)
  • Amazon Best Sellers Rank: #32,917 in Books (See Top 100 in Books)

More About the Author

Allen G. Taylor is a 30-year veteran of the computer industry and the author of 30 books, including Cruise for Free, SQL For Dummies, 8th Edition, Crystal Reports 2008 For Dummies, Database Development For Dummies, Access Power Programming with VBA, and SQL All-In-One For Dummies, Second Edition. He lectures internationally on astronomy, databases, innovation, and entrepreneurship. He also teaches database development and Crystal Reports through a leading online education. For the latest news on Allen's activities, check out www.DatabaseCentral.Info or his blog at www.moontube.wordpress.com.

Customer Reviews

Most Helpful Customer Reviews

34 of 35 people found the following review helpful By jimmy dean on August 14, 2011
Format: Paperback
Don't let the "for dummies" part fool you, this book is great even if you've been using SQL for years. I picked this book up because I read reviews saying this is far too advanced for a beginner. I can't speak for beginners, but it was great for me. I'm an intermediate level software engineer, and I have built more than few databases already. However, there are gaps in my knowledge, and I found this book helpful for getting myself more up-to-date with SQL concepts from schema design to performance tuning.

I particularly enjoyed his description of all the standard SQL data types from char, varchar to national char, blob and clob. There are some nuances between various data-types which I was a bit hazy on, but this book cleared that all up. He does a great job explaining things like indexing and how to tune up database queries. He touches on some advanced concepts like EF Codds normal forms, and explains some of the differences, and even tells you which normal forms are too obscure to really be relevant for most database systems. He also explains why de-normalization matters and how to find that "sweet spot" between performance and robustness (resistance to modification anomalies).

If you're not already familiar with RDBMS concepts like relations, attributes, tuples, ER models, and such, this book may be a very valuable read for you. I'm giving this book 5 stars because it gave me exactly what I wanted-- about 640 pages summarizing all the important concepts of SQL, plenty of real life examples, and illustrations as well.
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
11 of 12 people found the following review helpful By Merry One on March 18, 2013
Format: Paperback Verified Purchase
I started reading this book without much knowledge of SQL. My background isn't IT, but I work closely with systems and wanted to learn more on the side to help me with my job. This is a great guide. It's easy to follow and understand, moves along quickly, but it doesn't dumb down the material. Also, the 8 books in one encompass a lot of knowledge about SQL and databases. This is a good resource.
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
13 of 15 people found the following review helpful By Personne on October 5, 2012
Format: Paperback
I've been aware of the 'For Dummies' books for years. After several decades in the technology business, it's perhaps understandable why I've shied away from opening one. I'm not a dummy--there are simply things I don't know. But I found myself in the position of needing to know just a bit about SQL. So I donned an appropriate disguise and snuck into the library.

What a surprise. This is an excellent book, sitting astride the area that goes from basic introduction well into hands-on. It's written clearly without a hint of the condescension I feared. It does assume some technical background, but the author has a good sense of where the reader's knowledge is likely to end. I was impressed with the overall organization. It's 8 books (sort-of), with the goal of each well-delineated. Each volume has a clearly stated purpose and is written with a clarity that is rare among technical writers.

For those of us willing to admit an occasional bout of dummyhood, this is a fine antidote.
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
4 of 4 people found the following review helpful By Smitty8498 on May 26, 2013
Format: Paperback Verified Purchase
This book explains a lot about SOL, and it makes clear much of what you wish you understood better in other books. When you pick up your expensive SQL text, don't forget the "...for Dummies" book to go along with it.
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 Kat4nursing on November 29, 2012
Format: Kindle Edition Verified Purchase
Great help with Figuring out SQL for my class. Easy to understand and read. Set up well to guide 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
5 of 7 people found the following review helpful By enader on September 13, 2013
Format: Paperback Verified Purchase
If you are looking for something to teach you the basics of sql and building on it, this can do it, but its not for dummies. I was looking forward to something a lot more simple. I thought it would be basic like creating a new database, creating a table in the database, create a record in the table. Then explain how to view those components. Then maybe go onto something a little more complex like create another table, then go over the different joins. I have basic knowledge and really wanted a reference to sql syntax. The syntax is in there somewhere, but not easy to find. Book 1 Chapter 5:"Adding data the dull and boring way". That is what a dummy book is all about. We should be learning the boring way. Then the later books and chapters should advance us to a more advanced programmatic approach. The create, select, update should be drawn out in a very easy to understand format. Again it all seems to be in there, but difficult for me, as a dummy, to find. I guess I need a real sql primer, which is what I thought this would be.
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
17 of 25 people found the following review helpful By J. Lewis on July 29, 2011
Format: Paperback Verified Purchase
There are constant references to the CD content throughout the book however this is no web download for it. This makes the ebook marginal. On the plus side, because I had to type in all the examples as I was going through it, I may have learned the lesson material better.

I would've given 5 stars if the CD content was available for download.
2 Comments 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
1 of 1 people found the following review helpful By Strome804 on November 19, 2012
Format: Paperback Verified Purchase
Contained the most basic information in an easy to understand concept. Nicely written from learning the basic to understanding the more complex...very good!!
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

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
SQL All-in-One For Dummies
This item: SQL All-in-One For Dummies
Price: $28.73
Ships from and sold by Amazon.com

What Other Items Do Customers Buy After Viewing This Item?