In order to do the exercises for our SQL tutorial you will need to have a data.world account. They are free, and you can get one at data.world by selecting the JOIN button. If you already have an account on data.world, the previous link will take you to your home page.
Once you are logged in, if you want to do the exercises and save them you will need to create your own project from the SQL exercise dataset. Follow the steps below to create your project:
- Go to the SQL tutorial exercise data dataset on data.world. Select the down arrow to the right of the Explore this dataset button and select + Create a new project
- Add your project name, leave all the other options as they are, and select Create project. On the next screen you can either enter a description or do that later.
After you have created your project, the first page you’ll see is the project workspace. If you aren’t familiar with it, please read the article Quickstart to navigating the project workspace for an overview. If you would like more information on how to construct queries in SQL and data.world’s formatting options, see the article Query basics.
Once you have a project you need to write all your queries in it instead of following the Try query link at the bottom of the tutorial pages. If you forget and write a query in the blank project opened by Try query, you won't be able to save it in your project unless you copy the query text and paste it into a new query in your project workspace. The easiest way to remember to use your own project is to keep it open in its own browser window or tab while you're working through the tutorial.
If you prefer to do the exercises as a stand-alone exercise see this article. Hints and answers to the exercises are provided with each exercise.