Databases Demystified

ISBN-10: 0072253649

ISBN-13: 9780072253641

Edition: 2004

Authors: Andrew J. Oppel

List price: $21.95
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description:

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.
eBooks Starting from $21.95
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99
Customers also bought
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

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

Acknowledgments
Introduction
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?
Quiz
Exploring Relational Database Components
Conceptual Database Design Components
Entities
Attributes
Relationships
Business Rules
Logical/Physical Database Design Components
Tables
Columns and Data Types
Constraints
Integrity Constraints
Views
Quiz
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
Self-Joins
Quiz
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
Quiz
The Database Life Cycle
The Traditional Method
Planning
Requirements Gathering
Conceptual Design
Logical Design
Physical Design
Construction
Implementation and Rollout
Ongoing Support
Nontraditional Methods
Prototyping
Rapid Application Development (RAD)
Quiz
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
Denormalization
Practice Problems
TLA University Academic Tracking
Computer Books Company
Quiz
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
Quiz
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
Triggers
Designing Views
Adding Indexes for Performance
Quiz
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
Quiz
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
Roles
Views
Security Monitoring and Auditing
Quiz
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
Quiz
Databases for Online Analytical Processing
Data Warehouses
OLTP Systems Compared with Data Warehouse Systems
Data Warehouse Architecture
Data Marts
Data Mining
Quiz
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
Index
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×