# Ultimate Edition Feature Guide

This document explains the complete feature set in the Ultimate edition.

---

## 1. Free-for-learners access model
Users of the platform can learn and practise without being forced into a paid AI API cost structure.

### Why this matters
The platform is intentionally built to widen access rather than restrict it.

---

## 2. Multi-page learning suite
The Ultimate edition includes dedicated pages for:
- home
- course catalog
- curriculum
- curriculum maps
- playground
- practice
- capstones
- notes
- teacher dashboard
- certificate generation
- certificate validation
- onboarding
- testimonials
- institutions
- demo portal
- admin
- optional Supabase auth and dashboard
- about

### Why this matters
This feels more like a real educational product suite than a single SQL page.

---

## 3. Rich curriculum progression
The suite now includes 30 modules.

### Why this matters
The learner can move from foundations to advanced analytics, feature engineering, pedagogy, governance, and institutional delivery thinking.

---

## 4. Course-track architecture
The course catalog helps different learner categories follow clearer routes.

### Why this matters
A beginner analyst, a BI learner, a data scientist, and an institutional facilitator do not all need the same emphasis.

---

## 5. Live SQL playground
Learners can run SQL in the browser via SQL.js.

### Why this matters
No separate database installation is required for the starter learning workflow.

---

## 6. Challenge mode and solution checking
Learners can attempt structured tasks and compare output with the expected solution.

### Why this matters
This supports deliberate practice instead of passive reading only.

---

## 7. Schema explorer and query packs
The system explains the schema and provides starter SQL patterns.

### Why this matters
This reduces blank-screen anxiety and helps learners reason before querying.

---

## 8. Lesson note library
The note library now includes 20 note files.

### Why this matters
It supports:
- revision
- teacher reuse
- downloadable lesson support
- institutional delivery

---

## 9. Teacher dashboard
The teacher page supports:
- weekly delivery pacing
- assignment pack view
- exportable teacher pack
- linkage to notes and certificate flow

### Why this matters
It turns the platform into a teaching delivery tool, not just a learner utility.

---

## 10. Certificate generation page
The certificate page supports:
- certificate preview
- browser print / save as PDF
- local record saving for validation

### Why this matters
Completion evidence is useful in cohorts, academies, and institutional contexts.

---

## 11. Certificate validation page
The validation page checks:
- built-in demo records
- locally saved records in the same browser

### Why this matters
Trust and legitimacy improve when certificates can be verified.

---

## 12. Onboarding page
The onboarding page helps institutions gather deployment needs.

### Why this matters
It makes rollout conversations more structured without needing paid form infrastructure.

---

## 13. Testimonials page
The testimonials page provides social proof.

### Why this matters
Trust helps learners, teachers, and institutions adopt the platform more confidently.

---

## 14. Curriculum maps page
SVG maps explain:
- overall roadmap
- course tracks
- institutional rollout

### Why this matters
Visual structure improves communication and planning.

---

## 15. Institutions page
The institutions page explains rollout, governance, free access policy, and enterprise readiness.

### Why this matters
It helps school leaders and programme operators understand how to use the platform in organised settings.

---

## 16. Demo portal and admin mode
The system still includes a browser-based portal and admin layer.

### Why this matters
This keeps the suite usable in low-cost static deployments.

---

## 17. Optional Supabase auth mode
For stronger learner identity, the suite can optionally use the Supabase free tier.

### Why this matters
It provides a real-auth upgrade path without introducing paid AI API cost.

---

## 18. Launch and brand assets
The suite includes visual communication assets.

### Why this matters
A good platform should also be easy to explain, launch, and present.

---

## Final summary
The Ultimate edition is the most complete version in the workspace because it combines:
- learning depth
- teaching support
- validation
- communication assets
- rollout structure
- free access for learners
- optional free-tier identity upgrade