| | Beginning SQL: AND Beginning Database Design |  | Author: Paul Wilton Publisher: John Wiley & Sons Category: Book
List Price: £37.99 Buy New: £25.07 You Save: £12.92 (34%)
Avg. Customer Rating: 1 reviews
Media: Paperback
ISBN: 0470195711 EAN: 9780470195710 ASIN: 0470195711
Publication Date: August 20, 2007 Shipping: Eligible for Super Saver Shipping Availability: Usually dispatched within 9 to 12 days
|
| Also Available In:
|
| Similar Items:
|
| Customer Reviews:
Does a beginner need to know about performance tuning? October 30, 2005 7 out of 7 found this review helpful
This is Wrox's book for those keen to learn SQL who have no experience of database programming at all. The good news is that it's not bad. Unfortunately it is two books rather crudely glued together. The first book by Paul Wilton is what you would expect from a book with this title, a step-by-step introduction to SQL. It covers queries, functions, inner and outer joins, table and index creation, constraints and the fundamentals of relational database design. As the database-independent title of the book suggests it focuses on the standard features and functions of SQL that are common to all popular databases. In doing this the author makes the effort to point out where the popular databases vary from the standard. Understandably stored procedures are deemed to be beyond the scope of this book and are not mentioned. The databases covered by the first book are Oracle 10g, MySQL 4.1, SQL Server 2000, DB2 8.1 and Access XP. The book also includes a very handy appendix which explains how to obtain a free evaluation copy of each of these databases and how to install them on Windows. The second book, by John Colby, covers the more advanced topics of transactions, security and database performance tuning. Unfortunately the second book is written unashamedly only for SQL Server and little or no attempt is made to explain how the same functionality is delivered by other databases. I can't understand this. Wrox has a perfect good book already for those keen to learn about SQL Server by Robert Vieira. In my view for the next release of the book Wrox should drop the second section of this book altogether, as it doesn’t belong in a beginners’ guide to SQL and instead ask Paul to beef up the chapters on functions and data types, including an overview of the more often used datatypes in the five RDBMSs. In my experience beginners need to know how to use IDENTITY and SEQUENCE generators when they build their first database applications, not security and database performance tuning.
|
|
|
Learn how to have your own
Amazon Shop
Travel Maps and Guides
zeugma
| | Holiday Travel |
alpharooms.com for cheap holiday deals in spain and worldwide
Disneyland Paris for a great family holiday or short break.
Holday Cottages throughout Scotland, England, Wales, Ireland and France with Cottages4you
Hilton - need we say more, you will find Hilton Hotels in most areas throughout Britain, in cities and in the countryside.
Don't forget Travel Insurance
Airport Parking
|
|
|
|