- Paperback: 1080 pages
- Publisher: McGraw-Hill Osborne; 2 edition (1 Aug 2002)
- Language English
- ISBN-10: 0072225599
- ISBN-13: 978-0072225594
- Product Dimensions: 23.1 x 18.3 x 5.8 cm
- Average Customer Review: 4.3 out of 5 stars See all reviews (9 customer reviews)
- Amazon Bestsellers Rank: 868,305 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 Author
Product Description
Product Description
Learn all you need to know about SQL with this one-stop resource. Updated to include information on Web services and XML, this complete guide also comes with a Windows 2000- and XP- compatible CD containing 4 databases (SQL Server 2000, IBM DB2 Version 7.2, Sybase, and mySQL).
From the Publisher
The Most Comprehensive SQL Resource Available
Get in-depth details on all the powerful features and capabilities of SQL inside this one-stop guide. Featuring broad coverage of every aspect of this leading database language, this book provides you with an overview of SQL then shows you how to retrieve and update data, program with SQL, use stored procedures, and much more. Covering emerging standards and new related technologies including XML, Web services, EJB, J2EE, and JDBC, this book will help you gain the knowledge and essential skills you need to effectively work with SQL. Comprehensive, organized, and practical, this is the ultimate guide to understanding and using SQL.
Master SQL basics and use simple, multi-table, and summary queries
Understand key concepts and the latest developments in relational database technology
Set up and manage SQL-based databases and write programs to access them
Create and use the sample database to run the SQL query examples in the book
Find out about Xpath, Xquery, and other XML-based database query standards
Discover how J2EE-based applications relate to data management
Use and program SQL databases with application servers to create powerful Web applications
Preview the future of SQL--including MySQL and the impact of XML and Web Services
Inside This Book
(Learn More)
First Sentence
The SQL language and relational database systems based on it are one of the most important foundation technologies in the computer industry. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
The SQL language and relational database systems based on it are one of the most important foundation technologies in the computer industry. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
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
Most Helpful Customer Reviews
6 of 6 people found the following review helpful
Format:Paperback
While an excellent introduction to SQL, this book has a number of flaws that detract from it being a "Complete Reference". Most obviously, it suffers from first edition syndrome, with the text littered with obvious typos and minor errors, particularly in the chapter on Dynamic SQL. These shouldn't pose a serious problem to comprehension, however. Despite its technical content, the book seems more tailored for management than techies, with examples centred around salespeople and a strong summary flavour in the latter chapters. You would definitely need to use it in conjuction with vendor documentation for anything beyond basic SQL; but maybe that goes with the territory. The authors seem unwilling to stick their neck out and actually criticise any of the products mentioned; but there seems to be a definite bias towards expensive (Postgresql, MySQL and mSQL aren't mentioned at all, despite their wide deployment in cost-sensitive applications) databases, and an unspoken and unexplained resentment towards Oracle. Oh, and it's too long. I still recommend it for the clear explanations (the authors clearly understand the territory), and broad coverage.
3 of 3 people found the following review helpful
Format:Paperback
Whilst this is a complete reference book with examples, there is a real flaw in its structure, especially for novices. The primary problems arise from the ability to access examples on the CD. The first chapters present the user with example SQL queries. This "wets the appetite", making the reader keen to try the examples out. However, you need to load the examples into a database. Not so easy, this requires you to create the database and tables. Okay, so the book shows the SQL code used to create the tables. However, the SQL code has foreign keys that reference the other tables (which you've still to create). So you're in a chicken and egg situation, when you're just at the beginning of the book looking to do some simple "select" statements. This is the most frustrating aspect of this book. Secondly you'll need to make sure you have a development environment such as Windows NT, anything else and installing and running the demo's is a real chore. This book was helpful for reference but needs to provide greater user friendliness to enable you to get working from the first chapters.
2 of 2 people found the following review helpful
Format:Paperback
I had no previous experience in SQL and I needed to learn it fast for my job. I chose this book because it got good reviews, and I have no regrets that I bought it. The book is excellent for beginners as well as intermediate level programmers. The material is presented clearly and logically, and explanations and examples are very helpful. I would highly recommend this book to everyone who wants to learn SQL as well as to everyone who is looking for a good reference book.
Would you like to see more reviews about this item?
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
Good but flawed by lack of Oracle examples.
Whilst the book is generally very good, it was let down for me by it's lack of specific examples of Oracle implementation. Read more
Published on 10 Jan 2000
A good way to learn the basics of SQL.
This is the first SQL book that I have read.
I was able to start using SQL as soon as I started reading it. Read more
Published on 23 Aug 1999
Gives a taste of Oracle, microsoft, informix, DB2
Well written intro book. The CD has the demos of the above databases; first time I've ever seen that. The text is clean and well thought out.
Published on 12 July 1999
Indepth, with complete coverage.
Super book for beginning to advanced SQL. I was able to teach myself SQL from this book in conjunction with another, called The Practical SQL Handbook.
Published on 17 Jun 1999
Excellent book
I have bought many computer books and it is always a thrill to stumble on a book that throughly explains a subject. This book has excellent examples and very easy to read. Read more
Published on 18 May 1999
One of the best reference books I've ever read
This book gives practical examples in a clear and concise manner. I recommend it highly to anyone who needs to get up to speed on their SQL and database skills.
Published on 3 May 1999
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > SQL
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > SQL
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Languages & Tools
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.
