Alan R. Simon Book order (chronological)

This book serves as an essential resource for transitioning from SQL-92 to SQL-1999, offering much more than a simple bridge. Authored by SQL experts Jim Melton and Alan Simon, it provides a thorough and practical overview of SQL's latest version, detailing how to effectively implement its features. Catering to both novice and experienced users, the text covers the language's capabilities from basic to advanced levels, demonstrating how real applications utilize these features. The authors enhance understanding with engaging references to their custom database, available for download on the companion website. Key features include authoritative coverage from a team that includes the editor of the SQL-92 and SQL:1999 standards, a general introduction to SQL that outlines its components, history, and significance in computer languages, and an exploration of SQL:1999's advanced features such as value expressions, predicates, and active database support. Additionally, it addresses critical issues for programmers connecting applications to SQL databases, offers troubleshooting and internationalization guidance, and anticipates future changes in SQL. Appendices cover database design, a complete SQL-1999 example, and the standardization process, making this a comprehensive resource for anyone looking to deepen their SQL knowledge.