The Practical SQL Handbook is the best-selling guide to learning SQL, the standard language for accessing information in relational databases. This book not only teaches SQL as it has been established by ANSI standards committees but also as the language is used to solve real business problems. You'll learn step-by-step the basic vocabulary and functions of the language and the processes and issues involved in developing robust applications. This book provides a thorough grounding in the basics of database design, security, and integrity. You will learn SQL pragmatically, by creating a sample database and then working through dozens of examples with it. Fully updated to cover the ANSI SQL '92 standard, the third edition of The Practical SQL Handbook includes a cookbook of specific solutions, ready-to-use code, and general strategies for common business database challenges. Find out how to: *create and use views *use and apply subqueries *join tables for comprehensive data analysis *handle null values *create reports using groups and aggregate functions Bonus CD-ROM -- Get Hands-On Practice Using SQL!The CD-ROM includes the Windows 3.x
, Windows 95, and Windows NT versions of the SybaseA (R) 3.0 SQL AnywhereaA A Runtime, a full-featured SQL database. 0201447878B04062001
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Maße
Höhe: 230 mm
Breite: 187 mm
Dicke: 29 mm
Gewicht
ISBN-13
978-0-201-44787-3 (9780201447873)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Judith S. Bowman has been a database professional since the early 1980s. She is currently an independent consultant specializing in SQL and relational database issues and is the author of Practical SQL: The Sequel (Addison-Wesley, 2001). Sandra L. Emerson is an independent consultant and former Vice President of Publishing Programs for Sybase. Marcy Darnovsky, teaches at colleges throughout the San Francisco Bay area. She was formerly at Sybase.
0201447878AB04062001
*SQL and Relational Database Management *Designing Databases *Creating and Filling a Database *Selecting Data from the Database *Sorting Data and Other Selection Techniques *Grouping Data and Reporting from It *Joining Tables for Comprehensive Data Analysis *Structuring Queries with Subqueries *Creating and Using Views *Security, Transactions, Performance and Integrity *Solving Business Problems *Mistakes and How to Avoid Them Appendix A: Syntax Summary for the SQL Used in this Book Appendix B: Industry SQL Equivalents Appendix C: Glossary Appendix D: The Bookbiz Sample Database Appendix E: Bibliography Index
