|
|
In this chapter, you'll learn the basics of databases: how databases are constructed, how to create and relate tables, and how to build queries to retrieve information. This chapter also shows you how to use a SQL Server database named Northwind. This database contains the information for the fictitious Northwind Company, which sells food products. This database is one of the example databases that is typically installed with SQL Server. You can obtain a trial version of SQL Server from Microsoft's website at www.microsoft.com.
Note | At time of writing, you can download the trial version of SQL Server from Microsoft's website. If your Internet connection is too slow, you can also order a CD-ROM containing the trial version. |
I used the Developer edition of SQL Server when preparing this book. When running a production system, you should typically use the Enterprise edition of SQL Server. You can view the differences between the various types of SQL Server at Microsoft's website.
Featured in this chapter:
Introducing databases
Using SQL Server
Exploring the Northwind database
Building queries using Enterprise Manager
Creating a table
|
|