Database mastery from scratch, built entirely on an Android phone.
SQLite + Termux. 12 modules. 98 lessons. The second pillar of the full‑stack empire.
- Termux – terminal emulator
- SQLite (pre‑installed in Termux via
pkg install sqlite) - Python 3 +
sqlite3(for integration modules) - Acode – code editor with Markdown preview
Every practice sheet now includes a three‑level challenge system with built‑in hints.
- Easy – core concept, step‑by‑step.
- Medium – apply the concept with variations.
- Hard – solve a novel problem without direct instructions.
- Hints – progressive clues available on‑demand by typing
:hint. - No internet, no servers – the engine runs entirely in Termux using Python and SQLite.
After completing all 12 modules, you’ll build a complete, command‑line Enterprise Resource Planning system that integrates inventory, sales, human resources, and reporting.
The capstone starter script and full brief are in 05.Final Capstone/.
It proves you can architect a real‑world, multi‑table database application entirely on a phone.
Upon finishing the course and capstone, run the certificate generator:
python generate_certificate.pyAnswer the prompts and your own Harvard‑style diploma will be saved as GRADUATION.md.
Open it in Acode’s preview to see your name in gold. Frame it, share it, or print it – it’s your proof of world‑class database engineering mastery.
| Module | Topic |
|---|---|
| 01 | Foundations & First Queries |
| 02 | Reading & Filtering Data |
| 03 | Aggregation & Grouping |
| 04 | Joins & Unions |
| 05 | Subqueries & Advanced Filtering |
| 06 | Modifying Data & Schema |
| 07 | Date, Time & Built‑in Functions |
| 08 | Conditional Logic & Views |
| 09 | Python + SQLite Integration |
| 10 | Security, Optimization & Best Practices |
| 11 | Real‑World Projects |
| 12 | Beyond SQLite & Next Steps |
| 🏛️ | Final Capstone – Imperial ERP |
| 🎓 | Graduation Certificate |
- “Two bricks at a time” – never overwhelm, never skip.
- Phone‑first. Every command typed manually.
- Enterprise‑grade examples – banking, logistics, data.
- Zero fluff. Instant feedback. Learn by doing.
01.SQLPhone PLUGIN/– Setup guides & engine documentation02.SQLPhone SYLLABUS/– Full curriculum03.SQLPhone COURSE/– Lesson sheets, practice coaches, review challenges, debugging corners04.SQLPhone NOTES/– Cheat sheets and quick refs05.Final Capstone/– Imperial ERP project brief and starter scriptgenerate_certificate.py– Personalized graduation diploma generator