SQL For Dummies Paperback – May 16 1997
Customers Who Bought This Item Also Bought
To get the free app, enter your e-mail address or mobile phone number.
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 alternate Paperback edition.
From the Back Cover
"Taylor writes in a breezy, entertaining style that SQL novices will find inviting." Amazon.com
Covers Microsoft SQL Server 7
Find Out How to Use SQL for Effective Database Communication Handle SQL like a native speaker in no time! Written by a 30-year computer veteran, SQL For Dummies®, 3rd Edition, explains how to use this powerful language to create, manipulate, and manage relational databases. Get an insider's tour of relational databases and client-server systems, work your way up to sophisticated commands and statements, and check out the coverage of SQL-related products such as Microsoft SQL Server 7.
Inside, find helpful advice on how to:
- Find out about SQL components Data Definition Language, Data Manipulation Language, and Data Control Language
- Understand fundamental SQL commands and data types
- Extract data from many different data sources using ODBC (Open DataBase Connectivity)
- Create tables, views, schemas, and indices for easy data access
- Manage databases using SQL server
- Use SQL to transfer or retrieve information from the Internet or an intranet
- Enhance databases with popular development tools, such as Borland's C++Builder and IntraBuilder
Inside This Book(Learn More)
Browse and search another edition of this book.
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
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Top Customer Reviews
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.
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!)
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.
It covers most of the features of SQL supported by the Borland Database Engine for Database creation and manipulation, although I found it somewhat lacking in the area of security.
I've read several other books on the subject now and I think it compares favorably with most. I find the subject of normalization lacking in all of the books. If you are new to SQL my recommendation is to reduce the subject of normalization down to this: keep the long tables skinny and the fat tables short and minimize data redundancy.
If your new to SQL it's a good starting place and worth the price. It's especially useful for BCB or Delphi Programmers.
The first two chapters cover relational database and SQL fundamentals. The next few chapters discuss more details about SQL, first its "languages," then how to build a SQL database, and once it's built how to retrieve data from it, and also issues relating to keeping it secure.
Generally, a good "Dummies" book on a complex subject.
Most recent customer reviews
I like to start off projects with simple concepts and a few examples to get off the ground. Well this book does just that. Read morePublished on March 15 2007 by B. Chandler
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. Read morePublished on July 15 2003
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
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... Read morePublished on Jan. 29 2003 by Roger
Poorly written, jumps back and force between the topics not yet explainedPublished on July 19 2002 by JohnDoe155
This book assumes you already know the basics of SQL and programming. Feh! I sent it back and got PL/SQL 101... Read morePublished on May 29 2002 by Larry Wolkoski
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 morePublished on Feb. 21 2001
I was unimpressed with the way this book is presented. Not enough examples of core SQL.Published on Oct. 21 1999 by Kathy Bungard
Look for similar items by category
- Books > Computers & Technology > Databases > Database Management Systems
- Books > Computers & Technology > Databases > Relational Databases
- Books > Computers & Technology > Programming > Software Design, Testing & Engineering > Software Development
- Books > Computers & Technology > Software
- Books > Computers & Technology > Web Development > Programming > SQL
- Books > For Dummies Store > Computers & Internet > Databases > Database Management Systems
- Books > For Dummies Store > Computers & Internet > Databases > General
- Books > For Dummies Store > Computers & Internet > General
- Books > For Dummies Store > Computers & Internet > Programming > General
- Books > For Dummies Store > Computers & Internet > Software > General
- Books > For Dummies Store > Computers & Internet > Web Development > Scripting & Programming
- Books > Professional & Technical > Professional Science > Mathematics
- Books > Textbooks > Computer Science & Information Systems > Database Storage & Design
- Books > Textbooks > Computer Science & Information Systems > Programming Languages
- Books > Textbooks > Computer Science & Information Systems > Software Design & Engineering