Course

Database Design & Implementation

Skills in database design and SQL for efficient, robust backend development

of video
1.7 h
lectures
32
sections
6

$79one payment

Get the courseSee the curriculum

Lifetime access. 15-day money-back guarantee.

Want a mentor as well? The Academy gives you every course on Amigoscode plus code reviews, daily live calls and interview prep, for $129/month. Compare →

What you'll learn

By the end of this course

  • Database Design
  • Entity-Relationship Diagrams (ERD)
  • Unique Constraints in Database Design
  • One-to-One Relationships
  • One-to-Many Relationships
  • Many-to-Many Relationships
  • Normalizing Databases with 1NF, 2NF, 3NF

Curriculum

6 sections, 32 lectures

1.7 h of video. Open any section to see its lectures.

1Intro4 min
  1. 1Recommended Courses
  2. 2Intro To Database Design4 min
  3. 3Slides
2Database design1 h 17 min
  1. 1ERD Design Tools4 min
  2. 21 To 1 Relationships6 min
  3. 31 To Many Relationships5 min
  4. 4Many To Many Relationships8 min
  5. 5Many To Many Relationship SQL4 min
  6. 6End Of Section SQL
  7. 7Quiz
  8. 8Capturing Entities5 min
  9. 9Entities Properties7 min
  10. 10Identifying Unique Constraints3 min
  11. 11Datatypes6 min
  12. 12Defining Data Types6 min
  13. 13Sql For User_profile6 min
  14. 14Identiying Relationships5 min
  15. 15Foreign Keys3 min
  16. 16Cardinalities9 min
  17. 17ERD Objects
3Database normalization12 min
  1. 1What Is Database Normalization1 min
  2. 21NF - First Normal Form3 min
  3. 32NF - Second Normal Form5 min
  4. 43NF - Third Normal Form2 min
  5. 5Quiz
4Exercise 18 min
  1. 1Exercise2 min
  2. 2Exercise Solution5 min
5Exercise 22 min
  1. 1Exercise2 min
  2. 2Exercise Brief
  3. 3Solution
6Next steps1 min
  1. 1Feedback
  2. 2Next Course

Choose how you learn

Learn on your own, or with people who check your work

The course is yours to keep. The Academy is this course and every other one, plus the people who get you hired.

Database Design & Implementation

The course, on your own

$79one payment

  • 32 lectures, 1.7 h of video
  • Subtitles on every video
  • 6 months of IntelliJ IDEA Ultimate
  • Lifetime access to the course and its updates

15-day money-back guarantee

Recommended

The Academy

The courses, plus the people

$129/monthcancel anytime

This course, plus

  • Every course on Amigoscode 50+ in the Zero to Hired Roadmap
  • Daily live calls and 1:1 instructor time
  • Code reviews and pair programming on what you build
  • Interview prep mock interviews, System Design Lab, CV and LinkedIn review
  • Land an interview in 90 days or we coach you 1:1 free until you do.
Join the Academy

7-day money-back guarantee · Secure checkout on Skool

“Nelson was teaching 90% of my job. I was already implementing everything I learnt from it.”
MBMarlon BragaJava Full Stack Software Developer
“I was a totally different person. More confident as a developer, more prepared for my job.”
GabrielaSoftware Engineer at Mercado Livre
“I studied biomedicine and psychology. I found Nelson's Java tutorials while looking for a course for my brother. I was hooked and now here I am, a software engineer at IKEA.”
NajmaSoftware Engineer at IKEA

Read every review →

About this course

Who is this course for?

Level: Junior and Mid Engineers.

How long will it take?

There are about 2 hours of video. Most people finish in a week at 5 hours a week, plus the time you spend building along.

Do I keep access?

Yes. You pay once and keep the course for life, including updates.

What if it isn't for me?

Email us within 15 days of buying and we'll refund you in full.

Should I buy the course or join the Academy?

Buy the course if you only want this topic and you learn well on your own. Join the Academy if you want to get hired or move up: you get every course on Amigoscode, this one included, plus daily live calls, code reviews and interview prep, for $129/month. The course is $79 once.