Description
Database Design & Implementation, course Database design and implementation is published by AmigoseCode Academy. The backend starts with your database. It’s easy when you have a solid database design coding. In this course, you will learn how to design a database for back-end applications. You will learn how to design a subset of the YouTube platform that allows you to design your own databases.
What you will learn
- Register entities
- ERD design
- ERD Cardinalities
- One to One relationships
- One to Many relationships
- Many to Many relationships
- Definition of limitations
- Database standardization
- Execute SQL
- ERD design tool
- Record events
- unique features
- Identify unique constraints
- DataTypes
- SQL for the user file
- Identify relationships
- Foreign keys
- Cardinality
- Install Postgres on Mac
Database Design & Implementation course specifications
- Publisher: AmigosCode
- teacher : Nelson
- English language
- Education level: all levels
- Number of courses: 29
- Training duration: 2 hours and 8 minutes
Chapters of the Database Design & Implementation course
# 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 Normalization
# First Normal Form – 1NF
# Second Normal Form – 2NF
# Third Normal Form – 3NF
# Final say on Database Normalization
#Exercise
# Exercise Solution
# Next steps
Course prerequisites
-
A Mac, PC, or Linux-based computer
Pictures
Sample video
Installation guide
After Extract, view with your favorite Player.
Subtitle: None
Quality: 1080p
download link
File(s) password: www.downloadly.ir
Size
719 MB