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
Hello World. I am Nelson! I am a passionate Software Engineer and YouTuber teaching and helping thousands of people around the world how to code or how to become professional software engineers through my YouTube channel and online courses.
My mission is to make coding and programming concepts as easy to understand to everyone. My journey was not easy and I truly want to help you to become the best your can possible and believe the everything is possible.
Happy Coding
Course Curriculum
-
StartQuick word (1:22)
-
StartERD Design Tool (3:24)
-
StartCapturing Entities (4:32)
-
StartEntities Properties (6:49)
-
StartIdentifying Unique constraints (3:17)
-
StartDataTypes (6:11)
-
StartSQL for user_profile (6:22)
-
StartIdentifying Relationships (5:10)
-
StartForeign Keys (2:45)
-
StartCardinality (8:48)
-
Start1 to 1 Relationships (6:11)
-
Start1 to Many Relationships (4:59)
-
StartMany to Many Relationships (7:58)
-
StartMany to Many Relationship SQL (3:45)
-
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 (8:34)
-
StartTesting Constraints (4:54)
-
StartDatabase Normalisation (0:52)
-
StartFrist Normal Form - 1NF (3:23)
-
StartSecond Normal Form - 2NF (5:18)
-
StartThird Normal Form - 3NF (2:10)
-
StartFinal say on Database Normalisation (0:59)
-
StartExercise (2:17)
-
StartExercise Solution (5:26)
-
StartNext steps (1:38)