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.

    You'll get in-depth coverage of the C language and function libraries as well as all the newest C features, including restricted pointers, inline functions, variable-length arrays, and complex math. This jam-packed resource includes hundreds of examples and sample applications.

    You'll learn the concepts by tying them to on-the-job tasks, blending practice and theory in a way that only Head First can. With this book, you'll learn skills through a variety of genuine scenarios, from fixing a malfunctioning office network to planning a network for a high-technology haunted house. You'll learn exactly what you need to know, rather than a laundry list of acronyms and diagrams. This book will help you:Master the functionality, protocols, and packets that make up real-world networking Learn networking concepts through examples in the field Tackle tasks such as planning and diagramming networks, running cables, and configuring network devices such as routers and switches Monitor networks for performance and problems, and learn troubleshooting techniques Practice what you've learned with nearly one hundred exercises, questions, sample problems, and projects Head First's popular format is proven to stimulate learning and retention by engaging you with images, puzzles, stories, and more. Whether you're a network professional with a CCNA/CCNP or a student taking your first college networking course, Head First Networking will help you become a network guru.

    Fast Tract Digestion Heartburn is the first book to define and address the real cause of acid reflux. Acid reflux occurs as a result of digestive malabsorption of five difficult-to-digest carbohydrates. It leads to the overgrowth of gas-producing bacteria in the small intestine and the gas pressure drives acid reflux. Dropping a Mentos into a bottle of Coke is the perfect illustration of this phenomenon. Unfortunately, PPI drugs do not address the real cause, but also cause serious side effects including vitamin and mineral malabsorption, bone fractures, pneumonia, low blood magnesium levels, bacterial overgrowth, C diff infection and pneumonia as explained in the book.Fast Tract Digestion Heartburn offers science-based food choices and recipes (Fast Tract Diet) to limit the five difficult-to-digest carbohydrates, so that you can feel relief within a few days Also, it enables you to self-manage all of the symptoms of acid reflux going forward. The Fast Tract Diet is based on a scientific formula called Fermentation Potential (FP). FP is the key measure regardless of the carbohydrate count. Limiting foods with high FP will help control the overgrowth of bacteria in the small intestine and, as a result, acid reflux. The Fast Tract Diet was clinically tested on reflux sufferers in the Boston area. The results were overwhelming and proved the effectiveness of the diet as an alternative to proton pump inhibitor drugs.

    "Machine learning," the process of automating tasks once considered the domain of highly-trained analysts and mathematicians, is the key to efficiently extracting useful information from this sea of raw data. Machine Learning in Action is a unique book that blends the foundational theories of machine learning with the practical realities of building tools for everyday data analysis. In it, the author uses the flexible Python programming language to show how to build programs that implement algorithms for data classification, forecasting, recommendations, and higher-level features like summarization and simplification.

    Ninety-nine percent of the time, the world spins like a top, the skies are clear, and your refrigerator is full of good food. But the world is a volatile place-storms rage, fires burn, and diseases spread. No one is ever completely safe. Humans live as part of a very complex ecosystem that is unpredictable and merciless. Could you protect your family in the case of an emergency-domestic or global? The Disaster Preparedness Handbook will help you to establish a practical disaster plan for your entire family (covering all fourteen basic human needs) in case the unpredictable happens. Additional information is also presented for those with special needs, including the elderly and disabled, children, pregnant women, and even pets. Well-researched by an army veteran and current NASA engineer, this is the essential guide every family should have, study, and keep handy, in case the unthinkable should occur.Shelter.First Aid.Protection.With this book you can outline your survival plan.

     If you have ever found yourself lost halfway through other introductory materials on this topic, this is the book for you. If you don't understand set terminology such as vectors, hyperplanes, and centroids, then this is also the book for you. This starter course isn't a picture story book but does include many visual examples that break algorithms down into a digestible and practical format. As a starter course, this book connects the dots and offers the crash course I wish I had when I first started. The kind of guide I wish had before I started taking on introductory courses that presume you’re two days away from an advanced mathematics exam. That’s why this introductory course doesn’t go further on the subject than other introductory books, but rather, goes a step back. A half-step back in order to help everyone make his or her first strides in machine learning and is an ideal study companion for the visual learner. In this step-by-step guide you will learn: - How to download free datasets - What tools and software packages you need - Data scrubbing techniques, including one-hot encoding, binning and dealing with missing data - Preparing data for analysis, including k-fold Validation - Regression analysis to create trend lines - Clustering, including k-means and k-nearest Neighbors - Naive Bayes Classifier to predict new classes - Anomaly detection and SVM algorithms to combat anomalies and outliers - The basics of Neural Networks - Bias/Variance to improve your machine learning model - Decision Trees to decode classification Please feel welcome to join this starter course by buying a copy, or sending a free sample to your preferred device.

    Git permits virtually an infinite variety of methods for development and collaboration. Created by Linus Torvalds to manage development of the Linux kernel, it's become the principal tool for distributed version control. But Git's flexibility also means that some users don't understand how to use it to their best advantage. Version Control with Git offers tutorials on the most effective ways to use it, as well as friendly yet rigorous advice to help you navigate Git's many functions. With this book, you will:Learn how to use Git in several real-world development environments Gain insight into Git's common-use cases, initial tasks, and basic functions Understand how to use Git for both centralized and distributed version control Use Git to manage patches, diffs, merges, and conflicts Acquire advanced techniques such as rebasing, hooks, and ways to handle submodules (subprojects) Learn how to use Git with Subversion Git has earned the respect of developers around the world. Find out how you can benefit from this amazing tool with Version Control with Git.

    Some books try to give you copy-and-paste instructions for how to deal with every single system issue that may arise, but How Linux Works actually shows you how the Linux system functions so that you can come up with your own solutions. After a guided tour of filesystems, the boot sequence, system management basics, and networking, author Brian Ward delves into open-ended topics such as development tools, custom kernels, and buying hardware, all from an administrator's point of view. With a mixture of background theory and real-world examples, this book shows both "how" to administer Linux, and "why" each particular technique works, so that you will know how to make Linux work for you.

    Whether you're building the next killer app, investing in a startup, or simply curious about the technology, this practical book is essential reading.Bitcoin, the first successful decentralized digital currency, is still in its infancy and it's already spawned a multi-billion dollar global economy. This economy is open to anyone with the knowledge and passion to participate. Mastering Bitcoin provides you with the knowledge you need (passion not included).This book includes:A broad introduction to bitcoin--ideal for non-technical users, investors, and business executivesAn explanation of the technical foundations of bitcoin and cryptographic currencies for developers, engineers, and software and systems architectsDetails of the bitcoin decentralized network, peer-to-peer architecture, transaction lifecycle, and security principlesOffshoots of the bitcoin and blockchain inventions, including alternative chains, currencies, and applicationsUser stories, analogies, examples, and code snippets illustrating key technical concepts

    Kathy addresses everything needed to keep chickens simply, including coops, chick care, breed selection, chicken health, and beyond! Internationally known as The Chicken Chick, Kathy Shea Mormino brings an informative style and fresh perspective on raising backyard chickens to millions of fans around the world. An attorney by profession, Kathy is the founder and one-woman creative force behind her wildly popular and award-winning Facebook page and blog, The-Chicken-Chick.com. Now her practical, down-to-earth approach to chicken-keeping is available in book form. Sharing her years of hard-earned experience and collaborations with poultry veterinarians, nutritionists, and professors, she provides simple steps to care for these uncommon pets with confidence. Kathy’s personality permeates the book as she guides newbie, veteran, and would-be backyard chickeneers alike through all aspects of small-flock care—from getting into the hobby to housing, feeding, egg production, health, and much more. The result is accurate information presented in the fun and abundantly illustrated format that Mormino has delivered on her blog for years.

    

    Python is a beautiful computer language. It is simple, and it is intuitive. Python is used by a sorts of people – data scientists use it for much of their number crunching and analytics; security testers use it for testing out security and IT attacks; it is used to develop high-quality web applications and many of the large applications that you use on the internet are also written in Python, including YouTube, DropBox, and Instagram. Are you interested in learning Python? Then settle in and learn the basics in just 7 days - enough for you to be comfortable in moving on to the next level without any trouble.Are you interested in learning Python? Then settle in and learn the basics in just 7 days - enough for you to be comfortable in moving on to the next level without any trouble. In this book you'll learn: Setting Up Your Environment Let’s Get Programming Variables and Programs in Files Loops, Loops and More Loops Functions Dictionaries, Lists, and Tuples The “for” Loop Classes Modules File Input/Output Error Handling and much more! Now it's time for you to start your journey into Python programming! Click on the Buy Now button above and get started today!

    Willingham on educational neuroscience? Written for busy teachers, trainers, managers and students, this dip-in dip-out guide makes theories of learning accessible and practical. It explores over 100 classic and contemporary learning theorists in an easy-to-use, bite-sized format with clear relevant illustrations on how each theory will benefit your teaching and learning.Each model or theory is explained in less than 350 words, many with accompanying diagrams, and the 'how to use it' sections, in less than 500 words. Every entry includes:Do it steps in order to apply the theory or modelReflection points & challenges to develop your understanding of how to apply itAnalogies & metaphors from which understanding and meaning can be drawnTips for the classroomFurther reading if you want to explore a theory in greater depth. More titles by Bob Bates: Educational Leadership Simplified A Quick Guide to Special Needs and Disabilities

    With the refreshing candor reviewers admired in Writing Solid Code, Maguire talks about what did and what didn't work at Microsoft and tells you how to energize software teams to work effectively - and to enjoy their work; why you might want to kick your star programmer off your team; how to avoid corporate snares and overblown corporate processes; which tiny changes produce major results; how to deliver on schedule and without overwork; how to pull twice the value out of everything you do; how to get your team going on a creative roll; and how to raise the average programmer level at your company.