Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
The Programmer's Guide to SQL
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

The Programmer's Guide to SQL

The Programmer's Guide to SQL

Cristian Darie, Karli Watson

560 pages, parution le 05/11/2003

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

Livraison à partir de 0,01 en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients sav@commande.eyrolles.com
librairie française
Librairie française depuis 1925
Recevez nos newsletters
Vous serez régulièrement informé(e) de toutes nos actualités.
Inscription