Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Relational Database Design Pro
Introduction
Overview (2:36)
Why not spreadsheets ? (2:52)
Database environment (2:30)
Purpose of a database (3:20)
Basic concepts
Data modeling (8:09)
Relational database (3:04)
RDBMS (3:00)
Computer-based Information System (2:42)
Quiz
Business process analysis
Context of BPA (3:11)
Identification of the static structure (6:16)
Entity-Relationship Diagram
ER Diagram : Definition & Structure (8:49)
Inventory of the diagram components (1:57)
Building the diagram (25:34)
Relational model
Relational model : Definition & Structure (6:46)
Mapping rules (5:18)
Normalization (6:30)
Building the relational model (4:19)
Physical data model
From LDM to PDM (0:58)
Building the Physical data model (6:15)
ERDPlus file
Creation of the Database
How to create SQL script ? (1:02)
Generating the SQL script (0:43)
SQL_code
Postgresql_install
Building the Database schema (5:23)
Conclusion
Summary of the Course
Inventory of the diagram components
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock