English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 2h 08m | 753 MB
Master ERD & SQL 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
Table of Contents
1 Quick word
2 ERD Design Tool
3 Capturing Entities
4 Entities Properties
5 Identifying Unique constraints
6 DataTypes
7 SQL for user_profile
8 Identifying Relationships
9 Foreign Keys
10 Cardinality
11 1 to 1 Relationships
12 1 to Many Relationships
13 Many to Many Relationships
14 Many to Many Relationship SQL
15 Installing Postgres On Mac
16 Datagrip
17 Datagrip Installation
18 Connect to Databases using Datagrip
19 Executing SQL
20 Insert Data To Our Tables
21 Testing Constraints
22 Database Normalisation
23 Frist Normal Form – 1NF
24 Second Normal Form – 2NF
25 Third Normal Form – 3NF
26 Final say on Database Normalisation
27 Exercise
28 Exercise Solution
29 Next steps
Resolve the captcha to access the links!