Practical Database Design - Blog Schema Normalization to 3NF
What you'll learn
- Build a database design from a given set of requirements
- Determine a set of prelimiary entities and attributes to start a database design
- Normalise a database design into 1NF taking into consideration multivalued and miltipart fields
- Establish table candidate and primary keys
- Normalise a database design into 2NF taking into consideration partial key dependencies
- Identify multiple types of table relationships and define relationships between tables
- Normalise a database design into 3NF taking into consideration transitive dependencies
- Develop database design solutions to common features of a blog application
Requirements
- No Prior experience needed but would be advantageous
Description
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.
Who this course is for:
- Beginners, Developers, Students, and Enthusiasts new to relational database design
Instructor
- 4.4 Instructor Rating
- 1,562 Reviews
- 10,699 Students
- 26 Courses
Very Academy is a personal project where I create programming tutorials and courses to help people learn practical skills in Computer Science and Technology.
My goal is to make learning more accessible and enjoyable, especially for those just starting out or looking to grow their developer skills step by step. I focus on real-world topics and hands-on projects that you can actually use in your work or personal learning.
I’m always working on new content and improving existing courses based on your feedback. Your learning experience matters a lot to me, and I truly appreciate you being part of this journey.
Thanks for checking out Very Academy — I hope you enjoy the courses and find them genuinely useful in your learning path. More great stuff coming soon!