Sign in  |  Register
Advanced search
Publication Cover

CITATION

Oppel, Andy. Databases DeMYSTiFieD, 2nd Edition. US: McGraw-Hill Osborne Media, 2010.

Databases DeMYSTiFieD, 2nd Edition

Authors: Andy Oppel

Published:  November 2010

eISBN: 9780071748001 0071748008 | ISBN: 9780071747998
Open eBook
  • Contents
  • Acknowledgments
  • Introduction
  • Chapter 1 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?
  • Summary
  • Chapter 2 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
  • Summary
  • Chapter 3 Forms-Based Database Queries
  • QBE: The Roots of Forms-Based Queries
  • Getting Started in Microsoft Access
  • Getting Started with the Video Store Sample Database
  • Exploring Microsoft Access
  • The Microsoft Access Relationships Panel
  • The Microsoft Access Table Design View
  • Creating Queries in Microsoft Access
  • Example 3-1: List All Movies
  • Example 3-2: Choose Columns to Display
  • Example 3-3: Sorting Results
  • Example 3-4: Advanced Sorting
  • Example 3-5: Choosing Rows to Display
  • Example 3-6: Compound Row Selection
  • Example 3-7: Using Not Equal To
  • Example 3-8: Joining Tables
  • Example 3-9: Limiting Join Results
  • Example 3-10: Outer Joins
  • Example 3-11: Microsoft Access SQL
  • Example 3-12: Multiple Joins and Calculated Columns
  • Example 3-13: Aggregate Functions
  • Example 3-14: Self-Joins
  • Summary
  • Chapter 4 Introduction to SQL
  • The History of SQL
  • Getting Started with MySQL
  • Where’s the Data?
  • Finding Database Objects Using Catalog Views
  • Viewing Database Objects Using Toad for MySQL
  • Data Query Language (DQL): The Select Statement
  • Example 4-1: Listing Everything in a Table
  • Example 4-2: Limiting Columns to Display
  • Example 4-3: 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
  • Summary
  • Chapter 5 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)
  • Agile Software Development
  • Summary
  • Chapter 6 Logical Database Design Using Normalization
  • Overview of 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
  • Summary
  • Chapter 7 Data and Process Modeling
  • Entity Relationship Modeling
  • ERD Formats
  • Supertypes and Subtypes
  • Guidelines for Drawing ERDs
  • Process Models
  • The Flowchart
  • The Function Hierarchy Diagram
  • The Swim Lane Diagram
  • The Data Flow Diagram
  • Process Modeling with UML
  • Relating Entities and Processes
  • Summary
  • Chapter 8 Physical Database Design
  • Designing Tables
  • Implementing Supertypes 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
  • Summary
  • Chapter 9 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
  • Summary
  • Chapter 10 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
  • Summary
  • Chapter 11 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
  • Summary
  • Chapter 12 Databases for Online Analytical Processing
  • Data Warehouses
  • Data Warehouse Architecture
  • Data Marts
  • Data Mining
  • Summary
  • Chapter 13 Integrating XML Documents and Objects into Databases
  • The Basics of XML
  • SQL/XML
  • The XML Data Type
  • SQL/XML Functions
  • Object-Oriented Applications
  • Object-Oriented Programming
  • Object-Oriented Languages
  • Object Persistence
  • Object-Relational Databases
  • Summary
  • Final Exam
  • Answers to Quizzes and Final Exam
  • Appendix: Video Store Sample Database
  • Index