- Used Books
- Staff Picks
- Gifts & Gift Cards
- Sell Books
- Stores & Events
- Let's Talk Books
Special Offers see all
More at Powell's
Recently Viewed clear list
New Trade Paper
Ships in 1 to 3 days
Practical SQL Handbook 4TH Edition Using SQL Variatiby Judith Bowman
Synopses & Reviews
This latest edition of the best-selling implementation guide to the Structured Query Language teaches SQL fundamentals while providing practical solutions for critical business applications. The Practical SQL Handbook, Fourth Edition now includes expanded platform SQL coverage and extensive real-world examples based on feedback from actual SQL users.
The Practical SQL Handbook begins with a step-by-step introduction to SQL basics and examines the issues involved in designing SQL-based database applications. It fully explores SQLs most popular implementations from industry leaders, Oracle, Microsoft, Sybase, and Informix.
A bonus CD-ROM contains a time-limited, full-feature version of the Sybase® Adaptive Server Anywhere™ software as well as the sample database, scripts, and examples included in the book.
The Practical SQL Handbook is the most complete reference available for day-to-day SQL implementations.
Book News Annotation:
This guide to implementing Structured Query Language introduces basic concepts and offers practical suggestions for its application to business purposes. Instructions are included for the creation of databases, tables, and indexes, with particular attention to the retrieval of specific data, handling null values, and the use of nested queries and multiple tables. An accompanying CD-ROM contains sample databases, scripts, and examples from the book, in addition to a time-limited version of Sybase Adaptive Server Anywhere software.
Annotation c. Book News, Inc., Portland, OR (booknews.com)
This edition has added coverage of Microsoft SQL Server, Oracle, and Informix. The CD-ROM contains a 60-day full feature version of the Sybase Adaptive Server Anywhere, plus sample database and scripts discussed in the book.
About the Author
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.
Table of Contents
1.SQL and Relational Database Management.
2. Designing Datases.
3. Creating and Filling a Database.
4. Selecting Data from the Database.
5. Sorting Data and Other Selection Techniques.
6. Grouping Data and Reporting from it.
7. Joining Tables for Comprehensive Data Analysis.
8. Structuring Queries with Subqueries.
9. Creating and Using Views.
10. Security, Transactions, Performance, and Integrity.
11. Solving Business Problems.
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.
What Our Readers Are Saying
Other books you might like
Computers and Internet » Computer Languages » SQL