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?
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?
SQL Server Express for one.
Sample databases (AdventureWorks) can be downloaded here.
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.
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.
I would recommend MySQL over SQL Server Express if your purpose is to practice SQL. The command line interface is all you need.
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:
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.
You can get online practice with verifying your queries on SQL Exercises