Database Design & Implementation
2h 7m 49s
English
Paid
Course description
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.
Read more about the course
- Capture Entities
- Designing ERD
- ERD Cardinalities
- One to One Relationships
- One to Many Relationships
- Many to Many Relationships
- Defining Constraints
- Database Normalisation
- SQL Implementation
Watch Online
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 subscriptionComments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
DuckDB - The Ultimate Guide
Sources: 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
High Performance SQLite
Sources: Aaron Francis
This course is designed to take you from beginner to expert in SQLite. You'll learn how to use SQLite in production, how to optimize it, and how to use...
15 hours 27 minutes 55 seconds
100 Days Of Code: The Complete Web Development Bootcamp 2024
Sources: Academind Pro
Learn web development from A to Z in 100 days (or at your own pace) - from "basic" to "advanced", it's all included!
78 hours 51 minutes 55 seconds
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL
Sources: udemy
Are you interested in a career in Data Science or Data Analytics? In that case, inevitably you are going to encounter databases in your work. But how do you int
12 hours 32 minutes 7 seconds
Complete SQL + Databases Bootcamp: Zero to Mastery
Sources: zerotomastery.io
With so many online resources available, it can be paralyzing not only figuring out where to start but more importantly which courses will actually teach you the skills you need...
24 hours 6 minutes 52 seconds