Overview
Combines the proven tutorial approach to teaching SQL with a collection of SQL solutions for practical business problems
Shows programmers how to perform all of the most common SQL tasks for 5 of the most common databases: SQL Server, Oracle, DB2, Access and MySQL
Ideal for programmers needing to adapt their SQL code for a different database
Provides clearly explained code examples for all databases
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (15 chapters)
-
Front Matter
-
Back Matter
Keywords
About this book
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.
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 authors
Bibliographic Information
Book Title: The Programmer's Guide to SQL
Authors: Cristian Darie, Karli Watson, Chris Hart, Kevin Hoffman, Julian Skinner
DOI: https://doi.org/10.1007/978-1-4302-0800-6
Publisher: Apress Berkeley, CA
-
eBook Packages: Springer Book Archive
Copyright Information: Cristian Darie, Karli Watson with Chris Hart, Kevin Hoffman, Julian Skinner 2003
Softcover ISBN: 978-1-59059-218-2Published: 08 October 2003
eBook ISBN: 978-1-4302-0800-6Published: 01 January 2008
Edition Number: 1
Number of Pages: XV, 576
Topics: Database Management, Software Engineering/Programming and Operating Systems