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
2h 7m 49s
English
Paid
Database Design & Implementation is a 29-lesson 2 hours 7 minutes self-paced course by Nelson Djalo (Amigoscode). Backend starts from Your Database.
Course facts
- Lessons
- 29
- Duration
- 2 hours 7 minutes
- Level
- All levels
- Language
- English
- Updated
- Instructor
- Nelson Djalo (Amigoscode)
- Price
- Premium
- Capture Entities
- Designing ERD
- ERD Cardinalities
- One to One Relationships
- One to Many Relationships
- Many to Many Relationships
- Defining Constraints
- Database Normalisation
- SQL Implementation
Who teaches Database Design & Implementation? 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.
What lessons are included in Database Design & Implementation?
0:00
/ #1: Quick word
All Course Lessons (29)
| # | 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 |
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 subscriptionWhat courses are similar to Database Design & Implementation?
-
Updated 1y agoMaster SQL Queries From Basic to Advanced
By: Kamran AhmedExpand your SQL skills with this comprehensive course tailored for developers, data analysts , and anyone who interacts with databases.5/5 -
Updated 2y agoDatabase DevOps from Start to Finish
By: Tim CoreyIf you have only ever built a database using SQL Server Management Studio (SSMS), you are in for a treat. SQL Server Data Tools (SSDT) is designed for building2h 40m -
Updated 2y agoMake a Google search engine clone: JavaScript PHP and MySQL
By: UdemyDo you want to become an expert in JavaScript, PHP and MySQL?Do you want to build a real search engine just like Google? If so, you’re in the right place!5h 47m5/5 -
Updated 2y ago100 Days of Code: The Complete Web Development Bootcamp 2022
By: Academind Pro (Maximilian Schwarzmüller)100 Days of Code: Complete Web Development Bootcamp 2022 by Colt Steele — HTML, CSS, JavaScript, Node, Express, Mongo, and full-stack projects.78h 51m -
Updated 2y agoGetting Started With ClickHouse (2023 Edition)
By: UdemyLearn ClickHouse, the fastest and the most powerful database that can handle Petabytes of data with ease! ClickHouse is an Open-Source columnar data store devel4h 38m -
ClassicPostgreSQL Fundamentals
By: Big MachineEmbark on an exciting journey to master the fundamentals of SQL while exploring the fascinating world of databases with PostgreSQL.2h 5m5/5 -
Updated 2y agoNode, SQL, & PostgreSQL - Mastering Backend Web Development
By: UdemyBecome an in demand software engineer by taking this course on Node, SQL, PostgreSQL, and backend web development. As one of the most popular web development st4h 59m5/5 -
Updated 2y agoLearn Database Design with MySQL
By: O'Reilly MediaGood course for starting up & covers quickly the important topics and shows for beginners what MySQL can be used for. Database design is one of the most importa6h 14m
More courses by Nelson Djalo (Amigoscode)
-
Updated 2y agoSpring Boot Master Class
Learn how to get started with Spring Boot, a powerful framework to build web applications quickly, using less code. The Java-based programs you build in Spring9h 28m5/5 -
Updated 2y agoMicroservices and Distributed Systems
Microservices are an architectural and organisational approach to software development where software is composed of small independent services that.11h 18m5/5 -
Updated 2y agoSpring Data JPA Master Class
In this course you learn everything there is to learn about Spring Data JPA allowing to build scalable backend applications backed by any relational database.4h 21m5/5 -
Updated 3y agoIntelliJ IDEA Developer Guide
IntelliJ IDEA is an integrated development environment written in Java for developing software.4h 17m5/5 -
ClassicJava Master Class
Welcome to Amigoscode's most comprehensive Java course! It includes everything you need to gain a complete understanding of Java.24h 40m5/5 -
ClassicPROFESSIONAL Full Stack Developer
Are you ready to level up your coding skills and become a full stack professional?54h 23m5/5
Frequently asked questions
What prerequisites are needed before taking this course?
Before enrolling in this course, students should have a basic understanding of programming and databases. Familiarity with SQL and general database concepts will be beneficial, as the course covers topics such as SQL for user_profile, foreign keys, and database normalization. Additionally, understanding how to install software and use command-line tools will be helpful, especially for lessons on installing Postgres and using Datagrip.
What will I build during this course?
Throughout the course, students will design a database for a subset of the YouTube platform. This project involves capturing entities, identifying unique constraints, and establishing relationships such as 1 to 1, 1 to many, and many to many. By the end of the course, students will have a functional database schema ready to be implemented in backend applications.
Who is the target audience for this course?
This course is designed for software developers, database administrators, and IT professionals who aim to deepen their understanding of database design. It is particularly suitable for those who wish to implement robust database solutions as part of backend application development. Beginners with some programming and database knowledge will also find the course beneficial.
How does the depth of this course compare to others?
The course offers detailed insights into database design and implementation, focusing on practical applications such as designing a subset of the YouTube platform. While it covers fundamental topics like ERD design and SQL, it also delves into advanced areas such as database normalization up to the third normal form. Compared to introductory courses, this course provides a more comprehensive look at designing databases for real-world applications.
What specific tools or platforms are covered in the course?
The course covers several tools and platforms essential for database design and implementation. Students will learn to use the ERD Design Tool for capturing entities and relationships. They will also install and use Postgres on Mac and leverage Datagrip for database connectivity and SQL execution. These tools are integral to the hands-on approach of the course.
What topics are not covered in this course?
The course does not cover front-end development or advanced database management topics such as distributed databases, database security, or performance tuning. It focuses primarily on designing and implementing databases for backend applications, emphasizing concepts like entity relationships and normalization rather than exploring other database systems or technologies.
What is the time commitment required for this course?
The course consists of 29 lessons, each focusing on various aspects of database design and implementation. While the total runtime is listed as 00:00:00, students should expect to spend additional time on exercises, which include designing a subset of the YouTube platform and applying normalization techniques. The time commitment will vary based on the individual's pace and familiarity with the material.