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

Hernandez, Michael J.,Viescas, John L.

ISBN 10: 0201433362 / ISBN 13: 9780201433364

Editore: Addison-Wesley, 2000

Riguardo questo articolo

Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority!

Codice articolo S_433664453

Dati bibliografici

• Titolo: SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
• Editore: Addison-Wesley
• Data di pubblicazione: 2000
• Lingua: Inglese
• ISBN 10: 0201433362
• ISBN 13: 9780201433364
• Rilegatura: paperback
• Condizione: Good

Descrizione articolo

Riassunto

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.

Informazioni sull?autore

Michael J. Hernandez is a well-known relational database consultant, and is the owner of DataTex Consulting Group in Seattle. He has been a featured speaker at a variety of database conferences and is the author of Database Design for Mere Mortals. 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 Programmers Quick Reference Guide to SQL.