Database ERD Principles | Very Academy
Very Academy
Very Academy is an online education provider that offers a vast and ever-growing catalogue of tutorials and courses. Very Academy's mission is to provide universally accessible, highest quality Computer Science and Technology education.. By providing you with the most relevant, highest-quality learning experiences to support your learning, we hope to help foster students into globally competent professionals in the field of Computer Science and Technology..
Course Details
- Course Lessons13
- Course Period1h 53m
- No.Students2
- LanguageEnglish
- No Prerequisite
- (1)
- Start Now for free
Course Lessons
- 1 | Practical Database Design: Theory Into Practice Blog Schema 00:02:51
- 2 | Database Theory Key Terminology: Databases, RDBMS, and the Data Lifecycle 00:11:24
- 3 | Database Theory Entity and Tables 00:03:17
- 4 | Database Theory Attributes and Fields 00:06:00
- 5 | Database Design Objectives 00:14:09
- 6 | Database Introducing Entities 00:07:42
- 7 | Database Identifying Significant Entities 00:08:36
- 8 | Database Design Approach 1 Formulate the Preliminary Entity List 00:17:15
- 9 | Database Design Approach 2 Identifying Entities from a List of Attributes 00:07:30
- 10 | Database Design Build an Entity Relationship Diagram (ERD) in Lucid Chart 00:06:21
- 11 | Database Table and Field Naming Convention 00:13:18
- 12 | Database: Introducing Normalization and 1NF 00:08:24
- 13 | Database: Multivalued Fields and How to Resolve Them 00:06:54
Student Reviews
( 5 Of 5 )
1 reviewYoutube
29-07-2024
Practical Database Design: Theory Into Practice Blog Schema
Out of all the tech subjects I have lectured on, databases or relational database systems have always been a subject with a "steep learning curve". Students tend to find it challenging, and it just takes much more effort to learn than other subjects.
To my surprise, I am one of many people who have observed this trend. There is, in fact, a small niche of research papers written on this topic.
So why is it so challenging? When I think of how we might overcome some challenges when learning databases instantly, I think of one fact that remains true, which goes back to even when I started learning database systems. There needed to be more examples or actual database design in practice.
This course aims to help support anyone starting their journey into relational database systems by establishing underpinning skills and concepts of database and database design by working through practical scenario reasoning and providing the rationale to design decisions. Nothing beats experience in most subjects. That is amplified in the realms of relational database development. With the knowledge and experience gained in the course in hand, I hope that on completion of this course, it will provide the scaffolding, underpinning knowledge to support your endeavours in the world of relational database development.