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.

    Wouldn't it be wonderful if we could actually visualize data in such a way that we could maximize its potential and tell a story in a clear, concise manner? Thanks to the creative genius of Nathan Yau, we can. With this full-color book, data visualization guru and author Nathan Yau uses step-by-step tutorials to show you how to visualize and tell stories with data. He explains how to gather, parse, and format data and then design high quality graphics that help you explore and present patterns, outliers, and relationships.Presents a unique approach to visualizing and telling stories with data, from a data visualization expert and the creator of flowingdata.com, Nathan Yau Offers step-by-step tutorials and practical design tips for creating statistical graphics, geographical maps, and information design to find meaning in the numbers Details tools that can be used to visualize data-native graphics for the Web, such as ActionScript, Flash libraries, PHP, and JavaScript and tools to design graphics for print, such as R and Illustrator Contains numerous examples and descriptions of patterns and outliers and explains how to show them Visualize This demonstrates how to explain data visually so that you can present your information in a way that is easy to understand and appealing.

    Betty Edwards's bestseller The New Drawing on the Right Side of the Brain. Now, much as artists progress from drawing to painting, Edwards moves from black-and-white into color. This much-awaited new guide distills the enormous existing knowledge about color theory into a practical method of working with color to produce harmonious combinations.Using techniques tested and honed in her five-day intensive color workshops, Edwards provides a basic understanding of how to see color, how to use it, and-for those involved in art, painting, or design-how to mix and combine hues. Including more than 125 color images and exercises that move from simple to challenging, this volume explains how to:see what is really there rather than what you "know" in your mind about colored objectsperceive how light affects color, and how colors affect one anothermanipulate hue, value, and intensity of color and transform colors into their oppositesbalance color in still-life, landscape, figure, and portrait paintingunderstand the psychology of colorharmonize color in your surroundingsWhile we recognize and treasure the beautiful use of color, reproducing what we see can be a challenge. Accessibly unweaving color's complexity, this must-have primer is destined to be an instant classic.

    Exercises range from creating a typeface in an hour to designing a paper robot in an afternoon to designing web pages and other interactive experiences. Each exercise includes compelling visual solutions from other designers and background stories to help you increase your capacity to innovate.Creative Workshop also includes useful brainstorming techniques and wisdom from some of today's top designers. By road-testing these techniques as you attempt each challenge, you'll find new and more effective ways to solve tough design problems and bring your solutions to vibrant life.

    Thomas Wolfe wrote standing up in the kitchen, the top of the refrigerator as his desk, dreamily fondling his “male configurations”. . . Jean-Paul Sartre chewed on Corydrane tablets (a mix of amphetamine and aspirin), ingesting ten times the recommended dose each day . . . Descartes liked to linger in bed, his mind wandering in sleep through woods, gardens, and enchanted palaces where he experienced “every pleasure imaginable.” Here are: Anthony Trollope, who demanded of himself that each morning he write three thousand words (250 words every fifteen minutes for three hours) before going off to his job at the postal service, which he kept for thirty-three years during the writing of more than two dozen books . . . Karl Marx . . . Woody Allen . . . Agatha Christie . . . George Balanchine, who did most of his work while ironing . . . Leo Tolstoy . . . Charles Dickens . . . Pablo Picasso . . . George Gershwin, who, said his brother Ira, worked for twelve hours a day from late morning to midnight, composing at the piano in pajamas, bathrobe, and slippers . . . Here also are the daily rituals of Charles Darwin, Andy Warhol, John Updike, Twyla Tharp, Benjamin Franklin, William Faulkner, Jane Austen, Anne Rice, and Igor Stravinsky (he was never able to compose unless he was sure no one could hear him and, when blocked, stood on his head to “clear the brain”). Brilliantly compiled and edited, and filled with detail and anecdote, Daily Rituals is irresistible, addictive, magically inspiring.

    So, if you’ve passed through education and still find yourself asking “Where’s your liver?” or “What beats a full house in poker?” and are too embarrassed to ask, this book can help.Visual Aid provides the answers to the little questions in life in a simple colourful and engaging way. Included are: colour wheels, universal flags, star constellations, correct tablesettings, how reflexology works, the Italian wine regions, how to tie a knot, how to use chopsticks, sign language, morse code and many more. This eclectic collection of illustrations and diagrams will get you up to speed on life's basics, without the need for extensive reading—or even your utmost attention. In a small, handy format this accessible guide is perfect for anyone with an interest in visual stimuli or a thirst for general knowledge.

    This book is both an example-driven programmer's guide and a keep-on-your-desk reference, with new chapters that explain everything you need to know to get the most out of JavaScript, including:Scripted HTTP and Ajax XML processing Client-side graphics using the canvas tag Namespaces in JavaScript--essential when writing complex programs Classes, closures, persistence, Flash, and JavaScript embedded in Java applicationsPart I explains the core JavaScript language in detail. If you are new to JavaScript, it will teach you the language. If you are already a JavaScript programmer, Part I will sharpen your skills and deepen your understanding of the language.Part II explains the scripting environment provided by web browsers, with a focus on DOM scripting with unobtrusive JavaScript. The broad and deep coverage of client-side JavaScript is illustrated with many sophisticated examples that demonstrate how to:Generate a table of contents for an HTML document Display DHTML animations Automate form validation Draw dynamic pie charts Make HTML elements draggable Define keyboard shortcuts for web applications Create Ajax-enabled tool tips Use XPath and XSLT on XML documents loaded with Ajax And much morePart III is a complete reference for core JavaScript. It documents every class, object, constructor, method, function, property, and constant defined by JavaScript 1.5 and ECMAScript Version 3.Part IV is a reference for client-side JavaScript, covering legacy web browser APIs, the standard Level 2 DOM API, and emerging standards such as the XMLHttpRequest object and the canvas tag.More than 300,000 JavaScript programmers around the world have made this their indispensable reference book for building JavaScript applications."A must-have reference for expert JavaScript programmers...well-organized and detailed."-- Brendan Eich, creator of JavaScript

    This pioneering guide traces the entire history of industrial design, industrialization, and mass production from 1850 until today. Sixty comprehensive essays written by designers, theorists, advertisers, historians, and curators detail the most crucial movements, issues, and accomplishments of industrial design. They combine news reports on the very first design workshops, aesthetic manifestos, lectures, and more from the biggest names in the field: William Morris, Henry Dreyfuss, and Victor Papanek, to name only a few. The Industrial Design Reader is an excellent resource for educators, students, and practicing designers. • Features design from not only theoretical and aesthetic perspectives, but also from a socio-political point of view, with texts from Karl Marx, Ralph Nader, and others • Copublished with the Design Management Institute, which will actively promote the book to its membership

    Whether you’re photographing children, weddings, maternity and boudoir, or portraits of any kind, The Luminous Portrait will inspire you with Elizabeth’s personal approach and award-wining images, sharing the art to making flattering portraits that appear “lit from within.”

    How can your institution do it and do it well? The Participatory Museum is a practical guide to working with community members and visitors to make cultural institutions more dynamic, relevant, essential places. Museum consultant and exhibit designer Nina Simon weaves together innovative design techniques and case studies to make a powerful case for participatory practice. "Nina Simon's new book is essential for museum directors interested in experimenting with audience participation on the one hand and cautious about upending the tradition museum model on the other. In concentrating on the practical, this book makes implementation possible in most museums. More importantly, in describing the philosophy and rationale behind participatory activity, it makes clear that action does not always require new technology or machinery. Museums need to change, are changing, and will change further in the future. This book is a helpful and thoughtful road map for speeding such transformation." -Elaine Heumann Gurian, international museum consultant and author of Civilizing the Museum "This book is an extraordinary resource. Nina has assembled the collective wisdom of the field, and has given it her own brilliant spin. She shows us all how to walk the talk. Her book will make you want to go right out and start experimenting with participatory projects." -Kathleen McLean, participatory museum designer and author of Planning for People in Museum Exhibitions "I predict that in the future this book will be a classic work of museology." --Elizabeth Merritt, founding director of the Center for the Future of Museums

    He uses numerous examples to convey applications in practice - from product design via signaletics and graphic design to Corporate Design. By doing this he is making an important manual available to young designers that in its clarity both in terms of subject matter and visually is entirely committed to Vignelli's modern design.

    Learn to determine your cost of goods, set prices, identify the competition, and understand the ins and outs of wholesale and retail sales. Explore the various sales venues available, including independent craft fairs, Web sites such as Etsy, and traditional stores, and learn to maximize your visibility and sales in each one. Want to start your own website? Chapin shows you how to style and prop your crafts for photography and explains how the most popular Web marketplaces operate. You’ll find everything you need to turn your talent into profits.

    Distilled from the authors' years of experience at Sabre, Yahoo!, and Netflix, these best practices are grouped into six key principles to help you take advantage of the web technologies available today. With an entire section devoted to each design principle, Designing Web Interfaces helps you:Make It Direct-Edit content in context with design patterns for In Page Editing, Drag & Drop, and Direct SelectionKeep It Lightweight-Reduce the effort required to interact with a site by using In Context Tools to leave a "light footprint"Stay on the Page-Keep visitors on a page with overlays, inlays, dynamic content, and in-page flow patternsProvide an Invitation-Help visitors discover site features with invitations that cue them to the next level of interactionUse Transitions-Learn when, why, and how to use animations, cinematic effects, and other transitionsReact Immediately-Provide a rich experience by using lively responses such as Live Search, Live Suggest, Live Previews, and more Designing Web Interfaces illustrates many patterns with examples from working websites. If you need to build or renovate a website to be truly interactive, this book gives you the principles for success.

    Pricing Creativity: A Guide to Profit Beyond the Billable Hour distills pricing theory into principles, rules, tips, and tools specifically for the creative professional.

    With the 97 short and extremely useful tips for programmers in this book, you'll expand your skills by adopting new approaches to old problems, learning appropriate best practices, and honing your craft through sound advice.With contributions from some of the most experienced and respected practitioners in the industry--including Michael Feathers, Pete Goodliffe, Diomidis Spinellis, Cay Horstmann, Verity Stob, and many more--this book contains practical knowledge and principles that you can apply to all kinds of projects.A few of the 97 things you should know:"Code in the Language of the Domain" by Dan North"Write Tests for People" by Gerard Meszaros"Convenience Is Not an -ility" by Gregor Hohpe"Know Your IDE" by Heinz Kabutz"A Message to the Future" by Linda Rising"The Boy Scout Rule" by Robert C. Martin (Uncle Bob)"Beware the Share" by Udi Dahan