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.
