- Paperback: 496 pages
- Publisher: Addison Wesley; 3 edition (14 Oct 1996)
- Language English
- ISBN-10: 0201447878
- ISBN-13: 978-0201447873
- Product Dimensions: 22.9 x 18.5 x 3 cm
- Average Customer Review: 4.5 out of 5 stars See all reviews (35 customer reviews)
-
Amazon Bestsellers Rank:
654,481 in Books (See Top 100 in Books)
- #81 in Books > Computers & Internet > Computer Science > Databases > SQL
- 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? Visit the Amazon.co.uk 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
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
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
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
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
2 of 2 people found the following review helpful:
5.0 out of 5 stars
Simply the best entry-level SQL learning tool,
By A Customer
This review is from: The Practical SQL Handbook: Using Structured Query Language (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:
5.0 out of 5 stars
None other comes close!,
By A Customer
This review is from: The Practical SQL Handbook: Using Structured Query Language (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:
5.0 out of 5 stars
A "Must Have" for Database Programmers,
By A Customer
This review is from: The Practical SQL Handbook: Using Structured Query Language (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.
Share your thoughts with other customers: Create your own review
Would you like to see more reviews about this item?
|
Most Recent Customer Reviews |
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.
