This course is intended for the a beginner / intermediate who wants to understand relational database design and normalisation. From the novice all the way through to the expert. This includes database administrators, developers, data modellers, sysems or network administrators, technical managers, marketers, advertisers, forecasters, planners - anyone.
Approaching Relational database Modelling
1. Database Modelling Past and Present
2. Database Modelling in the Workplace
3. Database Modelling Building Blocks
Designing Relational Database Models
4. Understanding Normalisation
5. Reading and Writing Data with SQL
6. Advanced Relational Database Modelling
7. Understanding Data Warehouse Database Modelling
8. Building Fast-Performing Database Models
A Case Study in Relational Database Modelling
9. Planning and Preparation Through Analysis
10. Creating and Refining Tables During the Design Phase
11. Filling in the Details with a Detailed Design
12. Business Rules and Field Settings
Advanced Topics
13. Advanced Database Structures and Hardware Resources