Using SQL Online IDE

For our practice, we'll be using the Online IDE you can code along.

Here is a simple guideline for uploading your files

1. On Your browser search SQL ONLINE IDE

   Here is how the page looks like

   

On the left side, you can see the different SQL flavors available.

For MariaDB, PostgreSQL and MS SQL you first need to click to connect before you import.

1. Click on the import on the navigation bar at the top

   

On the pop-up that appears click on open.

1. Navigate to the folder that contains the data you want to upload and select the file to upload.

   

2. Another pop-up will appear. On the column name drop-down menu select first line that is if your file had headers in the first line. Leave the rest as default then click OK.

This is how the final view appears. Once you type your query, click on Run in the navigation bar. Your output will be seen on the terminal at the bottom.

You can easily scroll on the sidebar on the left side where your various tables are located.

Once done on the top, you can export your final data and save it in the format you need.

Vamos a praticar!