Databases Demystified: A Self-Teaching Guide
  • Alternative view 1 of Databases Demystified: A Self-Teaching Guide
  • Alternative view 2 of Databases Demystified: A Self-Teaching Guide

Databases Demystified: A Self-Teaching Guide

by Andrew Oppel
     
 

ISBN-10: 0072253649

ISBN-13: 9780072253641

Pub. Date: 02/27/2004

Publisher: McGraw-Hill Companies, The

The fast and easy way to understanding the fundamentals of databases

If you’re tired of wading through huge technical manuals that drown you in jargon, making it difficult to decipher database fundamentals, help has finally arrived. Databases Demystified is user-friendly, engaging, easy to follow, and designed for the non-expert wanting to quickly learn the

Overview

The fast and easy way to understanding the fundamentals of databases

If you’re tired of wading through huge technical manuals that drown you in jargon, making it difficult to decipher database fundamentals, help has finally arrived. Databases Demystified is user-friendly, engaging, easy to follow, and designed for the non-expert wanting to quickly learn the ins and outs of databases and immediately apply concepts learned.

Its step-by-step approach and detailed explanations of database design make this a comprehensive resource covering all the tools you need to build and manage your database. Learn how to form database queries using Microsoft Access and SQL, explore methods for connecting a database to applications, and discover how to store your historical data for analyses. From logical data design using normalization to database security and data warehousing, Databases Demystified gets your database up and running in no time.

Simple enough for a beginner, but challenging enough for an advanced student, Databases Demystified is your shortcut to mastering databases.

This one-of-a kind self-teaching text offers:

  • An easy way to understand databases
  • A quiz at the end of each chapter
  • A final exam at the end of the book
  • No unnecessary technical jargon
  • A time-saving approach

Product Details

ISBN-13:
9780072253641
Publisher:
McGraw-Hill Companies, The
Publication date:
02/27/2004
Series:
Demystified Series
Pages:
360
Product dimensions:
7.40(w) x 9.20(h) x 0.71(d)

Table of Contents

Acknowledgmentsxvii
Introductionxix
Chapter 1Database Fundamentals1
Properties of a Database1
The Database Management System (DBMS)2
Layers of Data Abstraction3
Physical Data Independence5
Logical Data Independence6
Prevalent Database Models7
Flat Files7
The Hierarchical Model9
The Network Model11
The Relational Model13
The Object-Oriented Model15
The Object-Relational Model16
A Brief History of Databases17
Why Focus on Relational?19
Quiz20
Chapter 2Exploring Relational Database Components25
Conceptual Database Design Components26
Entities27
Attributes27
Relationships28
Business Rules32
Logical/Physical Database Design Components33
Tables33
Columns and Data Types34
Constraints37
Integrity Constraints42
Views45
Quiz46
Chapter 3Forms-Based Database Queries51
QBE: The Roots of Forms-Based Queries52
Getting Started in Microsoft Access52
The Microsoft Access Relationships Panel55
The Microsoft Access Table Design View57
Creating Queries in Microsoft Access59
Example 3-1List All Customers62
Example 3-2Choosing Columns to Display63
Example 3-3Sorting Results64
Example 3-4Advanced Sorting66
Example 3-5Choosing Rows to Display66
Example 3-6Compound Row Selection68
Example 3-7Using Not Equal70
Example 3-8Joining Tables70
Example 3-9Limiting Join Results72
Example 3-10Outer Joins75
Example 3-11Multiple Joins; Calculated Columns77
Example 3-12Aggregate Functions80
Example 3-13Self-Joins82
Quiz85
Chapter 4Introduction to SQL89
The History of SQL90
Getting Started with Oracle SQL91
Where's the Data?96
Finding Database Objects Using Catalog Views97
Viewing Database Objects Using Oracle Enterprise Manager98
Data Query Language (DQL): The SELECT Statement100
Example 4-1Listing All Employees100
Example 4-2Limiting Columns to Display100
Example 4-3Sorting Results102
Choosing Rows to Display103
Joining Tables108
Aggregate Functions112
Data Manipulation Language (DML)114
Transaction Support (COMMIT and ROLLBACK)114
The INSERT Statement115
The UPDATE Statement116
The DELETE Statement117
Data Definition Language (DDL) Statements118
The CREATE TABLE Statement118
The ALTER TABLE Statement119
The CREATE VIEW Statement121
The CREATE INDEX Statement121
The DROP Statement122
Data Control Language (DCL) Statements122
The GRANT Statement123
The REVOKE Statement123
Quiz124
Chapter 5The Database Life Cycle129
The Traditional Method130
Planning130
Requirements Gathering132
Conceptual Design135
Logical Design136
Physical Design136
Construction137
Implementation and Rollout138
Ongoing Support138
Nontraditional Methods139
Prototyping139
Rapid Application Development (RAD)140
Quiz141
Chapter 6Logical Database Design Using Normalization145
The Need for Normalization147
Insert Anomaly148
Delete Anomaly148
Update Anomaly148
Applying the Normalization Process148
Choosing a Primary Key151
First Normal Form: Eliminating Repeating Data153
Second Normal Form: Eliminating Partial Dependencies156
Third Normal Form: Eliminating Transitive Dependencies158
Beyond Third Normal Form160
Denormalization163
Practice Problems164
TLA University Academic Tracking164
Computer Books Company170
Quiz174
Chapter 7Data and Process Modeling179
Entity Relationship Modeling180
ERD Formats180
Super Types and Subtypes184
Guidelines for Drawing ERDs188
Process Models189
The Flowchart190
The Function Hierarchy Diagram192
The Swim Lane Diagram193
The Data Flow Diagram194
Relating Entities and Processes196
Quiz198
Chapter 8Physical Database Design203
Designing Tables204
Implementing Super Types and Subtypes208
Naming Conventions211
Integrating Business Rules and Data Integrity214
NOT NULL Constraints216
Primary Key Constraints216
Referential (Foreign Key) Constraints216
Unique Constraints217
Check Constraints218
Data Types, Precision, and Scale218
Triggers219
Designing Views220
Adding Indexes for Performance221
Quiz222
Chapter 9Connecting Databases to the Outside World227
Deployment Models228
Centralized Model228
Distributed Model229
Client/Server Model231
Connecting Databases to the Web235
Introduction to the Internet and the Web236
Components of the Web "Technology Stack"238
Invoking Transactions from Web Pages239
Connecting Databases to Applications240
Connecting Databases via ODBC240
Connecting Databases to Java Applications241
Quiz242
Chapter 10Database Security247
Why Is Security Necessary?247
Database Server Security249
Physical Security249
Network Security250
System-Level Security255
Database Client and Application Security255
Login Credentials256
Data Encryption256
Other Client Considerations257
Database Access Security258
Database Security Architectures259
Schema Owner Accounts263
System Privileges264
Object Privileges265
Roles265
Views266
Security Monitoring and Auditing267
Quiz268
Chapter 11Database Implementation273
Cursor Processing273
Transaction Management276
What Is a Transaction?276
DBMS Support for Transactions276
Locking and Transaction Deadlock278
Performance Tuning283
Tuning Database Queries284
Tuning DML Statements286
Change Control287
Quiz288
Chapter 12Databases for Online Analytical Processing293
Data Warehouses294
OLTP Systems Compared with Data Warehouse Systems295
Data Warehouse Architecture296
Data Marts301
Data Mining302
Quiz303
Final Exam307
Answers to Quizzes and Final Exam325
Chapter 1325
Chapter 2325
Chapter 3326
Chapter 4326
Chapter 5326
Chapter 6326
Chapter 7326
Chapter 8327
Chapter 9327
Chapter 10327
Chapter 11327
Chapter 12327
Index329

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >