Currently Empty: $0.00
- Description
- Curriculum
- FAQ
- Reviews
Databases or relational database systems have always been a subject with a “steep learning curve”. Students tend to find it challenging, and learning takes much more effort 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.
Relational Database Underpinning Knowledge
Stage 1: Project Initiation
Stage 2: Establishing Entities and Attributes
Stage 3: Refining the Table Structures
-
8Introducing the Entities
-
9Identifying Significant Entities
-
10Project: Approach 1 – Formulate the Preliminary Entity List
-
11Project: Lucid Chart
-
12Project: Approach 1 – Associate Attributes with Entities
-
13Project: Approach 2 – Identifying Entities from a List of Attributes
-
14Illustrating a Database Design – Entity Relationship Diagram (ERD)
-
15Table and Field Naming Convention [19]
Stage 4: Establishing Keys
Stage 5: Dependency
Stage 6: Establishing Table Relationships
Stage 7: Normalization 3NF
Stage 8: Expanding the Database Design
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Stars 5
18
Stars 4
5
Stars 3
4
Stars 2
0
Stars 1
1