3 SQL Version of NorthWind Database
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.
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.
Download Link:
0 Commentaires