Design a Task Tracker Database (Free ERD + Docs)
The database design behind a task tracking tool: projects, tasks, sprints, comments and time logs, fully documented.
From the Database Star YouTube channel - 100k+ subscribers
- The complete ERD: see the whole database at a glance
- Online documentation for every table and column
- Explore it at your own pace, then build your own version
Free. Instant access. No spam, unsubscribe anytime.
What's Inside the Online Documentation
Full ERD
The actual full ERD (Entity Relationship Diagram) from the video, for a Task Tracking Tool
Table Explanation
An explanation of the purpose of each table, so you know what it is for
SQL Generator
Easily generate SQL scripts to create the sample tables in your own database
Hi, I'm Ben.
I’ve been teaching SQL and database design on Database Star since 2016, and on YouTube I help over 100,000 people learn it. I’m an Oracle SQL Certified Expert with 20+ years of working with databases. This guide is the companion to my task tracker video: the same design, documented in full so you can study it and build your own.
Ready to design your own task tracking database?
Get the ERD and the full database documentation. Free, straight to your inbox.
Free. Instant access. No spam, unsubscribe anytime.
Here's what others say...
"I’ve watched a few of your videos now. Pure gold! And your PDF’s from your website are very useful. Thank you for taking the time and effort to create these."
Adrian Tregoning
"Your videos and website are a great resource for the database developer community."
@sdmagic
"They were really great resources for me to learn/review key concepts during my job search, which I was fortunate enough to land!"
@Kevin-kh7xv