You are previewing Absolute Beginner’s Guide to Databases.
O'Reilly logo
Absolute Beginner’s Guide to Databases

Book Description

Absolute Beginner's Guide to Databases brings the elements of a database together using easy to understand language, perfect for the true beginner. It not only gives specific hands on practice, but also provides an overview of designing, maintaining and using a database. This book covers what databases are used for, why databases are important, why the design of the database is important, database normalization, keys to solid database design, differences in types of databases, and indexes--what they are, how we use them, and why they are important.

Table of Contents

  1. Copyright
  2. About the Author
  3. Acknowledgments
  4. Tell Us What You Think!
  5. Introduction
  6. Database Basics
    1. An Introduction to Databases
      1. What Is a Database?
      2. How Databases Are Used
      3. Typical Database Management Systems Used Today
      4. Key Database Terminology
      5. The Relational Database Model: An Overview
      6. Database-Related Careers
      7. What You Have Learned
    2. The Anatomy of a Real Database
      1. An Introduction to Microsoft Access
      2. The Sample Northwind Traders Database
      3. What You Have Learned
  7. Designing and Building Your First Database
    1. An Introduction to Database Design
      1. Your Project: A Time Entry and Billing Database
      2. Determine the Requirements of the Database
      3. Introduction to Database Modeling
      4. Model the Time Entry and Billing Database
      5. What You Have Learned
    2. Database Design Continued: An Introduction to Normalization
      1. What Does It Mean to Normalize a Database?
      2. Steps to Normalize Your Data Model
      3. Denormalize Data—When Does It Make Sense to Break the Rules?
      4. Normalization Applied—Review the TEB Database and Refine the Design
      5. What You Have Learned
    3. Using Access to Build the Time Entry and Billing Database
      1. Automatically Generate the Database from the TEB Model
      2. A Brief Review of the Access Database Designer
      3. Use the Design to Create the Time Entry and Billing Database
      4. What You Have Learned
  8. Maintaining Your Database—An Introduction to Database Integrity
    1. Maintaining Integrity Through Data Validation Rules
      1. An Overview of How Validation Rules Work in Databases
      2. Implement Field-Level Rules
      3. Implement Row-Level Rules
      4. What You Have Learned
    2. The Basics of Referential Integrity
      1. What Is Referential Integrity?
      2. Why Maintaining Referential Integrity Is Important
      3. How Referential Integrity Works
      4. What You Have Learned
  9. Using Your Database to Provide Information—An Introduction to SQL
    1. SQL Basics
      1. SQL Overview
      2. Select Statement
      3. Filter Results I: Use the Where Clause
      4. Organize Output I: Use the Order By Clause
      5. Combine Multiple Tables: Use the Join Statement
      6. Combine Multiple Resultsets: Use the Union Clause
      7. What You Have Learned
    2. SQL—Going Beyond the Basics
      1. Organize Output II: Use the Group By Clause
      2. Use Aggregate Functions
      3. Filter Results II: Use the Having Clause
      4. Filter Results III: Create Parameterized SQL Statements
      5. Modify Data with the Insert, Update, and Delete Statements
      6. What You Have Learned
    3. Making SQL Queries a Part of Your Database
      1. An Overview of the Access Query Designer
      2. Create Advanced Queries
      3. What You Have Learned
  10. Putting Your Database to Work—Building a Simple Access Database Application
    1. Building the User Interface Components
      1. Overview of the Access Form Designer
      2. Create Forms for the TEB Application
      3. Create a Main Menu Form
      4. What You Have Learned
    2. Providing Useful Output: An Introduction to Creating and Designing Reports
      1. Overview of the Access Report Designer
      2. Create Reports for the TEB Application
      3. Add Report Items to the Main Menu Form
      4. What You Have Learned
  11. The Structure of the TEB Database
    1. Case
    2. Client
    3. ClientCase
    4. Contact
    5. Court
    6. Department
    7. Employee
    8. EmployeeCase
    9. EmployeeClass
    10. Invoice
    11. Judge
    12. TimeEntryDetail
    13. WorkCategory
  12. TEB Referential Integrity Rules
    1. Case (PK: caseid)
    2. Client (PK: clientid)
    3. Court (PK: CourtID)
    4. Department (PK: departmentid)
    5. Employee (PK: employeeid)
    6. EmployeeClass
    7. Invoice (PK: InvoiceID)
  13. Glossary
  14. Database-Oriented Periodicals
  15. Web-Based Resources
  16. Index