Do you speak SQL? We do, and in this book we'll teach you how to use it for your real-world development projects! Every good programmer must have a working knowledge of SQL (Structured Query Language), and the practical approach of this book makes it an excellent choice for starting or improving your database programming skills.
The Programmer's Guide to SQL provides a practical guide to the SQL standard and to the way it is implemented with five of the most important database software today:
Oracle,
DB2,
SQL Server,
MySQL and
Access. Also, it is the only SQL book to provide two complete case studies with realistic examples, relevant to many of your database programming tasks.
The book discusses:
- Querying, modifying and summarizing data using 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
