loans.kit_id refers to kits.id: many loans to one material. An enabled FK guarantees the material exists, not that loan totals fit stock. That rule requires additional logic.
2
JOIN combines rows through ON. INNER JOIN shows matches. Material 1 has two loans and appears twice: that is model multiplicity. A wrong condition may multiply unrelated rows.
3
LEFT JOIN keeps materials without loans, with NULL on the right. To keep all materials and match only open loans, put l.returned IS NULL in ON. WHERE may remove rows after joining; also test a material with only returned loans.
4
Aliases k and l show column origins. Predict why Nova has a null loan_id. Replace LEFT JOIN with JOIN, run and explain what disappeared.
Your data workbench
Our model: kits.id ← loans.kit_id. One material can have many loans; names may repeat. We use fictional data only.
Predict before opening the reference. It shows verified output from the original example, not execution of your text. Run your changes with the kit on your computer.
-- Join without duplicating conclusions
SELECT k.id, k.label, l.id AS loan_id FROM kits AS k LEFT JOIN loans AS l ON l.kit_id=k.id ORDER BY k.id, l.id;
Run the command in the extracted folder’s terminal. Use python3 on macOS/Ubuntu or py if that is your Windows launcher. Every run starts in memory; read README.md for saving files and recovery practice.
The editor saves your .sql draft in this browser. Download it and replace lesson.sql in the kit; for the final project, availability.sql. The ZIP remains the original template. GitHub publishing sends only the confirmed file, without executing SQL or sending a database.
Download the lesson example and a workbook for your notes. The ZIP includes a guide to organizing activities in one or more repositories. Publishing is optional; eligible accounts can also use the GitHub upload button.
Your file for this lesson
Edit the example or record what you learned. This space does not run code or grade answers. The draft is saved only in this browser, separately per account; you choose when to download or upload to GitHub.
The example may be only a snippet or outline. Changing the extension does not make it a complete program. The activity ZIP contains starting material; the edited-file button downloads your text.
Your text will be saved in this browser when you edit it. On a shared computer, clear your drafts when finished.
As a visitor, this draft belongs to the browser and will not transfer to an account. Download a copy before signing in or creating an account.
Direct upload accepts up to 8 KiB of text in one file. Use downloads and the manual guide for projects with multiple files.
Save to my GitHub
Choose an authorized personal repository. Each upload creates a new file in an activity folder; existing content is preserved. You decide whether to use one repository or different destinations.
Hello! I’m Rullstpetbot, Rullst Academy’s robot crab. Let’s find your next step. Choose a hint below.Reviewed guidanceAI answer · check the lessonYouReference material supplied to the tutorPreparing an explanation…Answer available in the conversation.Conversation cleared from this page.AI is available. Reviewed hints are also here.Reviewed guidance is ready. AI chat is not connected in this environment yet.In this version, child or restricted accounts use guided help. AI chat requires an adult account with confirmed email.Use reviewed guidance. To chat with AI when available, sign in with an adult account and confirmed email.Help for this lesson follows your account permissions and progress. You can use “Explore the Academy” meanwhile.Read the notice and check the option before sending to AI.The usage limit has been reached. Continue with reviewed hints and try again later.I couldn't get an answer now. Your question is still in the field; use reviewed guidance or try later.Use a short question of up to 400 characters, without personal data.ExpandBack to panelChoose a track in the catalog and start with its first lesson. Read the goal, try the activity and check the feedback. Journeys suggest entry points; appearance does not define ability. Sign in to save progress. Child accounts follow guardian controls. After completing a track, check its downloadable material: some projects use Rust/Rullst and others are activity workbooks. Each download's README explains its format. Visit the learner guide to explore the features.Here we use reviewed mission hints, without sending messages to AI.One more hintReview the last hintGive me a hintExplore Rullst Academy
Let’s work it out togetherTry it out. Create an account to save achievements.Loading your journey…Couldn't connect right now. Your answer is still here. Try again to save.We couldn't save right now. Try again in a moment.Too many attempts in a short time. Wait a few minutes and try again.Use a nickname of 3 to 24 unaccented letters, numbers or _.Use at least 10 characters. If it's very long, shorten to at most 72 bytes (accented letters may use more than one).The passwords need to match.That nickname is already in use. Choose another or sign in.We couldn't match those details. Check your login details and password or code.Nickname3 to 24 unaccented letters, numbers or _.Email or nicknameUse your account email or login nickname. Learners without an email use their nickname.Open Rullst Academy at its configured address and try again.Review the exercise values and try again.Complete the previous lesson to save this discovery. You can already read the explanation.Sign inCreate accountRecover accessPasswordWell done! Let's understand what you discovered.This achievement is already saved. Reviewing is part of learning too!First play: tap an answer. Then choose what the app did.Choose a title of 3 to 40 characters and think: did you change the text or the computer?Count the four stars slowly. The game compares your choice with the answer we stored.Look for /jogar. The route connects that path to the game's response.Let's do it together: use 2 correct answers and 5 points per answer. Count 5 + 5. Write 10 for the total.For a correct answer, celebrate. For an incorrect one, invite another try.Think of the player: first they see the question, then answer, and last see the result.Use a title of at least 3 characters, a question of 6 or more and two different options. Test both answers, predict the scores and answer the server review question.You did it! Create an account and repeat this little discovery to keep it in your journey.Progress saved in your accountCompletedYour next discoveryUp aheadYou've practiced today. Take a break or explore more!One lesson is already a good achievement. Return when you can; your progress stays here.You earned 10 XP for today’s visit!Today’s 10 XP are already in your account.We could not confirm the bonus right now. Your account still works; try again.The bonus is paused while the account has a restriction or a guardian pause.Retry bonus confirmationYou did it!Not yet. Look at the question again and try another answer.Choose an answer.You're on the home page. Where could the game be?In this preview, /jogar opens the quiz. In your downloadable project, a Rullst route does this on the server.You opened help. To play, try another path.Both paths have been tested.Points for a correct answerPoints for an incorrect answerSaving…Listen to the explanationStop readingRead-aloud is unavailable in this browser. The text is right below.Password changed. Save the new code and sign in again. The previous code no longer works.You're signed in. Your achievements on this path are saved on the server.Check my discoveryI've saved my codeShow the questionReceive the answerShow the resultUse 3–24 letters, numbers or _ in the address.This address is reserved. Choose another nickname.Check the nickname and language. The nickname must fit on one line and be at most 40 characters.This address is already reserved by someone else. Choose another.You have already reserved five addresses. Reuse one of your previous addresses.Profile published. Your link is ready to share.Preferences saved. Your profile is private.Link copied!Copy this address:Participation saved. Your completed achievements can appear on the leaderboard.You are off the leaderboard. Your progress has been preserved.Publish your profile before joining the leaderboard. You can keep learning with a private profile.At this stage, only people aged 18 or over can join the leaderboard.File prepared for download. Keep it somewhere safe.Your account was deleted from the active database and its sessions were ended.Confirm that you want to delete the account before continuing.This account's drafts were removed from this browser.The browser did not allow draft removal. Use your browser settings to remove this site's data.Rullst Academy preview: try the first lesson for free. New registrations are paused while we complete privacy and guardian authorization flows.Choose…13 to 1513 to 17 years16 to 1718 or olderChoose how to sign in or create your account, then personalize your nickname and profile. Under-18s need an account created by their guardian.Registered accountsCompleted lessonsThis area is for administrators only.Email service not configuredEmail service configuredAn overview to keep track of the Rullst Academy.Privacy requests are handled through the Rullst Academy’s operational procedure. This dashboard shows totals only.Registration pausedRegistration openOpen privacy requestsPlatform statusAdministrationI declare that I am at least 18.What is your age group?SelectAnsweredAppeal a responseRecover by emailChange passwordUse at least 10 characters. After saving, sign in again with your new password; previous sessions will end.Account created. The learner can now sign in with the chosen nickname and password.Learner's passwordLearner's login nickname (avoid real names)Choose your new passwordMake a complaintWe could not connect this registration automatically. Use its existing sign-in method or confirm the account email first. No account was replaced.Linking requires an adult account with confirmed email and no processing restriction.This link already exists or the external account belongs to another Rullst Academy account. No accounts were merged or replaced.You cancelled authorization. Your account was not changed.Unlink GitHubThis address still needs Academy email confirmation. Open the link you received or request another using the email confirmation option.For this registration, choose the Google account with the same email entered here and verified by Google. Start registration again to correct the address.We could not confirm this sign-in. Try again or use another sign-in method.Unlink GoogleContinue with GoogleIf you choose Google sign-in, Google processes your authentication. We request only basic identity (openid) and email. We use the returned address to check registration. Gmail and Google Workspace with verified identity and email can activate registration and sign you in without another confirmation link. We can also connect an unrestricted existing adult account whose confirmed email matches the address validated by Google, keeping the account and its progress. Other addresses used with Google require Academy email confirmation. We store your stable Google account identifier, its link to your local account and the linking date. We do not store Google tokens, photos or names, or request Gmail, Drive, contacts or calendar access. Email matching alone, without these checks, does not connect accounts. Google sign-in does not prove age or parental consent. Unlinking revokes local access; you can also remove authorization from your Google Account connections page. Google processes data, including internationally, under its policy and the safeguards described in this notice.Sign up with GoogleUse the email of the Google account you will choose. With verified Gmail or Google Workspace, you are signed in on return: no new password or extra confirmation link. An eligible existing account with that confirmed email will be connected, keeping your progress. Other emails used with Google may require confirmation.Sign in with GoogleLink an external account to sign in on future visits. Available to adult accounts with confirmed email. Your Rullst Academy password keeps working.Sign in with the Google or GitHub account you used to register. Verified Gmail or Google Workspace can also connect your existing account through its confirmed email.This attempt expired or belongs to another browser. Please start again.Link GitHubAccount linked. You can use it to sign in next time.Linked sign-insAfter unlinking Google or resetting/changing your password, sign in with your current method and connect Google again in My account → Linked sign-ins.This external account is not linked yet. Use an existing sign-in or email and password, then link it in My account. If you do not have an account, create one first.or sign in with email and passwordor create a password to sign up with emailYour account was created with external sign-in. To confirm sensitive changes such as changing email or deleting the account, set a password using the link sent to your email. This ends sessions and removes existing links; then sign in with the new password and link your chosen providers again.If you choose GitHub sign-in when available, GitHub processes your authentication. Rullst Academy stores your numeric GitHub account ID, its link to your local account and the linking date. The adapter reads the public profile without requesting repository or private email access. We do not store names, photos, GitHub emails or tokens. We do not merge accounts by provider email. Unlinking revokes local access; to revoke authorization at GitHub too, visit Settings → Applications on GitHub. Backups follow the retention described in this notice.Sign up with GitHubFill in your email and country and read the notice above. With external sign-in, you do not need a password now. With GitHub, also confirm the email sent by Academy.Unlinking ends sessions opened with that provider. Changing or resetting your password removes all links; you can link them again afterward.Send password setup linkYou are already signed in. To link another sign-in, use My account.Signed in. Welcome to Rullst Academy!Sign in with GitHubThis sign-in provider is unavailable. Use another existing sign-in or email and password.External account unlinked. Sign in again to continue.The new address replaces the current one only after confirmation. Changing it ends your sessions. Existing accounts can add their first email here.Send address confirmationContact and securityCorrect dataCountry of residenceSelect your countryCreate supervised accountAdult's emailNeed an email link?Confirm your requestConfirm new emailConfirm access to FamilySave new passwordConfirm my emailYour emailA contact change was requested. Confirm the new email within 24 hours. This ends sessions and requires a new confirmation before creating accounts in Family.Confirm your new address · Rullst AcademyConfirm your email before signing in. You can request another link below.Done! The action is confirmed. Sign into your account to continue.A supervised account was created with your authorization. You can review or export data, pause activity collection and withdraw consent by deleting the learner's account in Family at any time. If you do not recognize this action, contact officialrullst@gmail.com. To protect the learner, their details are not included in this email.Family authorization recorded · Rullst AcademyService message from Rullst Academy. If you did not request this action, ignore the link. Do not share access links. Support and privacy: officialrullst@gmail.com.You requested Family access. Before creating child accounts, read https://academy.rullst.win/en/privacy. Learner data includes nickname, age group, country, language, protected password, progress, activities and your guardian link. Oracle hosts it in Brazil. Resend emails adults and stores content and logs in the US. There is no data sale, advertising, public child profile or learner messaging. You can review, export, pause activities or withdraw authorization by deleting the account. Child accounts inactive for 365 days are deleted. Confirm access within 24 hours; then authorize each account in Family. If you do not continue, no child account is created. You may delete your adult account at any time.Additional Family confirmation · Rullst AcademyCheck the email address.This link expired, was used or is invalid. Request a new link.Enter your account email. We will send you a link to choose a new password.If this address is eligible, we will send a link. Check spam too. Wait a few minutes before requesting another.Resend registration confirmationForgot my passwordUse the link within 30 minutes to choose a new password. Your sessions will be ended. If you did not request this, your password is unchanged.Recover access · Rullst AcademyA password or email change was completed on your account. If you do not recognize it, contact support. This message contains no password.Security change · Rullst AcademyEmail is unavailable. Please try again later.Email confirmed! Now sign in to your account. If you registered with Google, click Sign in with Google below and choose the same account. If you used GitHub or email and password, sign in with that method. Confirming your email does not sign you in automatically.You requested an adult account at Rullst Academy. Confirm your email below within 24 hours. Unconfirmed accounts are deleted after 48 hours.Enter the email you signed up with to request a new confirmation link.Confirm your email · Rullst AcademyYour email is confirmed and your place at Rullst Academy is ready.
Here, you can experiment, make mistakes, try again and discover what you can do. You don't need to know everything to begin: just take the first step, at your own pace.
Sign in using the method you chose when registering, choose a nickname in your profile and find your first lesson. We'll celebrate each discovery with you.Welcome to Rullst Academy!Your account is private and supervised by your guardian. They can see progress, limit activities and help with your password. You can also view, download or delete your data.I read the notice above and authorize the described data use for teaching and supervision. I know how to withdraw this authorization.These controls affect saved account activities. Open content can be read without signing in. Saving controls renews retention for 365 days. Deleting the account withdraws authorization and erases its data.A legal guardian creates and supervises each minor's account. The learner uses a nickname, without their own email, public profile, leaderboard or messaging. We do not request documents or photos. Email confirmation protects access; it does not prove age or parenthood.Initial limit of eight learner accounts per guardian.Rullst quiz: last permitted lesson (1 to 8)Before creating an account: we will store nickname, age group, country, language, protected password, activities, progress and your guardian link for teaching and supervision. Oracle hosts this data in Brazil; Resend emails only adults and stores content and logs in the US. We do not sell data or use ads. You can review, export, pause learning data collection or withdraw consent by deleting the learner's account here. Child accounts without activity or control renewal for 365 days are deleted. Backups expire within 14 days and reapply deletions on restore.Pause account activitiesYour guardian paused account activities or limited lessons. Talk to them to continue.Receive Family confirmationRetained untilFamily: learning with guidanceI am this learner's legal guardian and have authority to authorize this account.For a minor's account, ask your parent or legal guardian to sign into their own account and open Family. Do not enter your details here.Wait at least 10 minutes after confirming your email before requesting the additional Family confirmation. This is a Rullst Academy measure, not a legal time limit.Under reviewRullst explorerThis option is for older accounts that received a recovery code. Use your login nickname and the code you saved. Accounts created with an email should use an email recovery link.I have an older recovery codeUse an already linked sign-in or your email and password to continue your journey.I still need to confirm my emailNew passwordI read the privacy notice. My email will be used for access, security and essential account messages.Read the notice and confirm the required declarations.Object to processingPassword changed. Sign in with your new password.Public profiles and leaderboards are available only to adults with confirmed email and no processing restriction.Learning records are paused by a privacy restriction. Manage this in your account.Choose your nickname and how you’d like to appear. Your profile stays private until you decide to publish it.ReceivedRefreshCreate your account, then choose a nickname in your profile.Describe your requestRequest received. Keep the reference and check below for updates.Restrict processingEnabling this pauses new learning records and hides your profile and leaderboard entry. You can still access, export or delete data and submit requests. Disabling it does not republish your profile.Restrict use of my dataRequest correction, object, appeal a response or make a complaint. Do not send documents, passwords or sensitive data. Track the reply here; our initial response target is 15 days, subject to the applicable legal deadline. You may also contact the controller or your country's authority.You already have five pending requests. Wait for a response or use the privacy contact.Your privacy requestsStay connected with RullstChange saved.Submit requestSend recovery linkSend email confirmationUsing a supervised learner account? Ask your guardian to reset your password in their account's Family area.Under 13Use my saved codeSmall steps. Big discoveries.Email confirmed! Now sign in with Google, GitHub or email and password, using the method you registered with. Email confirmation does not sign you in automatically.Choose my profile nicknameYour next chapter starts hereThe world needs your ideas.We’re glad you’re here. This is your space to discover, experiment and create.You don’t need to know everything to begin. A question, a little curiosity and the courage to try are enough. Every small step counts here, including the ones you take again. Learn at your own pace, celebrate your discoveries and bring your imagination to life.Choose a nickname in your user profile whenever you like. Your profile starts private; sharing achievements and joining the ranking are your choices.A space that feels like youConfirm your email before signing in. If the address is eligible for registration, you’ll receive a link. Check your spam folder too. Already have an account? Sign in or request a password reset.Read the welcome againWith care, Rullst. Let’s create together.WelcomeYour nickname and profileYour space for discoveryAnswers drafted in this browser. Only a confirmed completion records progress.Back to the catalogChoose an available card to begin. Each track has its own page and lesson sequence.Track achievementYou completed every activity in this track. This learning achievement is not a professional certification.One idea at a time: understand, experiment and check your prediction.Complete trackClear this lesson’s draftDelete this lesson’s editor draft from this browser and return to the starting material? Download anything you want to keep first.Draft removed from this browser. The starting material is back in the editor.The draft changed in another tab. Your edits were kept here without replacing the other version. Download this version before reloading or continuing in another tab.The browser could not save the draft. Download your file before leaving; confirmed account progress is separate.Your text will be saved in this browser when you edit it. On a shared computer, clear your drafts when finished.Your draft from this browser was restored. Review it before uploading.Draft saved in this browser. This does not mean it was uploaded to GitHub.As a visitor, this draft belongs to the browser and will not transfer to an account. Download a copy before signing in or creating an account.Download the track’s final projectAvailable after completing the track. The ZIP contains the project files; your edits in this space remain in the edited file.Direct upload accepts up to 8 KiB of text in one file. Use downloads and the manual guide for projects with multiple files.The example may be only a snippet or outline. Changing the extension does not make it a complete program. The activity ZIP contains starting material; the edited-file button downloads your text.What I understood:
My example or practice plan (use fictional data):
How I checked the result:
A question or next step:
My learning recordThe quiz ZIP uses the last creation completed and saved to your account. Unchecked form changes or edits in this editor do not change that ZIP.Choose a scenarioMini experimentLearning simulation: compare cards and check your predictions. The browser is not compiling Rust or starting a server.This scenario’s resultShow resultYour guardian needs to enable this track in My account. Existing achievements remain saved.Other tracks the learner may practiceNew tracks start disabled. The general pause applies to all. Limits control account activities and progress; public text remains accessible.Rullst quiz: last permitted lesson (1 to 8)Try the first lesson of each track. Sign in or create an account to save progress and continue.From first discoveries to advanced projects. Explore mathematics, programming and new ideas with Rust and Rullst. Learn, experiment and create at your own pace.Your snippet in progressanswers preparedBuild your answers and check when you are ready.Discovery workshopMove cards with the arrows and check your sequence.lessonsFor curious people, even without prior interest in programming. Observe, compare and explain decisions using fictional situations.Investigative mindInvestigate claims, plan fair tests and check sources. Finish by assembling your own investigation.Download investigation workbookAn editable Markdown guide for applying questions, tests, records and revision outside Rullst Academy. Use safe situations and fictional data.Separate observation, preference and hypothesis.Plan tests and check the limits of evidence.Build a workbook for your own investigation.Idea detective22 lessons availableChoose a track and move at your own pace. Each has its own sequence, practice and achievement; you do not need to finish another track before starting.Direct uploads require an adult account with confirmed email and linked GitHub. Downloads remain available according to activity access.Choose a destination and check its path and visibility before confirming.I reviewed the code, destination and visibility. I want to upload this file.GitHub denied access or requested a pause. Check permissions and try again later.Destination repositoryDownload my edited fileDownload started. Check your downloads folder; GitHub upload is separate.Edit the example or record what you learned. This space does not run code or grade answers. The draft is saved only in this browser, separately per account; you choose when to download or upload to GitHub.The file already exists or the branch rejected the upload. Check the repository; nothing was overwritten. For a new version, edit the text and review again.Choose an authorized personal repository. Each upload creates a new file in an activity folder; existing content is preserved. You decide whether to use one repository or different destinations.The upload could not be completed. Check the repository and try again. The Rullst Academy does not replace existing files.File formatAuthorize the GitHub App on your linked personal account, selecting repositories and the contents permission. Then load again.Authorize repositories on GitHubLink GitHub in My account before loading repositories.Load my repositoriesRemember a repository per trackLoad more repositoriesThe connection did not confirm the result. Check GitHub or retry without editing the text; the same attempt does not create another copy.Create a repository on GitHubNo personal repositories are available on this page. Create one with a README and select it in the installation, or load the next page when available.One repository for all activitiesOpen my file on GitHubHow I want to organizeIf you authorize activity uploads, the GitHub App accesses only repositories selected during installation. The Rullst Academy checks the linked GitHub ID, its installation and the repository list to validate the destination. After your confirmation, it sends the reviewed text to a new file in the selected repository. The text and installation tokens are not stored in the Rullst Academy database. Destination preferences stay in this browser, separately per account, and can be removed with Clear local data. Deleting a Rullst Academy account does not delete files on GitHub; manage files and revoke the installation on GitHub itself. The editor draft also stays in this browser, separately per account and lesson. It does not follow you to another device; download a copy and clear drafts on shared computers.PrivatePublic: anyone can view itFile saved to GitHub. Open the link to inspect your commit.Upload file to GitHubUse up to 8 KB of text per upload. For larger projects, download the materials and upload manually.My code or notesSave to my GitHubDirect uploads are not available yet. You can download your file and follow the manual publishing guide.The repository visibility changed. Load it again and review before uploading.Your file for this lessonReview this trackFor anyone who wants to understand how a page works, starting from zero. Activities use small examples; reading the full code can come later.Idea gardener with RullstFollow a visit between browser and server, discover HTML and connect two pages. Then take your idea garden to your computer.Download my Rullst gardenA two-page Rullst 12 project, translated README and tests. Install Rust to run locally; the initial setup downloads dependencies.Understand the roles of Rust, Rullst and the browser.Connect routes, HTML structure and clear links.Check two pages, inserted text and a 404 error.Rullst: a page comes aliveFor anyone starting with clicks and their own quiz. No programming experience needed. To meet the tools first, try the introductory Rullst track.Turn a question into an interactive quiz.Experiment with answers, decisions and scoring.Take home a Rullst project with your quiz choices.For anyone who has never programmed or wants a gentle fresh start. No installation needed for the lessons. A trusted person can help with reading.First sparks in RustLight up a terminal, discover what quotes change and turn errors into clues. Your final mission: an explorer card built in Rust.Download my first Rust projectA terminal explorer card with instructions in your language. No external dependencies; requires Rust installed to run on your computer.Distinguish code, text and terminal output.Read names and calculations, using errors as clues.Prepare a Cargo project and check two cases.Rust: first sparksFor anyone wanting to practice code in small steps. This track introduces syntax; if everything still feels new, start with Rust: first sparks.Rust program builderValues, decisions, loops, functions, borrowing and Option. Build a scoring station and take home a runnable Rust project.Download Rust projectA Rust terminal program, without a framework. Includes comments in your language, a README and tests. The first track’s quiz project uses Rullst 12.Read values, conditions, loops and functions.Experiment with borrowing and absence using Option.Build and test a scoring station.Rust: from idea to programStart this trackTry the first lesson without an account. Sign in to save your achievements.Is this track for you?Your path, step by stepWhat you will discoverThe time is an estimate, not a deadline. Take breaks, use hints and try again whenever you need.There is still something to investigate. Use the hint and try again.Lesson completed and progress saved to your account.You changed the answer. Check again to validate this version.My files and GitHubChecking your access to this lesson…The editor and downloads open when this lesson is available to your account. Check access below or return to the track map.Every lesson can become your own record: code, notes or a practice plan. Saving a file to GitHub is optional and does not change your XP.Ready to check your answer.Read the feedback before trying again.Your tracksOne world, five territoriesDiscovery, Foundations, Building, Specialization and Frontiers represent depth. You advance through learning, with the support you need.Track completedChoose your route and learning space. Explore free tracks with reading support, three visual styles and saved progress.In the Aurora Expedition, we face the dragons of problems and ignorance with questions, knowledge and creativity. Mistakes give us clues for the next attempt.Dragons are the challenges.Explore this trackFind a starting point and choose the setting for your journey.What will you discover next?With JavaScript disabled, all suggestions appear below. Track links remain available.My routeI prefer to explore allExplore • imagine • discoverAsk • experiment • testBuild • understand • go deeper{done} of {total} lessonsProgress has not loaded yet. You can still explore the tracks.Reading supportIn lessons, Listen uses voices available on your device. You can also share reading with someone.Suggestions to exploreRemember choices in this browserNo completed lessons at this stop.Your spaceChoices apply on this page only.Reference stageThis choice recommends content. It does not report or change account age or grant permissions.The preference could not be saved. Your choice applies on this page; check browser storage permissions.Changing routes preserves your achievements. You can return here whenever you like.Current space: Adventure — rounded shapes, illustrations and gentle motion.Current space: Laboratory — a grid background, technical details and moderately rounded shapes.Current space: Studio — straighter lines, a clean background and less decorative motion.Space updated. Your achievements stay with you.Choices reset. Explore at your own pace.Your choices stay in this browser. They do not change your account or family permissions.Sign in to keep achievements. You can try the first lesson of each track without an account.18+ · Develop skillsAges 15–17 · Build my futureAges 5–7 · Discover through playAges 12–14 · Try different pathsAges 8–11 · Create and investigateIn upcoming advanced work, we will practice clear requirements, reviewing suggested code, failure tests and explained decisions. Learning to use AI includes knowing how to check the result.Learn with AI, check with evidenceAll possibilitiesShow suggestionsStudy available foundationsAll learning programsDiscover what people create at workA career path combines foundations, work tasks, projects and assessment. Today you can study the published foundations and explore the full plan.Careers in the age of AICareer pathsExplore careersConnect skills to professional tasks, original projects and practical assessment. Roadmaps show available stages and what is still needed.How would you like to explore?Choose a skill, explore a career or discover upcoming specializations. See what you can already study at Rullst Academy.Explore learning programsA discovery can become a projectA first experience for youIn preparationSign in to see the progress you have already earned.Develop skills through your own projectsBuild projects for your futureShall we discover what we can create?Try a field and find your pathYour ideas can come to lifeExplore development, security, AI, data and cloud. Each path shows what you can study now and what we are preparing.From your first ideas to professional projectsYour knowledge may go beyond the suggestion. Adventure, Laboratory and Studio styles remain independent.Start from scratch, build on what you have studied or deepen your knowledge. The roadmap shows available foundations and upcoming professional preparation.Connect foundations, original projects and professional skills. Develop autonomy gradually, with support in activities that need guidance.With an adult, choose a discovery. Observe, play and explain by pointing or drawing. The first activities need shared reading.Discover different fields through projects and see the full roadmap. Experiment before choosing where to go deeper.Try creating, investigating and caring for the digital world. Discover professions through small projects, with support when you need it.Your progress has not loaded yet.Editorial review: 2026-09-26. Source: a 2025 global employer survey; not a country- or language-specific job listing analysis or a hiring promise.Read the WEF reportSoftware, AI and data, networks and cybersecurity feature in the WEF skills and jobs growth outlook for 2030. Our first career path builds on the Rust and Rullst foundations already published.Why learn these skills?Other planned specializations: AI application security and Rust performance. Each path will have its own prerequisites, projects and assessment criteria.Learning programsFoundations available · career path in developmentView the roadmapPlanned · lessons not yet availablePost-quantum cryptographyA future security specialization: study quantum-resistant cryptography, inventory and migration. These algorithms can run on ordinary computers; this differs from programming quantum circuits.Explore the professional goal too{done} of {total} lessons completedThis shows progress in available tracks. Completing these foundations does not complete milestones in preparation or award professional certification.The project we want to help you buildGoal of the complete career path, still in preparation. You can start with the published foundations and build at your own pace.Quantum computingStart with the available mathematics and probability foundations. The quantum path is still being planned.Explore mathematics foundationsAn initial discovery of bits, qubits and measurement, followed by mathematical foundations and small simulated circuits. Advanced study will cover algorithms, noise and limitations.Your learning roadmapThe tracks below are available to study. Each milestone also shows the deeper work still needed to complete the career path.Your progress in published foundationsSkill pathsExplore skillsLearn a skill such as Rust, SQL, Git or critical thinking. Use these foundations across different careers.SpecializationsSee upcoming specializationsGo deeper into a subject after building the required foundations. The new paths below are being planned.Choose a reference for suggestions. It does not declare your age or change account permissions.Start with this discoveryAdjust my journey and styleWhat would you like to learn to build?Different ways to learnChoose an option and use colors in #RRGGBB format.CardsYour adventure starts with youChoose your characterChoose your character to begin1. Choose a class and an appearance2. Give your adventure its colorsEvery class can explore every track. This is a visual choice: it changes neither XP nor difficulty. Outfits and equipment are fixed. Your character does not need to resemble you.CompletedA colossal dark-scaled dragon with biomechanical wings, AI sensors and laser emitters above a citadel in the clouds.Defeat the dragons of ignorance and problems.Investigate a question, test an idea and solve a challenge. Each discovery opens a new path.Customize characterExplore the world mapEye colorOpen eye color pickerFaceFace 1 · European inspirationFace 2 · Asian inspirationFace 3 · African inspirationHair colorChoose hair colorUse the picker or type # followed by six characters from 0–9 or A–F. Example: #AF795B. Imaginary colors are welcome too!In progressOne editor, two styles to explore. Choose your character, customize and save when ready.Customize your characterChildren's adventureCloseChoose a children's adventure characterEnlarge portraitLittle explorerYoung explorerBrown-skinned girl with a long braid and orange backpack, holding a notebook and magnifying glass beside a geometric leaf.Magnifying glass in hand, questions in a notebook. The world has clues waiting for you.Does one leaf look like another? The explorer observes, sketches and compares before deciding. Every good question opens a new path.Observe · ask · discoverEast Asian boy with black hair, an orange backpack, a magnifying glass and an open notebook in a futuristic garden.Magnifying glass in hand, questions in a notebook. The world has clues waiting for you.He found an unusual seed in the garden. Before deciding what it is, he observes its shape, sketches it and compares it with others. A good question can open up a great adventure.Observe · ask · discoverFeminineChoose a face and customize skin, eyes and hair. Original colors are always available.Little guardianYoung guardianBlack girl with short coiled hair and an orange scarf, holding a small glowing bridge model.Courage also means asking for help, welcoming someone and finding a solution together.A bridge should work for the people crossing it. The guardian listens to the group, tests paths and helps everyone take part in the discovery.Care · collaborate · connectBrown-skinned child with wavy hair, a hearing aid and a green jacket, offering a hand and holding a small glowing bridge.Courage also means asking for help, welcoming someone and finding a solution together.The crew wants to cross a stream. He invites everyone to draw a bridge and tests a small model with his friends. Each person contributes in their own way. Together, they find a safe path.Care · collaborate · connectChoose a character, try its appearances and colors, and save your choice.Little inventorYoung inventorBoy with curly auburn hair and glasses, using a wheelchair and holding a robot crab on his lap.An idea, a few parts and lots of curiosity. Every attempt reveals something new!A wheel and a claw can respond to commands. Our inventor tests one change at a time and explains his discoveries so everyone can build together.Imagine · build · tryBlack girl with curly hair, safety goggles on her forehead and a light jacket, holding an orange and green robot crab.An idea, a few parts and lots of curiosity. Every attempt reveals something new!She built a robot crab to explore the garden. When it heads the wrong way, they observe, change one part and try again. Learning also means discovering what can still be improved.Imagine · build · tryMasculineYour character joins you in your account and on the map. Appearance does not change your lessons or permissions.Original colorsPresentationChoose this characterMeet the characterLittle heroes, big discoveriesMagicMage · feminineMage · masculineImagine what does not exist yetAdventure mapTravel through gardens, workshops and cities of the future. Each stop is a real Rullst Academy track. Choose a region or use the filters to find your next mission.The path suggests an order, not an obligation. Setup tracks for different systems are alternatives. Planned regions do not have available lessons yet.A world to discover. One step at a time.To exploreMagic, science and courage meet to discover technology. Choose your character and join our robot crab across islands of knowledge — from your first ideas to new worlds.Every great adventure begins with a choice.Character previewYour character is saved to your account. It appears on your public profile only if you enable that option in profile settings.{done} of {total} lessons completedCity of MakersGardens of DiscoveryIdea WorkshopsStellar HorizonsCitadel of KnowledgeRegions of knowledgeDiscard changesChanges discarded. Your saved character was preserved.This account is restricted. Changes are unavailable.Save my characterCharacter saved to your account. The adventure continues!Saving character…ScienceScientist · feminineScientist · masculineTurn questions into discoveriesTry the options. Sign in to save your character.Skin colorOpen skin color pickerLittle Inventors: child characters. Aura Masters: teen and adult characters. Explore the styles and save your favorite.Character stylesSwitch appearanceUse the arrow to switch between feminine and masculine, and the Face menu to explore each class's portraits. You can change your hero and colors whenever you like.Aura MastersLittle InventorsPreview updated. Save to keep it in your account.Track presentationChecking your account…WarriorWarrior · feminineWarrior · masculineMeet challenges with creativityHere, curiosity becomes discovery and every attempt helps you grow. Our robot crab has prepared the path. Choose who will accompany your journey, at your pace and in your colors.Rullst universe · Aurora expeditionYour journey companion
Could not save preferences or the draft in this browser. Achievements already saved to your account remain on the server.
Rullst Academy