Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Database Design & Implementation
Database Design & Implementation
Join the Community
Newsletter
Quick word (1:22)
ERD Design Tool
Capturing Entities
Entities Properties
Identifying Unique constraints
DataTypes
SQL for user_profile
Identifying Relationships
Foreign Keys
Cardinality
1 to 1 Relationships
1 to Many Relationships
Many to Many Relationships
Many to Many Relationship SQL
Installing Postgres On Mac (3:33)
Datagrip (3:06)
Datagrip Installation (2:27)
Connect to Databases using Datagrip (4:57)
Executing SQL (6:13)
Insert Data To Our Tables
Testing Constraints
Database Normalisation (0:52)
Frist Normal Form - 1NF
Second Normal Form - 2NF
Third Normal Form - 3NF
Final say on Database Normalisation (0:59)
Exercise
Exercise Solution (5:26)
Next steps (1:38)
Advanced Databases
ERD Design Tool
https://app.diagrams.net/
Complete and Continue
1 - Follow us on
LinkedIn
2 - Subscribe to our Newsletter