Database Reference
In-Depth Information
We are
not
attorneys or lawyers, and
cannot and do not interpret
how this developer li-
cense applies to you and your potential use of Oracle Database 11
g
Release 2.
Therefore, you may find it preferable to download and use the
Oracle Database Express
Edition 11
g
Release 2
package (downloadable from
http://www.oracle.com/technetwork/products/
express-edition/downloads/index.html
)
. The Oracle Technology Network Developer License for
the Oracle Database Express Edition (
http://www.oracle.com/technetwork/licenses/database-11g-
express-license-459621.html
)
is more permissive in its terms of use, which read in part:
We grant you a nonexclusive, nontransferable limited license to use the programs
for: (a) purposes of developing, prototyping and running your applications for your
own internal data processing operations; (b) you may also distribute the programs
with your applications; (c) you may use the programs to provide third party dem-
onstrations and training; and (d) you may copy and distribute the programs to your
licensees provided that each such licensee agrees to the terms of this Agreement.
2
Note that on a computer running the Windows operating systems, Oracle Database Express
Edition 11
g
Release 2 is available only for 32-bit operations systems, and that, as stated in the Oracle
Technical Network (OTN) developer license for Oracle Database Express Edition, there are limits on
the hardware characteristics of the computer running the DBMS. Nonetheless, you should be able
to do most of the SQL and Web related database work in this topic using Oracle Database Express
Edition 11
g
Release 2 and the downloadable Oracle SQL Developer GUI utility (downloadable
cussed later in this chapter [the main exceptions being (1) the Web based administration of Oracle
Database 11
g
Release 2 using the Oracle Database Control Enterprise Manager utility discussed in
Chapter 10B, and (2) some of the business intelligence (BI) topics in Appendix J].
Installing and using one of these DBMS products (or, at a minimum, having
Micorosft
Access 2013
) is a necessity for getting the most out of your study of the material in this topic—
using the material in a real DBMS is an important part of your learning process.
Of course, in order to use a DBMS product, you first have to install it and configure it on
your computer. Therefore, we discuss what you need to know to be able to successfully install
and use each DBMS product in the relevant online chapter.
Each of these DBMS products has one or more utility programs that you will use for database
administration tasks and for database development. Examples of these utilities are:
Microsoft SQL Server 2012 uses the
Microsoft SQL Server 2012 Management Studio
.
●
Oracle Database 11
g
Release 2 uses the
Oracle SQL Developer
.
●
MySQL 5.6 uses the
MySQL Workbench
.
●
In each online chapter, we discuss the appropriate utility programs for each DBMS product and
show you how to use them.
The first step in working with a specific database in a DBMS is to actually create that database.
However, this step is a bit more complicated than it might seem because each DBMS product
has different terminology for what we just called a
database
!
In Microsoft SQL Server 2012, we create a
database
(that was easy!).
●
In Oracle Database 11
g
Release 2, we may (but it is not required that we) create a
tablespace
to store the tables and other objects that make up what we are referring
to as a database.
●
In MySQL 5.6, we create a
schema
.
●
2
Oracle Corporation,
Oracle Technology Network Developer License for Oracle Database Express Edition
, avail-
able at
http://www.oracle.com/technetwork/licenses/database-11g-express-license-459621.html
.
Accessed on
May 26, 2013.
Search WWH ::
Custom Search