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

    In keeping with his reputation for writing about big ideas in an illuminating and graceful way, he shows how sports respond to deep human needs; describes the ways in which baseball, football and basketball became national institutions and how they reached their present forms; and covers the evolution of rules, the rise and fall of the most successful teams, and the historical significance of the most famous and influential figures such as Babe Ruth, Vince Lombardi, and Michael Jordan. Whether he is writing about baseball as the agrarian game, football as similar to warfare, basketball as the embodiment of post-industrial society, or the moral havoc created by baseball's designated hitter rule, Mandelbaum applies the full force of his learning and wit to subjects about which so many Americans care passionately: the games they played in their youth and continue to follow as adults. By offering a fresh and unconventional perspective on these games, The Meaning of Sports makes for fascinating and rewarding reading both for fans and newcomers.

    The man admitted he had attempted to siphon gas from a motor home but inadvertently put the siphon tube in the wrong tank. Instead of gasoline, the man sucked out the contents of the sewage holding tank. If stupidity were lethal, all of the criminals highlighted in The Stupid Crook Book would be dead. This book from highly successful author Leland H. Gregory III captures hilarious tales of captured criminals who are so dumb you almost feel sorry for them. Almost. This lineup of criminal bozos includes: * Michael Anthony Silver, who made a $250 call to a 1-900 psychic hotline in the course of robbing a home. When the phone bill came later that month the homeowners called the police, who traced the call back to the hotline. It turns out Silver used his real name with the psychic.* A would-be bank robber who fainted when a bank teller told him she had no money. The police later found his getaway car and discovered the key locked inside it.* Tony Bariteau, who was arrested and pled guilty to breaking into the Deja Vu store in Troy, Alabama-twice! He was arrested because the same witness spotted him smashing the same window and stealing much of the same merchandise. Deja vu indeed.* A wanted fugitive from Maryland who was running low on cash and stopped by a police station in Texas to ask for gas money. The police saved him the expense and gave him a free ride back to prison.The Stupid Crook Book builds on the successful trail Gregory blazed with America's Dumbest Criminals, the book he coauthored that spent 17 weeks on the New York Times best-seller list.Author's web site: www.realwacky.com/

    The chafing restrictions of a typical upbringing in upper-class, small town Alabama simply did not apply to Zelda, who was described as an unusual child and permitted to roam the streets with little supervision. Zelda refused to blossom into a typical 'Southern belle' on anyone's terms but her own and while still in high school enjoyed the status of a local celebrity for her shocking behavior. Everybody in town knew the name Zelda Sayre. Queen of the Montgomery social scene, Zelda had a different beau ready and willing to show her a good time for every day of the week. Before meeting F. Scott Fitzgerald, Zelda's life was a constant pursuit of pleasure. With little thought for the future and no responsibilities to speak of, Zelda committed herself fully to the mantra that accompanied her photo in her high school graduation book: "Why should all life be work, when we all can borrow. Let's think only of today, and not worry about tomorrow." But for now Zelda was still in rehearsal for her real life to begin, a life she was sure would be absolutely extraordinary. Zelda Sayre married F. Scott Fitzgerald on the 3rd of April 1920 and left sleepy Montgomery behind in order to dive headfirst into the shimmering, glamourous life of a New York socialite. With the publication of Scott's first novel, This Side of Paradise, Zelda found herself thrust into the limelight as the very epitome of the Flapper lifestyle. Concerned chiefly with fashion, wild parties and flouting social expectations, Zelda and Scott became icons of the Jazz Age, the personification of beauty and success. What Zelda and Scott shared was a romantic sense of self-importance that assured them that their life of carefree leisure and excess was the only life really worth living. Deeply in love, the Fitzgeralds were like to sides of the same coin, each reflecting the very best and worst of each other. While the world fell in love with the image of the Fitzgeralds they saw on the cover of magazines, behind the scenes the Fitzgerald's marriage could not withstand the tension of their creative arrangement. Zelda was Scott's muse and he mercilessly mined the events of their life for material for his books. Scott claimed Zelda's memories, things she said, experiences she had and even passages from her diary as his possessions and used them to form the basis of his fictional works. Zelda had a child but the domestic sphere offered no comfort or purpose for her. The Flapper lifestyle was not simply a phase she lived through, it formed the very basis of her character and once the parties grew dull, the Fitzgeralds' drinking became destructive and Zelda's beauty began to fade, the world held little allure for her. Zelda sought reprieve in work and tried to build a career as a ballet dancer. When that didn't work out she turned to writing but was forbidden by Scott from using her own life as material. Convinced that she would never leave her mark on the world as deeply or expressively as Scott had, Zelda retreated into herself and withdrew from the people she knew in happier times. The later years of Zelda's life were marred by her detachment from reality as, diagnosed with schizophrenia, Zelda spent the last eighteen years of her life living in and out of psychiatric hospitals. As Scott's life unraveled due to alcohol abuse, Zelda looked back on the years they had spent together, young and wild and beautiful, as the best of her life. She may have been right but she was wrong about one thing, Zelda did leave her mark on the world and it was a deep and expressive mark that no one could have left but her. Zelda Fitzgerald: The Biography

    Good journalism builds communities, arms citizens with important information, and serves as a public watchdog for civic, national, and global issues. But what happens when the news turns its back on its public role? Leonard Downie Jr., executive editor of The Washington Post, and Robert G. Kaiser, associate editor and senior correspondent, report on a growing crisis in American journalism. From the corporatization that leads media moguls to slash content for profit, to newsrooms that ignore global crises to report on personal entertainment, these veteran journalists chronicle an erosion of independent, relevant journalism. In the process, they make clear why incorruptible reporting is crucial to American society. Rooted in interviews and first-hand accounts, the authors take us inside the politically charged world of one of America’s powerful institutions, the media.

    Introduction by Jesse Sheidlower; illustrations by Arnold Roth.

    Communications expert Carmine Gallo has studied and analyzed the very best of Jobs's performances, offering point-by-point examples, tried-and-true techniques, and proven presentation secrets in 18 "scenes," including:Develop a messianic sense of purposeReveal the Conquering heroChannel your inner ZenStage your presentation with propsMake it look effortlessWith this revolutionary approach, you'll be surprised at how easy it is to sell your ideas, share your enthusiasm, and wow your audience the Steve Jobs way."No other leader captures an audience like Steve Jobs does and, like no other book, The Presentation Secrets of Steve Jobs captures the formula Steve uses to enthrall audiences."--Rob Enderle, The Enderle Group"Now you can learn from the best there is--both Jobs and Gallo. No matter whether you are a novice presenter or a professional speaker like me, you will read and reread this book with the same enthusiasm that people bring to their iPods."--David Meerman Scott, bestselling author of The New Rules of Marketing & PR and World Wide Rave

    Based on Donald Miller’s bestselling book Building a StoryBrand, Claire Diaz-Ortiz applies the seven principles of the StoryBrand Framework to help you build an effective, long-lasting social media plan for your brand. Social Media Success for Every Brand teaches readers how to incorporate the StoryBrand 7-Part Framework into their social media channels to increase engagement and see better results. Readers will understand exactly what they need to do with their social media to drive growth to their organization through the practical guidance of the five-point SHARE model:STORYHOWAUDIENCEREACHEXCELLENCESocial Media Success for Every Brand does not require the reader to be familiar with Building a StoryBrand but provides enough foundation to prepare the reader for practical success with their social media content. Together with the StoryBrand Framework, Claire’s SHARE model will help boost customer engagement and grow the organization’s brand awareness and revenues.

     They say you shouldn't ask your mom whether your business is a good idea, because she loves you and will lie to you. This is technically true, but it misses the point. You shouldn't ask anyone if your business is a good idea. It's a bad question and everyone will lie to you at least a little . As a matter of fact, it's not their responsibility to tell you the truth. It's your responsibility to find it and it's worth doing right .Talking to customers is one of the foundational skills of both Customer Development and Lean Startup. We all know we're supposed to do it, but nobody seems willing to admit that it's easy to screw up and hard to do right. This book is going to show you how customer conversations go wrong and how you can do better.

    Stephen Montgomery presents a fresh new look at the four temperaments, the four ancient "people patterns" that are the key to personality types. In this updated and expanded 2nd edition, Dr. Montgomery cites over 250 characters from well-known movies and TV shows The Wizard of Oz, Sex and the City, Harry Potter, Star Trek, Star Wars, The Fantastic Four, The Incredibles, The Lord of the Rings, Ghost Busters, and many more to help bring the temperaments alive for a modern audience.People Patterns features an easy-to-score personality quiz, and easy-to-read chapters on dating & mating, parents & children, and talent & career (with over 750 job suggestions grouped according to type). The book begins with a brief history of the four temperaments (tracing the idea back to Hippocrates), and it ends with port