Running the Relational Database Curriculum in your Browser

The web based version of the Relational Database curriculum is here! Follow the steps below to run the courses in your browser. If you want to run them locally instead, you can learn how here. Note: you cannot earn your certification running these locally.

How to get started

Follow these steps to get started with the browser version of the courses:

  1. First, you will need to create a GitHub account if don’t have one.
    If you don’t want to save your progress, you can skip to step 4 after you have a GitHub account.
    Note: You cannot earn your certification without saving your progress.
  2. After that, go to http://freecodecamp.org/learn/relational-database/
  3. To save your progress on freeCodeCamp.org, you will need to be signed in. Click the sign in button at the top right and sign in if you aren’t already.
    Note: If you sign out of freeCodeCamp after you start a course but before you finish, your progress will not be saved to you freeCodeCamp account.
  4. Go to http://freecodecamp.org/learn/relational-database/
  5. Click on one of the courses to go to the course page.
  6. Find and click the button to “start the course”.
  7. Gitpod will open in a new tab. If you are not signed in to Gitpod, you can login with GitHub by clicking the “Continue with GitHub” button.
  8. Gitpod will load a vitual machine for you. Once it is finished loading, you need to start CodeRoad to run the course. Do that by clicking the “hamburger” menu button at the top left of VSCode, going to the “View” menu, clicking on the “Command Palette” option, and running the “CodeRoad: Start” command. See this gif:

Mar-09-2022 20-44-44

Follow the instructions in CodeRoad to go through the course. If you get stuck at any point, see the troubleshooting steps below.

You can learn more about Gitpod here.



Troubleshooting

If you’re stuck in some way, continue reading to learn how to troubleshoot some of the issues we’ve seen…


Issues with starting a course:

Your container loaded, but the terminal is not visible

To open the terminal, click on the hamburger menu on the upper left corner > Terminal > New Terminal.


Issues within a course:

Stuck on a step

There’s various issues that make it so you might not be able pass or run a step. The first thing you should try is using the reset button on CodeRoad. That will reset your progress to the beginning of the step you are on - you will have to do the step again. If that doesn’t work, try exiting the terminal by typing exit into it, and opening a new one.


Issues with your progress getting saved:

You finished a course but don’t see check mark next to it when going back to your freeCodeCamp account

Refresh the page to see if that works. A page refresh is required before you see the check mark.

The checkmark still didn’t show up

After the last step of a course, you will see a ‘continue’ button to finish it:
Screen Shot 2022-03-09 at 8.52.28 PM

Clicking ‘continue’ is what triggers your progress to get saved. There’s a chance you didn’t click it or something went wrong. Open your finished course back up and it should take you to that screen. Click the continue button again to save your progress to your freeCodeCamp account.


How to save your files for certification projects

When you complete one of the certification projects, you will be asked to save your files somewhere and submit a link to them on freeCodeCamp. Each project has instructions how to create the files and what files you need to save and submit.

In the image above, the file explorer is the left panel with the universe.sql file in it. If you don’t see this panel, click the icon on the far left that looks like two pieces of paper to open it. It’s the one highlighted in white. Once the panel is open, click on a file to open it in the main editor and see the contents of the file. Select all of the contents and copy them. Create a file on your computer with the same name as the file you copied and paste the contents into it. Upload your file(s) somewhere public and submit the URL to them on freeCodeCamp.


Other issues:

You are stuck in some other way

Create a new topic on the forum and someone can help you troubleshoot the problem

36 Likes

I believe that my database is but it won’t let me pass, with the run feedback saying:

“characters” should have the correct rows for “Daisy” and “Yoshi”

Any hints for me, or is there a mistake in the tests?

4 Likes

Daisy’s color should have been Yellow @mrsimonsen? FYI, you be able to use that reset button to get to the beginning of the step you are on.

Edit: That looks correct @mrsimonsen. The run feedback isn’t for that step, it’s for one of the steps right before that step. Sometimes the tests get misaligned with the instructions - I’m not sure why, I’ll investigate further. I try to walk a few people through getting them realigned here

2 Likes

The step was to change Daisy’s color from Yellow to Orange. I’ve done the reset - which resets back to the start of the previous step - where I need to add Daisy and Yoshi.

1 Like

Were you able to get back on track after using the reset?

Also, are you running this on freeCodeCamp or locally?

2 Likes

Running through freeCodeCamp. Yesterday I reset twice and redid the previous and current step to have it still not pass.

1 Like

This did the trick. I edited the test directly in vim to I didn’t have to deal with the whole hiding part.

It was test 670 that wasn’t getting commented out. Thanks for your help!

2 Likes

The ls -1 command test in the tutorial isn’t passing even though it’s listing as it should. Any help would be appreciated.

2 Likes

That’s an l (el), not a 1 (one) @Stryife. Try it again with the el.

3 Likes

that worked thank you

3 Likes

Facing problem in this course. Accidentally closed the tutorial tab in the “Learning Bash” course, now can’t reopen it.
Also if I am stuck in a tutorial, giving the correct answer doesn’t complete it.
Edit: reopened the tutorial. Now the problem is passing the test.
the test is " Wait. You don’t need to recreate them. You can just move the other images here. Go back to the website folder from here. It’s three folder back."
I am currently in the website folder still doesn’t pass.

3 Likes

Check the hints in that step @tanjimanim007 - they should tell you how to pass it. If you are still facing problems, let us know.

1 Like

Yes that worked thanks.

3 Likes

Having a problem with the mario database

2 Likes

That looks like the command to display the databases, it’s asking to display the tables @Stryife.

1 Like

Weird because in the hints it even says use the list command but that worked

2 Likes

Thanks for reporting - I will get that fixed :+1:

2 Likes

I have finished the “Build a Celestial Bodies Database” project, I tried to upload my github repo to finish the challenge but it keeps telling me that I need to finish the project first. As you can see in the image that I have 100% the project and created the sql file. With the latest updates in github, I cannot push the universe.sql directly because github removed password authentication. Any help would be greatly appreciated.

1 Like

What did you do exactly on test 670?

I managed to get my self to the test folder but can’t understand what’s wrong :stuck_out_tongue:

Nvm I just deleted everything besides 690 and the other non test files and it worked as well :stuck_out_tongue:

1 Like