If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements.To help you attain this fundamental SQL knowledge, look to "Learning SQL," an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language."Learning SQL" moves you quickly through the basics and then on to some of the more commonly used advanced features. Among the topics discussed: The history of the computerized databaseSQL Data Statements--those used to create, manipulate, and retrieve data stored in your database; example statements include select, update, insert, and deleteSQL Schema Statements--those used to create database objects, such as tables, indexes, and constraintsHow data sets can interact with queriesThe importance of subqueriesData conversion and manipulation via SQL's built-in functionsHow conditional logic can be used in Data StatementsBest of all, "Learning SQL" talks to you in a real-world manner, discussing various platform differences that you're likely to encounter and offering a series of chapter exercises that walk you through the learning process. Whenever possible, the book sticks to the features included in the ANSI SQL standards. This means you'll be able to apply what you learn to any of several different databases; the book covers MySQL, Microsoft SQL Server, and Oracle Database, but the features and syntax should apply just as well (perhaps with some tweaking) to IBM DB2, Sybase Adaptive Server, and PostgreSQL.Put the power and flexibility of SQL to work. With "Learning SQL" you can master this important skill and know that the SQL statements you write are indeed correct.

    Now even the most efficient production processes and the highest practical rates of recycling may not be enough to result in dematerialization rates that would be high enough to negate the rising demand for materials generated by continuing population growth and rising standards of living. This book explores the costs of this dependence and the potential for substantial dematerialization of modern economies.Making the Modern World: Materials and Dematerialization considers the principal materials used throughout history, from wood and stone, through to metals, alloys, plastics and silicon, describing their extraction and production as well as their dominant applications. The evolving productivities of material extraction, processing, synthesis, finishing and distribution, and the energy costs and environmental impact of rising material consumption are examined in detail. The book concludes with an outlook for the future, discussing the prospects for dematerialization and potential constrains on materials.This interdisciplinary text provides useful perspectives for readers with backgrounds including resource economics, environmental studies, energy analysis, mineral geology, industrial organization, manufacturing and material science.

    This is the full story of how the team was saved from disintegration when Honda suddenly pulled out of Formula One; the management buyout for £1.00; and its subsequent sale to Mercedes for £140 million. As CEO, Nick Fry was in the driving seat for one of the most incredible journeys in the history of motorsport. Here, he gives an up-close-and-personal account of how he and Ross Brawn turned disaster into championship glory, and offers a unique and thrilling perspective on an elite global sport.

    Intended for professional development programs in introductory database management.

    Presents essential ideas on critical phenomena developed over the last decade in simple, qualitative terms. This new edition maintains the simple structure of the first and puts new emphasis on pedagogical considerations. Thermostatistics is incorporated into the text without eclipsing macroscopic thermodynamics, and is integrated into the conceptual framework of physical theory.

    The long-anticipated revision of this best-selling text offers the most comprehensive, up-to-date introduction to the theory and practice of artificial intelligence. *NEW-Nontechnical learning material-Accompanies each part of the book. *NEW-The Internet as a sample application for intelligent systems-Added in several places including logical agents, planning, and natural language. *NEW-Increased coverage of material - Includes expanded coverage of: default reasoning and truth maintenance systems, including multi-agent/distributed AI and game theory; probabilistic approaches to learning including EM; more detailed descriptions of probabilistic inference algorithms. *NEW-Updated and expanded exercises-75% of the exercises are revised, with 100 new exercises. *NEW-On-line Java software. *Makes it easy for students to do projects on the web using intelligent agents. *A unified, agent-based approach to AI-Organizes the material around the task of building intelligent agents. *Comprehensive, up-to-date coverage-Includes a unified view of the field organized around the rational decision making pa

    It supports secure remote logins, secure file transfer between computers, and a unique "tunneling" capability that adds encryption to otherwise insecure network applications. Best of all, SSH is free, with feature-filled commercial versions available as well.SSH: The Secure Shell: The Definitive Guide covers the Secure Shell in detail for both system administrators and end users. It demystifies the SSH man pages and includes thorough coverage of:SSH1, SSH2, OpenSSH, and F-Secure SSH for Unix, plus Windows and Macintosh products: the basics, the internals, and complex applications.Configuring SSH servers and clients, both system-wide and per user, with recommended settings to maximize security.Advanced key management using agents, agent forwarding, and forced commands.Forwarding (tunneling) of TCP and X11 applications in depth, even in the presence of firewalls and network address translation (NAT).Undocumented behaviors of popular SSH implementations.Installing and maintaining SSH systems.Whether you're communicating on a small LAN or across the Internet, SSH can ship your data from "here" to "there" efficiently and securely. So throw away those insecure .rhosts and hosts.equiv files, move up to SSH, and make your network a safe place to live and work.

    The book focuses on techniques of lasting value and explains them precisely in terms of a simple abstract machine. The book presents all major programming paradigms in a uniform framework that shows their deep relationships and how and where to use them together.After an introduction to programming concepts, the book presents both well-known and lesser-known computation models ("programming paradigms"). Each model has its own set of techniques and each is included on the basis of its usefulness in practice. The general models include declarative programming, declarative concurrency, message-passing concurrency, explicit state, object-oriented programming, shared-state concurrency, and relational programming. Specialized models include graphical user interface programming, distributed programming, and constraint programming. Each model is based on its kernel language—a simple core language that consists of a small number of programmer- significant elements. The kernel languages are introduced progressively, adding concepts one by one, thus showing the deep relationships between different models. The kernel languages are defined precisely in terms of a simple abstract machine. Because a wide variety of languages and programming paradigms can be modeled by a small set of closely related kernel languages, this approach allows programmer and student to grasp the underlying unity of programming. The book has many program fragments and exercises, all of which can be run on the Mozart Programming System, an Open Source software package that features an interactive incremental development environment.

    It should be labelled 'start here'." --Pieter Jan Stappers, ID-StudioLab, Delft University of Technology

    Python is considered easy to learn, but there's no quicker way to mastery of the language than learning from an expert teacher. This edition of "Learning Python" puts you in the hands of two expert teachers, Mark Lutz and David Ascher, whose friendly, well-structured prose has guided many a programmer to proficiency with the language. "Learning Python," Second Edition, offers programmers a comprehensive learning tool for Python and object-oriented programming. Thoroughly updated for the numerous language and class presentation changes that have taken place since the release of the first edition in 1999, this guide introduces the basic elements of the latest release of Python 2.3 and covers new features, such as list comprehensions, nested scopes, and iterators/generators. Beyond language features, this edition of "Learning Python" also includes new context for less-experienced programmers, including fresh overviews of object-oriented programming and dynamic typing, new discussions of program launch and configuration options, new coverage of documentation sources, and more. There are also new use cases throughout to make the application of language features more concrete. The first part of "Learning Python" gives programmers all the information they'll need to understand and construct programs in the Python language, including types, operators, statements, classes, functions, modules and exceptions. The authors then present more advanced material, showing how Python performs common tasks by offering real applications and the libraries available for those applications. Each chapter ends with a series of exercises that will test your Python skills and measure your understanding."Learning Python," Second Edition is a self-paced book that allows readers to focus on the core Python language in depth. As you work through the book, you'll gain a deep and complete understanding of the Python language that will help you to understand the larger application-level examples that you'll encounter on your own. If you're interested in learning Python--and want to do so quickly and efficiently--then "Learning Python," Second Edition is your best choice.

    It covers all the major cutting-edge technologies of production automation and material handling, and how these technologies are used to construct modern manufacturing systems. Manufacturing Operations; Industrial Control Systems; Sensors, Actuators, and Other Control System Components; Numerical Control; Industrial Robotics; Discrete Control Using Programmable Logic Controllers and Personal Computers; Material Transport Systems; Storage Systems; Automatic Data Capture; Single Station Manufacturing Cells; Group Technology and Cellular Manufacturing; Flexible Manufacturing Systems; Manual Assembly Lines; Transfer Lines and Similar Automated Manufacturing Systems; Automated Assembly Systems; Statistical Process Control; Inspection Principles and Practices; Inspection Technologies; Product Design and CAD/CAM in the Production System; Process Planning and Concurrent Engineering; Production Planning and Control Systems; and Lean Production and Agile Manufacturing. For anyone interested in Automation, Production Systems, and Computer-Integrated Manufacturing.

    It focuses on the important ideas of organic chemistry and backs them up with illustrations and challenging problems. The authors' acclaimed writing style makes this thorny subject easy to grasp and comprehend. The new edition brings the book to the forefront of the latest research developments.The book includes the ORGANIC VIEW CD, a browser-based study tool with animated 3D graphics, Drill/Review sections, and Practice Tests"The Chemistry of..." boxes throughout highlight biological and other real-world chemistryThis edition is completely up-to-date with the latest developments in the field

    Thisupdated and expanded edition retains the popular and innovativefeatures of previous editions-including Feature Problems, follow-upIntegrative and Practice Exercises to accompany every in-chapterExample, and Focus On application boxes, as well as new Keep inMind marginal notes. Topics covered include atoms and the atomictheory, chemical compounds and reactions, gases, Thermochemistry, electrons in atoms, chemical bonding, liquids, solids, andintermolecular forces, chemical kinetics, principles of chemicalequilibrium, acids and bases, electrochemistry, representative andtransitional elements, and nuclear and organic chemistry. Forindividuals interested in a broad overview of chemical principles andapplications

    This book attempts to capture the engineering wisdom and design philosophy of the UNIX, Linux, and Open Source software development community as it has evolved over the past three decades, and as it is applied today by the most experienced programmers. Eric Raymond offers the next generation of hackers the unique opportunity to learn the connection between UNIX philosophy and practice through careful case studies of the very best UNIX/Linux programs.

    Essentially, you are estimating a probability, but then updating that estimate based on other things that you know. This book is designed to give you an intuitive understanding of how to use Bayes Theorem. It starts with the definition of what Bayes Theorem is, but the focus of the book is on providing examples that you can follow and duplicate. Most of the examples are calculated in Excel, which is useful for updating probability if you have dozens or hundreds of data points to roll in.