Free Online Database?

[SidUK]

Hi,

Just wondering if anyone has connected to a free online database, which do you recommend? Just want to practice the Alteryx database connection and SQL.

Plan B would be to install SQL Server Express and use the "AdventureWorks" database.

Thanks.

Sid

[grossal · Accepted solution]

Hi @SidUK,

I used the ElephantSQL (link) free tier to practice with a PostgreSQL if that's fine for you. 

SQL Server Express is good too. I have also used some Docker images (e.g. MongoDB) to quickly spin up a database for practices or test cases.

Best

Alex

[SidUK]

Thanks for your suggestion.

Another idea i found was use the 12 month free trial Microsoft Azure but currently server restriction...priority to COVID19 related work.

[SidUK]

*UPDATE*

I connected to Azure DB, here steps I followed:

1) Get the free 12 month Azure account

https://azure.microsoft.com/en-gb/free/

2) Setup sample Database (adventureworks)

https://www.youtube.com/watch?v=p7X8lH_XMtI

3) Create ODBC connection

https://vmarena.com/how-to-configure-odbc-connection-to-the-azure-sql-database/

4) Connect to Azure DB using Alteryx

https://www.youtube.com/watch?v=Q9IEI7PHJrA

Enjoy!