A great way to learn database programming is to have a good sample database with lots of tables and appropriate relationships between them to work with. Queries can then be composed from within a variety of programming platforms, such as Java, PHP, Visual Basic 6, Visual Basic.Net, Visual C#, etc.
NorthWind is a free sample database that Microsoft included with every version of Access going all the way back to Access '97 -- 21 years ago to help people get started with the Access program.
The zip file contains 3 versions of the database for use in the following programs:
1. Access 2003.
2. MySQL server
3. Microsoft SQL Server 2008 R2 (and perhaps compatible with later versions of the server).
To install the database in Microsoft SQL Server you must have MS SQL server already installed and Server Management Studio (the graphical database editor program). Then just log into the server. Then select File ->Open -> File. Then navigate to the sql script file named: instnwnd.sql. Then execute the script from within Server Management Studio.
To install Northwind on MySQL server you must already have MySql server installed and running. You should also have MySQL Workbench (the graphical database editor program) installed. Then from within Workbench load and run these two scripts:
northwind.sql and northwind-data.sql.
The screen shot shows NorthWind running on Microsoft SQL Server 2008 R2.
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.
Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.