Oracle SQL Tutorial - Relationships and Primary and Foreign Keys - Database Design Primer
Caleb Curry via YouTube
Overview
Learn about database design fundamentals in Oracle SQL, focusing on relationships, primary keys, and foreign keys. Explore entity-attribute relationships, one-to-one, one-to-many, and many-to-many relationships, and understand how to implement them using primary and foreign keys. Gain practical knowledge on identifying entities, attributes, and designing basic database structures. This tutorial provides essential insights for beginners and intermediate learners looking to strengthen their understanding of relational database concepts and their implementation in Oracle SQL.
Syllabus
Intro
Entities and Attributes
How do you know if something is an entity
Entity and Attributes
Basic Database Design
OnetoOne Relationships
Attribute Relationships
OnetoMany Relationships
ManytoMany Relationships
Primary and Foreign Keys
Database Relationships
Taught by
Caleb Curry