Specific topics include: query, modify, and summarize data by using SQL functions Using complex nested queries and joins Programming database stored procedures, triggers, and views Creating tables, indexes, and other database objects Writing transaction-safe SQL Implementing basic database security The book also includes two complete case studies that demonstrate how to create and query the database for a full-featured website, as well as how to implement role-based security in your application. This book is ideal for any programmer, analyst, or database administrators in finding the SQL reference that also shows how to use SQL to solve real business problems.