An introduction to relational database management and SQL, concentrating on solving real business problems, for those with no previous knowledge of SQL. The accompanying CD-ROM contains the Windows 3.x, Windows 95, and Windows NT versions of an SQL database. This third edition is updated to cover the ANSI SQL '92 standard, and includes specific solutions, ready-to-use code, and general strategies for common business database challenges. Annotation c. by Book News, Inc., Portland, Or.

The Practical SQL Handbook: Using Structured Query Language (3rd Edition)

Computers & Technology

Bowman, Judith S.

Emerson, Sandra L.

Darnovsky, Marcy

Programming

Addison-Wesley

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. Highlights include: <ul>
<li>Detailed coverage of SQL commands for creating databases, tables, and indexes, and for </li> <li>adding, changing, and deleting data</li> <li>Using the SELECT command to retrieve specific data</li> <li>Handling NULL values (missing information) in a relational database</li> <li>Joining tables, including self joins and outer joins (ANSI and WHERE-clause syntax)</li> <li>Working with nested queries (subqueries) to get data from multiple tables</li> <li>Creating views (virtual tables) to provide customized access to data</li> <li>Using SQL functions</li> </ul>
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. 0201703092B05222001

The Practical SQL Handbook: Using SQL Variants

Addison-Wesley Professional

See the best price to sell, buy, or rent books by Bowman, Judith S.. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Bowman, Judith S.