SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

Hernandez, Michael J.

ISBN 10: 0201433362 / ISBN 13: 9780201433364

Published by Addison-Wesley, 2000

About this Item

Get fast and secure shipping knowing your purchase helps empower our community to transform their lives through work.

Seller Inventory # 4RZURM000W46

Bibliographic Details

• Title: SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
• Publisher: Addison-Wesley
• Publication Date: 2000
• Language: English
• ISBN 10: 0201433362
• ISBN 13: 9780201433364
• Binding: paperback
• Condition: Good

About this title

Synopsis

Now there's a practical, hands-on guide to SQL for millions of beginning-to-intermediate database users who desperately need to create fast, accurate, effective queries -- whether they have formal database training or not. The authors begin by introducing the fundamental concepts underlying relational databases and SQL. They then introduce the absolute basics of SQL, including the SELECT statement, creating expressions, and applying filters. Next, they introduce techniques for solving one of the most common problems database users encounter: drawing data from multiple tables at once. The book includes detailed coverage of grouping, totaling, and summarizing data; using SQL to update, insert, and delete data; and more. In the final section, Hernandez and Viescas introduce "thinking out of the box" techniques that allow users to solve a wide variety of complex SQL problems. Most chapters end with sample problems, solutions, and result sets -- all based on a library of five real-world databases included on the accompanying CD-ROM.

About the Author

Michael J. Hernandez is a program manager for the Visual Studio .NET group at Microsoft, and is a veteran relational database developer with more than fourteen years of experience. He has been a premiere instructor with training organizations such as AppDev Training Co., Focal Point, Inc., and Deep Training, and was one of the first two hundred Microsoft-authorized .NET instructors. He speaks regularly at conferences.

John L. Viescas is President of Viescas Consulting, Inc., a respected provider of database consulting services. He is also the author of the best-selling Running Microsoft Access 2000 and Programmer's Quick Reference Guide to SQL.

0201433362AB02032003