If you're a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases.Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you'll also discover how to efficiently design and manage databases to meet your needs.You'll also learn how to:Explore relational databases, including lightweight and centralized modelsUse SQLite and SQLiteStudio to create lightweight databases in minutesQuery and transform data in meaningful ways by using SELECT, WHERE, GROUP BY, and ORDER BYJoin tables to get a more complete view of your business dataBuild your own tables and centralized databases by using normalized design principlesManage data by learning how to INSERT, DELETE, and UPDATE records

    Featuring pithy, humorous, and illuminating one-on-one songwriting lessons with Keith Richards of the Rolling Stones, Ray Davies of the Kinks, Andy Partridge of XTC, Arthur Lee of Love, Chan Marshall of Cat Power, Bob Stanley of Saint Etienne, Gruff Rhys of Super Furry Animals, and a host of others who run the gamut from unknown muses to cult icons to superstars-including Hodgkinson's lovable crew of ne'er-do-wells first introduced in Guitar Man-Song Man is at once an investigation into the most ephemeral of arts and a highly readable journey of discovery.

    This is the first book that introduces Lisp as a language for the real world.Practical Common Lisp presents a thorough introduction to Common Lisp, providing you with an overall understanding of the language features and how they work. Over a third of the book is devoted to practical examples, such as the core of a spam filter and a web application for browsing MP3s and streaming them via the Shoutcast protocol to any standard MP3 client software (e.g., iTunes, XMMS, or WinAmp). In other "practical" chapters, author Peter Seibel demonstrates how to build a simple but flexible in-memory database, how to parse binary files, and how to build a unit test framework in 26 lines of code.

    Land of Lisp brings the language into the real world, teaching Lisp by showing readers how to write several complete Lisp-based games, including a text adventure, an evolution simulation, and a robot battle. While building these games, readers learn the core concepts of Lisp programming, such as data types, recursion, input/output, object-oriented programming, and macros. And thanks to the power of Lisp, the code is short. Rather than bogging things down with reference information that is easily found online, Land of Lisp focuses on using Lisp for real programming. The book is filled with the author Conrad Barski's famous Lisp cartoons, featuring the Lisp alien and other zany characters.

    It was the first Brian Eno album tobe composed almost completely in the confines of a recording studio,over a scant few months in the summer of 1975. The album was a proofof concept for Eno's budding ideas of "the studio as musicalinstrument," and a signpost for a bold new way of thinking aboutmusic.In this book, Geeta Dayal unravels Another Green World's abundantmysteries, venturing into its dense thickets of sound. How was analbum this cohesive and refined formed in such a seemingly ad hoc way?How were electronics and layers of synthetic treatments used to createan album so redolent of the natural world? How did a deck of cardsfigure into all of this? Here, through interviews and archivalresearch, she unearths the strange story of how Another Green Worldformed the link to Eno's future -- foreshadowing his metamorphosisfrom unlikely glam rocker to sonic painter and producer.

    While he is often unjustly overlooked as a mere adjunct to his more famous brothers Brian and Dennis, Carl was a major international rock star from his early teens.The proud owner of one of the greatest voices in popular music--one that graced some of the most important records of the pop era, including 'God Only Knows' and 'Good Vibrations'--Wilson was also one of the first musicians to bring the electric guitar to the forefront of rock'n'roll. His musical skills provided The Beach Boys' entree into the music business, from which he then stewarded their onstage journey through the ups and downs of the 60s to their comeback in the 70s and into the role of 'America's band' in the 80s. Along the way, Carl quietly endured his own battles with obesity, divorce, substance abuse, and ultimately terminal cancer, all the while working to protect his family's business and legacy. This major new biography reveals the true story of modern rock'n'roll, lived from the center of the most important decades of popular music.

    By reconstructing authentic, complex AI programs using state-of-the-art Common Lisp, the book teaches students and professionals how to build and debug robust practical programs, while demonstrating superior programming style and important AI concepts. The author strongly emphasizes the practical performance issues involved in writing real working programs of significant size. Chapters on troubleshooting and efficiency are included, along with a discussion of the fundamentals of object-oriented programming and a description of the main CLOS functions. This volume is an excellent text for a course on AI programming, a useful supplement for general AI courses and an indispensable reference for the professional programmer.

    You'll explore a wide range of important Java topics as you systematically learn how to pass the certification exam. Each chapter starts with a list of the exam objectives covered in that chapter. You'll find sample questions and exercises designed to reinforce key concepts and to prepare you for what you'll see in the real exam, along with numerous tips, notes, and visual aids throughout the book.About This BookTo earn the OCA Java SE 7 Programmer Certification, you need to know your Java inside and out, and to pass the exam it's good to understand the test itself. This book cracks open the questions, exercises, and expectations you'll face on the OCA exam so you'll be ready and confident on test day.OCA Java SE 7 Programmer I Certification Guide is a comprehensive guide to the 1Z0-803 exam. You'll explore important Java topics as you systematically learn what is required. Each chapter starts with a list of exam objectives, followed by sample questions and exercises designed to reinforce key concepts. It provides multiple ways to digest important techniques and concepts, including analogies, diagrams, flowcharts, and lots of well-commented code.Written for developers with a working knowledge of Java who want to earn the OCA Java SE 7 Programmer I Certification.Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications.What's InsideCovers all exam topicsHands-on coding exercisesHow to avoid built-in traps and pitfallsAbout the AuthorMala Gupta has been training programmers to pass Java certification exams since 2006. She holds OCA Java SE7 Programmer I, SCWCD, and SCJP certifications.Table of ContentsIntroductionJava basicsWorking with Java data typesMethods and encapsulationString, StringBuilder, Arrays, and ArrayListFlow controlWorking with inheritanceException handlingFull mock exam

    Written by the lead technical writer at one of Silicon Valley's most exciting companies, Modern Technical Writing is a set of guiding principles and thoughtful recommendations for new and experienced technical writers alike. Not a reference manual, and not comprehensive, it instead serves as an introduction to a sensible writing and publishing process, one that has eluded the profession for too long.

    This long-awaited revision contains changes throughout the text. There are new implementations of most of the major programming systems in the book, including the interpreters and compilers, and the authors have incorporated many small changes that reflect their experience teaching the course at MIT since the first edition was published. A new theme has been introduced that emphasizes the central role played by different approaches to dealing with time in computational models: objects with state, concurrent programming, functional programming and lazy evaluation, and nondeterministic programming. There are new example sections on higher-order procedures in graphics and on applications of stream processing in numerical programming, and many new exercises. In addition, all the programs have been reworked to run in any Scheme implementation that adheres to the IEEE standard.

    Fundamentals of Data Structures in C++ offers a complete rendering of basic data structure implementations, enhanced by superior pedagogy and astute analyses.

    Matthew Bannister said he was going to reinvent the station, the most popular in Europe. But things didn't go exactly to plan. The station lost millions of listeners. Its most famous DJs left, and their replacements proved to be disasters. Radio 1's commercial rivals regarded the internal turmoil with glee. For a while a saviour arrived, in the shape of Chris Evans. But his behaviour caused further upheavals, and his eventual departure provoked another mass desertion by listeners. What was to be done? In the middle of this crisis, Radio 1 bravely (or foolishly) allowed the writer Simon Garfield to observe its workings from the inside. For a year he was allowed unprecedented access to management meetings and to DJs in their studios, to research briefings and playlist conferences. Everyone interviewed spoke in passionate detail about their struggle to make their station credible and successful once more. The result is a gripping and often hilarious portrait a much loved national institution as it battles back from the brink of calamity.

    Learn how to leverage the Django web framework to its full potential in this advanced tutorial and reference. Endorsed by Django, Pro Django more or less picks up where The Definitive Guide to Django left off and examines in greater detail the unusual and complex problems that Python web application developers can face and how to solve them.Provides in-depth information about advanced tools and techniques available in every Django installation Runs the gamut from the theory of Django's internal operations to actual code that solves real-world problems for high-volume environments Goes above and beyond other books, leaving the basics behind Shows how Django can do things even its core developers never dreamed possible

    The hugely popular Gareth Malone recounts the heart-warming stories and transformations behind the award-winning BBC2 series The Choir