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.
Table of contents
1: Database Fundamentals
2: Exploring Relational Database Components
3: Forms-Based Database Queries
4: Introduction to SQL
5: The Database Life Cycle
6: Logical Database Design Using Normalization
7: Data and Process Modeling
8: Physical Database Design
9: Connecting Databases to the Outside World
10: Database Security
11: Database Implementation
12: Databases for Online Analytical Processing
A: Final Exam
B: Answers to Quizzes and Final Exam
Back cover copy
The fast and easy way to understanding the fundamentals of databases
If you’re tired of wading through huge technical manuals that drown you in jargon, making it difficult to decipher database fundamentals, help has finally arrived. Databases Demystified is user-friendly, engaging, easy to follow, and designed for the non-expert wanting to quickly learn the ins and outs of databases and immediately apply concepts learned.
Its step-by-step approach and detailed explanations of database design make this a comprehensive resource covering all the tools you need to build and manage your database. Learn how to form database queries using Microsoft Access and SQL, explore methods for connecting a database to applications, and discover how to store your historical data for analyses. From logical data design using normalization to database security and data warehousing, Databases Demystified gets your database up and running in no time.
Simple enough for a beginner, but challenging enough for an advanced student, Databases Demystified is your shortcut to mastering databases.