The Practical SQL Handbook: Using SQL Variants

The Practical SQL Handbook: Using SQL Variants

<P>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. <I> <B>The Practical SQL Handbook, Fourth Edition </B> </I>now includes expanded platform SQL coverage and extensive real-world examples based on feedback from actual SQL users.</P> <P> <I> <B>The Practical SQL Handbook </B> </I>begins with a step-by-step introduction to SQL basics and examines the issues involved in designing SQL-based database applications. It fully explores SQL’s most popular implementations from industry leaders, Oracle, Microsoft, Sybase, and Informix.</P> <P>Highlights include:</P> <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> <P>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.</P> <P> <I> <B>The Practical SQL Handbook </B> </I>is the most complete reference available for day-to-day SQL implementations.</P> <br> <br> 0201703092B05222001