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
Join premium to watch
Go to premium
| # | Title | Duration |
|---|---|---|
| 1 | Quick word | 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 |
Comments
0 commentsSimilar courses
Full-Stack Fundamentals 4 - Payments
Sources: Mckay Wrigley (takeoff)
In the previous section, we successfully implemented user authentication using Clerk. Now, based on this project, we will add online payment processing with...
54 minutes 17 seconds
Effective Database Design
Sources: Ben Brumm
The course "Effective Database Design" will provide you with an action plan, examples, and instructions for creating a well-designed database.
1 hour 3 minutes 56 seconds
PostgreSQL Replication, High Availability HA and Scalability
Sources: udemy
PostgreSQL is one of the most powerful and user-friendly database management systems. It is actively supported by the community and receives new releases...
3 hours 9 minutes 35 seconds
MySQL High Performance Tuning Guide
Sources: udemy
Tips for Tuning MySQL like a Pro. Learn how to prevent MySQL performance problems. Understand how MySQL optimizes and executes queries.
2 hours 49 minutes 22 seconds
Want to join the conversation?
Sign in to comment