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

  • 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
  • Getting Started With ClickHouse (2023 Edition)

    Getting Started With ClickHouse (2023 Edition)

    Sources: udemy
    Learn ClickHouse, the fastest and the most powerful database that can handle Petabytes of data with ease! ClickHouse is an Open-Source columnar data store devel
    4 hours 38 minutes 56 seconds
  • Fundamentals of Backend Engineering

    Fundamentals of Backend Engineering

    Sources: udemy
    Backend engineering is an art. During my 18 years career working with and building backend applications, I discovered that certain communication design patterns
    16 hours 53 minutes 4 seconds
  • MySQL High Performance Tuning Guide

    MySQL High Performance Tuning Guide

    Sources: udemy
    Tips for Tuning MySQL like a Pro. Learn how to prevent MySQL performance problems. Understand how MySQL optimizes and executes queries.
    2 hours 49 minutes 22 seconds
  • Make a Google search engine clone: JavaScript PHP and MySQL

    Make a Google search engine clone: JavaScript PHP and MySQL

    Sources: udemy
    Do you want to become an expert in JavaScript, PHP and MySQL?Do you want to build a real search engine just like Google? If so, you’re in the right place!
    5 hours 47 minutes 11 seconds