Databases Demystified 2nd Edition

Including detailed examples and concise explanations to aid in understanding; along with end-of-chapter quizzes and a final exam to help reinforce learning; this book covers the latest database technologies and techniques; and gives you the hands-on help you need to get started. --

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.

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.

Through clear language, step-by-step discussions, and quizzes at the end of each chapter, the author makes databases easy. Quickly learn the core skills needed to design, configure, manage, and manipulate databases, whether at work or at home. Topics such as exploring different database models, planning their design, minimizing redundant data, designing tables, applying database design concepts, and implementing database security are covered. This is that fast, easy-to-understand tutorial that you’ve been looking for.

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.

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.

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.

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.