Relational Databases Essential Training

Introduction

• Organize data with the relational model
• What you should know
• Exploring the code challenge environment

1. Get to Know Relational Databases

• A brief introduction to data storage
• E.F. Codd's relational model
• What the CRUD?
• Relations, tuples, tables, and records

2. Entity Relationship Diagrams

• 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

3. Data Integrity and Validation

• Data constraints
• Create a unique constraint
• Required attributes and null values
• Define a default value
• Establish table indexes
• Add check constraints

4. Relationships

• 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

5. Normalization

• Relational database normal forms
• When not to normalize

6. Structured Query Language

• Convert the ER diagram to a database
• Data definition queries
• Solution: Create tables with DDL commands
• Data manipulation queries
• Solution: Add data with DML commands
• Write database select queries
• Solution: Query data in a database
• Create a database view

7. Beyond the Relational Model

• Graph databases
• Document databases

Conclusion

• Next steps