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!

Kinematic Chains and Machine Components Design covers a broad spectrum of critical machine design topics and helps the reader understand the fundamentals and apply the technologies necessary for successful mechanical design and execution. The inclusion of examples and instructive problems present the reader with a teachable computer-oriented text. Useful analytical techniques provide the practitioner and student with powerful tools for the design of kinematic chains and machine components.
Kinematic Chains and Machine Components Design serves as a on-volume reference for engineers and students in mechanical engineering with applications for all engineers working in the fields of machine design and robotics. The book contains the fundamental laws and theories of science basic to mechanical engineering including mechanisms, robots and machine components to provide the reader with a thorough understanding of mechanical design.
* Combines theories of kinematics and behavior of mechanisms with the practical design of robots, machine parts, and machine systems into one comprehensive mechanical design book
* Offers the method of contour equations for the kinematic analysis of mechanicsl systems and dynamic force analysis
* Mathematica programs and packages for the analysis of mechanical systems
* An Instructor's Solutions Manual will be provided

"Data Modeling Essentials, Third Edition" provides expert tutelage for data modelers, business analysts and systems designers at all levels. Beginning with the basics, this book provides a thorough grounding in theory before guiding the reader through the various stages of applied data modeling and database design. Later chapters address advanced subjects, including business rules, data warehousing, enterprise-wide modeling and data management.
The third edition of this popular book retains its distinctive hallmarks of readability and usefulness, but has been given significantly expanded coverage and reorganized for greater reader comprehension. Authored by two leaders in the field, "Data Modeling Essentials, Third Edition" is the ideal reference for professionals and students looking for a real-world perspective.
- Thorough coverage of the fundamentals and relevant theory.
- Recognition and support for the creative side of the process.
- Expanded coverage of applied data modeling includes new chapters on logical and physical database design.
- New material describing a powerful technique for model verification.
- Unique coverage of the practical and human aspects of modeling, such as working with business specialists, managing change, and resolving conflict.
- Extensive online component including course notes and other teaching aids (www.mkp.com).
UML diagrams now available! Visit the companion site for more details.
Click here to view a book review by Steve Hoberman!

This book contains several introductory texts concerning the main directions in the theory
of evolutionary partial differential equations. The main objective is to present clear, rigorous,
and in depth surveys on the most important aspects of the present theory. The table of
contents includes:
W.Arendt: Semigroups and evolution equations: Calculus, regularity and kernel estimates
A.Bressan: The front tracking method for systems of conservation laws
E.DiBenedetto, J.M.Urbano, V.Vespri: Current issues on singular and degenerate evolution equations;
L.Hsiao, S.Jiang: Nonlinear hyperbolic-parabolic coupled systems
A.Lunardi: Nonlinear parabolic equations and systems
D.Serre: L1-stability of nonlinear waves in scalar conservation laws
B.Perthame: Kinetic formulations of parabolic and hyperbolic PDE s: from theory to numerics

The book contains seven survey papers about ordinary differential equations.
The common feature of all papers consists in the fact that nonlinear equations are focused on. This reflects the situation in modern mathematical modelling - nonlinear mathematical models are more realistic and describe the real world problems more accurately. The implications are that new methods and approaches have to be looked for, developed and adopted in order to understand and solve nonlinear ordinary differential equations.
The purpose of this volume is to inform the mathematical community and also other scientists interested in and using the mathematical apparatus of ordinary differential equations, about some of these methods and possible applications.

The book could be a good companion for any graduate student in partial differential equations or in applied mathematics. Each chapter brings indeed new ideas and new techniques which can be used in these fields. The differents chapters can be read independently and are of great pedagogical value. The advanced researcher will find along the book the most recent achievements in various fields.
.Independent chapters
.Most recent advances in each fields
.Hight didactic quality
.Self contained
.Excellence of the contributors
.Wide range of topics

Evidence-Based Educational Methods answers the challenge of the "No Child Left Behind Act" of 2001 by promoting evidence-based educational methods designed to improve student learning. Behavioral scientists have been refining these instructional methods for decades before the current call for evidence-based education. Precision Teaching, Direct Instruction, Computerized Teaching, Personalized System of Instruction, and other unique applications of behavior analysis are all informed by the scientific principles of learning, have been tested in the laboratory, and are often shown to have significant success in field applications. This book details each of these approaches to education based on the principles of behavior analysis. Individuals and agencies responsible for instruction that leaves no child behind will find this compendium an important resource for meeting that challenge, and young educators will greatly benefit from this text, as they will see a blueprint of the evidence-based education systems being planned for the future.
* The education literature is replete with fly-by-night ideas and unresearched opinions about how to teach children. This book has none of that. The reader is given researched educational methods. In fact, some methods draw on 3 or 4 decades of experimental data. The whole book is cohesive, not just a patchwork of different educators' opinions. All of the chapters are built on basic scientific principles of behavior, and all of the methods can be used with one another
* This is a book by scientist-practitioners, but not for scientists only. A parent can read many of these chapters, see the merit in the methods, and convey the need and the process for each of the methods
* No book stands alone, but is connected to a greater literature base. The reader is shown where other information can be found about these methods.
* The only thing better than scientific data is scientific data supported by consumer testimonial

"TCP/IP sockets in C# is an excellent book for anyone interested in writing network applications using Microsoft .Net frameworks. It is a unique combination of well written concise text and rich carefully selected set of working examples. For the beginner of network programming, it's a good starting book; on the other hand professionals could also take advantage of excellent handy sample code snippets and material on topics like message parsing and asynchronous programming."
Adarsh Khare, SDT, .Net Frameworks Team, Microsoft Corporation

The popularity of the C# language and the .NET framework is ever rising due to its ease of use, the extensive class libraries available in the .NET Framework, and the ubiquity of the Microsoft Windows operating system, to name a few advantages. TCP/IP Sockets in C# focuses on the Sockets API, the de facto standard for writing network applications in any programming language. Starting with simple client and server programs that use TCP/IP (the Internet protocol suite), students and practitioners quickly learn the basics and move on to firsthand experience with advanced topics including non-blocking sockets, multiplexing, threads, asynchronous programming, and multicasting. Key network programming concepts such as framing, performance and deadlocks are illustrated through hands-on examples. Using a detailed yet clear, concise approach, this book includes numerous code examples and focused discussions to provide a solid understanding of programming TCP/IP sockets in C#.
Features
*Tutorial-based instruction in key sockets programming techniques complemented by numerous code examples throughout
*Discussion moves quickly into the C# Sockets API definition and code examples, desirable for those who want to get up-to-speed quickly
*Important coverage of "under the hood" details that developers will find useful when creating and using a socket or a higher level TCP class that utilizes sockets
*Includes end-of-chapter exercises to facilitate learning, as well as sample code available for download at the book s companion web site
*Tutorial-based instruction in key sockets programming techniques complemented by numerous code examples throughout
*Discussion moves quickly into the C# Sockets API definition and code examples, desirable for those who want to get up-to-speed quickly
*Important coverage of "under the hood" details that developers will find useful when creating and using a socket or a higher level TCP class that utilizes sockets
*Includes end-of-chapter exercises to facilitate learning, as well as sample code available for download at the book's companion web site"

The second edition of "IPv6: Theory, Protocol, and Practice" guides readers through implemetation and deployment of IPv6. The Theory section takes a close, unbiased look at why so much time and effort has been expended on revising IPv4. In the Protocol section is a comprehensive review of the specifics of IPv6 and related protocols. Finally, the Practice section provides hands-on explanations of how to roll out IPv6 support and services.
This completely rewritten edition offers updated and comprehensive coverage of important topics including router and server configuration, security, the impact of IPv6 on mobile networks, and evaluating the impact of IPv6-enabled networks globally. Pete Loshin's famously lucid explanations benefit readers at every turn, making "Ipv6: Theory, Protocol, and Practice" the best way for a large diverse audience to get up to speed on this groundbreaking technology.
* The comprehensive, accessible, and up-to-date resource needed by network engineers and support staff, product developers and managers, programmers, and marketing professionals
* Divided into sections on theory, the protocol's technical details, and techniques for building Ipv6 networks, this book covers not only the protocol but the ways in which the protocol can be integrated into networks.
* Covers critical topics in depth, including router and server configuration, security, value assessment, and the impact of Ipv6 on global networks

The Russian-English volume contains about 50,000 terms covering various fields and subfields of nuclear engineering and technology: nuclear physics, thermonuclear research, nuclear reactors, nuclear fuel, isotopes, radiation, reliability and safety issues, environmental protection, emergency issues, radiation hazards. Terms from the military nuclear field are also included, as well as the names of nuclear power plants and nuclear societies worldwide. It also contains a section of about 250 abbreviations.

When the first edition of "Optical Interferometry" was published, interferometry was regarded as a rather esoteric method of making measurements, largely confined to the laboratory. Today, however, besides its use in several fields of research, it has applications in fields as diverse as measurement of length and velocity, sensors for rotation, acceleration, vibration and electrical and magnetic fields, as well as in microscopy and nanotechnology.

Most topics are discussed first at a level accessible to anyone with a basic knowledge of physical optics, then a more detailed treatment of the topic is undertaken, and finally each topic is supplemented by a reference list of more than 1000 selected original publications in total.
* Historical development of interferometry
* The laser as a light source
* Two-beam interference
* Techniques for frequency stabilization
* Coherence
* Electronic phase measurements
* Multiple-beam interference
* Quantum effects in optical interference
* Extensive coverage of the applications of interferometry, such as measurements of length, optical testing, interference microscopy, interference spectroscopy, Fourier-transform spectroscopy, interferometric sensors, nonlinear interferometers, stellar interferometry, and studies of space-time and gravitation.

Serial killers like Seattle's Ted Bundy, Maryland's Beltway Sniper, Atlanta's Wayne Williams, or England's Peter Sutcliffe usually outsmart the task forces on their trail for long periods of time. Keppel and Birnes take readers inside the operations of serial killer task forces to learn why. What is the underlying psychology of a serial killer and why this defeats task force investigations?
This is the first book of its kind that combines state-of-the-art psychological assessment experience with the expertise of a homicide investigator who has tracked some of this country's most notorious serial killers. The author also brings to the book hands-on best practices gleaned from the experience of other task forces.
Readers, both professionals and students, will benefit from the comprehensive and critical case reviews, the analysis of what went wrong, what went right, and the after-action recommendations of evaluators in the US, UK, and Canada.
The book covers:
* The nature of the psychology of a serial killer
* How crime assessment profiling reveals that psychology
* Why psychological profiles fail
* How serial killer task forces defeat themselves
* How the media can, and usually does, undermine the task force operation
* The big secret of all serial killer investigations: police already have the killer's name
* The best practices for catching a serial killer
* Comprehensive case reviews of some of the US's and UK's most baffling serial killer cases
* A list of best practices for serial killer task force investigators
* Recommendations for how to manage comprehensive files and computer records
* Practical advice on how to manage the media: what to say and not to say
* Insight into what a serial killer might be thinking and doing to stay away from police
* Recommendations for setting up and administering long-term investigations
* Practical tips on how to maintain a task force's psychological edge and avoid defeatism

Elsevier's Dictionary of Nature and Hunting" contains terms covering the following fields and subfields:

A. Plants and Ecosystems: Species, Cenoses
B. Animals: Species
C. Domestic Animals: General, Dogs, Horses, Cattle and Poultry
D. Hunting and Fishing: Game Names, Arms, Trapping, Methods.

It includes 5,594 terms, both scientific and common, in English, French, German and Russian and in Latin (for the generally accepted biological terms for European and North Asian plants and animals).

The dictionary was developed with the help of Russian specialists - scientists from the Severtsov Institute of the Russian Academy of Sciences, officials from the Union of the Hunters and Fishers of Russia, and French colleagues from various organizations dealing with environment protection and natural resources: OMPO (Oiseaux Migrateurs du Palearctique Occidental), ANCGE (Association National des Chasseurs du Gibier d'Eau), ONC (Office National de la Chasse) and CIC (Conseil International de la Chasse et de la Protection du Gibier).

"

Modern Cosmology begins with an introduction to the smooth, homogeneous universe described by a Friedman-Robertson-Walker metric, including careful treatments of dark energy, big bang nucleosynthesis, recombination, and dark matter. From this starting point, the reader is introduced to perturbations about an FRW universe: their evolution with the Einstein-Boltzmann equations, their generation by primordial inflation, and their observational consequences. These consequences include the anisotropy spectrum of the cosmic microwave background (CMB) featuring acoustic peaks and polarization, the matter power spectrum with baryonic wiggles, and their detection via photometric galaxy surveys, redshift distortions, cluster abundances, and weak lensing. The book concludes with a long chapter on data analysis.
Modern Cosmology is the first book to explain in detail the structure of the acoustic peaks in the CMB, the E/B decomposition in polarization which may allow for detection of primordial gravity waves, and the modern analysis techniques used on increasingly large cosmological data sets. Readers will gain the tools needed to work in cosmology and learn how modern observations are rapidly revolutionizing our picture of the universe.
* Provides foundations, calculations, and interpretations which illuminate current thinking in cosmology
* Covers the major advances in cosmology over the past decade
* Includes over 100 unique, pedagogical figures

A revision of the leading text on experimental physics. The feature of this book that has made it one of the most loved texts on the subject is that it goes far beyond a mere description of key experiments in physics. The author successfully provides the reader with an understanding and appreciation of the 'physics' behind the experiments. The second edition will be an extensive revision introducing many new devices, including the use of computers and software programs, that have come into use since the publication of the first edition. In addition the important areas of condensed matter physics and optical physics will be added, including two entirely new chapters on lasers and optics.
.Modern analysis and acquisition techniques
.Integration with matlab for data analysis and display
.New experiments include fundamentals of lasers

Unlike most books on filters, Analog and Digital Filter Design does not start from a position of mathematical complexity. It is written to show readers how to design effective and working electronic filters. The background information and equations from the first edition have been moved into an appendix to allow easier flow of the text while still providing the information for those who are interested.
The addition of questions at the end of each chapter as well as electronic simulation tools has allowed for a more practical, user-friendly text.
*Provides a practical design guide to both analog and digital electronic filters
*Includes electronic simulation tools
*Keeps heavy mathematics to a minimum

In addition to its thorough coverage of DSP design and programming techniques, Smith also covers the operation and usage of DSP chips. He uses Analog Devices' popular DSP chip family as design examples. Also included on the companion website is technical info on DSP processors from the four major manufacturers (Analog Devices, Texas Instruments, Motorola, and Lucent) and other DSP software.
*Covers all major DSP topics
*Full of insider information and shortcuts
*Basic techniques and algorithms explained without complex numbers

Do you spend too much time creating the building blocks of your graphics applications or finding and correcting errors? "Geometric Tools for Computer Graphics" is an extensive, conveniently organized collection of proven solutions to fundamental problems that you'd rather not solve over and over again, including building primitives, distance calculation, approximation, containment, decomposition, intersection determination, separation, and more.

If you have a mathematics degree, this book will save you time and trouble. If you don't, it will help you achieve things you may feel are out of your reach. Inside, each problem is clearly stated and diagrammed, and the fully detailed solutions are presented in easy-to-understand pseudocode. You also get the mathematics and geometry background needed to make optimal use of the solutions, as well as an abundance of reference material contained in a series of appendices.

Features
Filled with robust, thoroughly tested solutions that will save you time and help you avoid costly errors.
Covers problems relevant for both 2D and 3D graphics programming.
Presents each problem and solution in stand-alone form allowing you the option of reading only those entries that matter to you.
Provides the math and geometry background you need to understand the solutions and put them to work.
Clearly diagrams each problem and presents solutions in easy-to-understand pseudocode.
Resources associated with the book are available at the companion Web site www.mkp.com/gtcg.
* Filled with robust, thoroughly tested solutions that will save you time and help you avoid costly errors.
* Covers problems relevant for both 2D and 3D graphics programming.
* Presents each problem and solution in stand-alone form allowing you the option of reading only those entries that matter to you.
* Provides the math and geometry background you need to understand the solutions and put them to work.
* Clearly diagrams each problem and presents solutions in easy-to-understand pseudocode.
* Resources associated with the book are available at the companion Web site www.mkp.com/gtcg.

The second edition of this text has sold over 6,000 copies since publication in 1986 and this revision will make it even more useful. This is the only book available that is approachable by "beginners" in this subject. It has become an essential introduction to the subject for mathematics students, engineers, physicists, and economists who need to learn how to apply these vital methods. It is also the only book that thoroughly reviews certain areas of advanced calculus that are necessary to understand the subject.

Line and surface integrals
Divergence and curl of vector fields

Aging occurs at the level of individual cells, a complex interplay between intrinsic "programming" and exogenous "wear and tear," with genetically-determined cellular capacity to repair environmentally-induced DNA damage playing a central role in the rate of aging and its specific manifestations. In 12 chapters, "The Role of DNA Damage and Repair in Cell Aging" provides an intellectual framework for aging of mitotic and post-mitotic cells, describes a variety of model systems for further studies, and reviews current concepts of DNA responses and their relationship to the phenomenon of aging.

As part of a series entitled "Advances in Cell Aging and Gerontology," this volume also summarizes seminal recent discoveries such as the molecular basis for Werner syndrome (a mutant DNA helicase), the complementary roles of telomere shortening and telomerase activity in cell senescence versus immortalization, the role of apoptosis in the homeostasis of aging tissue, and the existence of an inducible SOS-like response in mammalian cells that minimizes DNA damage from repeatedly encountered injurious environmental agents. Insights into the relationship between cellular aging and age-associated diseases, particularly malignancies, are also provided in several chapters.

This book is an excellent single source of information for anyone interested in DNA repair, mechanisms of aging, or certainly their intersection. Students will gain a general appreciation of these fields, but even the most senior investigators will benefit from the detailed coverage of rapidly advancing areas.

Liquid markets generate hundreds or thousands of ticks (the minimum change in price a security can have, either up or down) every business day. Data vendors such as Reuters transmit more than 275,000 prices per day for foreign exchange spot rates alone. Thus, high-frequency data can be a fundamental object of study, as traders make decisions by observing high-frequency or tick-by-tick data. Yet most studies published in financial literature deal with low frequency, regularly spaced data. For a variety of reasons, high-frequency data are becoming a way for understanding market microstructure. This book discusses the best mathematical models and tools for dealing with such vast amounts of data.
This book provides a framework for the analysis, modeling, and inference of high frequency financial time series. With particular emphasis on foreign exchange markets, as well as currency, interest rate, and bond futures markets, this unified view of high frequency time series methods investigates the price formation process and concludes by reviewing techniques for constructing systematic trading models for financial assets.

An Introduction to Non-Harmonic Fourier Series, Revised Edition is an update of a widely known and highly respected classic textbook.
Throughout the book, material has also been added on recent developments, including stability theory, the frame radius, and applications to signal analysis and the control of partial differential equations.

A practical tool on radar systems that will be of major help to technicians, student engineers and engineers working in industry and in radar research and development. The many users of radar as well as systems engineers and designers will also find it highly useful. Also of interest to pilots and flight engineers and military command personnel and military contractors. ""This introduction to the field of radar is intended for actual users of radar. It focuses on the history, main principles, functions, modes, properties and specific nature of modern airborne radar. The book examines radar's role within the system when carrying out is assigned missions, showing the possibilities of radar as well as its limitations. Finally, given the changing operational requirements and the potential opened up by modern technological developments, a concluding section describes how radar may evolve in the future.
The authors review the current state of the main types of airborne and spaceborne radar systems, designed for specific missions as well as for the global environment of their host aircraft or satellites. They include numerous examples of the parameters of these radars. The emphasis in the book is not only on a particular radar technique, but equally on the main radar functions and missions. Even if a wide range of techniques are described in this book, the focus is on those which are connected to practical applications.

The Technician's Radio Receiver Handbook is an invaluable tool for anyone involved in the technologies of wireless, cellular telephone, telecommunications, avionics, and other forms of electronic communication using radio waves. The market demand for and use of wireless and telecommunication technology has increased dramatically over the past decade, leaving many technicians and other communications professionals with the need for accurate information on how the newest equipment works and how to fix any problems that arise. Joe Carr, a notable author in the amateur radio and communications markets, explains both the new and old technologies, the science behind the scenes, as well as troubleshooting techniques not found in any other book.
The book will also have a companion website including helpful calculation software, customizable spreadsheets, and much more.

Written for technicians and hands-on practitioners in clear, easy-to-read text with many detailed illustrations
Contains information on cutting-edge receiver equipment as well as the most popular types used today in a variety of markets.
Destined to be a constant reference and superb training guide for anyone interested in communications technology

Here it is--a collection of Forrest Mims's classic work from the original Popular Electronics magazine Using commonly available components and remarkable ingenuity, Forrest shows you how to build and experiment with circuits like these:
analog computers
color organs
digital phase-locked loops
frequency-to-voltage and voltage-to-frequency converters
interval timers
LED oscilloscopes
light wave communicators
magnetic field sensors
optoelectronics
pseudorandom number generators
tone sequencers
and much, much, more