Rullst AcademyRullst Academy/Learning paths
← Back to the catalog
Building · COMPLETE PATH AVAILABLE

Databases and SQL I

Build a verifiable catalog: tables, queries, relationships, transactions and recovery with SQLite.

12 lessons~202 min600 XP
Start this track

Try the first lesson without an account. Sign in to save your achievements.

What you will discover

  • Model records and explain keys, constraints and relationships.
  • Query, change and summarize fictional data with tests.
  • Solve a variation and rehearse restoring a backup.

Is this track for you?

For learners who can read tables and files; basic Python helps. Choose your system’s setup if needed.

The time is an estimate, not a deadline. Take breaks, use hints and try again whenever you need.

How can I tell what I learned?

Use the objectives and challenge below for reflection or a conversation with someone who can help. This is guided self-assessment: it sends no answers, awards no XP and does not automatically verify independence.

In Building, integrate a small original solution, test an unseen variation, record limits and seek review when possible. Reproducing the example is a start; explaining and adapting develops independence.

Your transfer challenge

Adapt to fictional hobby or workshop materials. Define a new question, query, error and recovery. Record help received and independent work.

Keep evidence: prediction, attempt, result, an original change and what you still cannot explain. Seek feedback when possible; if studying alone, return later without copying and compare attempts.

Try again another time

After a break, explain the idea without opening the solution and try a different example. Compare with your first attempt: what can you do independently, and where do you need a hint? You may write, speak or draw; choose a way to check the same idea. Record help received, including AI, and revisit the part you need. There is no universal deadline or extra XP for this record.

Completions and XP record Rullst Academy assessments. An introductory track can help everyday life and prepare further study; alone it does not prove complete mastery or professional readiness. Level indicates depth, not age.

At your own pace

Your path, step by step

One idea at a time: understand, experiment and check your prediction.

0 / 12
  1. 01A catalog to understand12 min · 50 XPYour next discovery
  2. 02Model with rules16 min · 50 XPUp ahead
  3. 03Query with intent14 min · 50 XPUp ahead
  4. 04Filter missing values carefully16 min · 50 XPUp ahead
  5. 05Insert and respect constraints16 min · 50 XPUp ahead
  6. 06Change without losing the target16 min · 50 XPUp ahead
  7. 07Join without duplicating conclusions18 min · 50 XPUp ahead
  8. 08Summarize and count carefully18 min · 50 XPUp ahead
  9. 09Transactions and decisions18 min · 50 XPUp ahead
  10. 10Inputs are data16 min · 50 XPUp ahead
  11. 11Save and test recovery18 min · 50 XPUp ahead
  12. 12Mission: a verifiable catalog24 min · 50 XPUp ahead

Rullstpetbot

AI can make mistakes. Check the lesson material.