Databases Demystified

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.

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.

There’s no easier, faster, or more practical way to learn the really tough subjects SQL Demystified explains how to use SQL (Structured Query Language)--the ubiquitous programming language for databases. Readers will learn to create database objects, add and retrieve data from a database, and modify existing data. This self-teaching guide comes complete with key points, background information, quizzes at the end of each chapter, and even a final exam. Simple enough for beginners but challenging enough for advanced students, this is a lively and entertaining brush-up, introductory text, or classroom supplement.

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.

The fast and easy way to learn signals and systems Get a working knowledge of signal processing and systems--even if you don't have formal training, unlimited time, or a genius IQ. Signals and Systems Demystified offers an effective, illuminating, and entertaining way to learn this essential electrical engineering subject. First, you'll learn methods used to calculate energy and power in signals. Next, you'll study signals in the frequency domain using Fourier analysis. Other topics covered include amplitude, frequency, and phase modulation, spectral analysis, convolution, the Laplace transform, and the z-transform. Packed with hundreds of sample equations and explained solutions, and featuring end-of-chapter quizzes and a final exam, this book will teach you the fundamentals of signals and systems in no time at all. Simple enough for a beginner, but challenging enough for an advanced student, Signals and Systems Demystified is your shortcut to mastering this complex subject. This hands-on, self-teaching text offers: An easy way to understand signal processing and systems Hundreds of worked examples with solutions A quiz at the end of each chapter to reinforce learning and pinpoint weaknesses A final exam at the end of the book No unnecessary technical jargon A time-saving approach to performing better on an exam or at work!

Learn BIOCHEMISTRY without stressing out your brain CELLS Trying to understand the chemical processes of living organisms but having trouble metabolizing the complex concepts? Here's your lifeline! Biochemistry Demystified helps synthesize your understanding of this important topic. You'll start with a review of basic chemical concepts and a look at cell structures and cell division. Next, you'll study carbohydrates, lipids, proteins, nucleic acids, nucleotides, and enzymes. Glycolysis, the citric acid cycle, oxidative phosphorylation, and the control of chemical processes round out the coverage. Hundreds of examples and illustrations make it easy to understand the material, and end-of-chapter questions and a final exam help reinforce learning. This fast and easy guide offers: Numerous figures to illustrate key concepts Details on DNA and RNA Coverage of hormones and neurotransmitters A chapter on analytical techniques and bioinformatics A time-saving approach to performing better on an exam or at work Simple enough for a beginner, but challenging enough for an advanced student, Biochemistry Demystified is your key to mastering this vital life sciences subject.

Need to learn MATHEMATICA? Problem SOLVED! Take full advantage of all the powerful capabilities of Mathematica with help from this hands-on guide. Filled with examples and step-by-step explanations, Mathematica Demystified takes you from your very first calculation all the way to plotting complex fractals. Using an intuitive format, this book explains the fundamentals of Mathematica up front. Learn how to define functions, create 2-D graphs of functions, write basic programs, and use modules. You'll move on to 3-D graphics, calculus, polynomial, linear, and differential equations, dynamical systems, and fractals. Hundreds of examples with concise explanations make it easy to understand the material, and end-of-chapter quizzes and a final exam help reinforce learning. This self-teaching guide offers: A quick way to get up and running on Mathematica Coverage of Mathematica 6 and 7 Tips for avoiding and correcting syntax errors Details on creating slideshow presentations of your work No unnecessary technical jargon A time-saving approach to performing better on an exam or at work! Simple enough for a beginner, but challenging enough for an advanced user, Mathematica Demystified is your shortcut to mastering this fully integrated technical computing software.

This step-by-step approach to untangling the complexities of ethics from the bestselling ... Demystified brand is a trusted companion to a college (346,000 students annually) course or as a self-teaching guide for readers studying on their own. About the Book This easy-to-use guide from the popular Demystified series makes learning about ethics simple by walking readers step-by-step through the fundamentals of the subject. Each chapter concludes with a self-test that allows readers to track their progress, and a comprehensive final exam at the end of the book gives instant feedback on new knowledge. Ethics Demystified lets readers to work at their own pace and provides them with the essentials of the subject. Readers will learn: The important concepts of ethical theory How to untangle moral dilemmas and questions of right conduct Metaethics and how to understand ethical facts and judgments How to define a “right action” with normative ethics Applied ethics—from civil liberties and capital punishment to euthanasia and affirmative action The role business ethics play in today’s corporate world Following the easy-to-use format of the books in the bestselling ... Demystified series, Ethics Demystified helps you truly comprehend this challenging subject a without overwhelming you with complexities or mystifying jargon. Bestselling series: Since its launch in 2002, the 100+ books in the Demystified series have sold more than 1.6 million units for more than $14 million in revenue. Unique features: Readers work at their own pace, and hands-on self tests and a “final exam” lets readers gauge their progress to ensure that they stay on track. Large audience: In 2006, 368,000 college students studied ethics. Current topic: Business ethics are becoming an important part of MBA programs. Step-by-step, self-teaching approach lets readers build ethics knowledge at their own pace. Chapter-ending quizzes, part-ending tests, and a final exam give readers instant feedback on their understanding of the topic. Ethics Demystified is an excellent self-teaching guide for: Undergraduate-level ethics and philosophy students (368,000 annual enrollment) Independent readers who want to build a solid foundation in ethics in their spare time