Résumé
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 of 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 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 that show how to create and query the underlying database for a fully featured web site, as well as how to implement role-based security in your applications. As such, it 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.
Contents
- Understanding SQL and Relational Databases
- Retrieving Data with SQL
- Modifying Data
- Summarizing and Grouping Data
- Performing Calculations and Using Functions
- Combining SQL Queries
- Querying Multiple Tables
- Hiding Complex SQL with Views
- Using Stored Procedures
- Transactions
- Users and Security
- Working with Database Objects
- Triggers
- Case Study: Building a Product Catalog
- Case Study: Implementing Role-Based Security
- Appendix A: Executing SQL Statements
- Appendix B: Setting Up the InstantUniversity Database
- Appendix C: Data Types
L'auteur - Cristian Darie
Cristian Darie is the Technical Lead and Project Manager for the Better Business Bureau, Romania. In the last five years he has been designing, implementing, and performance tuning large scale data-oriented software applications with Oracle, DB2, SQL Server, and MySQL databases, while working as a consultant for companies in various industries. He is the co-author of Visual C#: A Guide for VB6 Developers and Beginning ASP.NET E-Commerce and is the author of various MCAD and DB2 certification material. He has contributed as a technical reviewer on numerous database programming titles. Cristian can be contacted through his personal website, http://www.CristianDarie.ro.
L'auteur - Karli Watson
Karli Watson is the technical director of 3form (3form.net) 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 Web sites and has authored on the titles Beginning ASP.NET E-Commerce, Professional C#, Second Edition, and Professional ASP.NET 1.0.
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Apress |
Auteur(s) | Cristian Darie, Karli Watson |
Parution | 05/11/2003 |
Nb. de pages | 560 |
Format | 18 x 23,5 |
Couverture | Broché |
Poids | 910g |
Intérieur | Noir et Blanc |
EAN13 | 9781590592182 |
ISBN13 | 978-1-59059-218-2 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse