The Art of SQL

Note moyenne 3,85
( 98 avis fournis par Goodreads )
 
9780596008949: The Art of SQL

For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and most IT departments believe that developers should provide simple SQL code to solve immediate problems and let DBAs tune any "bad SQL" later.

In The Art of SQL, author and SQL expert Stephane Faroult argues that this "safe approach" only leads to disaster. His insightful book, named after Art of War by Sun Tzu, contends that writing quick inefficient code is sweeping the dirt under the rug. SQL code may run for 5 to 10 years, surviving several major releases of the database management system and on several generations of hardware. The code must be fast and sound from the start, and that requires a firm understanding of SQL and relational theory.

The Art of SQL offers best practices that teach experienced SQL users to focus on strategy rather than specifics. Faroult's approach takes a page from Sun Tzu's classic treatise by viewing database design as a military campaign. You need knowledge, skills, and talent. Talent can't be taught, but every strategist from Sun Tzu to modern-day generals believed that it can be nurtured through the experience of others. They passed on their experience acquired in the field through basic principles that served as guiding stars amid the sound and fury of battle. This is what Faroult does with SQL.

Like a successful battle plan, good architectural choices are based on contingencies. What if the volume of this or that table increases unexpectedly? What if, following a merger, the number of users doubles? What if you want to keep several years of data online? Faroult's way of looking at SQL performance may be unconventional and unique, but he's deadly serious about writing good SQL and using SQL well. The Art of SQL is not a cookbook, listing problems and giving recipes. The aim is to get you-and your manager-to raise good questions.

Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

About the Author :

Stephane Faroult first discovered relational databases and the SQL language back in 1983. He joined Oracle France in their early days (after a brief spell with IBM and a bout of teaching at the University of Ottawa) and soon developed an interest in performance and tuning topics. After leaving Oracle in 1988, he briefly tried to reform and did a bit of operational research, but after one year, he succumbed again to relational databases. He has been continuously performing database consultancy since then, and founded RoughSea Ltd in 1998.

Graduated in geology from Durham University (1968), then taught at Edinburgh University, obtaining an M.Phil in geology 1975. Worked in Greece as a geologist (1973,74), and then in University of Newcastle specialising in geological databases.Joined the British Geological Survey 1980, and has steered the organisations' use of database ever since, as data architect and database administrator. Has worked with databases since 1977, relational databases since 1981, and Oracle since 1985. He has lectured widely in the UK on geological aspects of database and has specialised on aspects of the SQL system as well as data modelling from the corporate architecture down to the departmental level. He has presented at various Oracle database conferences both in the UK, Europe and North America. Currently a director on the board of the UK Oracle Users Group.

Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.

Meilleurs résultats de recherche sur AbeBooks

Edition internationale
Edition internationale

1.

Stephane Faroult; Peter Robson
ISBN 10 : 0596008945 ISBN 13 : 9780596008949
Neuf(s) Paperback Quantité : 15
Edition internationale
Vendeur
US_Superfast_Bookstore
(New Castle, DE, Etats-Unis)
Evaluation vendeur
[?]

Description du livre Paperback. État : New. This is an International Edition Brand New Paperback Same Title Author and Edition as listed. ISBN and Cover design differs. Similar Contents as U.S Edition. Standard Delivery within 6-14 business days ACROSS THE GLOBE. We can ship to PO Box address in US. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" or "For sale in Asia only" or similar restrictions- printed only to discourage students from obtaining an affordable copy. US Court has asserted your right to buy and use International edition. Access code/CD may not provided with these editions. We may ship the books from multiple warehouses across the globe including Asia depending upon the availability of inventory. Printed in English. Customer satisfaction guaranteed. N° de réf. du libraire U_9780596008949

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 11,93
Autre devise

Ajouter au panier

Frais de port : EUR 2,27
Vers Etats-Unis
Destinations, frais et délais

2.

Faroult, Stephane
ISBN 10 : 0596008945 ISBN 13 : 9780596008949
Neuf(s) Paperback Quantité : > 20
impression à la demande
Vendeur
BargainBookStores
(Grand Rapids, MI, Etats-Unis)
Evaluation vendeur
[?]

Description du livre Paperback. État : New. This item is printed on demand. Item doesn't include CD/DVD. N° de réf. du libraire 848299

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 23,19
Autre devise

Ajouter au panier

Frais de port : EUR 3,42
Vers Etats-Unis
Destinations, frais et délais
Edition internationale
Edition internationale

3.

Faroult, Stephane; Robson, Peter
Edité par O'Reilly Media
ISBN 10 : 0596008945 ISBN 13 : 9780596008949
Neuf(s) Couverture souple Quantité : 15
Edition internationale
Vendeur
Sunshine Book Store
(Wilmington, DE, Etats-Unis)
Evaluation vendeur
[?]

Description du livre O'Reilly Media. État : New. 0596008945 This is an International Edition. Brand New, Paperback, Delivery within 6-14 business days, Similar Contents as U.S Edition, ISBN and Cover design may differ, printed in Black & White. Choose Expedited shipping for delivery within 3-8 business days. We do not ship to PO Box, APO , FPO Address. In some instances, subjects such as Management, Accounting, Finance may have different end chapter case studies and exercises. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" and "Content may different from U.S. Edition" - printed only to discourage U.S. students from obtaining an affordable copy. The U.S. Supreme Court has asserted your right to purchase international editions, and ruled on this issue. Access code/CD is not provided with these editions , unless specified. We may ship the books from multiple warehouses across the globe, including India depending upon the availability of inventory storage. Customer satisfaction guaranteed. N° de réf. du libraire HU_9780596008949

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 26,69
Autre devise

Ajouter au panier

Frais de port : Gratuit
Vers Etats-Unis
Destinations, frais et délais

4.

Faroult, Stephane; Robson, Peter
Edité par O'Reilly Media
ISBN 10 : 0596008945 ISBN 13 : 9780596008949
Neuf(s) PAPERBACK Quantité : > 20
Vendeur
Mediaoutlet12345
(Springfield, VA, Etats-Unis)
Evaluation vendeur
[?]

Description du livre O'Reilly Media. PAPERBACK. État : New. 0596008945 *BRAND NEW* Ships Same Day or Next!. N° de réf. du libraire SWATI2122346784

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 24,34
Autre devise

Ajouter au panier

Frais de port : EUR 3,42
Vers Etats-Unis
Destinations, frais et délais

5.

Stephane Faroult, Peter Robson
Edité par O Reilly Media, Inc, USA, United States (2006)
ISBN 10 : 0596008945 ISBN 13 : 9780596008949
Neuf(s) Paperback Quantité : 1
Vendeur
The Book Depository
(London, Royaume-Uni)
Evaluation vendeur
[?]

Description du livre O Reilly Media, Inc, USA, United States, 2006. Paperback. État : New. Language: English . Brand New Book. For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and most IT departments believe that developers should provide simple SQL code to solve immediate problems and let DBAs tune any bad SQL later. In The Art of SQL , author and SQL expert, Stephane Faroult argues that this safe approach only leads to disaster. His insightful book, named after Art of War by Sun Tzu, contends that writing quick inefficient code is sweeping the dirt under the rug. SQL code may run for 5 to 10 years, surviving several major releases of the database management system and on several generations of hardware. The code must be fast and sound from the start, and that requires a firm understanding of SQL and relational theory. The Art of SQL offers best practices that teach experienced SQL users to focus on strategy rather than specifics. Faroult s approach takes a page from Sun Tzu s classic treatise by viewing database design as a military campaign. You need knowledge, skills, and talent.Talent can t be taught, but every strategist from Sun Tzu to modern-day generals believed that it can be nurtured through the experience of others. They passed on their experience acquired in the field through basic principles that served as guiding stars amid the sound and fury of battle. This is what Faroult does with SQL. Like a successful battle plan, good architectural choices are based on contingencies. What if the volume of this or that table increases unexpectedly? What if, following a merger, the number of users doubles? What if you want to keep several years of data online? Faroult s way of looking at SQL performance may be unconventional and unique, but he s deadly serious about writing good SQL and using SQL well. The Art of SQL is not a cookbook, listing problems and giving recipes. The aim is to get you - and your manager - to raise good questions. N° de réf. du libraire AAH9780596008949

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 28,62
Autre devise

Ajouter au panier

Frais de port : Gratuit
De Royaume-Uni vers Etats-Unis
Destinations, frais et délais

6.

Stephane Faroult, Peter Robson
Edité par O Reilly Media, Inc, USA, United States (2006)
ISBN 10 : 0596008945 ISBN 13 : 9780596008949
Neuf(s) Paperback Quantité : 1
Vendeur
The Book Depository US
(London, Royaume-Uni)
Evaluation vendeur
[?]

Description du livre O Reilly Media, Inc, USA, United States, 2006. Paperback. État : New. Language: English . Brand New Book. For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and most IT departments believe that developers should provide simple SQL code to solve immediate problems and let DBAs tune any bad SQL later. In The Art of SQL , author and SQL expert, Stephane Faroult argues that this safe approach only leads to disaster. His insightful book, named after Art of War by Sun Tzu, contends that writing quick inefficient code is sweeping the dirt under the rug. SQL code may run for 5 to 10 years, surviving several major releases of the database management system and on several generations of hardware. The code must be fast and sound from the start, and that requires a firm understanding of SQL and relational theory. The Art of SQL offers best practices that teach experienced SQL users to focus on strategy rather than specifics. Faroult s approach takes a page from Sun Tzu s classic treatise by viewing database design as a military campaign. You need knowledge, skills, and talent.Talent can t be taught, but every strategist from Sun Tzu to modern-day generals believed that it can be nurtured through the experience of others. They passed on their experience acquired in the field through basic principles that served as guiding stars amid the sound and fury of battle. This is what Faroult does with SQL. Like a successful battle plan, good architectural choices are based on contingencies. What if the volume of this or that table increases unexpectedly? What if, following a merger, the number of users doubles? What if you want to keep several years of data online? Faroult s way of looking at SQL performance may be unconventional and unique, but he s deadly serious about writing good SQL and using SQL well. The Art of SQL is not a cookbook, listing problems and giving recipes. The aim is to get you - and your manager - to raise good questions. N° de réf. du libraire AAH9780596008949

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 28,80
Autre devise

Ajouter au panier

Frais de port : Gratuit
De Royaume-Uni vers Etats-Unis
Destinations, frais et délais

7.

Faroult, Stephane
Edité par O'Reilly Media (2017)
ISBN 10 : 0596008945 ISBN 13 : 9780596008949
Neuf(s) Paperback Quantité : 15
impression à la demande
Vendeur
Murray Media
(North Miami Beach, FL, Etats-Unis)
Evaluation vendeur
[?]

Description du livre O'Reilly Media, 2017. Paperback. État : New. This item is printed on demand. N° de réf. du libraire 0596008945

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 28,83
Autre devise

Ajouter au panier

Frais de port : EUR 2,56
Vers Etats-Unis
Destinations, frais et délais

8.

Faroult, Stephane; Robson, Peter
Edité par O'Reilly Media
ISBN 10 : 0596008945 ISBN 13 : 9780596008949
Neuf(s) PAPERBACK Quantité : 3
Vendeur
Lakeside Books
(Benton Harbor, MI, Etats-Unis)
Evaluation vendeur
[?]

Description du livre O'Reilly Media. PAPERBACK. État : New. 0596008945 BRAND NEW, GIFT QUALITY! NOT OVERSTOCKS OR MARKED UP REMAINDERS! DIRECT FROM THE PUBLISHER!|1.27. N° de réf. du libraire OTF-S-9780596008949

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 28,29
Autre devise

Ajouter au panier

Frais de port : EUR 3,42
Vers Etats-Unis
Destinations, frais et délais

9.

Peter Robson
Edité par O'Reilly Media
ISBN 10 : 0596008945 ISBN 13 : 9780596008949
Neuf(s) Paperback Quantité : 20
impression à la demande
Vendeur
BuySomeBooks
(Las Vegas, NV, Etats-Unis)
Evaluation vendeur
[?]

Description du livre O'Reilly Media. Paperback. État : New. This item is printed on demand. Paperback. 370 pages. For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and most IT departments believe that developers should provide simple SQL code to solve immediate problems and let DBAs tune any bad SQL later. In The Art of SQL, author and SQL expert Stephane Faroult argues that this safe approach only leads to disaster. His insightful book, named after Art of War by Sun Tzu, contends that writing quick inefficient code is sweeping the dirt under the rug. SQL code may run for 5 to 10 years, surviving several major releases of the database management system and on several generations of hardware. The code must be fast and sound from the start, and that requires a firm understanding of SQL and relational theory. The Art of SQL offers best practices that teach experienced SQL users to focus on strategy rather than specifics. Faroults approach takes a page from Sun Tzus classic treatise by viewing database design as a military campaign. You need knowledge, skills, and talent. Talent cant be taught, but every strategist from Sun Tzu to modern-day generals believed that it can be nurtured through the experience of others. They passed on their experience acquired in the field through basic principles that served as guiding stars amid the sound and fury of battle. This is what Faroult does with SQL. Like a successful battle plan, good architectural choices are based on contingencies. What if the volume of this or that table increases unexpectedly What if, following a merger, the number of users doubles What if you want to keep several years of data online Faroults way of looking at SQL performance may be unconventional and unique, but hes deadly serious about writing good SQL and using SQL well. The Art of SQL is not a cookbook, listing problems and giving recipes. The aim is to get you-and your manager-to raise good questions. This item ships from La Vergne,TN. Paperback. N° de réf. du libraire 9780596008949

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 28,66
Autre devise

Ajouter au panier

Frais de port : EUR 3,39
Vers Etats-Unis
Destinations, frais et délais

10.

Stephane Faroult, Peter Robson
Edité par O'Reilly Media, Inc, USA
ISBN 10 : 0596008945 ISBN 13 : 9780596008949
Neuf(s) Paperback Quantité : 8
Vendeur
THE SAINT BOOKSTORE
(Southport, Royaume-Uni)
Evaluation vendeur
[?]

Description du livre O'Reilly Media, Inc, USA. Paperback. État : new. BRAND NEW, The Art of SQL, Stephane Faroult, Peter Robson, For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and most IT departments believe that developers should provide simple SQL code to solve immediate problems and let DBAs tune any "bad SQL" later. In "The Art of SQL", author and SQL expert, Stephane Faroult argues that this "safe approach" only leads to disaster. His insightful book, named after "Art of War" by Sun Tzu, contends that writing quick inefficient code is sweeping the dirt under the rug. SQL code may run for 5 to 10 years, surviving several major releases of the database management system and on several generations of hardware. The code must be fast and sound from the start, and that requires a firm understanding of SQL and relational theory. "The Art of SQL" offers best practices that teach experienced SQL users to focus on strategy rather than specifics. Faroult's approach takes a page from Sun Tzu's classic treatise by viewing database design as a military campaign. You need knowledge, skills, and talent. Talent can't be taught, but every strategist from Sun Tzu to modern-day generals believed that it can be nurtured through the experience of others. They passed on their experience acquired in the field through basic principles that served as guiding stars amid the sound and fury of battle. This is what Faroult does with SQL. Like a successful battle plan, good architectural choices are based on contingencies. What if the volume of this or that table increases unexpectedly? What if, following a merger, the number of users doubles? What if you want to keep several years of data online? Faroult's way of looking at SQL performance may be unconventional and unique, but he's deadly serious about writing good SQL and using SQL well. "The Art of SQL" is not a cookbook, listing problems and giving recipes. The aim is to get you - and your manager - to raise good questions. N° de réf. du libraire B9780596008949

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 24,43
Autre devise

Ajouter au panier

Frais de port : EUR 7,74
De Royaume-Uni vers Etats-Unis
Destinations, frais et délais

autres exemplaires de ce livre sont disponibles

Afficher tous les résultats pour ce livre