CDN$ 24.00
  • List Price: CDN$ 47.99
  • You Save: CDN$ 23.99 (50%)
FREE Shipping on orders over CDN$ 25.
Only 10 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
SQL All-in-One For Dummie... has been added to your Cart
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 3 images

SQL All-in-One For Dummies Paperback – Apr 5 2011

5.0 out of 5 stars 1 customer review

See all 3 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
"Please retry"
CDN$ 24.00
CDN$ 24.00 CDN$ 27.16

Harry Potter and the Cursed Child
click to open popover

Special Offers and Product Promotions

  • You'll save an extra 5% on Books purchased from, now through July 29th. No code necessary, discount applied at checkout. Here's how (restrictions apply)

Frequently Bought Together

  • SQL All-in-One For Dummies
  • +
  • SQL in 10 Minutes, Sams Teach Yourself (4th Edition)
  • +
  • SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (3rd Edition)
Total price: CDN$ 81.86
Buy the selected items together

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

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

Product Details

  • Paperback: 744 pages
  • Publisher: For Dummies; 2 edition (April 5 2011)
  • Language: English
  • ISBN-10: 0470929960
  • ISBN-13: 978-0470929964
  • Product Dimensions: 18.8 x 3.6 x 23.6 cm
  • Shipping Weight: 862 g
  • Average Customer Review: 5.0 out of 5 stars 1 customer review
  • Amazon Bestsellers Rank: #38,779 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

  • See Complete Table of Contents

Product Description

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 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 lectures nationally on databases, innovation, and entrepreneurship, and teaches database development internationally through a leading online education provider. Among his more than 20 books are all editions of SQL For Dummies and Database Development For Dummies.

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

5.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See the customer review
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback Verified Purchase
very good book about SQL, if you are beginner for SQL.
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 Helpful Customer Reviews on (beta) HASH(0xa64444b0) out of 5 stars 36 reviews
35 of 37 people found the following review helpful
HASH(0xa6b9145c) out of 5 stars Beware, it really isn't for dummies at all! Covers a lot of ground / A good primer. Aug. 14 2011
By jimmy dean - Published on
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.
12 of 13 people found the following review helpful
HASH(0xa66d5510) out of 5 stars Good guide for beginners March 18 2013
By Merry One - Published on
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.
14 of 16 people found the following review helpful
HASH(0xa62d50c0) out of 5 stars Not so dumb after all Oct. 5 2012
By Personne - Published on
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.
8 of 10 people found the following review helpful
HASH(0xa6453600) out of 5 stars NOT FOR DUMMMIES Sept. 13 2013
By enader - Published on
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.
4 of 4 people found the following review helpful
HASH(0xa69117b0) out of 5 stars You'll love it May 26 2013
By Smitty8498 - Published on
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.