Database Design & Implementation

02:07:49 Inglés Premium 22/11/2023 29 videos

Descripción del curso

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

Curriculum

Section 1: Module 1

02 - Quick word 01:23
03 - ERD Design Tool 03:25
04 - Capturing Entities 04:33
05 - Entities Properties 06:50
06 - Identifying Unique constraints 03:18
07 - DataTypes 06:12
08 - SQL for user_profile 06:23
09 - Identifying Relationships 05:11
10 - Foreign Keys 02:46
11 - Cardinality 08:49
12 - 1 to 1 Relationships 06:12
13 - 1 to Many Relationships 05:00
14 - Many to Many Relationships 07:59
15 - Many to Many Relationship SQL 03:46
16 - Installing Postgres On Mac 03:34
17 - Datagrip 03:07
18 - Datagrip Installation 02:28
19 - Connect to Databases using Datagrip 04:58
20 - Executing SQL 06:14
21 - Insert Data To Our Tables 08:35
22 - Testing Constraints 04:55
23 - Database Normalisation 00:53
24 - Frist Normal Form - 1NF 03:24
25 - Second Normal Form - 2NF 05:19
26 - Third Normal Form - 3NF 02:11
27 - Final say on Database Normalisation 01:00
28 - Exercise 02:18
29 - Exercise Solution 05:27
30 - Next steps 01:39

About the Instructor

amigoscode (Nelson Djalo)

$0.00

$8.00

Que esta incluido?

Streaming Multiplataforma
Acceso de por vida
Soporte al cliente
Actualizaciones gratuitas