AmigosCode – Database Design & Implementation 2021-5

Database Design & 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.

What you’ll learn

• Capture Entities
• Designing ERD
• ERD Cardinalities
• One to One Relationships
• One to Many Relationships
• Many to Many Relationships
• Defining Constraints
• Database Normalisation
• SQL Implementation

Specificatoin of Database Design & Implementation

• Publisher : AmigosCode
• Teacher : Nelson
• Language : English
• Level : All Levels
• Number of Course : 29
• Duration : 2 hours and 8 minutes

Content of Database Design & Implementation

# Quick word
# ERD Design Tool
# Capturing Entities
# Entities Properties
# Identifying Unique constraints
# DataTypes
# SQL for user_profile
# Identifying Relationships
# Foreign Keys
# Cardinality
# 1 to 1 Relationships
# 1 to Many Relationships
# Many to Many Relationships
# Many to Many Relationship SQL
# Installing Postgres On Mac
# Datagrip
# Datagrip Installation
# Connect to Databases using Datagrip
# Executing SQL
# Insert Data To Our Tables
# Testing Constraints
# Database Normalisation
# Frist Normal Form – 1NF
# Second Normal Form – 2NF
# Third Normal Form – 3NF
# Final say on Database Normalisation
# Exercise
# Exercise Solution
# Next steps

Requirements

• A Mac, PC, or Linux-based Computer

Pictures

Sample Clip

Installation Guide

Extract the files and watch with your favorite player

Subtitle : Not Available

Quality: 1080p

Download Links

Download – 719 MB

File size

719 MB