Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Public SQL database for educational purposes

Tags:

sql

jdbc

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.

like image 913
Grzegorz Oledzki Avatar asked May 26 '10 08:05

Grzegorz Oledzki


People also ask

Which database is best for students?

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.

Where can I practice SQL for free?

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.

What is SQL in education?

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.


3 Answers

Try SQL Exercises

Start with learning stage

like image 188
msi77 Avatar answered Oct 05 '22 12:10

msi77


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?

like image 27
spender Avatar answered Oct 05 '22 11:10

spender


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.

like image 23
Snake Avatar answered Oct 05 '22 11:10

Snake