Description - The Programmer's Guide to SQL by Cristian Darie
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.
Buy The Programmer's Guide to SQL by Cristian Darie from Australia's Online Independent Bookstore, Boomerang Books.
(235mm x 178mm x mm)
Country of Publication:
Other Editions - The Programmer's Guide to SQL by Cristian Darie
Book Reviews - The Programmer's Guide to SQL by Cristian Darie
Author Biography - Cristian Darie
Cristian Darie is a software engineer with experience in a wide range of modern technologies. He is the author of numerous books, including his popular ASP.NET C# e-commerce tutorial, his Ajax and PHP tutorial, and his search engine optimization tutorial for PHP developers. Cristian studied distributed application architectures for his Ph.D, and is getting involved with various commercial and research projects. When not planning to buy Google, he enjoys his bit of social life. If you want to say "Hi," you can reach Cristian through his personal website, www.CristianDarie.ro.