I need a test database to practice joins and other kinds of data retrieval operations in SQL.
What's a good free test database and RDBMS system to use on Windows?
views:
44answers:
6
+1
A:
SQL Server Express for one.
Sample databases (AdventureWorks) can be downloaded here.
AdaTheDev
2010-06-08 08:13:45
A:
If it's just for practising SQL you could install Access assuming you have an MS Office CD that includes it already.
Otherwise MySQL or SQL Server Express are probably your best bets.
Paolo
2010-06-08 08:15:47
+1
A:
You can use this link. The adventure works database is used as an example for numerous online and offline resources.
After which, download the SMSS Express to work on it.
Nai
2010-06-08 08:16:50
A:
I would recommend MySQL over SQL Server Express if your purpose is to practice SQL. The command line interface is all you need.
FarmBoy
2010-06-08 08:17:17
+3
A:
Every major RDBMS provider has some free edition. Those are full versions limited by database size and maximum memory usage.
Top players:
Then, there is number of open source products:
- PostgreSQL
- Firebird
- MySQL
- SQLite (not really a RDBMS, but understands SQL and it can be used for your purposes. Also, very small and compact)
If this is not enough, check this Wikipedia article: Comparison of relational database management systems.
There's more than 50 RDBMS's listed and you'll probably find something that suits your needs.
zendar
2010-06-08 08:34:10
A:
You can get online practice with verifying your queries on SQL Exercises
msi77
2010-06-08 11:40:14