Database Design Fundamentals for Software Engineers Course Course

Module 1: Introduction to Databases

⏳ ~1 hour

• Topics: Definition of databases, limitations of file-based systems, and core database properties.

• Hands-on: Create basic DB examples and interact with console modules to explore dataset organization.

Module 2: Entity-Relationship Modeling

⏳ ~1.5 hours

• Topics: ER model constructs: entity types, relationships, attributes, keys, weak entities, cardinality.

• Hands-on: Design sample ER diagrams and map exercises to reinforce modeling principles.

Module 3: Relational Data Model & Schema Design

⏳ ~1 hour

• Topics: Translate ER models to relational schemas, apply naming conventions, choose primary and foreign keys.

• Hands-on: Create relational tables from ER diagrams and implement constraints in the editor.

Module 4: Normalization Techniques

⏳ ~1.5 hours

• Topics: Study functional dependencies and apply 1NF, 2NF, and 3NF normalization rules.

• Hands-on: Normalize unstructured schemas through interactive drills with community cases.

Module 5: Basic SQL Operations

⏳ ~1 hour

• Topics: Execute CREATE TABLE, INSERT, UPDATE, DELETE, and simple SELECT queries.

• Hands-on: Use SQL to manipulate and query tables built in earlier modules.

Module 6: Design Best Practices & Integrity

⏳ ~1 hour

• Topics: Enforce referential integrity, use constraints, and discuss design trade-offs and decisions.

• Hands-on: Implement constraints in schemas and analyze their effects on sample data operations.

Module 7: Case Study & Quiz

⏳ ~30 minutes

• Topics: Apply full design cycle on a mini project: ER modeling, normalization, and SQL implementation.

• Hands-on: Complete a capstone design exercise and assessment quiz to consolidate learning.

Get certificate