You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level.Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing outPowerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES functionPivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result setBucketization, and why you should never use that term in Brooklyn.How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniquesThe technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a stringWritten in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days. The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.

    It’ll have you scratching your head wondering why we even bother to go to school.Think Magellan was the first man to circumnavigate the globe, baseball was invented in America, Henry VIII had six wives, Mount Everest is the tallest mountain? Wrong, wrong, wrong, and wrong again. You’ll be surprised at how much you don’t know! Check out THE BOOK OF GENERAL IGNORANCE for more fun entries and complete answers to the following:How long can a chicken live without its head?About two years.What do chameleons do?They don’t change color to match the background. Never have; never will. Complete myth. Utter fabrication. Total Lie. They change color as a result of different emotional states.How many legs does a centipede have?Not a hundred.How many toes has a two-toed sloth?It’s either six or eight.Who was the first American president?Peyton Randolph.What were George Washington’s false teeth made from?Mostly hippopotamus.What was James Bond’s favorite drink?Not the vodka martini.

    This practical guide not only shows you how to search, analyze, and explore data with Elasticsearch, but also helps you deal with the complexities of human language, geolocation, and relationships.If you're a newcomer to both search and distributed systems, you'll quickly learn how to integrate Elasticsearch into your application. More experienced users will pick up lots of advanced techniques. Throughout the book, you'll follow a problem-based approach to learn why, when, and how to use Elasticsearch features.Understand how Elasticsearch interprets data in your documentsIndex and query your data to take advantage of search concepts such as relevance and word proximityHandle human language through the effective use of analyzers and queriesSummarize and group data to show overall trends, with aggregations and analyticsUse geo-points and geo-shapes--Elasticsearch's approaches to geolocationModel your data to take advantage of Elasticsearch's horizontal scalabilityLearn how to configure and monitor your cluster in production

    The books published on the subject are so technical that only a person trained in pure physics and higher mathematics is able to fully understand them. In order to make a popular explanation of this far-reaching theory available, the present book is published.

    Such systems--whether political parties, stock markets, or ant colonies--present some of the most intriguing theoretical and practical challenges confronting the social sciences. Engagingly written, and balancing technical detail with intuitive explanations, Complex Adaptive Systems focuses on the key tools and ideas that have emerged in the field since the mid-1990s, as well as the techniques needed to investigate such systems. It provides a detailed introduction to concepts such as emergence, self-organized criticality, automata, networks, diversity, adaptation, and feedback. It also demonstrates how complex adaptive systems can be explored using methods ranging from mathematics to computational models of adaptive agents. John Miller and Scott Page show how to combine ideas from economics, political science, biology, physics, and computer science to illuminate topics in organization, adaptation, decentralization, and robustness. They also demonstrate how the usual extremes used in modeling can be fruitfully transcended.

    Longer training, ever more advanced technologies—neither seems to prevent grievous errors. But in a hopeful turn, acclaimed surgeon and writer Atul Gawande finds a remedy in the humblest and simplest of techniques: the checklist. First introduced decades ago by the U.S. Air Force, checklists have enabled pilots to fly aircraft of mind-boggling sophistication. Now innovative checklists are being adopted in hospitals around the world, helping doctors and nurses respond to everything from flu epidemics to avalanches. Even in the immensely complex world of surgery, a simple ninety-second variant has cut the rate of fatalities by more than a third.In riveting stories, Gawande takes us from Austria, where an emergency checklist saved a drowning victim who had spent half an hour underwater, to Michigan, where a cleanliness checklist in intensive care units virtually eliminated a type of deadly hospital infection. He explains how checklists actually work to prompt striking and immediate improvements. And he follows the checklist revolution into fields well beyond medicine, from disaster response to investment banking, skyscraper construction, and businesses of all kinds.An intellectual adventure in which lives are lost and saved and one simple idea makes a tremendous difference, The Checklist Manifesto is essential reading for anyone working to get things right.

    The presentation stresses analytical methods, concrete examples, and geometric intuition. A unique feature of the book is its emphasis on applications. These include mechanical vibrations, lasers, biological rhythms, superconducting circuits, insect outbreaks, chemical oscillators, genetic control systems, chaotic waterwheels, and even a technique for using chaos to send secret messages. In each case, the scientific background is explained at an elementary level and closely integrated with mathematical theory.About the Author:Steven Strogatz is in the Center for Applied Mathematics and the Department of Theoretical and Applied Mathematics at Cornell University. Since receiving his Ph.D. from Harvard university in 1986, Professor Strogatz has been honored with several awards, including the E.M. Baker Award for Excellence, the highest teaching award given by MIT.

    The Intellectual Devotional is a secular version of the same—a collection of 365 short lessons that will inspire and invigorate the reader every day of the year. Each daily digest of wisdom is drawn from one of seven fields of knowledge: history, literature, philosophy, mathematics and science, religion, fine arts, and music.Impress your friends by explaining Plato's Cave Allegory, pepper your cocktail party conversation with opera terms, and unlock the mystery of how batteries work. Daily readings range from important passages in literature to basic principles of physics, from pivotal events in history to images of famous paintings with accompanying analysis. The book's goal is to refresh knowledge we've forgotten, make new discoveries, and exercise modes of thinking that are ordinarily neglected once our school days are behind us. Offering an escape from the daily grind to contemplate higher things, The Intellectual Devotional is a great way to awaken in the morning or to revitalize one's mind before retiring in the evening.

    For more than four decades success‐oriented readers have turned to the no‐nonsense, time‐tested motivational techniques described in 'The Magic of Believing' to achieve their long and short term goals. Millions have benefited from these visualization techniques, which show how to turn your thoughts and dreams into effective actions that can lead to enhanced income, happier relationships, increased effectiveness, heightened influence and improved peace of mind.

    It is within the realm of possibility that their work may usher in a change in global economics as profound as the Industrial Revolution. As may be expected, press reports dealing with asteroid mining have been numerous, ranging in scope from short and breezy to broad and serious, and in quality from accurate to impressionistic to simply uninformed. There is good reason to be curious about what may be the biggest game-changer in human economic history. And there is good reason to look closely at the underlying science and engineering that form the foundation of this work.

    The Kindle VerseSearch Bible with improved navigation and a more organized format.*New Search Feature* - Book List, Chapter List, JumpToVerse.Indexed Verses and Chapters.Interactive Table of Contents.Expanded Chapter Links for easy access.One Year Reading Plan.Arrow Tabs are fully utilized.Red Letter Edition.

    Big Blue, as the company is known, tends to rely for its success on magical thinking but that magic ran out a long time ago. The company got in trouble back in the 1990s and had to hire for the first time an outside CEO, Lou Gerstner, to save the day. Gerstner pushed IBM into services with spectacular results but this hurt the company, too. As services have became commoditized IBM could only compete by offshoring the work and quality suffered. The other negative impact of Gerstner was his compensation which was for the first time in IBM history very high. Only the Watson family had become rich running IBM with later CEOs like John Opel and John Akers living comfortable lives with lots of perks, but they never got BIG RICH. That changed with Gerstner. Sam Palmisano an IBM lifer followed Gerstner as CEO and followed, too, the Gerstner playbook. Palmisano retired three years ago with a retirement package worth $241 million, replaced by IBM's first woman CEO, Ginni Rometty, who certainly expects a comparable golden parachute. In order to achieve these numbers, though, IBM has essentially sacrificed both its customers and employees. In order to have ever growing earnings per share the company has cut labor to the bone, off-shored everything it can, dropped quality, deliberately underbid contracts to win them then not performed. IBM's acquisition policy is one of buying companies to get their sales then cutting costs to the bone and under-delivering. This and share buybacks have kept earnings growing until this house of cards recently began to fall. Ginni Rometty, who will end up taking the fall for Palmisano's flawed strategy, has stated a very specific earnings goal for 2015 that she will destroy the company to achieve if she must. This book how IBM fell from grace, where it is headed, and what specifically can be done to save the company before it is too late.

    The Ultimate Guide to Journaling is a must read for anyone who is interested in journaling.Journaling is an important personal development tool that helps us deepen our connection with ourselves and expand our self-awareness.Whether you are new to the concept of journaling or a seasoned journaler, this book contains tips, techniques and over 100 journaling suggestions and prompts that will take your journaling practice to new levels.We'll also touch on other need-to-know aspects of journaling, including the benefits of journaling, the best time to journal, how often to journal, and useful journaling tools.

    Design and troubleshooting examples and exercises show students the important and practical applications of circuit analysis. At least one odd- and one even-numbered exercise for each important topic or concept is included at the end of each chapter. SPICE(Simulation Program with Integrated Cicuit Emphasis), a powerful simulation program designed to simplify computer-aided circuit analysis, is introduced in a special appendix which provides an in-depth description of how to use it.

    Over 80 per cent of adults in the UK use caffeine every day, but when does this habit become a reliance? Caffeine is a bitter addictive drug which attacks the central nervous system and makes you jittery. Fooling you into thinking you are more alert, caffeine will often disrupt your sleep and actually increase overall fatigue. Quite simply, it's bad for you with no real benefits.In The Easy Way to Quit Caffeine, Allen Carr addresses the difficulties that coffee-drinkers and soda consumers face in trying to quit caffeine. By explaining what caffeine does to your body, and providing simple step-by-step instructions to free you from your addiction, Carr shows you how to lead a happier, healthier and more chilled life.