The Programmer's Guide to SQL (Paperback, Softcover reprint of the original 1st ed.)

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. in search of an SQL reference that also demonstrates how to use SQL to solve real business problems

General

Imprint:	Apress
Country of origin:	United States
Release date:	October 2003
First published:	2003
Authors:	Cristian Darie • Karli Watson
Dimensions:	235 x 178 x 25mm (L x W x T)
Format:	Paperback
Pages:	576
Edition:	Softcover reprint of the original 1st ed.
ISBN-13:	978-1-59059-218-2
Categories:	Books > Computing & IT > Computer programming > General Books > Computing & IT > Computer software packages > Database software > General Books > Computing & IT > Applications of computing > Databases > General
LSN:	1-59059-218-2
Barcode:	9781590592182

Is the information for this product incomplete, wrong or inappropriate? Let us know about it.

Does this product have an incorrect or missing image? Send us a new image.

Is this product missing categories? Add more categories.

Review This Product

No reviews yet - be the first to create one!