- Paperback: 406 pages
- Publisher: Addison Wesley Longman Publishing Co (Aug 1989)
- Language English
- ISBN-10: 0201517388
- ISBN-13: 978-0201517385
- Product Dimensions: 23 x 18.6 x 2.4 cm
- Average Customer Review: 4.5 out of 5 stars See all reviews (35 customer reviews)
- Amazon Bestsellers Rank: 2,503,778 in Books (See Top 100 in Books)
- See Complete Table of Contents
| ||||||||||||||||||
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
|
There is a newer edition of this item:
|
Product details |
More About the Authors
Discover books, learn about writers, and more.
Product Description
Amazon.co.uk Review
The Practical SQL Handbook 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, as demonstrated by a section on common database tasks (how to specify decimal precision, for example). 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-MB download marathon. --David Wall --This text refers to an out of print or unavailable edition of this title.
Product Description
The Practical SQL Handbook is the best-selling guide to learning SQL, the standard language for accessing information in relational databases. This book not only teaches SQL as it has been established by ANSI standards committees but also as the language is used to solve real business problems. You'll learn step-by-step the basic vocabulary and functions of the language and the processes and issues involved in developing robust applications. This book provides a thorough grounding in the basics of database design, security, and integrity. You will learn SQL pragmatically, by creating a sample database and then working through dozens of examples with it. Fully updated to cover the ANSI SQL '92 standard, the third edition of The Practical SQL Handbook includes a cookbook of specific solutions, ready-to-use code, and general strategies for common business database challenges. Find out how to: *create and use views *use and apply subqueries *join tables for comprehensive data analysis *handle null values *create reports using groups and aggregate functions Bonus CD-ROM -- Get Hands-On Practice Using SQL!The CD-ROM includes the Windows 3.x , Windows 95, and Windows NT versions of the SybaseA (R) 3.0 SQL AnywhereaA A Runtime, a full-featured SQL database. 0201447878B04062001
--This text refers to an out of print or unavailable edition of this title.
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
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
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
2 of 2 people found the following review helpful
Format:Paperback
Forget about the complaints that this book is just about Sybase SQL. Any book that tries to teach SQL has to use a vendor software as a tool to convey the concepts. This one happens to be using Sybase Anywhere. But it really doesn't matter. Imagine yourself learning how to drive, do you really care whether the car is Honda Accord or Toyota Camry? As long as you don't boycott Japanese product, your only concern should be whether the person sitting next to you is a good driver and teacher!
This book is the best SQL teacher I've ever met. Granted, before reading this book, I've already had graduate level courses on relational database and years of working experience in using several big name vendor databases, but I still learned a lot from this one in both conceptual and technical senses. And because of that, I can tell with 100% confidence that this book teaches SQL in the most efficient and general way - it introduces key SQL concept in a crystal clear manner; it teaches basic SQL syntax in the most standard form as possible and reminds you of the vendor specific variations diligently wherever they occur; it presents the full picture from database design principle to FAQs of daily SQL usages in easy and concise language. It's simply the best SQL book for beginners. For experienced SQLers, this book can serve as a field guide to help you maintain a clear big picture of core SQL when you start to get lost in the forest of numerous vendor specific DBMS products.
Oh, do you really care about the minor typos and the shabby free SQL Anywhere software comes with the book? (p.s., it works with limited functions). Again, your car may have scratches and some fancy functions of the stereo may not work, but as long as your purpose is to learn how to drive and you have a good teacher sitting next to you, it doesn't matter at all.
I'm amazed by how good a teacher the authors are. Having taught myself, I know how difficult teaching could be. The authors of this book really know how to teach - teaching is art, they are masters. I salute them.
1 of 1 people found the following review helpful
Format:Paperback
I have had this book for about a year now and I still use it quite regularly. It's really a great reference book. If you want to know how to do any kind of a join this book will show you in terms that are easy to understand. Because of this book there isn't a SQL statement that I can't wright. It's quite outstanding even if it's not a wrox book ;)
1 of 1 people found the following review helpful
Format:Paperback
I've read over 100 books relative to programming and databases - this one ranks inside the top 5. The writing style is a good read, the book is technically correct (and that's rare today...) and each method is linked to a solid example representing real business requirements. If you're new to SQL, you need it. If you're an experienced DBA, you will probably pick up some good pointers, regardless of your RDBMS. If you program databases - this is a Must Have to build, troubleshoot and tune your queries.
Would you like to see more reviews about this item?
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
THE FREE CD IS BRILLIANT
The book is easy to follow for beginners.
The CD is worth its weight in Gold - as no amount of reading can replace physically creating queries. Read more
Published on 12 Dec 2003
Not a good book for quick learners
This book is wordily! However if you are new to database stuff then this is a book for you. Otherwise this is not a good reference. Read more
Published on 31 Aug 1999
Great Book!!!! Good reference book.
I got this book for a class I was taking. Good reference book,not really for learning purposes though.
Published on 12 Aug 1999
Excellent SQL source for beginners and advanced developers
The book is extremely well written. It is organized and easy to follow. The sample queries (complete with results) are a big help in understanding the syntax. Read more
Published on 3 Aug 1999
Great book - bad cd
The book's approach and explanations are fantastic. I haveextensive experience with Access but none at all with real programming and this book was exactly what I needed. Read more
Published on 8 July 1999
Great Book if you want to know SQL basics and more...!
I really like this Book, it's my first time buying SQL book and it won't be the last! after finish this book all over... i will go on to another one... Read more
Published on 14 May 1999
Buy this book to learn practical SQL
I needed to be able to learn practical SQL in a hurry, and this book was invaluable in learning this language in the absolute shortest amount of time of any I have read. Read more
Published on 4 May 1999
A tremendous intro to SQL
I found this book to be very informative. Unlike some reviewers, I didn't find find this book to really be geared toward one type of database or another. Read more
Published on 24 April 1999
CD-ROM software read-only version
My comment is on the CD-ROM. The cover (front and back) says "The CD-ROM includes the ... Sybase SQL Anywhere Runtime, a FULL-featured SQL database" (capitals are mine). Read more
Published on 17 Mar 1999
EXCELLENT. This is the BEST generic SQL book I have seen
I have used this book as a SQL reference with SQL Server, Oracle, Interbase, and Sybase back ends with great success. Read more
Published on 11 Jan 1999
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
