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
The Complete 2023 Web Development Bootcamp
Sources: udemy
Welcome to the Complete Web Development Bootcamp, the only course you need to learn to code and become a full-stack web developer. With over 12,000 ratings and a 4.8 average, my...
62 hours 32 minutes 23 seconds
SQL - MySQL for Data Analytics and Business Intelligence
Sources: udemy
Well, when you can work with SQL, it means you don’t have to rely on others sending you data and executing queries for you. You can do that on your own. This al
9 hours 22 minutes 55 seconds
Database DevOps from Start to Finish
Sources: iamtimcorey.com (Tim Corey)
If 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 building
2 hours 40 minutes 37 seconds
Master SQL Queries From Basic to Advanced
Sources: Kamran Ahmed
The course is designed for developers, data analysts, and anyone working with databases. It covers the entire range of SQL queries - from basics to advanced...
PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours
Sources: udemy
Subqueries? Yes, Recursive CTEs? Yes, Server programming with SQL and PL/pgSQL, Stored Procedures? Yes, Window Functions? Yes indeed and much more... This compr
67 hours 20 minutes 55 seconds