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 signing up through this link. If you already have an account on data.world, the previous link will take you to your home page.
The exercises in the tutorial are based on the dataset SQL tutorial exercise data. Once you are logged in you'll have access to the dataset and you can create your own project to use with the exercises. You can do the exercises without creating your own project by following the Try query link on each exercise, however we recommend saving your own project with answers for each of the exercises as some of the exercises are built on the results of previous exercises. 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 our article on navigating the project workspace for an overview.
Once you have a project you need to write all your queries in it instead of following the Try query link in the SQL articles. 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 existing project. The only way to get it into your project is to copy the query text and paste it into a new query window 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.
To do the exercises, select + Add -> SQL Query in the Project workspace:
You'll be taken to a new blank query window. If you need help on how to write SQL and data.world’s query-formatting options, see the article Query basics. When you have finished writing and testing your query, we recommend that you name it by the exercise number and save it:
Exercises are found at the end of each article in the SQL tutorial and you can do them after reading the article or you can work through them as a stand-alone exercise in this article (coming soon). Hints and answers to are provided with each exercise.