Skip to content

Databases Demystified

Spend $50 to get a free DVD!

ISBN-10: 0072253649

ISBN-13: 9780072253641

Edition: 2004

Authors: Andrew J. Oppel

List price: $21.95
Blue ribbon 30 day, 100% satisfaction guarantee!
Out of stock
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Designed for users without formal training, extra time, or genius IQs, this book offers an easy-to-absorb teaching style for students to understand databases.
Customers also bought

Book details

List price: $21.95
Copyright year: 2004
Publisher: McGraw-Hill Osborne
Publication date: 2/27/2004
Binding: Paperback
Pages: 360
Size: 7.25" wide x 9.00" long x 0.75" tall
Weight: 1.298
Language: English

Andrew J. (Andy) Oppel has designed and implemented hundreds of databases for a wide range of applications. He is the author of Databases Demystified and SQL Demystified .Robert Sheldon is a consultant and technical writer. He has designed and implemented various Access and SQL Server databases

Database Fundamentals
Properties of a Database
The Database Management System (DBMS)
Layers of Data Abstraction
Physical Data Independence
Logical Data Independence
Prevalent Database Models
Flat Files
The Hierarchical Model
The Network Model
The Relational Model
The Object-Oriented Model
The Object-Relational Model
A Brief History of Databases
Why Focus on Relational?
Exploring Relational Database Components
Conceptual Database Design Components
Business Rules
Logical/Physical Database Design Components
Columns and Data Types
Integrity Constraints
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
List All Customers
Choosing Columns to Display
Sorting Results
Advanced Sorting
Choosing Rows to Display
Compound Row Selection
Using Not Equal
Joining Tables
Limiting Join Results
Outer Joins
Multiple Joins; Calculated Columns
Aggregate Functions
Introduction to SQL
The History of SQL
Getting Started with Oracle SQL
Where's the Data?
Finding Database Objects Using Catalog Views
Viewing Database Objects Using Oracle Enterprise Manager
Data Query Language (DQL): The SELECT Statement
Listing All Employees
Limiting Columns to Display
Sorting Results
Choosing Rows to Display
Joining Tables
Aggregate Functions
Data Manipulation Language (DML)
Transaction Support (COMMIT and ROLLBACK)
The INSERT Statement
The UPDATE Statement
The DELETE Statement
Data Definition Language (DDL) Statements
The CREATE TABLE Statement
The ALTER TABLE Statement
The CREATE VIEW Statement
The CREATE INDEX Statement
The DROP Statement
Data Control Language (DCL) Statements
The GRANT Statement
The REVOKE Statement
The Database Life Cycle
The Traditional Method
Requirements Gathering
Conceptual Design
Logical Design
Physical Design
Implementation and Rollout
Ongoing Support
Nontraditional Methods
Rapid Application Development (RAD)
Logical Database Design Using Normalization
The Need for Normalization
Insert Anomaly
Delete Anomaly
Update Anomaly
Applying the Normalization Process
Choosing a Primary Key
First Normal Form: Eliminating Repeating Data
Second Normal Form: Eliminating Partial Dependencies
Third Normal Form: Eliminating Transitive Dependencies
Beyond Third Normal Form
Practice Problems
TLA University Academic Tracking
Computer Books Company
Data and Process Modeling
Entity Relationship Modeling
ERD Formats
Super Types and Subtypes
Guidelines for Drawing ERDs
Process Models
The Flowchart
The Function Hierarchy Diagram
The Swim Lane Diagram
The Data Flow Diagram
Relating Entities and Processes
Physical Database Design
Designing Tables
Implementing Super Types and Subtypes
Naming Conventions
Integrating Business Rules and Data Integrity
NOT NULL Constraints
Primary Key Constraints
Referential (Foreign Key) Constraints
Unique Constraints
Check Constraints
Data Types, Precision, and Scale
Designing Views
Adding Indexes for Performance
Connecting Databases to the Outside World
Deployment Models
Centralized Model
Distributed Model
Client/Server Model
Connecting Databases to the Web
Introduction to the Internet and the Web
Components of the Web "Technology Stack"
Invoking Transactions from Web Pages
Connecting Databases to Applications
Connecting Databases via ODBC
Connecting Databases to Java Applications
Database Security
Why Is Security Necessary?
Database Server Security
Physical Security
Network Security
System-Level Security
Database Client and Application Security
Login Credentials
Data Encryption
Other Client Considerations
Database Access Security
Database Security Architectures
Schema Owner Accounts
System Privileges
Object Privileges
Security Monitoring and Auditing
Database Implementation
Cursor Processing
Transaction Management
What Is a Transaction?
DBMS Support for Transactions
Locking and Transaction Deadlock
Performance Tuning
Tuning Database Queries
Tuning DML Statements
Change Control
Databases for Online Analytical Processing
Data Warehouses
OLTP Systems Compared with Data Warehouse Systems
Data Warehouse Architecture
Data Marts
Data Mining
Final Exam
Answers to Quizzes and Final Exam
Chapter 1
Chapter 2
Chapter 3
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Chapter 8
Chapter 9
Chapter 10
Chapter 11
Chapter 12