Skip to main content
CourseFlix

Database Design & Implementation

2h 7m 49s
English
Paid

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.

  • 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 (Amigoscode) thumbnail

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

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 29 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Quick word
All Course Lessons (29)
#Lesson TitleDurationAccess
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
Unlock unlimited learning

Get instant access to all 28 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Course content

29 lessons · 2h 7m 49s
Show all 29 lessons
  1. 1 Quick word 01:23
  2. 2 ERD Design Tool 03:25
  3. 3 Capturing Entities 04:33
  4. 4 Entities Properties 06:50
  5. 5 Identifying Unique constraints 03:18
  6. 6 DataTypes 06:12
  7. 7 SQL for user_profile 06:23
  8. 8 Identifying Relationships 05:11
  9. 9 Foreign Keys 02:46
  10. 10 Cardinality 08:49
  11. 11 1 to 1 Relationships 06:12
  12. 12 1 to Many Relationships 05:00
  13. 13 Many to Many Relationships 07:59
  14. 14 Many to Many Relationship SQL 03:46
  15. 15 Installing Postgres On Mac 03:34
  16. 16 Datagrip 03:07
  17. 17 Datagrip Installation 02:28
  18. 18 Connect to Databases using Datagrip 04:58
  19. 19 Executing SQL 06:14
  20. 20 Insert Data To Our Tables 08:35
  21. 21 Testing Constraints 04:55
  22. 22 Database Normalisation 00:53
  23. 23 Frist Normal Form - 1NF 03:24
  24. 24 Second Normal Form - 2NF 05:19
  25. 25 Third Normal Form - 3NF 02:11
  26. 26 Final say on Database Normalisation 01:00
  27. 27 Exercise 02:18
  28. 28 Exercise Solution 05:27
  29. 29 Next steps 01:39

Related courses

  • PostgreSQL Replication, High Availability HA and Scalability thumbnail

    PostgreSQL Replication, High Availability HA and Scalability

    By: Udemy
    PostgreSQL is one of the most powerful and user-friendly database management systems.
    3 hours 9 minutes 35 seconds
  •  Ludicrous Speed Postgres thumbnail

    Ludicrous Speed Postgres

    By: Creston Jamison
    Unlock 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 thumbnail

    DuckDB - The Ultimate Guide

    By: Udemy
    Why 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

Frequently asked questions

What is Database Design & Implementation about?
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…
Who teaches Database Design & Implementation?
Database Design & Implementation is taught by Nelson Djalo (Amigoscode). You can find more courses by this instructor on the corresponding source page.
How long is Database Design & Implementation?
Database Design & Implementation contains 29 lessons with a total runtime of 2 hours 7 minutes. All lessons are available to watch online at your own pace.
Is Database Design & Implementation free to watch?
Database Design & Implementation is part of CourseFlix's premium catalog. A CourseFlix subscription unlocks the full video player; the course description, table of contents, and preview information are available to everyone.
Where can I watch Database Design & Implementation online?
Database Design & Implementation is available to watch online on CourseFlix at https://courseflix.net/course/database-design-implementation. The page hosts every lesson with the integrated video player; no download is required.