AmigosCode - Database Design & Implementation (36 files)
 create-people.sql |
206.74kB |
| create-people_1.sql |
206.74kB |
| diagram.drawio |
139.35kB |
| diagram_2.drawio |
139.35kB |
| erd (1).drawio |
598.90kB |
| erd - exercise.drawio |
591.11kB |
| erd.drawio |
599.17kB |
| lesson1.mp4 |
55.12MB |
| lesson2.mp4 |
12.31MB |
| lesson3.mp4 |
20.16MB |
| lesson4.mp4 |
23.85MB |
| lesson5.mp4 |
12.49MB |
| lesson6.mp4 |
27.68MB |
| lesson7.mp4 |
24.95MB |
| lesson8.mp4 |
23.52MB |
| lesson9.mp4 |
10.86MB |
| lesson10.mp4 |
40.23MB |
| lesson11.mp4 |
29.26MB |
| lesson12.mp4 |
20.73MB |
| lesson13.mp4 |
36.36MB |
| lesson14.mp4 |
18.51MB |
| lesson15.mp4 |
25.25MB |
| lesson16.mp4 |
22.01MB |
| lesson17.mp4 |
21.51MB |
| lesson18.mp4 |
23.73MB |
| lesson19.mp4 |
30.91MB |
| lesson20.mp4 |
45.75MB |
| lesson21.mp4 |
30.58MB |
| lesson22.mp4 |
36.33MB |
| lesson23.mp4 |
11.26MB |
| lesson24.mp4 |
16.40MB |
| lesson25.mp4 |
9.93MB |
| lesson26.mp4 |
41.57MB |
| lesson27.mp4 |
11.13MB |
| lesson28.mp4 |
31.91MB |
| lesson29.mp4 |
65.49MB |
Type: Course
Bibtex:
Tags:
Bibtex:
@article{,
title= {AmigosCode - Database Design & Implementation},
journal= {},
author= {},
year= {},
url= {},
abstract= {Here's a snapshot of what you will learn:
Capturing Entities: Understand the importance of accurately identifying and defining the entities in your database. This is the first step towards a well-structured database.
Designing ERD: Learn to create Entity Relationship Diagrams, a powerful tool to visualize your database structure and relationships between entities.
ERD Cardinalities: Delve into the heart of database relationships with cardinalities, understanding how entities interact with each other.
One to One Relationships: Uncover the nuances of one-to-one relationships and how to design them efficiently in your database.
One to Many Relationships: Explore the dynamics of one-to-many relationships, a common scenario in database design, and learn to implement them effectively.
Many to Many Relationships: Tackle the complexity of many-to-many relationships, learning how to break them down and represent them effectively in your database.
Defining Constraints: Learn how to define constraints to maintain the integrity of your data, ensuring your database remains reliable and accurate.
Database Normalisation: Understand the principles of database normalisation, a key process that helps eliminate redundancy and improve data integrity.
SQL Implementation: Put your design into action with SQL, the standard language for interacting with databases. Learn how to create, manipulate, and query your database using SQL},
keywords= {},
terms= {},
license= {},
superseded= {}
}
