Managing Databases with SQL Server 2012, Oracle Database 11g Release 2, and MySQL 5.6 - Database Processing: Fundamentals, Design, and Implementation - page 429

Processing: Fundamentals, Design, and Implementation (13th edition) com-
panion Web site, accessible at http://www.pearsonhighered.com/kroenke.
The online material (which also includes all the appendices to this topic) is
in PDF format and requires that you have a PDF reader installed. If you need
a PDF reader, we suggest you download and install the current version of the
free Adobe Reader from http://www.adobe.com/products/acrobat.html.
The material in these chapters describes the basic features and func-
tions of Microsoft SQL Server 2012 in Chapter 10A, Oracle Database 11 g
Release 2, in Chapter 10B, and MySQL 5.6 in Chapter 10C. The discussion
in these chapters uses the View Ridge Gallery database from Chapter 7, and
it parallels the discussion of SQL DDL, DML, and SQL/PSM in Chapter 7
and the discussion database administration tasks in Chapter 9.
These DBMS products are large and complicated products. In these
chapters, we will only be able to scratch the surface of what each is capable
of. Your goal should be to learn sufficient basics so you can continue learn-
ing on your own or in other classes.
The topics and techniques discussed in these chapters will usually also ap-
ply to earlier versions of each software product. For example, the material on
SQL Server 2012 will also apply to SQL Server 2008 R2, to SQL Server 2008,
and to the earlier SQL Server 2005, though the exact functions of the earlier
versions vary a bit from SQL Server 2012. Similarly, the material on Oracle
Database 11 g Release 2, will usually work with Oracle Database 11 g and
Oracle 10 g , and the material on MySQL 5.6 will work with MySQL 5.5 and 5.1.
Installing the DBMS
In this section of each online chapter, we will discuss the various versions of each DBMS avail-
able, recommend which version you should use, and cover important points about DBMS
installation and setup. Each of these DBMS products has a freely available version that is easy
to download and install and that can be used with most of the material in this topic (the ex-
ception being some of the business intelligence (BI) topics in Appendix J).
For example, Microsoft SQL Server 2012 is available in the Microsoft SQL Server 2012
Express Advanced package (downloadable from http://www.microsoft.com/en-us/sqlserver/
editions/2012-editions/express.aspx ), and MySQL 5.6 is available in the MySQL Community
Server 5.6 (downloadable from http://dev.mysql.com/downloads/mysql/5.6.html , but if you are
using a Windows operating system, you should download and use the MySQL Installer 5.6 for
Windows from http://dev.mysql.com/downloads/installer/5.6.html ).
Oracle Database 11 g Release 2 presents a more complex situation. In Chapter 10B, we
describe and discuss Oracle Database 11 g Release 2. While this program is available online
(downloadable from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/
index.html ) , unless you purchase a “production release version of the product” 1 you must use the
program strictly according to the terms of the Oracle Technology Network Developer License
( http://www.oracle.com/technetwork/licenses/standard-license-152015.html ) .
1 Oracle Corporation, Oracle Technology Network Developer License , available at http://www.oracle.com/
technetwork/licenses/standard-license-152015.html . Accessed on May 26, 2013.