pickabook books with huge discounts for everyone
pickabook books with huge discounts for everyone
Visit our new collection website www.collectionsforschool.co.uk
     
Email: Subscribe to news & offers:
Need assistance? Log In/Register


Item Details
Title: THE ART OF SQL
By: Stephane Faroult, Peter Robson
Format: Paperback

List price: £43.99
Our price: £32.11
Discount:
27% off
You save: £11.88
ISBN 10: 0596008945
ISBN 13: 9780596008949
Availability: Usually dispatched within 1-2 days.
 Delivery rates
Stock: Currently 2 available
Publisher: O'REILLY MEDIA, INC, USA
Pub. date: 28 March, 2006
Pages: 368
Description: Demonstrates that since SQL code may run for 5 to 10 years, and run on different hardware, it must be fast and sound from the start. This book offers SQL best practices and relational theory that force you to focus on strategy rather than specifics.
Synopsis: 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.
Illustrations: Illustrations
Publication: US
Imprint: O'Reilly Media, Inc, USA
Returns: Returnable
Some other items by this author:
A TRANSNATIONAL STUDY OF LAW AND JUSTICE ON TV
A TRANSNATIONAL STUDY OF LAW AND JUSTICE ON TV
A TRANSNATIONAL STUDY OF LAW AND JUSTICE ON TV (HB)
COORDINATE GRAPHS (PB)
ECONOMIC INTEGRATION IN AFRICA
ECONOMIC INTEGRATION IN AFRICA
ECONOMIC INTEGRATION IN AFRICA
ECONOMIC INTEGRATION IN AFRICA
ECONOMIC INTEGRATION IN AFRICA
ECONOMIC INTEGRATION IN AFRICA (HB)
ECONOMIC INTEGRATION IN AFRICA (PB)
EVERYDAY GRAPHS (PB)
FILM AND THE LAW
FILM AND THE LAW (PB)
FOUNTAINS ABBEY (PB)
FRED ROWNTREE: ARCHITECT (PB)
GETTING THE MESSAGE ACROSS (PB)
GRAPHS ANSWERS (PB)
HOUSING LAW (PB)
INTEGRATION, DEVELOPMENT AND EQUITY: ECONOMIC INTEGRATION IN WEST AFRICA
INTEGRATION, DEVELOPMENT AND EQUITY: ECONOMIC INTEGRATION IN WEST AFRICA
INTEGRATION, DEVELOPMENT AND EQUITY: ECONOMIC INTEGRATION IN WEST AFRICA
INTEGRATION, DEVELOPMENT AND EQUITY: ECONOMIC INTEGRATION IN WEST AFRICA
INTEGRATION, DEVELOPMENT AND EQUITY: ECONOMIC INTEGRATION IN WEST AFRICA
INTEGRATION, DEVELOPMENT AND EQUITY: ECONOMIC INTEGRATION IN WEST AFRICA
INTEGRATION, DEVELOPMENT AND EQUITY: ECONOMIC INTEGRATION IN WEST AFRICA (HB)
INTEGRATION, DEVELOPMENT AND EQUITY: ECONOMIC INTEGRATION IN WEST AFRICA (PB)
LAW AND FILM (PB)
LAW AND JUSTICE ON THE SMALL SCREEN
LAW AND POVERTY (HB)
LAW AND POVERTY (PB)
MATHS DICTIONARY (PB)
MATHS FOR PRACTICE AND REVISION (PB)
MATHS FOR PRACTICE AND REVISION (PB)
MATHS FOR PRACTICE AND REVISION (PB)
MATHS FOR PRACTICE AND REVISION (PB)
MATHS FOR PRACTICE AND REVISION (PB)
MATHS FOR PRACTICE AND REVISION (PB)
MATHS FOR PRACTICE AND REVISION (PB)
MATHS FOR PRACTICE AND REVISION (PB)
MATHS FOR PRACTICE AND REVISION (PB)
MATHS FOR PRACTICE AND REVISION (PB)
MATHS FOR PRACTICE AND REVISION (PB)
MATHS PRACTICE PAPERS FOR SENIOR SCHOOL ENTRY (PB)
MATHS PRACTICE PAPERS FOR SENIOR SCHOOL ENTRY - ANSWERS AND EXPLANATIONS (PB)
MONEY LAUNDERING LAW
NEUROSCIENCE AND CONNECTIONIST THEORY
POVERTY AND THE LAW
POVERTY AND THE LAW (HB)
POVERTY AND THE LAW (PB)
REFACTORING SQL APPLICATIONS
REFACTORING SQL APPLICATIONS
REFACTORING SQL APPLICATIONS
REFACTORING SQL APPLICATIONS (PB)
RESIDENTIAL TENANCIES (HB)
RESIDENTIAL TENANCIES (HB)
SCALE DRAWINGS, PLANS AND BEARINGS (PB)
SCALE DRAWINGS, PLANS AND BEARINGS ANSWERS (PB)
SCIENCE DICTIONARY (PB)
SKOOKUM TUGS (HB)
SQL SUCCESS (PB)
THE ART OF SQL
THE ART OF SQL
THE ART OF SQL
THE ECONOMICS OF INTERNATIONAL INTEGRATION
THE ECONOMICS OF INTERNATIONAL INTEGRATION
THE ECONOMICS OF INTERNATIONAL INTEGRATION
THE ECONOMICS OF INTERNATIONAL INTEGRATION
THE ECONOMICS OF INTERNATIONAL INTEGRATION (HB)
THE ECONOMICS OF INTERNATIONAL INTEGRATION (HB)
THE ECONOMICS OF INTERNATIONAL INTEGRATION (PB)
THE ECONOMICS OF INTERNATIONAL INTEGRATION (PB)
THE ECONOMIES OF AFRICA
THE ECONOMIES OF AFRICA
THE ECONOMIES OF AFRICA
THE ECONOMIES OF AFRICA
THE ECONOMIES OF AFRICA
THE ECONOMIES OF AFRICA (HB)
THE ECONOMIES OF AFRICA (PB)
THE FISHING ROBSONS (PB)
THE OPERATION OF THE MATRIMONIAL HOMES (FAMILY PROTECTION) (SCOTLAND) ACT 1981 (PB)
THE SPACES OF JUSTICE
THE SPACES OF JUSTICE (HB)
THE UNITED NATIONS LIBRARY ON TRANSNATIONAL CORPORATIONS (HB)
WELFARE LAW (HB)
WHILE YOU ARE WAITING STORIES (PB)

TOP SELLERS IN THIS CATEGORY
Learn Adobe Animate CC for Interactive Media (Paperback)
By: Joseph Labrecque, Rob Schwartz
Pearson Education (US)
Our Price : £11.10
more details
Agile Project Management with Kanban (Paperback)
By: Eric Brechner
Microsoft Press,U.S.
Our Price : £21.44
more details
NES/Famicom: A Visual Compendium (Hardback)
By: Bitmap Books
Bitmap Books
Our Price : £28.49
more details
Learning to Program in Python (Paperback)
By: P. M. Heathcote
PG Online Limited
Our Price : £13.30
more details
Level Up! The Guide to Great Video Game Design (Paperback)
By: Scott Rogers
John Wiley & Sons Inc
Our Price : £20.44
more details
BROWSE FOR BOOKS IN RELATED CATEGORIES
 COMPUTING AND INFORMATION TECHNOLOGY
 computer programming


Information provided by www.pickabook.co.uk
SHOPPING BASKET
  
Your basket is empty
  Total Items: 0
 

NEW
Ramadan and Eid al-Fitr
By: SARA KHAN
A celebratory, inclusive and educational exploration of Ramadan and Eid al-Fitr for both children that celebrate and children who want to understand and appreciate their peers who do.
add to basket

Learning
That''s My Story!: Drama for Confidence, Communication and C...
By: ADAM POWER-ANNAND
The ability to communicate is an essential life skill for all children, underpinning their confidence, personal and social wellbeing, and sense of self.
add to basket