I am looking for a publicly available SQL database with free access, where one can run some SELECT
queries for free on some meaningful data (not item1, item2, item3). Have you seen any? Even better if it came together with some tutorial.
Vendor is not that relevant, as long as one can connect using a generic JDBC client.
MySQL is a proven, cost-effective database widely used by educational institutions worldwide to automate many of the academic and administrative processes. It is also one of the most popular databases used in teaching curriculums and by scientists in research institutions.
If you're learning SQL for the first time, you've probably dabbled with at least one of the following resources: codeacademy, datacamp, and khan academy. Each of these websites provides an interactive, hands-on method for beginners to learn SQL. These are great, free resources and you absolutely should use them.
Structured Query Language (SQL) skills are crucial in software engineering and computer science. However, teaching SQL effectively requires both pedagogical skill and considerable knowledge of the language.
Try SQL Exercises
Start with learning stage
If SQL Server is an option then Northwind/Adventureworks are the standard "training" DBs. Do a search.
For mySql this project looks promising:
http://sourceforge.net/projects/awmysql/
Also, this might be a dupe:
Is there a "Northwind" type database available for MySQL?
Where can I download Northwind database for Postgresql?
I would suggest setting up Microsoft SQL Server 2008 Express (or the R2), and adding the Northwind or Adventureworks database. It's pretty big so I'm sure you can play with it.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With