The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools.You'll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from the U.S. Census and other federal and state government agencies. With exercises and real-world examples in each chapter, this book will teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently.You'll learn how to: •Create databases and related tables using your own data •Define the right data types for your information •Aggregate, sort, and filter data to find patterns •Use basic math and advanced statistical functions •Identify errors in data and clean them up •Import and export data using delimited text files •Write queries for geographic information systems (GIS) •Create advanced queries and automate tasks Learning SQL doesn't have to be dry and complicated. Practical SQL delivers clear examples with an easy-to-follow approach to teach you the tools you need to build and manage your own databases. This book uses PostgreSQL, but the SQL syntax is applicable to many database applications, including Microsoft SQL Server and MySQL.

    And who better to guide you through the brewing process than a tea guru with more than forty years of experience under his belt? Stephen Lee, cofounder of Tazo Tea and Stash Tea, turned his attention to fermented tea and founded Kombucha Wonder Drink in 2001. In Kombucha Revolution, Lee reveals the secrets to brewing the perfect batch of kombucha and caring for your very own SCOBY (Symbiotic Culture of Bacteria and Yeast). He also shares his favorite recipes—plus contributions from brewers, bartenders, and chefs like “Kombucha Mamma” Hannah Crum and Wildwood’s Dustin Clark—for infusing your brew with fruits, herbs, and spices, and incorporating it into juices, smoothies, sauces, snacks, sweets, and cocktails. With recipes for Lavender–Green Tea Kombucha, Cranberry Bitters Cocktails, Kombucha Vinegar, Green Smoothies, Kombucha Lime Ceviche,  and Kombucha Pear Sorbet, mixing this healthful brew into your everyday lifestyle has never been so revolutionary.

    As in the original book, Dive Into Python, each chapter starts with a real, complete code sample, proceeds to pick it apart and explain the pieces, and then puts it all back together in a summary at the end.This book includes:Example programs completely rewritten to illustrate powerful new concepts now available in Python 3: sets, iterators, generators, closures, comprehensions, and much more A detailed case study of porting a major library from Python 2 to Python 3 A comprehensive appendix of all the syntactic and semantic changes in Python 3 This is the perfect resource for you if you need to port applications to Python 3, or if you like to jump into languages fast and get going right away.

    This guide also helps you understand the many data-mining techniques in use today.Based on an MBA course Provost has taught at New York University over the past ten years, Data Science for Business provides examples of real-world business problems to illustrate these principles. You’ll not only learn how to improve communication between business stakeholders and data scientists, but also how participate intelligently in your company’s data science projects. You’ll also discover how to think data-analytically, and fully appreciate how data science methods can support business decision-making.Understand how data science fits in your organization—and how you can use it for competitive advantageTreat data as a business asset that requires careful investment if you’re to gain real valueApproach business problems data-analytically, using the data-mining process to gather good data in the most appropriate wayLearn general concepts for actually extracting knowledge from dataApply data science principles when interviewing data science job candidates

    Inside you'll find a huge number of hands-on exercises and techniques to help you remove roadblocks to change - whether you're seeking to overcome anxiety and depression, boost self-esteem, lose weight, beat addiction or simply improve your outlook in your professional and personal life - and regain control over your life.Rhena Branch and Rob Willson are CBT therapists at the Priory Clinic in London, and the authors of Cognitive Behavioural Therapy For Dummies.

    The topic everyone in the world should be talking about.

    Although dashboards are potentially powerful, this potential is rarely realized. The greatest display technology in the world won't solve this if you fail to use effective visual design. And if a dashboard fails to tell you precisely what you need to know in an instant, you'll never use it, even if it's filled with cute gauges, meters, and traffic lights. Don't let your investment in dashboard technology go to waste.This book will teach you the visual design skills you need to create dashboards that communicate clearly, rapidly, and compellingly. Information Dashboard Design will explain how to:Avoid the thirteen mistakes common to dashboard design Provide viewers with the information they need quickly and clearly Apply what we now know about visual perception to the visual presentation of information Minimize distractions, cliches, and unnecessary embellishments that create confusion Organize business information to support meaning and usability Create an aesthetically pleasing viewing experience Maintain consistency of design to provide accurate interpretation Optimize the power of dashboard technology by pairing it with visual effectiveness Stephen Few has over 20 years of experience as an IT innovator, consultant, and educator. As Principal of the consultancy Perceptual Edge, Stephen focuses on data visualization for analyzing and communicating quantitative business information. He provides consulting and training services, speaks frequently at conferences, and teaches in the MBA program at the University of California in Berkeley. He is also the author of Show Me the Numbers: Designing Tables and Graphs to Enlighten. Visit his website at www.perceptualedge.com.

    An introduction to Python programming for beginners.

    This text, organized with a traditional functional-group approach, applies the most modern teaching and pedagogical techniques to the study of organic chemistry. In a highly accessible fashion, this top-selling text bridges the gap between conceptual understanding and actual application - while strongly emphasizing the development of problem-solving skills. Additionally, it provides up-to-date aspects of spectroscopy, relevant photographs, and many applications to polymer chemistry integrated throughout the text.

    With an almost unlimited range of input and output add-ons, sensors, indicators, displays, motors, and more, the Arduino offers you countless ways to create devices that interact with the world around you.In Arduino Workshop, you'll learn how these add-ons work and how to integrate them into your own projects. You'll start off with an overview of the Arduino system but quickly move on to coverage of various electronic components and concepts. Hands-on projects throughout the book reinforce what you've learned and show you how to apply that knowledge. As your understanding grows, the projects increase in complexity and sophistication.Among the book's 65 projects are useful devices like:A digital thermometer that charts temperature changes on an LCD A GPS logger that records data from your travels, which can be displayed on Google Maps A handy tester that lets you check the voltage of any single-cell battery A keypad-controlled lock that requires a secret code to open You'll also learn to build Arduino toys and games like:An electronic version of the classic six-sided die A binary quiz game that challenges your number conversion skills A motorized remote control tank with collision detection to keep it from crashingArduino Workshop will teach you the tricks and design principles of a master craftsman. Whatever your skill level, you'll have fun as you learn to harness the power of the Arduino for your own DIY projects.

    Developed by computer science instructors, books in the For the absolute beginner series teach the principles of programming through simple game creation. You will acquire the skills that you need for more practical Python programming applications and you will learn how these skills can be put to use in real-world scenarios. Best of all, by the time you finish this book you will be able to apply the basic principles you've learned to the next programming language you tackle.Features Fun approach to a difficult topic Readers will create games with Python as they learn the fundamentals of this programming language The CD will include games that readers can cut and paste into their own Web site The author provides challenges at the end of chapters to push readers to program on their own.

    As the lead singer of a punk rock band and a competitive triathlete, his tattoo-covered biceps don’t exactly scream “plant eater.” But it’s that very misconception he rallies against in his provocative book, Meat Is for Pussies.According to Joseph, eating animals—whether in the form of steak, burgers, wings, or ribs—is for the weak. Contrary to popularly accepted wisdom, eating animal protein doesn’t make you stronger, tougher, or manlier—it makes you sicker, heavier, slower, and more prone to life-threatening disease. In essence: it makes you a pussy.In Meat Is for Pussies, Joseph shares his shocking and compelling story of evolving from a life of violence and hard-knock living to a man who chooses not to participate in the cycle of violence by eating animals. He also dispels the common myths surrounding meat, while sharing the latest information on the nutritional benefits of a plant-based diet and the dangers of eating meat and processed foods. In addition, Joseph offers practical guidance about such everyday issues as meal planning, recipes, and working out.There is a substantial category of vegan literature out there, but no one has written a book like this. By turns explosive, controversial, moving, and laugh-out-loud funny, and illustrated with eight pages of black-and-white photos, Meat Is for Pussies is a plant-based manifesto.

    Don't be so sure, says John Gribbin, one of today's best popular science writers. In this fascinating and intriguing new book, Gribbin argues that the very existence of intelligent life anywhere in the cosmos is, from an astrophysicist's point of view, a miracle. So why is there life on Earth and (seemingly) nowhere else? What happened to make this planet special? Taking us back some 600 million years, Gribbin lets you experience the series of unique cosmic events that were responsible for our unique form of life within the Milky Way Galaxy. Written by one of our foremost popular science writers, author of the bestselling In Search of Schrödinger's Cat Offers a bold answer to the eternal question, "Are we alone in the universe?" Explores how the impact of a "supercomet" with Venus 600 million years ago created our moon, and along with it, the perfect conditions for life on Earth From one of our most talented science writers, this book is a daring, fascinating exploration into the dawning of the universe, cosmic collisions and their consequences, and the uniqueness of life on Earth.

    His talents are vividly revealed in this exciting and penetrating explanation of how the central laws of physical science evolved — from Pythagoras' discovery of frequency ratios in the 6th century B.C. to today's research on elementary particles.Unlike many books on physics which focus entirely on fact and theory with little or no historic detail, the present work incorporates fascinating personal and biographical data about the great physicists of past and present. Thus Dr. Gamow discusses on an equal basis the trail of Galileo and the basic laws of mechanics which he discovered, or gives his personal recollections about Niels Bohr along with detailed discussion of Bohr's atomic model. You'll also find revealing glimpses of Newton, Huygens, Heisenberg, Pauli, Einstein, and many other immortals of science.Each chapter is centered around a single great figure, or at most two, with other physicists of the era and their contributions forming a background. Major topics include the dawn of physics, the Dark Ages and the Renaissance, Newtonian physics, heat as energy, electricity, the relativistic revolution, quantum theory, and the atomic nucleus and elementary particles.As Dr. Gamow points out in the Preface, the aim of this book is to give the reader the feeling of what physics is, and what kind of people physicists are. This delightfully informal approach, combined with the book's clear, easy-to-follow explanations, will especially appeal to young readers but will stimulate and entertain science enthusiasts of all ages. 1961 edition."The whole thing is a tour de force covering all the important landmarks." — Guardian

    What you need to learn to pass a Cisco certification exam such as CCNA and what you need to know to survive in the real world are two very different things. The strategies that this book offers weren 't on the exam, but they 're exactly what you need to do your job well.Network Warrior takes you step by step through the world of hubs, switches, firewalls, and more, including ways to troubleshoot a congested network, and when to upgrade and why. Along the way, you 'll gain an historical perspective of various networking features, such as the way Ethernet evolved. Based on the author 's own experience as well as those he worked for and with, Network Warrior is a Cisco-centric book, focused primarily on the TCP/IP protocol and Ethernet networks -- the realm that Cisco Systems now dominates. The book covers: The type of networks now in use, from LANs, WANs and MANs to CANsThe OSI Model and the layers involved in sending data Hubs, repeaters, switches, and trunks in practice Auto negotiation and why it 's a common problem in network slowdowns Route maps, routing protocols, and switching algorithms in Cisco routers The resilient Ethernet -- how to make things truly redundant Cisco 6500 multi-layer switches and the Catalyst 3750 switch Telecom nomenclature -- why it 's different from the data world T1 and DS3 Firewall theory, designing access lists, authentication in Cisco devices Server load balancing technology Content switch module in action Designing QOS and what QOS does not do IP design and subnetting made easy The book also explains how to sell your ideas to management, how networks become a mess as a company grows, and why change control is your friend. Network Warrior will help network administrators and engineers win the complex battles they face every day.