Offers a technique for learning how to design, implement, maintain, and use databases. With a focus on proper database design, this book provides an introduction to Structured Query Language (SQL) and Microsoft Access. It covers topics such as security, data warehouse and data mart design techniques, and storing complex data such as XML documents.
This title offers the easiest way to learn essential database skills. Written by a database technology instructor and bestselling author, this book offers a proven, self-paced technique for learning how to design, implement, maintain, and use databases. You can follow clear examples and step-by-step instructions that cover the fundamental concepts and demonstrate how to effectively apply them. With a focus on proper database design, "Databases: A Beginner's Guide" provides an introduction to Structured Query Language (SQL) and Microsoft Access. The book covers key topics such as security, data warehouse and data mart design techniques, storing complex data such as XML documents, and connecting databases to applications.
Acknowledgments Introduction Part I: Database Concepts Chapter 1. Database Fundamentals Chapter 2. Exploring Relational Database Components Chapter 3. Form-based Database Queries Chapter 4. Introduction to SQL Part II: Database Development Chapter 5. The Database Life Cycle Chapter 6. Database Design Using Normalization Chapter 7. Data and Process Modeling Chapter 8. Physical Database Design Part III: Database Implementation Chapter 9. Connecting Databases to the Outside World Chapter 10. Database Security Chapter 11. Deploying Databases Chapter 12. Databases for Online Analytical Processing Chapter 13. Integrating XML Documents and Objects into Databases Part IV: Appendices Appendix A. Answers to Self Tests Appendix B. Solutions to the Try This Exercises Index