Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
Mastering Oracle SQL
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

Mastering Oracle SQL

Mastering Oracle SQL

Sanjay Mishra, Alan Beaulieu

475 pages, parution le 19/11/2004

Résumé

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory.

Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracle's implementation of SQL than any other book on the market. It covers Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType.

Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just don't explore the full depth of what is possible with Oracle-specific SQL. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.

L'auteur - Sanjay Mishra

Sanjay Mishra is a certified Oracle database administrator with more than nine
years of IT experience. For the past six years, he has been involved in the design,
architecture, and implementation of many mission-critical and decision support
databases. He has worked extensively in the areas of database architecture, database
management, backup/recovery, disaster planning, performance tuning, Oracle Parallel
Server, and parallel execution. He has a bachelor of science degree in electrical
engineering and a master of engineering degree in systems science and automation. He
can be reached at sanjay_mishra@i2.com.

L'auteur - Alan Beaulieu

Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters and can be reached at albeau_mosql@yahoo.com.

Sommaire

  • Introduction to SQL
  • The WHERE Clause
  • Joins
  • Group Operations
  • Subqueries
  • Handling Temporal Data
  • Set Operations
  • Hierarchical Queries
  • DECODE and CASE
  • Partitioning
  • PL/SQL
  • Objects and Collections
  • Advanced Group Operations
  • Advanced ANALYTIC SQL
  • SQL Best Practice
  • XML
  • Regular Expressions
  • Model Queries
  • Oracle's Old Join Syntax
Voir tout
Replier

Caractéristiques techniques

  PAPIER
Éditeur(s) O'Reilly
Auteur(s) Sanjay Mishra, Alan Beaulieu
Parution 19/11/2004
Nb. de pages 475
Format 18 x 23
Couverture Broché
Poids 800g
Intérieur Noir et Blanc
EAN13 9780596006327
ISBN13 978-0-596-00632-7

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