Wattle Software - producers of XMLwriter XML editor
 Bookstore Home | XMLwriter Home | Search | Site Map 
XML Related
 General XML
 XSLT & Stylesheets
 XHTML
 SGML
 XML DTDs
 XML Schema
Web Development
 Web Graphics
 HTML
 Dynamic HTML
Web Services
 General Web Services
 UDDI
 SOAP
 WSDL
 Programming/Scripting 
 PHP Programming
 Perl Programming
 Active Server Pages
 Java Server Pages
 JavaScript
 VBScript
 .NET Programming
 
XMLwriter
 About XMLwriter
 Download XMLwriter
 Buy XMLwriter
XML Resources
 XML Links
 XML Training
 The XML Guide
 XML Book Samples
 

The Practical SQL Handbook: Using Structured Query Language (3rd Edition)


By Judith S. Bowman, Sandra L. Emerson, Marcy Darnovsky
 
Image of: The Practical SQL Handbook: Using Structured Query Language (3rd Edition)
Pricing Details:

List Price:$42.95
You save:-- (--)
Your Price:Currently Unavailable
Buy Now

Book Details:

Format:Paperback, 454 pages.
Publisher:Pearson Education 1996-10-14
ISBN:0201447878

Average Customer Rating:

4.5 4.5 out of 5 stars (55 reviews)

Editorial Reviews:

The bestselling guide to learning Structured Query Language as it is really used is updated to reflect the growth of the database market, as well as the latest ANSI SQL standard and other important developments. The CD-ROM includes Sybase SQL Anywhere Desktop Runtime, a full-featured SQL database that gives readers hands-on SQL programming experience.

This superb text explains Structured Query Language (SQL) simply without being condescending and deeply without being obscure. From its early chapters about relational database theory to its superb coverage of transaction management, this book is informative and easy to follow.

The authors begin by explaining how to design efficient data structures, an important part of database management. From there, they discuss how to populate a database with pieces of data and then explain how to construct queries that extract needed information. Throughout, the text is filled with statements, code, and output--and even common SQL errors. You ought to be able to follow along on any ANSI SQL 92-compliant system as you read this book.

Later chapters cover reports, joins, views, subqueries, and security. The authors explain each from a practical point of view. A section on common business-database tasks (how to specify decimal precision, for example) confirms this point of view. A good glossary exists in the back of this book, and a comprehensive table documents the differences among Sybase, Microsoft, Informix, and Oracle SQL command sets. The companion CD-ROM contains the Sybase SQL Anywhere Studio software, which ordinarily requires a 15-megabyte download marathon. --David Wall


Customer Reviews:

Displaying 1 to 5 of 55 total reviews (Page 1 of 12):

5 out of 5 stars SQL primer

I learned SQL using this book and referred to it often when I was starting out. Lots of clear examples. Highly recommended for those who have to learn SQL.

5 out of 5 stars Great Book on SQL

We're building a start-up library for a new employee and this is the first book I'll order. The book was purchased for everyone in our group some time ago as a SQL primer. It is well written, logically ordered, and a comprehensive introduction to SQL. It is truly a pleasure to read.

5 out of 5 stars The best for learning concepts and structure

Outstanding book for beginner looking to learn SQL from scratch. Thrown into an SQL job with no experience whatsoever, this book helped me become functional in a very short period of time. Provides sound fundamental concepts which will help lead to more efficient procedures, scripts, web-design, etc.

5 out of 5 stars Good Beginning Book

I have been programming for over 15 years, and I have never had the need to venture into the world of SQL, until early 2001. At that time I started looking for a basic book to help me understand the SQL syntax. I finally purchased this book in Jan 2002; by this time I had a rough understanding of SQL, but would have been hard pressed to write any useful statements. I typically used Access to create the statement and then copied it into my code.

After reading this book I feel able to write most any SQL statement, and to be able to understand the current ones in the code. I also found the answer to several syntax problems that I had: why I would get an error with an SQL statement the had a aggregate function and I was trying to select a column value as well. I would recommend this book to any beginner who needs to have a better understanding of SQL.

The only draw back, for me, was that the book concentrates on the SyBase version of SQL; however, there is a chart in the back of the book that list syntax for four different version of SQL: SyBase, Microsoft, Informix, and Oracle.

5 out of 5 stars Easy Reading Practical Advice

I consider this the best book around for introducing yourself to SQL. It is easy to read, written in plain English and explains jargon and terminology unique to SQL. Although SQL does have a background in logic and mathematics, most practitioners work more by intuition and experience than set theory. The authors give clear practical advice and detailed explanations of all aspects of the SQL language and how they are used. They explain the theory behind relational databases plainly and to a detail necessary to understand what you are doing. Common mistakes and answers to questions gleaned from the net round out the book. The is the best SQL book by far, well written and edited, with sensitive typesetting and pleasing cover art. The only thing it lacks is a web based approach to database querying. Although it supplies an excellent example by taking your through the building of a book store database (!) the examples are more generic with an older enterprise orientation. For the specifics of building database driven web sites lookup one of the good books on PHP or ASP programming.

More Customer Reviews:
Next Page


Customers who bought this book were also interested in:


Practical SQL The Sequel (With CD-ROM)


The Practical SQL Handbook: Using SQL Variants (4th Edition)


Sams Teach Yourself SQL in 10 Minutes (3rd Edition)


SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL


SQL Cookbook (Cookbooks (O'Reilly))

 

Find similar books by category...


Search for more:

Search books:  



Google
 
Web XMLwriter.net




Last updated: Fri Jan 9 3:28:12 CST 2009
© Wattle Software 2007. All rights reserved.