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 comments

Want to join the conversation?

Sign in to comment

Similar courses

SQL - The Complete Guide (MySQL, PostgreSQL & more)

SQL - The Complete Guide (MySQL, PostgreSQL & more)

Sources: Academind Pro
SQL is THE most important query language you can learn! It's used by many popular database management systems like MySQL or PostgreSQL. But it's also used by data analysis and b...
19 hours 35 minutes 38 seconds
Complete SQL + Databases Bootcamp: Zero to Mastery

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
Neo4j: GraphDB Foundations with Cypher

Neo4j: GraphDB Foundations with Cypher

Sources: udemy
Learn what a graph database is, gain the fundamental skills to use Neo4j on your next project. Learn how some of the worlds top tech companies structure and que
4 hours 44 minutes
SQL & MySQL Subqueries: Understanding the weird parts

SQL & MySQL Subqueries: Understanding the weird parts

Sources: udemy
Master the Art of SQL Subqueries with this Comprehensive Course - Take Your Data Management Skills to the Next Level! Whether you're a beginner or an ...
8 hours 53 minutes 49 seconds
PostgreSQL High Performance Tuning Guide

PostgreSQL High Performance Tuning Guide

Sources: udemy
PostgreSQL is one of the most powerful and convenient database management systems. It is actively supported by the community and receives new releases every...
2 hours 41 minutes 14 seconds