Database Design & Implementation
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
Your Instructor
Hi, I am Mama Samba Braima AKA Nelson!
Passionate DevOps/Software Engineer and a YouTuber. After graduating from King's College in Computer Science I acquired expertise working as a Java Engineer for companies such as CitiGroup and Starling. Over the years, I discovered my passion for teaching - that's how it all started.
From my Youtube channel to the Amigoscode website and Java Bootcamps in London, I have taught coding to millions of people from around the world and helped them to break into the Software Engineering world.
My mission is to make learning accessible for everybody. Whether you're just starting or have been coding for a while, I want to help you become the best version of yourself and prove to you that anything is possible!
Course Curriculum
Database Design & Implementation
Available in
days
days
after you enroll
-
StartJoin the Community
-
StartQuick word (1:22)
-
StartERD Design Tool
-
StartCapturing Entities
-
StartEntities Properties
-
StartIdentifying Unique constraints
-
StartDataTypes
-
StartSQL for user_profile
-
StartIdentifying Relationships
-
StartForeign Keys
-
StartCardinality
-
Start1 to 1 Relationships
-
Start1 to Many Relationships
-
StartMany to Many Relationships
-
StartMany to Many Relationship SQL
-
StartInstalling Postgres On Mac (3:33)
-
StartDatagrip (3:06)
-
StartDatagrip Installation (2:27)
-
StartConnect to Databases using Datagrip (4:57)
-
StartExecuting SQL (6:13)
-
StartInsert Data To Our Tables
-
StartTesting Constraints
-
StartDatabase Normalisation (0:52)
-
StartFrist Normal Form - 1NF
-
StartSecond Normal Form - 2NF
-
StartThird Normal Form - 3NF
-
StartFinal say on Database Normalisation (0:59)
-
StartExercise
-
StartExercise Solution (5:26)
-
StartNext steps (1:38)
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.