| Lesson 7 | Setting up your database |
| Objective | Set up the database of your choice. |
If you are using Microsoft Access, you can download the database directly from the Resources page. If you are using Microsoft SQL Server or
Oracle, you can download the necessary scripts from the same area. Try running the scripts yourself, and if you have trouble, give the scripts to
your DBA. He or she can apply the scripts quickly and easily, and then you will be able to run your test again.
The scripts create the database and tables that will let you query the database and experiment with information without harming any production information that may be on your server. Because the database can be rebuilt at any time, you won't have to worry about deleting everything or otherwise resetting the database.
For database-specific directions, follow the link for Microsoft SQL Server and Microsoft Access from the list below. For other databases, consult your administrator or the documentation.
The scripts create the database and tables that will let you query the database and experiment with information without harming any production information that may be on your server. Because the database can be rebuilt at any time, you won't have to worry about deleting everything or otherwise resetting the database.
For database-specific directions, follow the link for Microsoft SQL Server and Microsoft Access from the list below. For other databases, consult your administrator or the documentation.
A good site to reference the PUBS database is
It is located at Microsoft.
It is located at Microsoft.
