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

  • Ultimate Expert Guide: Mastering PostgreSQL Administration

    Ultimate Expert Guide: Mastering PostgreSQL Administration

    Sources: udemy
    With the increasing popularity of Open Source Databases, organisations are looking for best alternatives among the widely available choices in the market. Among
    10 hours 19 minutes 42 seconds
  • Introduction to Microsoft Orleans

    Introduction to Microsoft Orleans

    Sources: pluralsight
    Microsoft Orleans, the Virtual Actor Framework developed by Microsoft Research is ideal for building distributed high scale systems with C#.
    1 hour 45 minutes
  • 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
  • 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
  • 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