Session 1
Section A: Introduction to Databases
• Overview
• Flat File Database
• Relational Databases
• RDBMS Benefits
• RDBMS
• RDBMS Disadvantages
Section B: Relational Databases
• Application Components
• Two and Three Tier
• Terminology and Entities
• Primary Key
• Data Model
• Design Language
• Strong and Weak Entities
• Relationships
Section C: Database Planning
• DB Design Life Cycle
• Requirements Document
• The Interviews
• Choosing a DBMS
• Application Interface
Section D: DB Design Methodology
• Design Problems
• Design Phases
• Conceptual Design
• Sample Data Types
• Model
• Design Steps
• Identify Relationships
Section E: DB Design Methodology (cont.)
• Candidate/Primary Keys
• Entity-Relationship Model
• Information Engineering
• Strong and Weak Entities
• Relationships
• Information Engineers
• Chen Data Model
Section F: Database Normalization
• Overview
• Normal Forms
• First Normal Form Rules
• Primary Key
• First Normal Form
Section G: Database Normalization (cont.)
• Second Normal Form
• 2NF Rules
• Functional Dependencies
• Third Normal Form
• Boyce-Codd Normal Form
• Data Normalization
Session 2
Section A: Logical Database Design
• Identify Relationships
• M:N Relationships
• Complex Relationships
• Recursive Relationships
• Relationship Attributes
• Redundant Relationships
Section B: Creating a Logical Model
• DDL
• Validate Logical Model
• Data Integrity
• Referential Integrity
• Foreign Key Constraints
• Insert, Update, Delete
• Enterprise Data Model
Section C: Physical Database Design
• Using a DDL
• Create Table Code
• Create Table
• Enterprise Constraints
• Multiple Constraints
• Constraints and Updates
Section D: Physical Database Design (cont.)
• Foreign Key Constraints
• Secondary Indexes
• Denormalization
• Nonkey Attributes
• Foreign Keys
• Aggregation
• User and Employee View
• Access Rules
Section E: Introduction to SQL
• Overview
• SQL Subsets
• SQL-supported Data Types
Session 3
Section A: SQL
• Overview
• Schema
• Alter and Drop
• Insert
• Delete
• Update
• Select
Section B: Select Statement Modifiers
• Select From
• Select Distinct
• Where Clause & Operators
• Between
• Or, Not, Like, & Wildcards
• Brackets
• Order By
• Grant and Revoke
Section C: Relational Algebra
• Overview
• Selection and Projection
• Cartesian Product
• Union
• Difference
• Intersection
Section D: Relational Algebra (cont.)
• Theta Join and Equijoin
• Natural and Outer Join
• Database Diagram
• Inner Join
• Distinct and Join
• Join Multiple Tables
Section E: Transactions & DB Security
• Transaction
• ACID Properties
• Lost Update
• Dirty Read
• Nonrepeatable Read
• Phantoms
• Serializability
• Control Methods
• Concurrency Control
• Database Security
• Security Techniques