From the course: AWS Certified Database – Specialty (DBS-C01) Cert Prep: 2 Design and Deployment
Unlock this course with a free trial
Join today to access over 22,600 courses taught by industry experts.
Using an ERD tool - Amazon Web Services (AWS) Tutorial
From the course: AWS Certified Database – Specialty (DBS-C01) Cert Prep: 2 Design and Deployment
Using an ERD tool
- One of the most dangerous things you can do when it comes to database design is just jump into the database and think, "Well, we've planned out all of our entities, and I'm ready to start creating tables." And so you create this table and that table and you start building it. The reason is that if you go through another process, you might think of things you missed. Let me throw four phrases at you to get your thinking the right way. Database model, database modeling, entity relationship diagram, entity relationship model. All four of these phrases, whether we're talking about database models or database modeling, or ERD or ERM, we're talking about the same basic thing, building a logical model that represents what our database is going to be physically, in other words, what we're really going to implement. The model says this is the database logically. The physical design says this is the database in the DBMS. Now…
Contents
-
-
Designing databases6m 54s
-
(Locked)
Using an ERD tool9m 3s
-
(Locked)
Designing database solutions6m 31s
-
(Locked)
Designing for performance7m 37s
-
(Locked)
Designing for scalability6m 41s
-
(Locked)
Designing for compliance6m 27s
-
(Locked)
Planning for recovery6m
-
(Locked)
Planning for high availability7m 17s
-
(Locked)
Planning for encryption6m 24s
-
-