Catálogo de publicaciones

Are you an SQL programmer that, like many, came to SQL after learning and writing procedural or object-oriented code? Or have switched jobs to where a different brand of SQL is being used, or maybe even been told to learn SQL yourself?

If even one answer is yes, then you need this book. A "Manual of Style" for the SQL programmer, this book is a collection of heuristics and rules, tips, and tricks that will help you improve SQL programming style and proficiency, and for formatting and writing portable, readable, maintainable SQL code. Based on many years of experience consulting in SQL shops, and gathering questions and resolving his students’ SQL style issues, Joe Celko can help you become an even better SQL programmer.

+ Help you write Standard SQL without an accent or a dialect that is used in another programming language or a specific flavor of SQL, code that can be maintained and used by other people.
+ Enable you to give your group a coding standard for internal use, to enable programmers to use a consistent style.
+ Give you the mental tools to approach a new problem with SQL as your tool, rather than another programming language — one that someone else might not know!

In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzles—and then helps solve them with a variety of solutions and explanations. Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but help develop the mindset needed to solve the many difficult SQL puzzles you face every day. Of course, part of the fun is to see whether or not you can write better solutions than Joe’s.

* A great collection of tricky SQL puzzles with a variety of solutions and explanations.

* Uses the proven format of puzzles and solutions to provide a user-friendly, practical look into SQL programming problems - many of which will help users solve their own problems.

* New edition features:
— Many new puzzles added!
— Dozens of new solutions to puzzles, and using features in SQL-99
— Code is edited to conform to SQL STYLE rules
— New chapter on temporal query puzzles
— New chapter on common misconceptions about SQL and RDBMS that leads to problems

Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity.

This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, you’ll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, you’ll be coding more quickly, writing more efficient code, and applying the full power of SQL

• Filled with the insights of one of the world’s leading SQL authorities - noted for his knowledge and his ability to teach what he knows.

• Focuses on auxiliary tables (for computing functions and other values by joins), temporal tables (for temporal queries, historical data, and audit information), and virtual tables (for improved performance).

• Presents clear guidance for selecting and correctly applying the right table technique.

Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioner’s guide to mastering the two most challenging aspects of developing database applications in SQL. In this book, Celko illustrates several major approaches to representing trees and hierarchies and related topics that should be of interest to the working database programmer. These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more. This book covers SQL-92 and SQL:1999.

· Includes graph theory and programming techniques.
· Running examples throughout the book help illustrate and tie concepts together.
· Loads of code, available for download from www.mkp.com.

The book introduces the principles of hardware design and describes the tools and techniques required to begin hacking. The DVD contains hack instructions for over 20 game consoles and hardware devices from Nintendo, Apple, Sony, Microsoft, Palm and more.

The presentation of these 20 projects on DVD media provides users with benefits and options not available on the printed page. All images are hi-res color that can be enlarged or printed, the text is easily searched, and the user can copy the contents to their hard disk and add comments directly into the PDF files. The DVD media also lends itself well to group projects (it includes a 10 user license).
The 160-page book includes chapters on hacking tools and electrical engineering basics, along with chapters on the background, design and functionality of each hardware device.

* Packed full of high resolution colour images that reveal the smallest details of each step in a hack
* Includes in depth coverage of the tools of the hacking trade and the basics of electrical engineering
* DVD includes a "Using the Tools" video starring Joe "kingpin" Grand

As medical devices become more intricate, with an increasing number of components made from a wide range of materials, it is important that they meet stringent requirements to ensure that they are safe to be implanted and will not be rejected by the human body. Joining and assembly of medical materials and devices provides a comprehensive overview of joining techniques for a range of medical materials and applications.

Part one provides an introduction to medical devices and joining methods with further specific chapters on microwelding methods in medical components and the effects of sterilization on medical materials and welded devices. Part two focuses on medical metals and includes chapters on the joining of shape memory alloys, platinum (Pt) alloys and stainless steel wires for implantable medical devices and evaluating the corrosion performance of metal medical device welds. Part three moves on to highlight the joining and assembly of medical plastics and discusses techniques including ultrasonic welding, transmission laser welding and radio frequency (RF)/dielectric welding. Finally, part four discusses the joining and assembly of biomaterial and tissue implants including metal-ceramic joining techniques for orthopaedic applications and tissue adhesives and sealants for surgical applications.

Joining and assembly of medical materials and devices is a technical guide for engineers and researchers within the medical industry, professionals requiring an understanding of joining and assembly techniques in a medical setting, and academics interested in this field.

• Introduces joining methods in medical applications including microwelding and considers the effects of sterilization on the resulting joints and devices
• Considers the joining, assembly and corrosion performance of medical metals including shape memory alloys, platinum alloys and stainless steel wires
• Considers the joining and assembly of medical plastics including multiple welding methods, bonding strategies and adhesives

Dr. McIlwraith’s Joint Disease in the Horse, 2^nd Edition is the only book to give you a full account of equine joint disease, combining a thorough, up-to-date survey of scientific advances with a practical guide to both medical and surgical treatments. With contributions from nationally and internationally recognized pioneers in the field, this groundbreaking text offers an overview of joint structure and function and translates the latest information on basic joint pathobiology into practical application for the clinician. Step-by-step guidance on injection techniques and medications, along with a survey of practical arthroscopic surgery and developments, make it a truly indispensable reference for all equine veterinarians treating sports and racing horses.

This second edition of Joint Replacement Technology provides a thoroughly updated review of recent developments in joint replacement technology. Joint replacement is a standard treatment for joint degradation and has improved the quality of life of millions of patients. Collaboration between clinicians and researchers is critical to its continued success and to meet the rising expectations of patients and surgeons.

Part one introduces the advances in joint replacement technology, tribological considerations and experiments, and immune and regenerative responses to joint replacements. Part two covers the materials and techniques used in joint replacement. The advantages and disadvantages of different metals are explained here, as well as the use of ceramics. This section also addresses challenges in joint bearing surfaces, design, and cementless fixation techniques. Biological and mechanical issues are considered in part three, including healing responses to implants and biological causes of prosthetic joint failure, and a new chapter on imaging of joint prostheses. Each chapter in part four describes the clinical challenges of replacing specific joints, with specific focus on hip, knee, intervertebral disc joint, shoulder arthroplasty, elbow arthroplasty, and pyrocarbon small joint arthroplasty.

Thanks to its widespread collaboration and international contributors, Joint Replacement Technology is useful for materials scientists and engineers in both academia and biomedical industry. Chemists, clinicians, and other researchers in this area will also find it invaluable.

• This second edition provides an updated comprehensive review of recent developments in joint replacement technology
• Provides coverage for the most pertinent materials science and engineering issues in depth
• Reviews the specific joints, biological and mechanical issues and fixation techniques

Joint RES and Distribution Network Expansion Planning Under a Demand Response Framework explains the implementation of the algorithms needed for joint expansion planning of distributed generation and distribution network models, discussing how to expand the generation and distribution network by adding renewable generation, demand response, storage units, and new assets (lines and substations) so that the current and future energy supply in islands is served at a minimum cost, and with quality requirements.

This book discusses the outcomes of the models discussed, including factors such as the location and size of new generation assets to be installed. It also introduces other issues relevant to the planning of insular distribution systems, including DR and hybrid storage. DR and ESS will play a much more significant role in future expansion planning models, where the present study stresses their relevance, including additional considerations to the planning model.

• Investigates the costs and benefits of deploying energy storage systems (ESS) and DR
• Explores distribution and generation expansion planning
• Analyzes and addresses power flow constraints and the impact of real time pricing mechanisms
• Details the RES integration challenge at length