Learning DATABASE fundamentals just got a whole lot EASIER! Now you can design, build, and manage a fully functional database with ease. Thoroughly updated to cover the latest technologies and techniques, Databases Demystified, Second Edition gives you the hands-on help you need to get started. Written in a step-by-step format, this practical guide covers methods that can be used with any database, including Microsoft Access, MySQL, Microsoft SQL Server, and Oracle. You'll learn about relational database components, database queries, SQL, the database life cycle, logical database design using normalization, and physical database design. Data and process modeling, database security, Online Analytical Processing (OLAP), and XML are also covered. Detailed examples and concise explanations make it easy to understand the material, and end-of-chapter quizzes and a final exam help reinforce learning. It's a no-brainer! You'll find out how to: Create and run database queries using the forms-based query tool in Microsoft Access Write SQL statements and queries Use entity relationship diagrams (ERDs) for data modeling Design physical tables Connect databases to users, computer systems, and applications Secure database data Handle cursor processing, transaction management, and performance tuning Integrate XML documents and objects into databases Simple enough for a beginner, but challenging enough for an advanced student, Databases Demystified, Second Edition is your self-paced guide to learning universal database concepts.

Accounting information and tips you can take to the bank! You may not know the first thing about debits, credits, and cash ratios now—but when you’re done with this book, you’ll be able to juggle profits and losses with your eyes closed and read any balance sheet like it’s a good novel. Accounting DeMySTiFieD, Second Edition, is a curriculum-based, self-teaching guide that makes learning accounting easier than 1-2-3. With graphs, plain-English explanations, and real-life examples, it starts with the fundamentals—such as basic financial terms, balance sheets, and cash flow statements—and eases you into the more complicated stuff, like adjusting entries, double entry bookkeeping, profit ratios, and liquidity. Completely updated and revised to cover finance terms, theories, and best practices, Accounting DeMySTiFieD teaches you the ins and outs of accounting in no time at all. This fast and easy guide features: A complete overview of financial statements, GAAP rules, transactions, cost, budgets, and tax accounting Proven accounting insights, tips, strategies, and techniques Chapter-ending practice exercises, quizzes, and final exam to reinforce your knowledge and chart progress Tons of examples to show how accounting works in the real world Simple enough for a beginner but challenging enough for a more advanced student, Accounting DeMySTiFieD is your shortcut to mastery of this otherwise complex subject.

The simple way to master corporate finance The math, the formulas, the problem solving . . . does corporate finance make your head spin? You're not alone. It's one of the toughest subjects for business students—which is why Corporate Finance DeMYSTiFieD is written in a way that makes learning it easier than ever. This self-teaching guide first explains the basic principles of corporate finance, including accounting statements, cash flows, and ratio analysis. Then, you'll learn all the specifics of more advanced practices like estimating future cash flows, scenario analysis, and option valuation. Filled with end-of-chapter quizzes and a final exam, Corporate Finance DeMYSTiFieD teaches you the ins-and-outs of this otherwise confounding subject in no time at all. This fast and easy guide features: An overview of important concepts, such as time value of money, interest rate conversion, payment composition, and amortization schedules Easy-to-understand descriptions of corporate finance principles and strategies Chapter-ending quizzes and a comprehensive final exam to reinforce what you've learned and pinpoint problem areas Hundreds of updated examples with practical solutions Simple enough for a beginner, but challenging enough for an advanced student, Corporate Finance DeMYSTiFieD is your shortcut to a working knowledge of this important business topic.

MULTIPLY your chances of learning STATISTICS Trying to understand statistics but feeling a bit uncertain? Here's your solution. Statistics Demystifed, Second Edition helps you master this fundamental topic with ease. Written in a step-by-step format, this practical guide begins by reviewing background mathematics, probability basics, and descriptive measures. The book goes on to demonstrate statistics in action with coverage of sampling, estimation, hypotheses, prediction, regression, correlation, causation, order, and chaos. Detailed examples, concise explanations, and worked-out problems make it easy to understand the material, and end-of-chapter quizzes and a final exam help reinforce learning. It's a no-brainer! You'll learn about: The probability fallacy Random sampling Estimation Assumptions and testing Chaos, bounds, and randomness Variance and standard deviation Correlation and cause/effect relations The use of statistics in medicine, law, math, and engineering Simple enough for a beginner, but challenging enough for an advanced student, Statistics Demystified, Second Edition helps you master this essential subject.

DeMYSTiFieD fuels your knowledge of tricky subjects like alternative energy If you think a Maglev train is a child's toy, or learning about fusion makes your brain reach critical mass, Alternative Energy DeMYSTiFieD, Second Edition will power up your knowledge of this topic's fundamental concepts and theories at your own pace. This practical guide eases you into this field of science, starting at primitive heating sources such as coal and wood. As you progress, you will master the science behind alternative energies such as evaporative cooling, fuel-cell vehicles, aeroelectric power, and more. You will understand the difference between conventional fluorescent and compact fluorescent lamps as well as the benefits of large-scale wind power. Detailed examples make it easy to understand the material, and end-of-chapter quizzes and a final exam help reinforce key ideas. It's a no-brainer! You'll learn about: Passive solar heating Thermal-mass cooling Propulsion with biofuels Electric vehicles Large-scale hydropower Semiconductor lamps Geothermal power Simple enough for a beginner, but challenging enough for an advanced student, Alternative Energy DeMYSTiFieD, Second Edition is your shortcut to a working knowledge of this timely topic.

In good times and bad, you need to know your OPTIONS Market volatility is at a record high, which has investors running scared. You don't have to be one of them. Whether your goal is to protect your money in a downturn or profit handsomely from an upturn, trading options is the answer. Options DeMYSTiFieD reveals why today’s smartest investors rely on the versatility of the options marketplace--and how you can, too! With its quick, snappy explanations and easy-to-understand examples, it provides the knowledge you need to start trading options like a pro in no time. Chapterending quizzes and a final exam round out Options DeMYSTiFieD into a comprehensive self-teaching guide that allows you to learn at your own pace. This fast and easy guide has everything you need to: Protect your investments from market downturns--even those in your IRA or 401(k) Increase income from stocks you already own Multiply the leverage you have in the market to max out your profits Manage the risk of investing without decreasing profit potential Engage in more complex trading, such as covered calls, spreads, straddles, and hedges Simple enough for a beginner but challenging enough for an advanced trader, Options DeMYSTiFieD has what you need to build a solid foundation in options trading.

Demystified is your vaccine for tricky subjects like microbiology If you don't know your prokaryotes from your protozoa, or learning about fungi puts you in a funk, look no further--Microbiology Demystified, Second Edition is your cure for learning this topic's fundamental concepts and theories at your own pace. This practical guide eases you into this field of science, starting at the cell level. As you progress, you will master microbiology essentials such as bacteria, algae, viruses, pasteurization, and more. You will understand the difference between friendly and unfriendly microorganisms as well as the microscope's role in shaping microbiology. Detailed examples make it easy to understand the material, and end-of-chapter quizzes and a final exam help reinforce key ideas. It's a no-brainer! You'll learn about: Classification of microorganisms Immunology Germ theory Recombinant DNA technology Pathogens E.coli Antiseptics Simple enough for a beginner, but challenging enough for an advanced student, Microbiology Demystified. Second Edition, helps you master this essential subject.

Solve your math troubles with DeMYSTiFieD If you cannot tell the difference between your Roman and Arabic numerals, or if when someone asks 'what is pi' you say "delicious," you need Everyday Math DeMYSTiFieD, Second Edition, to unravel these fundamental concepts and theories at your own pace. This practical guide eases you into basic math, starting with counting and simple operations. As you progress, you will master essential concepts such as division, converting decimals into fractions, determining volume, and more. You will learn to measure capital gains and losses as well as apply percentages in the real world. Detailed examples make it easy to understand the material, and end-of- chapter quizzes and a final exam help reinforce key ideas. It's a no-brainer! You'll learn about: Decimals Proportions Prime numbers Surface area Powers of 10 Graphs English vs. metric units Simple enough for a beginner but challenging enough for an advanced student, Everyday Math DeMYSTiFieD, Second Edition, helps you master this essential subject.

Start building a rock-solid portfolio with as little as $500! Do you think cash vehicle is another phrase for "expensive car"? Would you know a hybrid investment if you saw one? Does T-bill mean anything to you? The world of investing is a complex (and sometimes scary) place. Fortunately, you have a knowledgeable tour guide that speaks a language you understand! Investing DeMYSTiFieD, Second Edition, untanglesan otherwise perplexing topic, making it easier than ever to invest like a veteran! Outlining step-by-step techniques for making the most of your money while keeping it out of harm’s way, this self-teaching guide explains how to identify and take advantage of rich opportunities--from mutual funds to taxfree bonds to real estate. Market-proven tips and techniques, handy checklists, and chapter-ending quizzes help you build a solid foundation on thesubject at your own speed. This fast and easy guide helps you: Determine your investment personality to increase your success Protect your money from the next market downturn Boost returns while managing risk with the right allocation strategies Understand balance sheets, income statements, and other documents Generate greater returns from your 401(k), IRA, or other retirement account Simple enough for a novice but challenging enough for an experienced investor, Investing DeMYSTiFieD helps you put your money in the right places, whetheryou're looking to earn quick cash or build for the future.

Accounting as easy as 1-2-3! Do you know the difference between FIFO and LIFO? Can you use the word dilutive in a sentence? Does the phrase "amortization of bond premiums" mean anything to you? No one said the journey to becoming a CPA is easy--but with Intermediate Accounting DeMYSTiFieD as your travel companion, you're guaranteed a smooth ride. An easy-to-use self-teaching guide that reviews and expands upon core Generally Accepted Accounting Principles (GAAP), Intermediate Accounting DeMYSTiFieD covers everything you need to ace your exams and take a big step toward the career of your dreams. The book provides a fresh review of all the basics, so you can easily glide into more advanced principles. You'll learn how to generate accurate and reliable financial statements, maintain proper internal controls within a company, and locate international accounting standards. This fast and easy guide offers: Tactics for maintaining solid internal controls within a business Strategies for creating accurate financial statements Techniques for overcoming common accounting errors Quizzes and a final exam for gauging what you've learned Tips and examples for mastering more advanced accounting theories Simple enough for a novice but challenging enough for a veteran CPA, Intermediate Accounting DeMYSTiFieD is a shortcut to decoding key accounting concepts and principles.