Backend starts from Your Database. When you have a solid database design coding is easy. In this course you will learn how to design databases for your backend applications. You will learn how to design a subset of YouTube Platform allowing you design your own databases.
Database Design & Implementation
- Capture Entities
- Designing ERD
- ERD Cardinalities
- One to One Relationships
- One to Many Relationships
- Many to Many Relationships
- Defining Constraints
- Database Normalisation
- SQL Implementation
About the Author: Nelson Djalo (Amigoscode)
Nelson Djalo publishes the Amigoscode YouTube channel and standalone course platform — one of the largest independent Java / Spring Boot tutorial sources online, with several million subscribers and a multi-year track record of weekly back-end engineering tutorials.
The course catalog covers the full Java back-end stack: Java fundamentals, Spring Boot for production web services, Spring Security and OAuth, Spring Data and JPA, microservices patterns with Spring Cloud, Kafka and event-driven architecture, Docker and Kubernetes for the deployment layer, AWS for cloud infrastructure, and the database side (PostgreSQL, MongoDB, Redis). Material is project-oriented — most courses build a working microservice or full application end-to-end.
The CourseFlix listing under this source carries over 13 Amigoscode courses spanning that range. Material is paid; Amigoscode runs on per-course or membership pricing on the original platform. Courses are aimed at Java developers building production back-end services.
Watch Online 29 lessons
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 1 | Quick word Demo | 01:23 | |
| 2 | ERD Design Tool | 03:25 | |
| 3 | Capturing Entities | 04:33 | |
| 4 | Entities Properties | 06:50 | |
| 5 | Identifying Unique constraints | 03:18 | |
| 6 | DataTypes | 06:12 | |
| 7 | SQL for user_profile | 06:23 | |
| 8 | Identifying Relationships | 05:11 | |
| 9 | Foreign Keys | 02:46 | |
| 10 | Cardinality | 08:49 | |
| 11 | 1 to 1 Relationships | 06:12 | |
| 12 | 1 to Many Relationships | 05:00 | |
| 13 | Many to Many Relationships | 07:59 | |
| 14 | Many to Many Relationship SQL | 03:46 | |
| 15 | Installing Postgres On Mac | 03:34 | |
| 16 | Datagrip | 03:07 | |
| 17 | Datagrip Installation | 02:28 | |
| 18 | Connect to Databases using Datagrip | 04:58 | |
| 19 | Executing SQL | 06:14 | |
| 20 | Insert Data To Our Tables | 08:35 | |
| 21 | Testing Constraints | 04:55 | |
| 22 | Database Normalisation | 00:53 | |
| 23 | Frist Normal Form - 1NF | 03:24 | |
| 24 | Second Normal Form - 2NF | 05:19 | |
| 25 | Third Normal Form - 3NF | 02:11 | |
| 26 | Final say on Database Normalisation | 01:00 | |
| 27 | Exercise | 02:18 | |
| 28 | Exercise Solution | 05:27 | |
| 29 | Next steps | 01:39 |
Get instant access to all 28 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.
Learn more about subscriptionCourse content
29 lessons · 2h 7m 49sShow all 29 lessons
- 1 Quick word 01:23
- 2 ERD Design Tool 03:25
- 3 Capturing Entities 04:33
- 4 Entities Properties 06:50
- 5 Identifying Unique constraints 03:18
- 6 DataTypes 06:12
- 7 SQL for user_profile 06:23
- 8 Identifying Relationships 05:11
- 9 Foreign Keys 02:46
- 10 Cardinality 08:49
- 11 1 to 1 Relationships 06:12
- 12 1 to Many Relationships 05:00
- 13 Many to Many Relationships 07:59
- 14 Many to Many Relationship SQL 03:46
- 15 Installing Postgres On Mac 03:34
- 16 Datagrip 03:07
- 17 Datagrip Installation 02:28
- 18 Connect to Databases using Datagrip 04:58
- 19 Executing SQL 06:14
- 20 Insert Data To Our Tables 08:35
- 21 Testing Constraints 04:55
- 22 Database Normalisation 00:53
- 23 Frist Normal Form - 1NF 03:24
- 24 Second Normal Form - 2NF 05:19
- 25 Third Normal Form - 3NF 02:11
- 26 Final say on Database Normalisation 01:00
- 27 Exercise 02:18
- 28 Exercise Solution 05:27
- 29 Next steps 01:39
Related courses
-

PostgreSQL Replication, High Availability HA and Scalability
By: UdemyPostgreSQL is one of the most powerful and user-friendly database management systems.3 hours 9 minutes 35 seconds -

Ludicrous Speed Postgres
By: Creston JamisonUnlock the potential of your PostgreSQL setup with our comprehensive course designed for performance optimization .12 hours 27 minutes 44 seconds 5 / 5 -

DuckDB - The Ultimate Guide
By: UdemyWhy should you study DuckDB? DuckDB is one of the fastest-growing technologies, with the number of search queries increasing by 1200% over the past two years!5 hours 56 minutes 13 seconds 5 / 5