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

    A unifying framework uses a few core principles to organize readers' thinking then examines the models as real-world scenarios from a practitioner's perspective. By analyzing these applications, readers develop the critical-thinking and problem-solving skills necessary to respond to challenging situations in their future careers. Introduction: Why Study Financial Markets and Institutions?; Overview of the Financial System. Fundamentals of Financial Markets: What Do Interest Rates Mean and What Is Their Role in Valuation?; Why Do Interest Rates Change?; How Do Risk and Term Structure Affect Interest Rates?; Are Financial Markets Efficient? Central Banking and the Conduct of Monetary Policy: Structure of Central Banks and the Federal Reserve System; Conduct of Monetary Policy: Tools, Goals, Strategy, and Tactics. Financial Markets: The Money Markets; The Bond Market; The Stock Market; The Mortgage Markets; The Foreign Exchange Market; The International Financial System. Fundamentals of Financial Institutions: Why Do Financial Institutions Exist?; What Should Be Done About Conflicts of Interest? A Central Issue in Business Ethics. The Financial Institutions Industry: Banking and the Management of Financial Institutions; Commercial Banking Industry: Structure and Competition; Savings Associations and Credit Unions; Banking Regulation; The Mutual Fund Industry; Insurance Companies and Pension Funds; Investment Banks, Security Brokers and Dealers, and Venture Capital Firms. The Management of Financial Institutions: Risk Management in Financial Institutions; Hedging with Financial Derivatives. On the Web: Finance Companies. For all readers interested in financial markets and institutions.

    He solidified his standing as the nation's foremost political forecaster with his near perfect prediction of the 2012 election. Silver is the founder and editor in chief of FiveThirtyEight.com. Drawing on his own groundbreaking work, Silver examines the world of prediction, investigating how we can distinguish a true signal from a universe of noisy data. Most predictions fail, often at great cost to society, because most of us have a poor understanding of probability and uncertainty. Both experts and laypeople mistake more confident predictions for more accurate ones. But overconfidence is often the reason for failure. If our appreciation of uncertainty improves, our predictions can get better too. This is the "prediction paradox": The more humility we have about our ability to make predictions, the more successful we can be in planning for the future.In keeping with his own aim to seek truth from data, Silver visits the most successful forecasters in a range of areas, from hurricanes to baseball, from the poker table to the stock market, from Capitol Hill to the NBA. He explains and evaluates how these forecasters think and what bonds they share. What lies behind their success? Are they good-or just lucky? What patterns have they unraveled? And are their forecasts really right? He explores unanticipated commonalities and exposes unexpected juxtapositions. And sometimes, it is not so much how good a prediction is in an absolute sense that matters but how good it is relative to the competition. In other cases, prediction is still a very rudimentary-and dangerous-science.Silver observes that the most accurate forecasters tend to have a superior command of probability, and they tend to be both humble and hardworking. They distinguish the predictable from the unpredictable, and they notice a thousand little details that lead them closer to the truth. Because of their appreciation of probability, they can distinguish the signal from the noise.

    The book starts with a section on general cell structure and replication. Basic tissue types are covered in the following section, and the third section presents the microstructures of each of the major body systems. The highest -quality color light micrographs and electron micrograph images are accompanied by concise text and captions which explain the appearance, function, and clinical significance of each image. The accompanying website lets you view all the images from the atlas with a virtual microscope, allowing you to view the image at a variety of pre-set magnifications.Includes access to website containing book images and additional material, extra illustrations, self tests, and more. Utilizes virtual microscope function on the website, allowing you to see images first in low-powered and then in high powered magnification. Incorporates new information on histology of bone marrow, male reproductive system, respiratory system, pancreas, blood, cartilage, muscle types, staining methods, and more. Uses Color coding at the side of each page to make it easier to access information quickly and efficiently. Includes access to www.studentconsult.com - where you'll find the complete text and illustrations of the book online, fully searchable - Integration Links to bonus content in other STUDENT CONSULT titles - 300 new USMLE-style review questions, with answers and rationales - content clipping for handheld devices - an interactive community center with a wealth of additional resources - and much more!

    In this guide for students, each equation is the subject of an entire chapter, with detailed, plain-language explanations of the physical meaning of each symbol in the equation, for both the integral and differential forms. The final chapter shows how Maxwell's equations may be combined to produce the wave equation, the basis for the electromagnetic theory of light. This book is a wonderful resource for undergraduate and graduate courses in electromagnetism and electromagnetics. A website hosted by the author at www.cambridge.org/9780521701471 contains interactive solutions to every problem in the text as well as audio podcasts to walk students through each chapter.

    For instance, the average mall shopper will spend about $100, then leave when she hits that limit. She'll probably buy shoes rather than clothing, because she doesn't want to think about her dress size. And the store most likely to get her money isn't the one with the nicest display or the deepest discounts-it's the one closest to her parking spot.In his consulting with dozens of leading companies, Michael J. Silverstein has interviewed thousands of customers, extracting fascinating patterns about what really drives their purchase decisions. His first book, the acclaimed bestseller Trading Up, has taught a generation of marketers about the "new luxury" phenomenon, and why consumers will happily pay a steep premium for goods and services that are emotionally satisfying, from golf clubs to bathroom fixtures to beauty products.But Trading Up revealed only part of the story of the new consumer. The same middle-class people who are happily trading up at Victoria's Secret and Panera are going on treasure hunts at Costco and Home Depot. And they are often getting as much emotional satisfaction in the discount stores as in the luxury stores. TREASURE HUNT shows how even the most mundane shopping-for things like paper towels and pet food-has become an adventure rather than a tedious chore.In just about every category, both the high end and the low end are growing and innovation- rich. Many middle-class consumers gladly spend $5 a day for a Starbucks venti latte; others spend forty cents a day on home-brewed coffee, feel good about their frugality, and save up the difference to buy Apple's newest Nano. TREASURE HUNT explains the success of companies as diverse as Dollar General, H. E. Butt, eBay, Commerce Bank, and Tchibo.But beware: in our bifurcated global market, businesses need a clear strategy for aiming high or low, while avoiding the treacherous middle, where so many have recently stumbled. If your offering isn't exciting enough to inspire trading up, but not enough of a bargain to satisfy the treasure hunters, you'll have no emotional connection with your target audience. And then, as many fallen companies have discovered, your tried-and-true marketing strategies will go into a severe stall.TREASURE HUNT takes us into the homes of real people making real decisions, and into the CEO's offices of innovative companies finding new ways to accommodate them. Written with the same flair, empathy, and intelligence that made Trading Up an instant classic, this is an essential guide to the moods and habits of the constantly changing consumer.

    Peek behind the counter and learn how sportsbooks operate. Combine that insider knowledge with why-didn’t-I-think-of-that sports betting logic, and you have the winning formula.Ed Miller is a best-selling (over 300,000 copies sold) author of books on poker and gambling. This is his first book on sports betting, but maybe his favorite book to write so far.Matthew Davidow is a sports modeler, using proprietary methods to beat major sports betting markets for over 15 years, and co-founding two leading private sports analytics firms along the way.What people are saying about The Logic Of Sports Betting:"Matt and Ed are two of the smartest minds in sports betting." - Rufus Peabody, professional sports bettor"As a sportsbook employee for 30-plus years, I find it difficult to read or watch anything about sports betting. But I could not put The Logic Of Sports Betting down. It’s that good." - Robert Walker, Las Vegas bookmaker

    Shankar, a well-known physicist and contagiously enthusiastic educator, was among the first to offer a course through the innovative Open Yale Course program. His popular online video lectures on introductory physics have been viewed over a million times. In this concise and self-contained book based on his online Yale course, Shankar explains the fundamental concepts of physics from Galileo’s and Newton’s discoveries to the twentieth-century’s revolutionary ideas on relativity and quantum mechanics.   The book begins at the simplest level, develops the basics, and reinforces fundamentals, ensuring a solid foundation in the principles and methods of physics. It provides an ideal introduction for college-level students of physics, chemistry, and engineering, for motivated AP Physics students, and for general readers interested in advances in the sciences. Instructor resources--including problem sets and sample examinations--and more information about Professor Shankar's course are available at http://oyc.yale.edu/physics/phys-200.

    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

    Medical care is in crisis, we are repeatedly told, and so it is. Barely one in five Americans thinks the medical system works well. Enter David M. Cutler, a Harvard economist who served on President Clinton's health care task force and later advised presidential candidate Bill Bradley. One of the nation's leading experts on the subject, Cutler argues in Your Money or Your Life that health care has in fact improvedexponentially over the last fifty years, and that the successes of our system suggest ways in which we might improve care, make the system easier to deal with, and extend coverage to all Americans. Cutler applies an economic analysis to show that our spending on medicine is well worth it--and thatwe could do even better by spending more. Further, millions of people with easily manageable diseases, from hypertension to depression to diabetes, receive either too much or too little care because of inefficiencies in the way we reimburse care, resulting in poor health and in some cases prematuredeath. The key to improving the system, Cutler argues, is to change the way we organize health care. Everyone must be insured for the medical system to perform well, and payments should be based on the quality of services provided not just on the amount of cutting and poking performed. Lively and compelling, Your Money or Your Life offers a realistic yet rigorous economic approach to reforming health care--one that promises to break through the stalemate of failed reform.