Relational Database Design: A Data Modeling Workshop

Master the Fundamentals of Data Modeling with Relational Databases

This course provides a solid foundation in data modeling using relational databases. You'll learn how to translate real-world business needs into effective database structures through practical application. This isn't about database creation; it's about mastering the crucial data modeling process.

What sets this course apart? You'll gain valuable data modeling skills by doing. We'll work through hands-on projects with two imaginary clients, interpreting their business requirements and creating entity relationship diagrams (ERDs) to meet their needs. You'll also learn how to adapt and modify these diagrams as their businesses evolve.

Here's a detailed look at what you'll learn:

• Introduction to Relational Databases: Understand the core components of relational databases, including tables, primary keys, and foreign keys.
• Database Design Principles: Learn about proper database design, avoiding data anomalies and redundant data. We'll cover normalization techniques (First, Second, and Third Normal Forms) and understand the pitfalls of over-normalization.
• Entity Relationship Diagrams (ERDs): Develop proficiency in creating entity relationship diagrams to represent entities and their attributes. You'll learn to model entity relationships and handle complex scenarios like many-to-many relationships.
• Hands-on Data Modeling Projects:
  • Project 1: Downtown Floral: Build an initial data model based on specific business requirements and then update it iteratively to reflect changing business needs.
  • Project 2: Best Tech U: Develop an initial data model and refine it through multiple rounds of updates based on evolving business requirements.

Don't let the technical terms overwhelm you! We'll break down complex concepts into manageable steps. Get ready to confidently translate business requirements into robust and scalable data models.