In each case, the book demonstrates how the SQL standard is implemented (and and often extended) by each database system vendor. Specific topics include:
Querying, modifying, and summarizing data 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 show how to create and query the underlying database for a fully featured website, as well as how to implement role-based security in your applications. This book is ideal for any programmer, analyst, or database administrator in search of a SQL reference that also demonstrates how to use SQL to solve real business problems.
Títulos relacionados con The Programmer's Guide to SQL:
*Para península. Tiempo estimado para días laborables
