A Guide to SQL [Paperback]

Philip J. Pratt (Author), Mary Z. Last (Author)

Book Description

ISBN-10: 0324597681 | ISBN-13: 978-0324597684 | Publication Date: October 2, 2008 | Edition: 8

A GUIDE TO SQL, 8E, continues to be the essential SQL reference. It builds on the success of previous editions by presenting basic SQL commands in the context of a running case in which a business uses SQL to manage orders, parts, customers, and sales reps. The book covers the fundamentals of SQL programming using straightforward instruction and extensive hands-on exercises. Continuing with its focus on learning the basics regardless of the database environment chosen, this edition features examples from the latest databases: Oracle 11g, Access 2007, and MySQL. The eighth edition expands on the use of running case studies by adding a third running case to the extensive hands-on pedagogy at the end of every chapter.

Editorial Reviews

Amazon.com Review

The author uses an interesting didactic innovation that every textbook writer should consider imitating: Instead of illustrating ideas with microprograms, which are good for almost nothing except illustrating the idea, Pratt develops two examples throughout the entire book. By the time you complete this thin but comprehensive volume, you will have completed two real databases. The book also contains embedded questions so you can check whether or not you've grasped specific concepts before proceeding to the next section. Pratt's extended case studies show how SQL programs can be layered on one another other to slowly build up functionality. As such, it serves both as an SQL language manual as well as an example of how to create relatively large SQL codes. This book does not make specific reference to any particular SQL implementation, so it can be used with any standard SQL engine. --This text refers to an out of print or unavailable edition of this title.

About the Author

Philip J. Pratt is Professor Emeritus of Mathematics and Computer Science at Grand Valley State University, where he taught for 33 years. His teaching interests include database management, systems analysis, complex analysis, and discrete mathematics. He has authored over 60 textbooks, including coauthoring three levels of Microsoft Office Access 2007 books for the Shelly Cashman Series. --This text refers to an alternate Paperback edition.

Product Details

• Paperback: 309 pages
• Publisher: Course Technology; 8 edition (October 2, 2008)
• Language: English
• ISBN-10: 0324597681
• ISBN-13: 978-0324597684
• Product Dimensions: 9 x 7.3 x 0.8 inches
• Shipping Weight: 1.2 pounds (View shipping rates and policies)
• Average Customer Review: 3.5 out of 5 stars  See all reviews (18 customer reviews)
• Amazon Best Sellers Rank: #20,152 in Books (See Top 100 in Books)
  • #5 in Books > Computers & Technology > Microsoft > Development > SQL Server
  • #23 in Books > Computers & Technology > Computer Science > Software Engineering > Information Systems

More About the Author

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

Customer Reviews

Most Helpful Customer Reviews

11 of 12 people found the following review helpful:

2.0 out of 5 stars Not really bad, but not that good either, May 19, 2003

By 

"acdaniel" (San Diego, CA USA) - See all my reviews

This review is from: A Guide to SQL, Fifth Edition (Paperback)

I didn't choose this book, it is required for an SQL class I am taking. In our class we are using Microsoft SQL Server 7, and the book tells you that the code will work on any flavors of SQL (or maybe I misread) but it actually focuses on Oracle. Some commands are really different for MSSQL,which uses Transact-SQL, and I have to do a lot of searching to find the equivalents in Microsoft's version.

The book is made for beginners, real beginners. It tells you a little bit about the history of SQL and stuff. Then it starts talking about databases in general, but it never gets really far, it just briefly explains what databases are, and I think people would want more than what is said here.

Then it starts with SQL scripting and all the normal chapters.

One thing I didn't like, is that in the first chapter it jumps you to the code, before explaining what it does. And it never really explains the code thoroughly. It could use more examples with different situations.

One more thing, this is the kind of book that you have to follow the little game. "We are building this database...", it's all been done for you, you never get to design or understand the concepts of designing a database, and doesn't explain a lot about foreign keys and relationships. It tells you "it's a real world database"...but you never really learn anything until you do it on your own.

I wouldn't recommend it...

11 of 15 people found the following review helpful:

2.0 out of 5 stars A Guide To SQL, December 15, 1999

By 

Michael L Holman (US) - See all my reviews

This review is from: Guide to SQL (Paperback)

Sketchy at best. Gives some good examples but does not cover all of the SQL language. Jumps around a lot. Definitely not worth the 30+ dollars.

2 of 2 people found the following review helpful:

4.0 out of 5 stars GOOD STARTING POINT FOR SQL LEARNING, November 3, 2006

By 

Geo (San Juan, PR) - See all my reviews

This review is from: A Guide to SQL (Paperback)

For SQL Learning "GUIDE TO SQL" is a good book. Its stays on the basics, and it assumes that you know how to differ a good DB design from a bad one. The book goes over the main stream of database systems, MSSQL, MYSQL, and Oracle, but it focuses the most on Oracle. This book is a good buy if you want to learn SQL fast.