The bonus CD-ROM that accompanies this book includes full-function Windows NT/2000 versions of these three leading brands of SQL-based DBMS:
- Microsoft SQL Server 2000
- IBM DB2
- MySQL
In addition, the last section of this appendix contains instructions on how to download a trial version of the Oracle DBMS.
These are not incomplete “demo” versions of the DBMS products. Rather, they are full-capability evaluation versions of the latest software from these leading database vendors, allowing you to learn SQL using a live DBMS, test out and compare each product, and find a SQL DBMS that best suits your specific needs.
The CD-ROM also includes data files that you can use to populate the DBMS products with the five tables of the sample database so that you can easily run the example queries in the book. The files reside in the root directory of the CD-ROM and are named:
- CUSTOMERS.DAT
- OFFICES.DAT
- ORDERS.DAT
- PRODUCTS.DAT
- SALESREPS.DAT
Enjoy this unique CD-ROM, which is available only with SQL: The Complete Reference, the most comprehensive book on SQL with the most comprehensive collection of valuable SQL DBMS software from the leading DBMS vendors.
1. Installing the SQL DBMS Software
When you insert the bonus CD-ROM into your CD-ROM drive, Windows automatically launches the DBMS installation program on the CD-ROM. The program prompts you to accept the McGraw-Hill/Osborne license agreement and then allows you to select a DBMS for installation, as shown here:
The sections that follow contain detailed instructions for installing each brand of SQL DBMS.
2. Microsoft SQL Server 2000
The following table lists details and facts about the product and the company:
Product name SQL Server 2000 Enterprise Edition
First shipment 1988
Platform Windows NT/2000
Software limitations Expires 120 days after installation
Vendor Microsoft Corporation
Founded 1975
Annual sales $27.7 billion
2.1. Hardware and Software Requirements
Category Requirements
Computer Intel or compatible Pentium 166MHz or higher
Operating system Microsoft Windows NT Workstation 4.0 with SP5 or later,
Windows NT Server 4.0 with SP5 or later, Windows NT
Server 4.0 Enterprise Edition with SP5 or later, Windows
2000 Professional, Windows 2000 Server, Windows 2000
Advanced Server, or Windows 2000 Datacenter Server
operating system
Memory (RAM) 128MB or more recommended
Hard disk space Approx. 250MB for typical installation
Internet software Microsoft Internet Explorer version 5.0 or later
Network software Windows 95, Windows 98, Windows Millennium Edition,
Windows NT 4.0, or Windows 2000 built-in network
software (additional network software is not required
unless you are using Banyan VINES or AppleTalk ADSP;
Novell NetWare IPX/SPX client support is provided by
the NWLink protocol of Windows networking)
2.2. Installation Notes
The official Microsoft SQL Server 2000 evaluation CD-ROM has been pruned somewhat in order for the SQL Server 2000 software to fit onto the bonus CD-ROM. Therefore, you must choose precisely the selections indicated in the instructions in the next section or the installation may not proceed smoothly. In addition, do not attempt to install OLAP Analysis Services.
If you have any further questions about SQL Server 2000 installation, please refer to the SQL Server Installation Guide on the bonus CD-ROM. The file is located at \MSSQL\books\instsql.chm.
Finally, if you are installing SQL Server 2000 on the same computer alongside a previous version of SQL Server, back up your previous Microsoft SQL Server installation, and do not install SQL Server 2000 in the same directory as the previous installation
2.3. SQL Server 2000 Installation
Perform the following steps to install SQL Server 2000:
- Log on to the system as a member of the Administrators group.
- Insert the bonus CD-ROM into your CD-ROM drive.
- Windows automatically launches the DBMS installation program on the CD-ROM. If the installation program does not launch automatically, double-click SQLINSTALL.EXE in the root directory of the CD-ROM to launch it manually.
- The installation program displays a dialog prompting you to accept the McGraw-Hill/Osborne license agreement. Indicate your acceptance of the agreement and click Next.
- The installation program displays the DBMS selection dialog. Select Microsoft SQL Server 2000 Enterprise Edition from the list of DBMS choices and click Next.
- The SQL Server installation Welcome dialog appears. Click Next to continue.
- The Computer Name dialog appears. Click Next to accept the Local Computer selection.
- The Installation Selection dialog appears. Click Next to accept the Create A New Instance Of SQL Server, or Install Client Tools selection.
- The User Information dialog appears. Enter your name and company if they are different than the default values indicated and click Next.
- The Software License Agreement dialog appears. Click Yes to accept the agreement.
- The Installation Definition dialog appears. Click Next to accept the Server and Client Tools selection.
- The Instance Name dialog appears. Click Next to accept the Default check box, or enter an Instance Name if you already have a previous SQL Server installation.
- The Setup Type dialog appears. Leave the Typical choice selected. The dialog also indicates the default directories into which the SQL Server files will be copied. Accept the defaults or click Browse to specify different directories and click Next.
- The Services Accounts dialog appears. Leave the Use The Same Account For Each Service. Auto Start SQL Server Service choice selected. Enter an existing user name and password to use for the SQL Server service, or select Use the Local System Account, and click Next.
- The Authentication Mode dialog appears. Select Mixed Mode and enter a password for the sa login.
- The Start Copying Files dialog appears. Click Next to continue.
- If you are prompted to shut down running tasks, click Next to continue and click Finish to begin installation.
- The installation program installs SQL Server on your hard disk. This may take several minutes.
- When installation is complete, the Setup Complete dialog appears. Click Finish to return to Windows.
2.4. Starting SQL Server 2000
After you install SQL Server 2000, you must reboot your computer before you can begin to use the software. SQL server is started automatically after you reboot and each time you start your computer after that. Alternatively, to start SQL Server without rebooting, go into the SQL Server Service Manager and select Start/Continue.
2.5. Uninstalling SQL Server 2000
Perform the following steps to uninstall SQL Server 2000:
- Choose Start | Settings | Control Panel from the Windows taskbar.
- Double-click on the Add/Remove Programs application.
- Select Microsoft SQL Server 2000 from the list of currently installed programs and click Change/Remove.
- The Confirm File Deletion dialog appears. Click Yes to continue.
- The Remove Shared File? dialog appears and asks you to confirm that you want to remove shared files that are no longer being used. Click Yes to All to remove these files and click Yes when the second confirmation dialog appears.
- Windows removes all SQL Server 2000 programs from your system.
4. IBM DB2
The following table provides a variety of miscellaneous details about the product and the company:
Product name DB2 Universal Database 7.2 Enterprise Edition
First shipment 1985
Platform Windows NT/2000
Software limitations Expires 90 days after installation
Vendor IBM Corporation
Founded 1911
Annual sales $83.4 billion
4.1. Hardware and Software Requirements
IBM DB2 Enterprise Edition requires the following hardware and software:
Category Requirements
Computer Pentium-based personal computer
Operating system Microsoft Windows NT Version 4.0 SP5 or later, or
Microsoft Windows 2000
Memory (RAM) 128MB or more recommended
Hard disk space Approx. 245MB for typical installation
Network software TCP/IP, IPX/SPX, Named Pipes, NetBios, and MPTN
(APPC over TCP/IP)
Other If you have the IBM Antivirus program installed on your
computer, it must be disabled or uninstalled to perform
the DB2 installation
4.2. Installation Notes
The official IBM DB2 evaluation CD-ROM has been pruned somewhat in order for the DB2 software to fit onto the bonus CD-ROM. Therefore, you must choose precisely the selections indicated in the instructions in the next section or the installation may not proceed smoothly. In addition, do not attempt to install OLAP Starter Kit.
If you have any further questions about DB2 installation, please refer to the DB2 Installation Guide on the bonus CD-ROM. The file is located at \IBMDB2\doc\en\ db2i6\db2i6.htm.
4.3. DB2 Enterprise Edition Installation
Perform the following steps to install DB2 Universal Database Enterprise Edition:
- Log on to the system as a user that meets the requirements for installing DB2. The account you are logged in as must (a) be defined locally, (b) belong to the Local Administrator’s group, and (c) have the following advanced user rights:
-
- Act as part of the operating system
- Create token object
- Increase quotas
- Replace a process level token
- Insert the bonus CD-ROM into your CD-ROM drive.
- Windows automatically launches the DBMS installation program on the CD-ROM. If the installation program does not launch automatically, double-click SQLINSTALL.EXE in the root directory of the CD-ROM to launch it manually.
- The installation program displays a dialog prompting you to accept the McGraw-Hill/Osborne license agreement. Indicate your acceptance of the agreement and click Next.
- The installation program displays the DBMS selection dialog. Select IBM DB2 Universal Database 7.2 Enterprise Edition from the list of DBMS choices and click Next.
- The installation program displays a dialog prompting you to accept the IBM Corporation license agreement. Indicate your acceptance of the agreement and click Next.
- The Select Products dialog appears. Click Next to accept the DB2 Enterprise Edition selection.
- The Select Installation Type dialog appears. Click Next to accept the Typical selection.
- The Select Destination Location dialog appears and indicates the default directory into which the IBM DB2 files will be copied. Accept the default or click Browse to specify a different directory and click Next.
- The Enter Username and Password dialog appears. Accept the default db2admin user name, enter a password, and click Next. If the db2admin user name already existed from a previous DB2 installation, you must enter the existing db2admin password; otherwise you will be prompted to confirm that you want to create the new user name.
- The Start Copying Files dialog appears. Click Next to continue.
- The installation program installs DB2 on your hard disk. This may take several minutes.
- The Install OLAP Start Kit dialog appears. Select Do Not Install The OLAP Starter Kit and click Continue.
- When installation is complete, the Setup Complete dialog appears. Click Finish to exit the DB2 installation program.
- The DB2 First Steps program executes automatically for you to begin working immediately with DB2.
4.3. Starting DB2 Enterprise Edition
After you install DB2 Enterprise Edition, you can use the DB2 First Steps program to begin working with DB2 immediately. After that, DB2 is started automatically each time you start your computer.
4.4. Uninstalling DB2 Enterprise Edition
Perform the following steps to uninstall DB2 Enterprise Edition:
- Choose Start | Settings | Control Panel from the Windows taskbar
- Double-click on the Add/Remove Programs application.
- Select IBM DB2 from the list of currently installed programs and click Change/Remove.
- The Confirm DB2 Deletion dialog appears. Click Yes to continue.
- If DB2 is running, the INFORMATION dialog appears and asks you to confirm that you want to shut down the running DB2 processes. Click Yes to continue.
- Windows removes all DB2 programs from your system.
5. MySQL
The following table lists details and facts about the product and the company:
Product name MySQL 3.23.51
First shipment 1995
Platform Windows 9x/Me, Windows NT4/2000/XP
Software limitations None Vendor MySQL AB
Founded 1995
Annual sales Privately held
5.1. Hardware and Software Requirements
MySQL 3.23 requires the following hardware and software:
Category Requirements
Computer Intel or compatible Pentium
Operating system Windows 9x/Me, Windows NT4 SP3 or later,
Windows 2000/Windows XP
Memory (RAM) 128MB or more recommended
Hard disk space Approx. 50MB
Network software TCP/IP
5.2. Installation Notes
If you have any further questions about MySQL installation, please refer to the MySQL Installation Instructions on the MySQL web site. At the time this book went to publication, the installation instructions were located at: http://www.mysql.com/ doc/W/i/Windows_installation.html
If this MySQL-maintained web link becomes outdated or is no longer accurate in the future, you may want to check MySQL’s main web site (www.mysql.com) to locate the installation instructions.
You can also go to the MySQL web site to download the most recent version of the MySQL DBMS.
5.3. MySQL Installation
Perform the following steps to install MySQL:
- Log on to the system as a member of the Administrators group.
- Insert the bonus CD-ROM into your CD-ROM drive.
- Windows automatically launches the DBMS installation program on the CD-ROM. If the installation program does not launch automatically, double-click SQLINSTALL.EXE in the root directory of the CD-ROM to launch it manually.
- The installation program displays a dialog prompting you to accept the McGraw-Hill/Osborne license agreement. Indicate your acceptance of the agreement and click Next.
- The installation program displays the DBMS selection dialog. Select MySQL 23 from the list of DBMS choices and click Next.
- The MySQL installation Welcome dialog appears. Click Next to continue.
- The Information dialog appears. Click Next to continue.
- The Choose Destination Location dialog appears and indicates the default directory into which the MySQL files will be copied. Accept the default or click Browse to specify a different directory and click Next.
- The Setup Type dialog appears. Click Next to accept the Typical selection.
- The installation program installs MySQL on your hard disk. This may take several minutes.
- When installation is complete, the Setup Complete dialog appears. Click Finish to exit the MySQL installation program.
5.4. Starting MySQL
After you install MySQL, you can run the command lines client program mysql.exe (located in c:\mysql\bin) to begin working with MySQL immediately.
5.5. Uninstalling MySQL
Perform the following steps to uninstall MySQL:
- Choose Start | Settings | Control Panel from the Windows taskbar.
- Double-click on the Add/Remove Programs application.
- Select MySQL Servers And Clients from the list of currently installed programs and click Change/Remove.
- The Confirm File Deletion dialog appears. Click Yes to continue.
- Windows removes all MySQL programs from your system.
6. Downloading the Oracle DBMS Software
The latest version of the Oracle DBMS takes up to three CD-ROMs, so in this second edition of SQL: The Complete Reference, we were not able to fit it onto the bonus CD-ROM along with the other brands of DBMS.
However, you can download the latest version of Oracle’s DBMS directly from the Oracle web site. At the time this book went to publication, the latest version was available for download at http://otn.oracle.com/software/products/ oracle9i/content.html.
McGraw-Hill/Osborne and the authors cannot be held responsible if this Oracle-maintained web link becomes outdated or is no longer accurate in the future, so if the link is not working, you may want to check Oracle’s main web site (www.oracle.com) to download the most recent version of the Oracle DBMS.
Source: Liang Y. Daniel (2013), Introduction to programming with SQL, Pearson; 3rd edition.