A guide to SQL - Softcover

Philip J. Pratt

Softcover

ISBN 10: 0534984304 ISBN 13: 9780534984304

Publisher: Boyd & Fraser, 1991

Synopsis

A GUIDE TO SQL, Ninth Edition, provides an effective introduction to SQL programming using straightforward instruction, extensive hands-on exercises, and a strong foundation in real-world business applications. The Ninth Edition builds on the longstanding success of this proven text by presenting basic SQL commands in the context of a running case, in which a business uses SQL to manage orders, items, customers, and sales reps. The authors emphasize that fundamental principles and practices apply regardless of the database environment chosen, and they include examples from the latest versions of Oracle and Microsoft Access, and SQL Server throughout the text.

About this title

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.

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 more than 75 textbooks and hasco-authored three levels of Microsoft Office Access 2013 books for the Shelly Cashman Series and A Guide to SQL.

Edition details

• Publisher: Boyd & Fraser
• Publication date: 1991
• Language: English
• ISBN 10: 0534984304
• ISBN 13: 9780534984304
• Binding: Paperback
• Edition number: 2
• Number of pages: 218