Overview
-
Modeling phenomena with a relational database is an invaluable skill in today’s big-data world. This course covers the fundamentals of the relational model for creating databases.
Syllabus
-
Introduction
- Organize data with the relational model
- What you should know
- A brief introduction to data storage
- E.F. Codd's relational model
- What the CRUD?
- Relations, tuples, tables, and records
- Develop a model of the real world
- Choose an ER design tool
- Design a table
- Attribute data types
- Use primary keys to identify records
- Object naming considerations
- Data constraints
- Create a unique constraint
- Required attributes and null values
- Define a default value
- Establish table indexes
- Add check constraints
- Relate tables with foreign keys
- Diagram a relationship
- Relationship optionality and cardinality
- One-to-many relationships
- One-to-one relationships
- Many-to-many relationships
- Self joins
- Cascade changes
- Relational database normal forms
- When not to normalize
- Convert the ER diagram to a database
- Data definition queries
- Data manipulation queries
- Write database select queries
- Create a database view
- Graph databases
- Document databases
- Next steps
