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

Hernandez, Michael J.; Viescas, John L.

Brossura

ISBN 10: 0201433362 ISBN 13: 9780201433364

Casa editrice: Addison-Wesley, 2000

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.

Su questo libro

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.

Dettagli dell?edizione

• Editore: Addison-Wesley
• Data di pubblicazione: 2000
• Lingua: Inglese
• ISBN 10: 0201433362
• ISBN 13: 9780201433364
• Rilegatura: Copertina flessibile
• Numero di pagine: 492
• Contatto del produttore: non disponibile
• Persona responsabile: non disponibile