sql: practical guide for developers

contents 1 databasics 2 retrieval: basic selection 3 reshaping results 4 aggregating results 5 joins 6 set queries: union, intersect, and except 7 subqueries 8 modifying data 9 creating, deleting, and altering tables 10 views 11 transactions 12 database privileges 13 introduction to cursors, embedded sql, stored procedures, and triggers index 9202 – xếp hạng
Nội dung trích xuất từ tài liệu:
sql: practical guide for developersCritical Acclaim forSQL: Practical Guide for DevelopersThe book lives up to its title: it is a very practical guide. The authors clearly know their SQLand manage to write about the language in a step-by-step style that progresses smoothlyfrom the simple to the more difficult aspects of the language. The profuse use of examples,each with an accompanying motivation and explanation of the results, lets the reader followeven complex topics without a constant struggle. The authors have even included examplesthat illustrate common errors programmers make, explaining the right way to perform thetask. It doesn’t hurt that the sample application is based on something everybody uses everyday: food.I especially enjoyed the manner in which the authors explained the rationale behind mostof the SQL facilities. Even though they have not been an active part of the standard’s devel-opment efforts, their insight into the underlying reasons for a feature’s inclusion is spoton. They also do an excellent job of explaining complex sets of rules in easily understoodlanguage—I learned new ways of understanding some of the very rules that I personallywrote into the standard!Each chapter ends with a summary of the principle points, and most of them include prac-tical advice for programmers who intend to use the SQL language features described in thechapter. The inclusion at every chapter’s end of a set of questions and exercises—all directlyrelevant to the chapter’s material—makes this book an excellent candidate for use in theclassroom.– Jim Melton, Oracle Corporation, Editor of ISO/IEC 9075-* (SQL) and Co-Chair, W3C XMLQuery Working GroupThis book provides a succinct yet complete introduction to the fundamental aspects of theSQL language. It is not just another SQL text. The authors’ use of simple yet clear examplesto illustrate difficult concepts throughout the text makes this a perfect book for use in anintroductory database systems class as a supplement or as an introductory reference forthe novice practitioner.– Paul Fortier, University of Massachusetts, DartmouthSQL: Practical Guidefor DevelopersThe Morgan Kaufmann Practical Guides SeriesSeries Editor, Michael J. DonahooSQL: Practical Guide for DevelopersMichael J. Donahoo and Gregory D. SpeegleC# 2.0: Practical Guide for ProgrammersMichel de Champlain and Brian G. PatrickMulti-Tier Application Programming with PHP: Practical Guide for Architectsand ProgrammersDavid WallTCP/IP Sockets in C#: Practical Guide for ProgrammersDavid B. Makofske, Michael J. Donahoo, and Kenneth L. CalvertJava Cryptography Extensions: Practical Guide for ProgrammersJason WeissJSP: Practical Guide for Java ProgrammersRobert J. BrunnerJSTL: Practical Guide for JSP ProgrammersSue SpielmanJava: Practical Guide for ProgrammersZbigniew M. SikoraThe Struts Framework: Practical Guide for Java ProgrammersSue SpielmanMulticast Sockets: Practical Guide for ProgrammersDavid Makofske and Kevin AlmerothTCP/IP Sockets in Java: Practical Guide for ProgrammersKenneth L. Calvert and Michael J. DonahooTCP/IP Sockets in C: Practical Guide for ProgrammersMichael J. Donahoo and Kenneth L. CalvertJDBC: Practical Guide for Java ProgrammersGregory D. SpeegleFor further information on these books and for a list of forthcoming titles, please visit ourWeb site at http://www.mkp.com/practicalSQL: Practical Guidefor Developers Michael J. Donahoo Gregory D. Speegle AMSTERDAM • BOSTON • HEIDELBERG • LONDON NEW YORK • OXFORD • PARIS • SAN DIEGO SAN FRANCISCO • SINGAPORE • SYDNEY • TOKYO Morgan Kaufmann Publishers is an imprint of ElsevierPublisher Diane CerraPublishing Services Manager Simon CrumpProject Manager Brandy LillyEditorial Assistant Asma StephanCover Design Yvo RiezebosCover Image Getty ImagesComposition Cepha Imaging Pvt. Ltd.Technical Illustration Dartmouth Publishing, Inc.Copyeditor Graphic World Inc.Proofreader Graphic World Inc.Interior printer The Maple-Vail Book Manufacturing GroupCover printer Phoenix Color Corp.Morgan Kaufmann Publishers is an imprint of Elsevier.500 Sansome Street, Suite 400, San Francisco, CA 94111This book is printed on acid-free paper.© 2005 by Elsevier Inc. All rights reserved.Designations used by companies to distinguish their products are often claimed as trademarks orregistered trademarks. In all instances in which Morgan Kaufmann Publishers is aware of a claim,the product names appear in initial capital or all capital letters. Readers, however, should contactthe appropriate companies for more complete information regarding trademarks and registration.No par ...