Databases A Beginner's Guide | Beginner's Guide

Databases A Beginner's Guide

Authors: Andy Oppel

Published: March 2009

eISBN: 9780071608473 0071608478 | ISBN: 9780071608466

Contents

Acknowledgments

Introduction

Part I: Database Concepts

1 Database Fundamentals

Properties of a Database

Prevalent Database Models

A Brief History of Databases

Why Focus on Relational?

2 Exploring Relational Database Components

Conceptual Database Design Components

Try This 2-1: Exploring the Northwind Database

Logical/Physical Database Design Components

3 Forms-based Database Queries

QBE: The Roots of Forms-based Queries

Getting Started in Microsoft Access

The Microsoft Access Relationships Panel

The Microsoft Access Table Design View

Creating Queries in Microsoft Access

Try This 3-1: List All Customers

Try This 3-2: Choose Columns to Display

Try This 3-3: Sorting Results

Try This 3-4: Advanced Sorting

Try This 3-5: Choosing Rows to Display

Try This 3-6: Compound Row Selection

Try This 3-7: Using Not Equal

Try This 3-8: Joining Tables

Try This 3-9: Limiting Join Results

Try This 3-10: Outer Joins

Try This 3-11: Microsoft Access SQL

Try This 3-12: Multiple Joins and Calculated Columns

Try This 3-13: Aggregate Functions

Try This 3-14: Self-Joins

4 Introduction to SQL

A Brief History of SQL

Getting Started with Oracle SQL

Try This 4-1: Unlock the HR Account and Log in as HR

Where’s the Data?

Try This 4-2 Using the Application Express Object Browser

Data Query Language (DQL): The SELECT Statement

Data Manipulation Language (DML)

Data Definition Language (DDL) Statements

Data Control Language (DCL) Statements

Part II: Database Development

5 The Database Life Cycle

The Traditional Life Cycle

Nontraditional Life Cycles

The Project Triangle

Try This 5-1: Project Database Management Tasks

6 Database Design Using Normalization

The Need for Normalization

Applying the Normalization Process

Denormalization

Try This 6-1: UTLA Academic Tracking

Practice Problems

Try This 6-2: Computer Books Company

7 Data and Process Modeling

Entity Relationship Modeling

Process Models

Relating Entities and Processes

Try This 7-1: Draw an ERD in Information Engineering (IE) Format

8 Physical Database Design

Designing Tables

Integrating Business Rules and Data Integrity

Designing Views

Adding Indexes for Performance

Try This 8-1: Mapping a Logical Model to a Physical Database Design

Part III: Database Implementation

9 Connecting Databases to the Outside World

Deployment Models

Connecting Databases to the Web

Connecting Databases to Applications

Try This 9-1: Exploring the World Wide Web

10 Database Security

Why Is Security Necessary?

Database Server Security

Database Client and Application Security

Database Access Security

Security Monitoring and Auditing

Try This 10-1: Database Object Privileges

11 Deploying Databases

Cursor Processing

Transaction Management

Try This 11-1: SQL Transaction Support

Performance Tuning

Change Control

12 Databases for Online Analytical Processing

Data Warehouses

Data Marts

Data Mining

Try This 12-1: Design Star Schema Fact and Dimension Tables

13 Integrating XML Documents and Objects into Databases

Learn the Basics of XML

Learn About SQL/XML

Try This 13-1: Using SQL/XML Functions

Object-Oriented Applications

Object-Relational Databases

Part IV: Appendices

A: Answers to Self Tests

Chapter 1: Database Fundamentals

Chapter 2: Exploring Relational Database Components

Chapter 3: Forms-based Database Queries

Chapter 4: Introduction to SQL

Chapter 5: The Database Life Cycle

Chapter 6: Database Design Using Normalization

Chapter 7: Data and Process Modeling

Chapter 8: Physical Database Design

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

B: Solutions to the Try This Exercises

Try This 5-1 Solution: Project Database Management Tasks

Try This 6-1 Solution: UTLA Academic Tracking

Try This 6-2 Solution: Computer Books Company

Try This 7-1 Solution: Draw an ERD in Information Engineering (IE) Format

Try This 8-1 Solution: Mapping a Logical Model to a Physical Database Design

Try This 10-1 Solution: Database Object Privileges

Try This 11-1 Solution: SQL Transaction Support

Try This 12-1 Solution: Design Star Schema Fact and Dimension Tables

Try This 13-1 Solution: Using SQL/XML Functions

Index