SQL & Relational Database Design Curriculum

Public curriculum preview for visitors and enrolled students. Use this page to evaluate module scope, outcomes, and learning path.

Download PDFBack to Course
Curriculum

SQL & Relational Database Design

Structured, hands-on learning path for SQL & Relational Database Design with detailed weekly outcomes and practical delivery.

Duration: 12 Weeks
Level: Intermediate
Study Time: 2 hours/week + labs
School: Hexadigitall Academy
12 WeeksIntermediateProject-Based

Welcome to SQL & Relational Database Design! 🎓

This curriculum for SQL & Relational Database Design follows a Bloom-aligned progression from practical foundations to measurable professional outcomes, with weekly evidence, labs, and portfolio outputs matched to intermediate expectations.

Each week advances from comprehension and application toward evaluation and creation, ensuring progressive learning and capstone readiness.

Your success is our priority. By the end, you will produce portfolio-ready artifacts and confidently explain your technical decisions. You will graduate with a professionally curated portfolio that demonstrates scope, depth, and delivery quality. You will graduate with a professionally curated portfolio that demonstrates scope, depth, and delivery quality. You will graduate with a professionally curated portfolio that demonstrates scope, depth, and delivery quality. You will graduate with a professionally curated portfolio that demonstrates scope, depth, and delivery quality.

Prerequisites

  • SQL proficiency: complex joins, window functions, query optimization, and performance analysis
  • Hands-on experience with data visualization tools (Tableau, Looker, Power BI, or similar)
  • Understanding of relational and dimensional modeling, fact/dimension tables, and star schema design
  • Familiarity with data quality frameworks: validation rules, anomaly detection, and completeness checks

Essential Resources

  • SQL optimization guides, query pattern library, and performance tuning references
  • Data modeling templates, dimensional design patterns, and quality framework schemas
  • Analytics cookbook with common calculations, transformations, and business metric definitions

Complementary Courses

Advanced Analytics & Machine Learning

Learn predictive modeling, statistical methods, and experimentation frameworks

Data Architecture & Engineering

Master ETL/ELT patterns, data warehouse design, and pipeline orchestration

Business Intelligence & Reporting

Deepen dashboard design, storytelling with data, and executive communication

Learning Roadmap

  • Early Weeks: SQL fundamentals, data modeling, and quality basics
  • Middle Weeks: Complex transformations, performance optimization, and BI tools
  • Late Weeks: Data governance, advanced analytics, and strategic reporting

Detailed Weekly Curriculum

Each week includes outcomes and practical lab work aligned to the curriculum structure.

Week 1

SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 1)

2 hours + labs
Learning Outcomes
  • Understand the principles of SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 1) and link them to course outcomes through progressive practical delivery milestones.
  • Apply SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 1) in a guided scenario using realistic tools, constraints, and quality gates.
  • Analyze trade-offs, risks, and decision points for SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 1), then record rationale for stakeholder review.
  • Document a portfolio-ready analytics quality workbook for SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 1) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 1) with schema/model decisions documented.
  • Run quality checks and performance tuning for SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 1) queries or transformations.
  • Publish SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 1) outputs to a dashboard/report with reproducible refresh steps.
Week 2

SQL & Relational Database Design: Color Systems and Accessibility (Sprint 1)

2 hours + labs
Learning Outcomes
  • Understand the principles of SQL & Relational Database Design: Color Systems and Accessibility (Sprint 1) and link them to course outcomes through progressive practical delivery milestones.
  • Apply SQL & Relational Database Design: Color Systems and Accessibility (Sprint 1) in a guided scenario using realistic tools, constraints, and quality gates.
  • Analyze trade-offs, risks, and decision points for SQL & Relational Database Design: Color Systems and Accessibility (Sprint 1), then record rationale for stakeholder review.
  • Document a portfolio-ready analytics quality workbook for SQL & Relational Database Design: Color Systems and Accessibility (Sprint 1) with measurable success criteria and next actions.
Lab Exercise
  • Design and apply role/permission structure for SQL & Relational Database Design: Color Systems and Accessibility (Sprint 1) with least-privilege enforcement.
  • Implement approval and audit workflow for privileged operations in SQL & Relational Database Design: Color Systems and Accessibility (Sprint 1).
  • Validate access paths for SQL & Relational Database Design: Color Systems and Accessibility (Sprint 1) using positive/negative test cases and break-glass controls.
Week 3

SQL & Relational Database Design: Typography and Readability (Sprint 1)

2 hours + labs
Learning Outcomes
  • Understand the principles of SQL & Relational Database Design: Typography and Readability (Sprint 1) and link them to course outcomes through progressive practical delivery milestones.
  • Apply SQL & Relational Database Design: Typography and Readability (Sprint 1) in a guided scenario using realistic tools, constraints, and quality gates.
  • Analyze trade-offs, risks, and decision points for SQL & Relational Database Design: Typography and Readability (Sprint 1), then record rationale for stakeholder review.
  • Document a portfolio-ready analytics quality workbook for SQL & Relational Database Design: Typography and Readability (Sprint 1) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for SQL & Relational Database Design: Typography and Readability (Sprint 1) with schema/model decisions documented.
  • Run quality checks and performance tuning for SQL & Relational Database Design: Typography and Readability (Sprint 1) queries or transformations.
  • Publish SQL & Relational Database Design: Typography and Readability (Sprint 1) outputs to a dashboard/report with reproducible refresh steps.
Week 4

SQL & Relational Database Design: Layouts and Composition (Sprint 1)

2 hours + labs
Learning Outcomes
  • Understand the principles of SQL & Relational Database Design: Layouts and Composition (Sprint 1) and link them to course outcomes through progressive practical delivery milestones.
  • Apply SQL & Relational Database Design: Layouts and Composition (Sprint 1) in a guided scenario using realistic tools, constraints, and quality gates.
  • Analyze trade-offs, risks, and decision points for SQL & Relational Database Design: Layouts and Composition (Sprint 1), then record rationale for stakeholder review.
  • Document a portfolio-ready analytics quality workbook for SQL & Relational Database Design: Layouts and Composition (Sprint 1) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for SQL & Relational Database Design: Layouts and Composition (Sprint 1) with schema/model decisions documented.
  • Run quality checks and performance tuning for SQL & Relational Database Design: Layouts and Composition (Sprint 1) queries or transformations.
  • Publish SQL & Relational Database Design: Layouts and Composition (Sprint 1) outputs to a dashboard/report with reproducible refresh steps.
Week 5

SQL & Relational Database Design: Interaction Patterns and Components (Sprint 1)

2 hours + labs
Learning Outcomes
  • Apply the principles of SQL & Relational Database Design: Interaction Patterns and Components (Sprint 1) and link them to course outcomes through progressive practical delivery milestones.
  • Analyze SQL & Relational Database Design: Interaction Patterns and Components (Sprint 1) in a guided scenario using realistic tools, constraints, and quality gates.
  • Evaluate trade-offs, risks, and decision points for SQL & Relational Database Design: Interaction Patterns and Components (Sprint 1), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for SQL & Relational Database Design: Interaction Patterns and Components (Sprint 1) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for SQL & Relational Database Design: Interaction Patterns and Components (Sprint 1) with schema/model decisions documented.
  • Run quality checks and performance tuning for SQL & Relational Database Design: Interaction Patterns and Components (Sprint 1) queries or transformations.
  • Publish SQL & Relational Database Design: Interaction Patterns and Components (Sprint 1) outputs to a dashboard/report with reproducible refresh steps.
Week 6

SQL & Relational Database Design: Design Systems and Documentation (Sprint 1)

2 hours + labs
Learning Outcomes
  • Apply the principles of SQL & Relational Database Design: Design Systems and Documentation (Sprint 1) and link them to course outcomes through progressive practical delivery milestones.
  • Analyze SQL & Relational Database Design: Design Systems and Documentation (Sprint 1) in a guided scenario using realistic tools, constraints, and quality gates.
  • Evaluate trade-offs, risks, and decision points for SQL & Relational Database Design: Design Systems and Documentation (Sprint 1), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for SQL & Relational Database Design: Design Systems and Documentation (Sprint 1) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for SQL & Relational Database Design: Design Systems and Documentation (Sprint 1) with schema/model decisions documented.
  • Run quality checks and performance tuning for SQL & Relational Database Design: Design Systems and Documentation (Sprint 1) queries or transformations.
  • Publish SQL & Relational Database Design: Design Systems and Documentation (Sprint 1) outputs to a dashboard/report with reproducible refresh steps.
Week 7

SQL & Relational Database Design: Usability Testing and Iteration (Sprint 1)

2 hours + labs
Learning Outcomes
  • Apply the principles of SQL & Relational Database Design: Usability Testing and Iteration (Sprint 1) and link them to course outcomes through progressive practical delivery milestones.
  • Analyze SQL & Relational Database Design: Usability Testing and Iteration (Sprint 1) in a guided scenario using realistic tools, constraints, and quality gates.
  • Evaluate trade-offs, risks, and decision points for SQL & Relational Database Design: Usability Testing and Iteration (Sprint 1), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for SQL & Relational Database Design: Usability Testing and Iteration (Sprint 1) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for SQL & Relational Database Design: Usability Testing and Iteration (Sprint 1) with schema/model decisions documented.
  • Run quality checks and performance tuning for SQL & Relational Database Design: Usability Testing and Iteration (Sprint 1) queries or transformations.
  • Publish SQL & Relational Database Design: Usability Testing and Iteration (Sprint 1) outputs to a dashboard/report with reproducible refresh steps.
Week 8

SQL & Relational Database Design: Portfolio Packaging and Storytelling (Sprint 1)

2 hours + labs
Learning Outcomes
  • Apply the principles of SQL & Relational Database Design: Portfolio Packaging and Storytelling (Sprint 1) and link them to course outcomes through progressive practical delivery milestones.
  • Analyze SQL & Relational Database Design: Portfolio Packaging and Storytelling (Sprint 1) in a guided scenario using realistic tools, constraints, and quality gates.
  • Evaluate trade-offs, risks, and decision points for SQL & Relational Database Design: Portfolio Packaging and Storytelling (Sprint 1), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for SQL & Relational Database Design: Portfolio Packaging and Storytelling (Sprint 1) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for SQL & Relational Database Design: Portfolio Packaging and Storytelling (Sprint 1) with schema/model decisions documented.
  • Run quality checks and performance tuning for SQL & Relational Database Design: Portfolio Packaging and Storytelling (Sprint 1) queries or transformations.
  • Publish SQL & Relational Database Design: Portfolio Packaging and Storytelling (Sprint 1) outputs to a dashboard/report with reproducible refresh steps.
Week 9

SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 2)

2 hours + labs
Learning Outcomes
  • Analyze the principles of SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 2) and link them to course outcomes through progressive practical delivery milestones.
  • Evaluate SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 2) in a guided scenario using realistic tools, constraints, and quality gates.
  • Create trade-offs, risks, and decision points for SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 2), then record rationale for stakeholder review.
  • Defend a portfolio-ready analytics quality workbook for SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 2) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 2) with schema/model decisions documented.
  • Run quality checks and performance tuning for SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 2) queries or transformations.
  • Publish SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 2) outputs to a dashboard/report with reproducible refresh steps.
Week 10

SQL & Relational Database Design: Color Systems and Accessibility (Sprint 2)

2 hours + labs
Learning Outcomes
  • Analyze the principles of SQL & Relational Database Design: Color Systems and Accessibility (Sprint 2) and link them to course outcomes through progressive practical delivery milestones.
  • Evaluate SQL & Relational Database Design: Color Systems and Accessibility (Sprint 2) in a guided scenario using realistic tools, constraints, and quality gates.
  • Create trade-offs, risks, and decision points for SQL & Relational Database Design: Color Systems and Accessibility (Sprint 2), then record rationale for stakeholder review.
  • Defend a portfolio-ready analytics quality workbook for SQL & Relational Database Design: Color Systems and Accessibility (Sprint 2) with measurable success criteria and next actions.
Lab Exercise
  • Design and apply role/permission structure for SQL & Relational Database Design: Color Systems and Accessibility (Sprint 2) with least-privilege enforcement.
  • Implement approval and audit workflow for privileged operations in SQL & Relational Database Design: Color Systems and Accessibility (Sprint 2).
  • Validate access paths for SQL & Relational Database Design: Color Systems and Accessibility (Sprint 2) using positive/negative test cases and break-glass controls.
Week 11

SQL & Relational Database Design: Typography and Readability (Sprint 2)

2 hours + labs
Learning Outcomes
  • Analyze the principles of SQL & Relational Database Design: Typography and Readability (Sprint 2) and link them to course outcomes through progressive practical delivery milestones.
  • Evaluate SQL & Relational Database Design: Typography and Readability (Sprint 2) in a guided scenario using realistic tools, constraints, and quality gates.
  • Create trade-offs, risks, and decision points for SQL & Relational Database Design: Typography and Readability (Sprint 2), then record rationale for stakeholder review.
  • Defend a portfolio-ready analytics quality workbook for SQL & Relational Database Design: Typography and Readability (Sprint 2) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for SQL & Relational Database Design: Typography and Readability (Sprint 2) with schema/model decisions documented.
  • Run quality checks and performance tuning for SQL & Relational Database Design: Typography and Readability (Sprint 2) queries or transformations.
  • Publish SQL & Relational Database Design: Typography and Readability (Sprint 2) outputs to a dashboard/report with reproducible refresh steps.
Week 12

SQL & Relational Database Design: Layouts and Composition (Sprint 2)

2 hours + labs
Learning Outcomes
  • Analyze the principles of SQL & Relational Database Design: Layouts and Composition (Sprint 2) and link them to course outcomes through progressive practical delivery milestones.
  • Evaluate SQL & Relational Database Design: Layouts and Composition (Sprint 2) in a guided scenario using realistic tools, constraints, and quality gates.
  • Create trade-offs, risks, and decision points for SQL & Relational Database Design: Layouts and Composition (Sprint 2), then record rationale for stakeholder review.
  • Defend a portfolio-ready analytics quality workbook for SQL & Relational Database Design: Layouts and Composition (Sprint 2) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for SQL & Relational Database Design: Layouts and Composition (Sprint 2) with schema/model decisions documented.
  • Run quality checks and performance tuning for SQL & Relational Database Design: Layouts and Composition (Sprint 2) queries or transformations.
  • Publish SQL & Relational Database Design: Layouts and Composition (Sprint 2) outputs to a dashboard/report with reproducible refresh steps.

Capstone Projects

Project 1: SQL & Relational Database Design Foundation Build

Deliver a concrete foundation implementation covering the first phase of the curriculum.

  • Implement and validate SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 1).
  • Integrate SQL & Relational Database Design: Color Systems and Accessibility (Sprint 1) with reusable workflow standards.
  • Publish evidence for SQL & Relational Database Design: Typography and Readability (Sprint 1) with test and quality artifacts.

Project 2: SQL & Relational Database Design Integrated Systems Build

Combine mid-program competencies into a production-style integrated workflow.

  • Build an end-to-end flow around SQL & Relational Database Design: Interaction Patterns and Components (Sprint 1) and SQL & Relational Database Design: Design Systems and Documentation (Sprint 1).
  • Add controls, observability, and rollback paths for reliability.
  • Document architecture decisions and trade-offs tied to SQL & Relational Database Design: Usability Testing and Iteration (Sprint 1).

Project 3: SQL & Relational Database Design Capstone Delivery

Ship a portfolio-ready capstone with measurable outcomes and stakeholder-ready presentation.

  • Deliver a complete implementation centered on SQL & Relational Database Design: Design Principles and Visual Hierarchy (Sprint 2).
  • Validate readiness for SQL & Relational Database Design: Color Systems and Accessibility (Sprint 2) using objective acceptance checks.
  • Present final defense and roadmap based on SQL & Relational Database Design: Typography and Readability (Sprint 2) outcomes.