Introduction to Databases
o Introduction to Databases
o What Is a Database?
o File-Based Databases
o The Evolution of Databases
o Relational Databases and Database
o Management Systems (DBMSs)
o Origins of Relational Databases
Relational Database Fundamentals
o Introduction to Relational Databases
o Multitier Database Architecture
o Relational Model Terminology
o Using Tables to Represent Data
o Characteristics of Relations
o Data Models
o Entities and Data Relationships
o Relational Integrity
o Database Languages
o Data Dictionaries
Database Planning
o Introduction to Database Planning
o Database Design Life Cycle
o Database Requirements Document
o ProAudio Case Study
o Selecting a DBMS
o Selecting an Application Interface
Overview of Database Design Methodology
o Introduction to Database Design
o Methodology
o Effects of Poor Database Design
o Practices
o Database Design Phases
o Conceptual Database Design
o Entity-Relationship (ER) Models
Normalization
o Introduction to Normalization
o What Is Normalization?
o Normal Forms
o First Normal Form
o Second Normal Form
o Third Normal Form
o Boyce-Codd Normal Form (BCNF
Logical Database Design
o Introduction to Logical Database
o Design
o Logical Database Design
o Creating a Logical Data Model
o Using a Database Definition
o Language
o Validating the Logical Data Model
o Defining Integrity Constraints
o Creating an Enterprise Data Model
Physical Database Design
o Introduction to Physical Database
o Design
o Physical Database Design
o MySQL Query Browser
o Creating Enterprise Constraints
o Using Secondary Indexes
o Denormalization
o Creating User Views
o Designing Database Access Rules
Structured Query Language
o Introduction to Structured Query
o Language
o SQL Basics
o Data Definition Language
o Data Manipulation Language
o Retrieving Data from Relations
o Data Control Language
Relational Algebra
o Introduction to Relational Algebra
o Defining Relational Algebra
o Selection
o Projection
o Cartesian Product
o Union
o Difference
o Intersection
o Joins
Transactions and Database Security
o Introduction to Database
o Transactions and Security
o Transactions
o Concurrency Control
o Database Security
