Itzik Ben-Gan explains key T-SQL concepts and helps you apply your knowledge with hands-on exercises. The book first introduces T-SQL's roots and underlying logic. Next, it walks you through core topics such as single-table queries, joins, subqueries, table expressions, and set operators. Then the book covers more-advanced data-query topics such as window functions, pivoting, and grouping sets. The book also explains how to modify data, work with temporal tables, and handle transactions, and provides an overview of programmable objects. Microsoft Data Platform MVP Itzik Ben-Gan shows you how to: Review core SQL concepts and its mathematical roots Create tables and enforce data integrity Perform effective single-table queries by using the SELECT statement Query multiple tables by using joins, subqueries, table expressions, and set operators Use advanced query techniques such as window functions, pivoting, and grouping sets Insert, update, delete, and merge data Use transactions in a concurrent environment Get started with programmable objects-from variables and batches to user-defined functions, stored procedures, triggers, and dynamic SQL

    The world is doomed, they argue, and there are just too many problems to overcome. But is this really the case? In Fewer, Richer, Greener, author Laurence B. Siegel reveals that the world has improved--and will continue to improve--in almost every dimension imaginable.This practical yet lighthearted book makes a convincing case for having gratitude for today's world and optimism about the bountiful world of tomorrow. Life has actually improved tremendously. We live in the safest, most prosperous time in all human history. Whatever the metric--food, health, longevity, education, conflict--it is demonstrably true that right now is the best time to be alive. The recent, dramatic slowing in global population growth continues to spread prosperity from the developed to the developing world. Technology is helping billions of people rise above levels of mere subsistence. This technology of prosperity is cumulative and rapidly improving: we use it to solve problems in ways that would have be unimaginable only a few decades ago. An optimistic antidote for pessimism and fear, this book:Helps to restore and reinforce our faith in the future Documents and explains how global changes impact our present and influence our future Discusses the costs and unforeseen consequences of some of the changes occurring in the modern world Offers engaging narrative, accurate data and research, and an in-depth look at the best books on the topic by leading thinkers Traces the history of economic progress and explores its consequences for human life around the world Fewer, Richer, Greener: Prospects for Humanity in an Age of Abundance is a must-read for anyone who wishes to regain hope for the present and wants to build a better future.

    Starting with a "macro" view of accounting information, the authors present real financial statements. They establish how a financial statement communicates the financing, investing, and operating activities of a business to users of accounting information. Kimmel, Weygandt and Kieso motivate students by grounding the discussion in the real world, showing them the relevance of the topics covered to their future.

    Calculating and assessing the overall financial health of the business is an important part of any managerial position. From reading and deciphering financial statements, to understanding net present value, to calculating return on investment, Finance for Managers provides the fundamentals of financial literacy. Easy to use and nontechnical, this helpful guide gives managers the smart advice they need to increase their impact on financial planning, budgeting, and forecasting.

    But Alex Epstein shows that if we look at the big picture, the much-hated fossil fuel industry is dramatically improving our planet by making it a far safer and richer place. The key difference between a healthy and unhealthy environment, Epstein argues, is development—the transformation of nature to meet human needs. And the energy required for development is overwhelmingly made possible by the fossil fuel industry, the only way to produce cheap, plentiful, reliable energy on a global scale. While acknowledging the challenges of fossil fuels (and every form of energy), Epstein argues that the overall benefits, including the largely ignored environmental benefits, are incomparably greater.

    What's more, its potential is nearly limitless--every hour the sun beams down more energy than the world uses in a year. But in Taming the Sun, energy expert Varun Sivaram warns that the world is not yet equipped to harness erratic sunshine to meet most of its energy needs. And if solar's current surge peters out, prospects for replacing fossil fuels and averting catastrophic climate change will dim.Innovation can brighten those prospects, Sivaram explains, drawing on firsthand experience and original research spanning science, business, and government. Financial innovation is already enticing deep-pocketed investors to fund solar projects around the world, from the sunniest deserts to the poorest villages. Technological innovation could replace today's solar panels with coatings as cheap as paint and employ artificial photosynthesis to store intermittent sunshine as convenient fuels. And systemic innovation could add flexibility to the world's power grids and other energy systems so they can dependably channel the sun's unreliable energy.Unleashing all this innovation will require visionary public policy: funding researchers developing next-generation solar technologies, refashioning energy systems and economic markets, and putting together a diverse clean energy portfolio. Although solar can't power the planet by itself, it can be the centerpiece of a global clean energy revolution.A Council on Foreign Relations Book

    But is it really as simple as that? Kevin Rodgers has his doubts, and in this fascinating inside account of the financial world over the past three decades, he explains why. Taking us from the days when traders still shouted their deals down the phone to the silent modern world of computer trading, he shows how, far more than the pursuit of personal gain, it has been the pursuit of ever-more sophisticated systems, algorithms and financial models that has undermined banking and made it chronically unstable. He also shows how, by their very nature, the computers on which modern finance now so completely depend are hopelessly ill-equipped to forestall a future crash. Both a very personal and evocative account of how banking has changed since the 1980s, and a masterclass in how it actually works, Why Aren't They Shouting also offers a nuanced, if alarming, glimpse into its likely future.

    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.

    This text's applied approach addresses how and why a business operates. Students can then build upon their practical skills through examples, exercises and projects to help them gain a full understanding of how and why to develop a business plan. Each text is packaged with a Business Plan Booklet and CD-ROM, which are tied to end-of-part features, allowing students hands-on practice in creating a sound business plan. Through lively examples this text emphasizes key core skill areas including, Decision-Making and Planning, Teamwork, Technology, and Communication.

    For more than a decade, well-known consultant and business professor Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Microsoft Excel for data analysis, modeling, and decision making. Now this award-winning educator shares the best of his classroom experience in this practical, business-focused guide. Each chapter advances your data analysis and modeling expertise using real-world examples and learn-by-doing exercises. You also get all the book’s problem-and-solution files on CD—for all the practice you need to solve complex problems and work smarter with Excel.Learn how to solve real business problems with Excel!Create best, worst, and most-likely scenarios for sales Calculate how long it would take to recoup a project’s startup costs Plan personal finances, such as computing loan terms or saving for retirement Estimate a product’s demand curve Simulate stock performance over a year Determine which product mix will yield the greatest profits Interpret the effects of price and advertising on sales Assign a dollar value to customer loyalty Manage inventory and order quantities with precision Create customer service queues with short wait times Estimate the probabilities of equipment failure Model business uncertainties Get new perspectives on data with PivotTable dynamic views Help predict quarterly revenue, outcomes of sporting events, presidential elections, and more! On the CD:Practice files for all the book’s exercises Solutions for problem sets Fully searchable eBook A Note Regarding the CD or DVDThe print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

    This clear, accessible, and even humorous book is ideal for young readers new to economics and for all readers who seek a better understanding of the full sweep of economic history and ideas. Economic historian Niall Kishtainy organizes short, chronological chapters that center on big ideas and events. He recounts the contributions of key thinkers including Adam Smith, David Ricardo, Karl Marx, John Maynard Keynes, and others, while examining topics ranging from the invention of money and the rise of agrarianism to the Great Depression, entrepreneurship, environmental destruction, inequality, and behavioral economics. The result is a uniquely enjoyable volume that succeeds in illuminating the economic ideas and forces that shape our world.

    No matter how much cash or experience you currently have, this book will take you on a journey through buying your first multifamily investment property and give you a framework for turning that into long-term financial freedom. Millionaires are created every day—isn’t it time you joined the ranks? It won’t happen overnight and it won’t always be easy, but The Multifamily Millionaire series will make sure it happens sooner than you ever thought possible! Inside this book, you’ll discover:• How to create a million-dollar net worth in five years using the stack method • The seven different types of small multifamily real estate and which make the best rental properties• How to quickly and accurately analyze your investment, whether its two units or twenty units • Three creative no and low money down strategies that work in any market• A game-changing algorithm for estimating your ongoing repair and reserve expenses • The powerful Multifamily Millionaire Model that illustrates how a million dollars can be created from one single deal• Six off-market acquisition strategies to help you land incredible deals, even in a competitive market• How the BRRRR strategy can help you supercharge your small multifamily portfolio• Detailed instructions for managing your growing portfolio (hint: find five-star tenants!)• And so much more

    Intermediate Accounting integrates this new information throughout the chapters so they'll learn how to apply the new global accounting standards. Global examples are presented to clearly show how the information is utilised in the field. The use of various currencies is also explored, which is critical for accountants to know in today's global businesses environment.

    But it's not a world populated by pinstriped men waiting to rob you, steal your savings and do nasty things to small kittens. You can win. (And you never have to pay a penny in tax!) This book shows you how. Robbie Burns, bestselling author of The Naked Trader, has been spread betting for years. He explains why it's an indispensable tool to use alongside normal investing or trading. Especially as you can make money even if the market goes down. Robbie takes you through everything from how it works, to managing your risk, working out exposure, and how, often, doing nothing is the best move! He explains the ins and outs of successfully betting on shares in his trademark down-to-earth style, covering everything you need to know. From the simple stuff through to proven strategies, including those that can be used in different markets - it's all here. There are also behind-the-scenes visits to two top spread betting firms. But it's a big, bad old world out there, and there are a whole heap of mistakes you can make, an awful lot of money you can lose. Rounding up spine-chilling traders' tales of spread bets gone wrong, and using all he has learnt from making silly mistakes himself, Robbie also helps you learn what not to do. This is the ultimate guide to spread betting - how to do it, have fun and hopefully make a few quid.

    'Poisoned Wells' exposes the root causes of this paradox of poverty from plenty.