Practical SQL Handbook, Fourth Edition now includes expanded platform SQL coverage and extensive real-world examples based on input from actual SQL users. Practical SQL Handbook begins with a step-by-step introduction to the basics of SQL and examine the issues involved in designing SQL database-based application. It fully explores the most popular SQL implementations from industry leaders, Oracle, Microsoft, Sybase, and Informix. Includes: Detailed coverage of SQL commands to create databases, tables, and indexes, and to add, modify, and delete data Use the SELECT command to retrieve specific data handling NULL values (missing information) in a relational database Joining tables, including self joins and outer joins (ANSI and WHERE-clause syntax) Working with nested queries (subqueries) to get data from multiple tables Create views (virtual tables) to provide customized access to data Using SQL functions A bonus CD-ROM containing versions, limited full-time features of Sybase Adaptive Server Anywhere?