The Programmer's Guide to SQL provides an in-depth yet concise tutorial on the use of Structured Query Language (SQL), the standard that defines how to create and manipulate databases and the data that they store. Once you've mastered the fundamentals, the book serves as a handy desktop reference on SQL usage, covering all the major SQL statements that you're likely to need when programming databases, with example code for five major database systems: SQL Server, Oracle, DB2, MySQL, and Access. In each case, it demonstrates how the SQL standard is implemented, and in some cases extended, by each database system vendor. It discusses: - Querying, modifying and summarizing data using SQL - SQL Functions - Complex nested queries and joins - Programming database stores procedures, triggers and views - Creating tables, indexes and other database objects - How to write transaction-safe SQL - How to implement basic database security The book covers the very latest version of the SQL standard, SQL-99, and includes two complete case studies, showing how to create and query the underlying database for a fully featured web site, and how to implement role-based security in your applications. As such, it is ideal for any programmer, analyst, or database administrator in search of an SQL reference that also demonstrates how to use SQL to solve real business problems.

This book covers Structured Query Language (SQL), the standard that defines how to create and manipulate databases and the data that they store. It works well on two levels: As an in-depth yet concise tutorial on how to use the language, with lots of clearly worked examples and as a handy desktop reference on SQL implementation, covering all the major SQL statements that you're likely to need when programming databases, with example code for five major database systems: SQL Server, Oracle, DB2, MySQL, and Access.

Understanding SQL.- Retrieving Data.- Modifying Data.- Summarizing Data.- Functions.- Combining SQL Queries.- Table Joins.- Hiding Complex SQL with Views.- Stored Procedures.- Transactions.- Security.- Working with Database Objects.- Triggers.- Appendices.