- Paperback: 576 pages
- Publisher: Apress; 1 edition (Oct 8 2003)
- Language: English
- ISBN-10: 1590592182
- ISBN-13: 978-1590592182
- Product Dimensions: 23.3 x 18 x 3.1 cm
- Shipping Weight: 903 g
- Amazon Bestsellers Rank: #785,336 in Books (See Top 100 in Books)
- See Complete Table of Contents
|
||||||||||||||||||
|
||||||||||||||||||
|
||||||||||||||||||
| |||||||||||||||
Product Details |
Product Description
Book Description
The Programmer's Guide to SQL provides an in-depth yet concise tutorial on the use of Structured Query Language (SQL). Once you've mastered the fundamentals, the book serves as a handy desktop reference on SQL usage, covering all of the major SQL statements that youll need when programming databases. It also comes complete with example code for five major database systems: SQL Server, Oracle, DB2, MySQL, and Access.
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.
About the Author
Cristian Darie is a software engineer with experience in a wide range of modern technologies, and the author of numerous books, including his popular ASP.NET C# E-Commerce tutorial, his AJAX and PHP tutorial, and his SEO tutorial for PHP developers. Cristian is studying distributed application architectures for his PhD, 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, http://www.cristiandarie.ro.
Karli Watson is the technical director of 3form, as well as a freelance IT specialist, author, developer, and consultant. For the most part, he indulges in .NET and related technologies and has written numerous books about them. He has extensive knowledge of programming database-driven websites and has authored on the titles Beginning ASP .NET 2.0 E-Commerce, Beginning ASP.NET 1.1 E-Commerce, The Programmer's Guide to SQL, Professional C#, Second Edition, and Professional ASP.NET 1.0.
Karli Watson is the technical director of 3form, as well as a freelance IT specialist, author, developer, and consultant. For the most part, he indulges in .NET and related technologies and has written numerous books about them. He has extensive knowledge of programming database-driven websites and has authored on the titles Beginning ASP .NET 2.0 E-Commerce, Beginning ASP.NET 1.1 E-Commerce, The Programmer's Guide to SQL, Professional C#, Second Edition, and Professional ASP.NET 1.0.
Inside This Book
(Learn More)
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Customer Reviews
|
There are no customer reviews yet on Amazon.ca
|
||||||||||||||||||||
|
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
4.0 out of 5 stars (1 customer review)
9 of 11 people found the following review helpful
4.0 out of 5 stars
Nice cross-vendor comparisons, Sep 12 2004
By Thomas M. Shreve - Published on Amazon.com
This review is from: The Programmer's Guide to SQL (Paperback)
A good basic book on SQL development. My favorite thing about the book was the nice way the authors laid out the syntax differences between SQL Server, Oracle, DB2 and MySQL.
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
Would you like to update product info or give feedback on images?
