Special Edition Using SQL [Paperback]

Rafe Colburn (Author)

Book Description

Publication Date: November 6, 1999 | ISBN-10: 0789719746 | ISBN-13: 978-0789719744 | Edition: 1

Special Edition Using SQL provides a comprehensive walk through of the SQL language. At the same time, this book is a useful reference to someone who is already an experienced database user and SQL programmer. It includes lots of information that will help you build, maintain, and manage a database. Topics covered include Database Design, Aggregating Query Results, Organizing Query Results, Real World Issues, Database Performance and Integrity, Database Security, Transactions, Stored Procedures, Database Management, Writing a Custom Loader in Perl, ODBC, DBI/DBD, JDBC, Web Publishing, and Tools for Web Publishing.

Editorial Reviews

From the Back Cover

Special Edition Using SQL provides a comprehensive walk through of the SQL language. At the same time, this book is a useful reference to someone who is already an experienced database user and SQL programmer. It includes lots of information that will help you build, maintain, and manage a database. Topics covered include Database Design, Aggregating Query Results, Organizing Query Results, Real World Issues, Database Performance and Integrity, Database Security, Transactions, Stored Procedures, Database Management, Writing a Custom Loader in Perl, ODBC, DBI/DBD, JDBC, Web Publishing, and Tools for Web Publishing.

About the Author

Rafe Colburn is a programmer working for Interpath Communications in the Professional Services department. He spends most of his time writing database-backed Web applications used on both public Web sites and Intranets. He has extensive experience designing both small and large scale databases using a number of popular relational database packages. He is also the author of Teach Yourself CGI Programming in a Week.

Product Details

• Paperback: 672 pages
• Publisher: Que; 1 edition (November 6, 1999)
• Language: English
• ISBN-10: 0789719746
• ISBN-13: 978-0789719744
• Product Dimensions: 9.1 x 7.4 x 1.6 inches
• Shipping Weight: 2.6 pounds (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars  See all reviews (6 customer reviews)
• Amazon Best Sellers Rank: #1,783,257 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

15 of 15 people found the following review helpful:

5.0 out of 5 stars I'm back to buy another copy..., February 21, 2000

By 

Joseph Clark (Portland, Maine) - See all my reviews

This review is from: Special Edition Using SQL (Paperback)

The copy my company owns is so good, I decided to buy one for myself! This is an excellent reference to SQL and database design in general, from a basic discussion of the normal forms to the most complex applications of SQL. I use it as a learning tool as well as a reference. It features easy, understandable examples and discussions of the real-world differences between databases, application servers, and development techniques. Highly recommended.

9 of 9 people found the following review helpful:

5.0 out of 5 stars Soon to be a Classic, February 23, 2000

By 

Ananda Sim (Australia) - See all my reviews

This review is from: Special Edition Using SQL (Paperback)

SQL has come from the dusts and cobwebs of Codd-Date academia journals to a business use language. Rafe has written one of the best books I have browsed through. I develop in MS Access and the jump from Access to SQL Server or Oracle is intimidating. Even though MS says that the transition is easy, these are essentially different animals with different properties and behaviours.

The content design means that one can improve on one's knowledge of any (generic) product and still have an intro to a specific product.

The tips pages on the inside covers are a very good idea.

In such a high quality book however, the quality control of content does have a few bad spots.

And Rafe, stay away from words like "egregious" - we're here to learn SQL not English

5 of 6 people found the following review helpful:

5.0 out of 5 stars Excellent Resource for More Advanced SQL Questions, June 1, 2001

By 

Mark K. Mcdonough "Mark McDonough" (Reston, VA USA) - See all my reviews
(VINE VOICE)    (REAL NAME)   

This review is from: Special Edition Using SQL (Paperback)

When I was doing sorta minimal SQL and mostly concentrating on programming, database administration and debugging, the fairly sketchy SQL books I happened to buy first were good enough.

But recently I've started doing lots of web-database development, writing much more complex queries and having to be a lot smarter about SQL. This book has been quite helpful. Yes, there are a lot of words here, and yes, I would have trimmed a couple of chapters. But the book explains a great deal of complex info and is written very clearly. It's clear that the author is tied to real world -- I gather from his bio that he's a web application developer in real life. Wish I'd bought the book earlier.

When I want to quickly remind myself of some common bit of syntax, there are other books where I can find the info quicker. But when I have those "gee, how am I going to do *this*?" moments, this is the book I grab.