Vous voulez voir cette page en français ? Cliquez ici.

Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

SQL for Dummies [Paperback]

Allen G. Taylor
3.0 out of 5 stars  See all reviews (17 customer reviews)

Available from these sellers.


Amazon Price New from Used from
Paperback --  
Paperback, 1997 --  
There is a newer edition of this item:
SQL For Dummies SQL For Dummies
CDN$ 22.56
In Stock.
Join Amazon Student in Canada

Book Description

1997 For Dummies

With the abundance of fine database applications -- from Microsoft Access and Claris FileMaker Pro to products from Oracle, Sybase, and Informix -- SQL is more important than ever as the glue that holds disparate databases together. Now completely updated with the latest on SQL enhancements and SQL-compatible database software, SQL For Dummies®, 2nd Edition, is the practical, easy-to-understand reference for anyone wanting to get something done using Standard Query Language.

In SQL For Dummies, 2nd Edition, computer information systems expert Allen G. Taylor offers practical, how-to guidance on tables, views, schemas, and indexes that make data access easy. He also provides expert tips on relational databases, SQL commands and data types, and SQL components like Data Definition Language, Data Manipulation Language, and Data Control Language. From the fundamentals of database structure and design to coverage of specific SQL commands, SQL For Dummies, 2nd Edition, is a must-have reference for anyone with databases to manage and systems to integrate.

Plus, SQL For Dummies, 2nd Edition, features coverage of accessing databases over the Internet and enhancing database application interfaces with development tools such as Borland's C++ Builder and IntraBuilder.

Product Details

Product Description

From Amazon

This is the rare case of a book that can take you from a beginner to an advanced-intermediate level. Like many of the books in IDG's Dummies series, this volume begins with a definition ("What is SQL?") and ends with "The Part of Tens," a collection of tips in a top ten list form. Taylor writes in a breezy, entertaining style that SQL novices will find inviting. One caveat: The examples are given in Borland's Delphi, a rapid application development (RAD) tool. Some sections show several screen shots from Delphi and it may be difficult to follow along in these sections if you don't have the program in front of you. As with other Dummies books, SQL for Dummies is entertaining to read although the nonstop jokes may distract some readers from the technical content. --This text refers to an out of print or unavailable edition of this title.

From the Back Cover

Take charge of relational databases!

Now updated with coverage of the SQL:1999 standard

Step-by-step instructions for database design and implementation

The fun and easy way to create and maintain databases with SQL
SQL gives you the power to create, manipulate, update, and retrieve information in any major relational database management system. But how do you get up to speed on this complex language? Relax! With Allen G. Taylor at your side, you'll be building tables, creating views, and writing nested queries in no time.

Discover how to:

  • Understand SQL and relational databases basics
  • Build a multitable database
  • Retrieve data from a database
  • Use SQL in Internet and enterprise applications
  • Capitalize on new SQL:1999 features
  • Explanations in plain English
  • "Get in, get out" information
  • Icons and other navigational aids
  • Tear-out cheat sheet
  • Top ten lists
  • A dash of humor and fun
Get Smart! www.dummies.com
  • Register to win cool prizes
  • Browse exclusive articles and excerpts
  • Get a free Dummies Daily e-mail newsletter
  • Chat with authors and preview other books
  • Talk to us, ask questions, get answers
--This text refers to an out of print or unavailable edition of this title.

Inside This Book (Learn More)
Browse and search another edition of this book.
First Sentence
SQL (short for structured query language) is an industry-standard language specially designed to enable people to create databases, add new data to databases, maintain the data, and retrieve selected parts of the data. Read the first page
Explore More
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

Most helpful customer reviews
5.0 out of 5 stars Its Great July 15 2003
This book was just a good as my University's suggested text book. If you need to know something regarding SQL, it is IN HERE. Definitely worth checking out, you won't have regret or be disappointed.
Was this review helpful to you?
3.0 out of 5 stars All that it claims to be March 15 2007
By bernie TOP 100 REVIEWER
I like to start off projects with simple concepts and a few examples to get off the ground. Well this book does just that. Unfortunately I would also like to have some example of input and output. I chose this book because it was not database specific, as I am converting files from an Informix database, through a filter, to a flat file, for later conversion to an Oracle database, with a different structure. Unfortunately this book (being universal) has no universal explanation as to how to get information from a flat file in or out of the database. First you have to find the term they use, not ASCII, not flat, not import, not export, not not not. The term is found in chapter 7 "foreign." The explanation on how to do this is to "...turn to one of the professional data translation services." Great, just what I wanted to know.
Was this review helpful to you?
5.0 out of 5 stars Would Rate This Book 6 stars out of 5 Jan. 29 2003
By Roger
I bought SQL for Dummies when I was handed a web project that demanded a high traffic database. Previous to the purchase I had only worked with flat text files and had no SQL experience. This book can take you from basic database design all the way up to advanced SQL issues. Thanks to SQL for Dummies I never lost pace with the project. It explained terms and issues very plainly. It also had excellent example code. I still use the book today as an excellent reference tool.
If you were stranded on Database Island, this would be the only book you would need...
Was this review helpful to you?
2.0 out of 5 stars You will be dummy if you buy this book July 20 2002
Poorly written, jumps back and force between the topics not yet explained
Was this review helpful to you?
1.0 out of 5 stars Definitely NOT for beginners May 30 2002
This book assumes you already know the basics of SQL and programming. Feh! I sent it back and got PL/SQL 101...a book that REALLY understands how to teach beginners with no prior experience in SQL.
Was this review helpful to you?
4.0 out of 5 stars SQL, Unequalled May 5 2002
Buying any book targeted for 'dummies' sets the record straight in terms of my knowledge of SQL. I'm a South African computer science student and bought SQL for Dummies to supplement material prescribed by the university.
Firstly, the book is set out in an easy to understand manner starting with the section called Contents at a Glance and followed by an extensive Table of Contents. The text uses icons for tips, things to remember, warnings, technical stuff, etc. which reinforces key concepts.
Mr Taylor conveys his thoughts on a serious subject, particularly for first timers, in a humourous manner making the subject even more accessible. The contents of the book is set out in clear and concise way, with key topics highlighted. The book is extensive in its covering of the subject, not only directed at building and extracting information from a database, but also giving information on security issues and using SQL with the internet.
I found the book of particular use and can recommend it to any newcomers to SQL.
Was this review helpful to you?
4.0 out of 5 stars Excellent Starting Point Nov. 28 2001
The last time I worked with databases, my entire computer (RAM + mass storage) had less than one MEGAbyte of memory. No hard disk, just two 360 kB floppy disk drives and 128K of RAM. I just got saddled with a data-mining project that will process tens of gigabytes of data in a networked environment. My analysis tools can use SQL to access the data. This book was the first thing I insisted on. (Kind of embarassing for a senior person to be seen carrying a thick yellow and black book with the word "DUMMIES" on it ...)
This has proven to be an excellent starting point. I know plenty about computers and programming. I vaguely remember the essentials of relational databases (for those who don't, basic information is in the book, it should be enough to get started, even if you are absolutely ignorant!) Taylor packaged enough of the right information that I could read his book over the weekend and dive into the planning stages of our project on Monday sounding like I knew a thing or two.
The book charts a course from the most basic elements of databases to modestly complicated database and query materials. The author discusses common pitfalls and useful strategies. This book isn't enough, by itself, to turn somebody into a database wonk, but it's a great starting point.
I got a bit annoyed by some of the "cute" material used to make the subject seem less threatening, but that filler doesn't take up too much space and is easily skipped. Also, the book is overly Microsoft centered--the author uses Windows applications as examples and champions Microsofts ODBC. A section about using SQL in a Unix/Linux environment should have been included (access from shell scripts, PERL, etc?). A solid four-star introduction to SQL and database technology in a Microsoft world.
(If you'd like to discuss this book or review in more detail, please click on the "about me" link above and drop me some email. Thanks!)
Was this review helpful to you?
3.0 out of 5 stars Overall adequate, but could have been better July 7 2001
First off, I must stress that after I finished reading this book I did walk away with a far greater knowledge of SQL. To this end the book served its purpose and was worth the time/money I invested in the book.
My most serious criticism is that the early chapters introduced complex examples, which I forced myself to understand...only to discover that the author explained the issues more thoroughly at a later stage. On page 55 the author explains the MIN function with a sub/nested SQL query...introducing nested queries at such an early stage was a little confusing and it distracted me from the function being discussed.
As a result I spent considerable time working through the early chapters...but the later chapters were easy to follow.
Had the author taken a bit of time to consider the placement and appropriateness of each example, this book would have received a 4/5 rating in my mind. Of course an indirect advantage of this lack of fore-thought is that if the reader is prepared to work through the earlier examples the learning process is much more active.
Was this review helpful to you?
Want to see more reviews on this item?

Look for similar items by category