SQL For Dummies and over one million other books are available for Amazon Kindle. Learn more

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

Have one to sell? Sell yours here
Search inside another edition of this book
Start reading SQL For Dummies on your Kindle in under a minute.

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

SQL for Dummies [Paperback]

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

Available from these sellers.


Formats

 Amazon Price New from Used from
Kindle Edition CDN $16.15   -- --
Paperback CDN $17.00   -- --
Paperback, 1997 --   -- --
There is a newer edition of this item:
SQL For Dummies SQL For Dummies 3.0 out of 5 stars (17)
CDN$ 22.56
In Stock.

Book Description

Publication Date: 1997 | Series: 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.

Customers Who Viewed This Item Also Viewed

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 10 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. --Jake Bond --This text refers to an out of print or unavailable edition of this title.

From the Back Cover

Demystify database management systems with this fun and friendly guide to SQL

The secret is SQL, and once you get the hang of that, you can build relational databases and get valuable information into and out of them with ease. Here's how to structure a database management system with SQL, implement the design, protect your data, access and work with it, maintain your database, and much more, using the newest version of SQL.

  • Down to data basics — learn what a relational database is and what goes into designing a good one

  • SQL secrets revealed — get an overview of SQL fundamentals and actually build a database

  • Data in, data out — find out how to add, retrieve, display, delete, or change data in your database

  • What's your query? — discover how to find what you need using different queries

  • Guarding your stuff — protect your data from theft, accidental or malicious corruption, and loss due to equipment failure

  • Getting SQL to play nice — use Open DataBase Connectivity (ODBC) to solve the problems of combining SQL with other languages

  • XML is your friend — communicate with other applications using XML with SQL

  • Eliminating errors — understand what SQL is trying to tell you when something goes wrong

Open the book and find:

  • Essential database design considerations

  • How a database management system differs from a database

  • What SQL is and isn't

  • Different types of data

  • Ten common database blunders

  • How to use values, value expressions, and relational operators

  • Tips on using XML data with SQL

  • Common threats to your data

Learn to:

  • Create relational databases with powerful data retrieval capacity

  • Use SQL with XML and Access® 2010

  • Structure a database management system and implement database design

  • Work with all the core SQL features

See all Product Description
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
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

› Explore similar items

Customer Reviews

Most helpful customer reviews
5.0 out of 5 stars Its Great July 15 2003
By "udsteve"
Format:Paperback
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?
Yes
No
3.0 out of 5 stars All that it claims to be Mar 15 2007
By bernie TOP 500 REVIEWER
Format:Paperback
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?
Yes
No
5.0 out of 5 stars Would Rate This Book 6 stars out of 5 Jan 29 2003
By Roger
Format:Paperback
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?
Yes
No
Want to see more reviews on this item?
Most recent customer reviews
1.0 out of 5 stars Want to learn SQL? Find some other book.
.
I worked with SQL some years ago and bought this book as a refresher. I've used only one other "dummy" book and that was "ASP for Dummies" and found it... Read more
Published on Jun 10 2003 by S. King
2.0 out of 5 stars You will be dummy if you buy this book
Poorly written, jumps back and force between the topics not yet explained
Published on July 20 2002 by JohnDoe155
1.0 out of 5 stars Definitely NOT for beginners
This book assumes you already know the basics of SQL and programming. Feh! I sent it back and got PL/SQL 101... Read more
Published on May 30 2002 by Larry Wolkoski
4.0 out of 5 stars SQL, Unequalled
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... Read more
Published on May 5 2002 by Marie Marburger
4.0 out of 5 stars Excellent Starting Point
The last time I worked with databases, my entire computer (RAM + mass storage) had less than one MEGAbyte of memory. Read more
Published on Nov 29 2001 by Elderbear
3.0 out of 5 stars Overall adequate, but could have been better
First off, I must stress that after I finished reading this book I did walk away with a far greater knowledge of SQL. Read more
Published on July 8 2001 by David H Schneider
1.0 out of 5 stars Dummies, my hat!
After being thrown kicking and screaming into the world of the relational database, I figured I'd better get some book-learning from something that would start with the absolute... Read more
Published on Feb 21 2001
4.0 out of 5 stars Good intro to SQL
This book helps to "demystify" SQL. Before I started reading this and also "Learn SQL in 10 Minutes," by Ben Forta, I had a mortal fear of databases, one that... Read more
Published on Sep 27 2000 by Todd Hawley
2.0 out of 5 stars Don't waste your money
I was unimpressed with the way this book is presented. Not enough examples of core SQL.
Published on Oct 22 1999 by Kathy Bungard
5.0 out of 5 stars This was an excellent SQL primer
I spent a lot of time looking for a book that actually covered ANSI 92 SQL, and even though I vowed a long time ago to never buy a 'Dummies' book, this one was an exception and... Read more
Published on Sep 29 1999
Search Customer Reviews
Only search this product's reviews

    Your Shopping Cart is empty.

    Give it purpose—fill it with books, DVDs, clothes, electronics, and more.

    If you already have an account, sign in.

    View Cart (0 items)

      Listmania!

      Create a Listmania! list

      Look for similar items by category

      Feedback

      Would you like to update product info or give feedback on images?