Using SQL Online IDE
Hello,
I'm passionate about transforming raw data into actionable insights, driven by a lifelong fascination with numbers. As a data analyst, I enjoy uncovering meaningful patterns and collaborating with like-minded individuals.
I'm also a strong advocate for mental health and use data to contribute to this important cause. My background in the medical field enhances my analytical approach, bridging the gap between healthcare and data analysis.
For our practice, we'll be using the Online IDE you can code along.
Here is a simple guideline for uploading your files
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.
Click on the import on the navigation bar at the top
On the pop-up that appears click on open.
Navigate to the folder that contains the data you want to upload and select the file to upload.
Another pop-up will appear. On the column name drop-down menu select
first linethat 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!
