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

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 29 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Quick word

All Course Lessons (29)

#Lesson TitleDurationAccess
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 subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

  • Fundamentals of Database Engineering

    Fundamentals of Database Engineering

    Sources: udemy
    Database Engineering is a very interesting sector in software engineering. If you are interested in learning about database engineering you have come to the rig
    26 hours 2 minutes 59 seconds
  • Complete SQL Mastery

    Complete SQL Mastery

    Sources: codewithmosh (Mosh Hamedani)
    Big databases are everywhere these days. Facebook, Netflix, Uber, Airbnb use SQL-driven databases - to name just a few. So, to be a successful developer or data scientist you ne...
    10 hours 47 minutes 7 seconds
  • The Complete SQL Bootcamp: Go from Zero to Hero

    The Complete SQL Bootcamp: Go from Zero to Hero

    Sources: udemy
    You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any ot
    8 hours 45 minutes 49 seconds
  • Full-Stack Fundamentals 3 - Auth

    Full-Stack Fundamentals 3 - Auth

    Sources: Mckay Wrigley (takeoff)
    In the previous project, we created a working application - Prompt Manager, mastering the key principles of full-stack development using Next.js, Supabase...
    1 hour 9 minutes 21 seconds