Database design training develops relational database design skills and techniques. E-R diagrams and normalization forms are emphasized. The training concentrates on designing for data integrity and efficiency at the same time. On the database design training students will experience the necessity of proper design methods and gain an in depth understanding of the link between design, creation, and utilization.
Relational Database Design Concepts Course Overview:
Developing Relational Databases
• Relational Database Fundamentals
• Database Development Methodology Overview
Building a Logical Data Model
• Understanding Data Analysis and Modeling
• Identifying Entities and Attributes
• Isolating Keys
• Relationships between Entities (One-to-One, One-to-Many, Many-to-Many)
• Creating Entity-Relationship Diagrams
• Complex Modeling Issues
- Exclusive and Recursive Relationships
- Supertype / Subtype Entities
• Normalization as a Design Technique
• Progressive Steps to Normalization (First, Second, and Third Normal Form)
• Higher Levels of Normalization
• Using Normalization to Build an E-R Diagram
Transforming to Physical Design
• Migrating Entities to Tables
• Selecting Primary Keys
• Defining Columns
• Enforcing Relationships with Foreign Keys
• Implementing Exclusive and Recursive Relationships
• Implementing Supertypes / Subtypes
• Enforcing Business Rules
- NOT NULL, UNIQUE and CHECK Constraints
- Assigning DEFAULT Values
- DELETE and UPDATE Rules
• Historical and Control Tables
• Database VIEWs
• Estimating Table Sizes
• Designing for Security: Users and Roles
| 
