Database Reference
In-Depth Information
discussion in these 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 data-
base administration tasks in Chapter 9.
Topics in each online chapter written to cover each spe-
cific DBMS product include:
Creating SQL Views for the View Ridge Gallery
Database
Database Application Logic and SQL/Persistent
Stored Modules (SQL/PSM)
DBMS Concurrency Control
DBMS Security
DBMS Database Backup and Recovery
Installing the DBMS
Other DBMS Topics Not Discussed
Using the DBMS Database Administration and
Database Development Utilities
These chapters build on the material presented in
Chapter 7, but coverage of these topics is at a depth far be-
yond the Chapter 7 coverage. Please see the online chapter
for the DBMS product you want to install and use.
Creating a Database
Creating and Running SQL Scripts
Reviewing the Database Structure in the DBMS
GUI Utility
Creating and Populating the View Ridge Gallery
Database Tables
Key Terms
locking behavior
Microsoft Access 2013
Microsoft SQL Server 2012
Microsoft SQL Server 2012 Express Advanced
Microsoft SQL Server 2012 Management Studio
MySQL 5.6
MySQL AUTO_INCREMENT property
MySQL Community Server 5.6
MySQL Installer 5.6 for Windows
MySQL Workbench
Oracle Database Express Edition 11 g Release 2
Oracle Database 11 g Release 2
Oracle SQL Developer
PL/SQL SEQUENCE object
Procedural Language/SQL (PL/SQL)
schema
stored procedures
tablespace
Transact-SQL (T-SQL)
transaction isolation level
triggers
T-SQL IDENTITY property
user-defined functions
Project Questions
10.1 Determine which DBMS product or products you will be using while working through
the material in this topic.
10.2 Based on your answer to Project Question 10.1, download Chapter 10A, Chapter 10B,
and/or Chapter 10C as appropriate from the Database Processing: Fundamentals, Design,
and Implementation (13 th Edition) Companion Website at http://www.pearsonhighered
.com/kroenke .
10.3 Based on your answer to Project Question 10.1 and the discussions in Chapter 10A,
Chapter 10B, and/or Chapter 10C, download and install the DBMS software that
you will be using while working through the material in this topic. When you have
completed this Project Question, you should have available for your use a working
installation of the DBMS product or products you want to use.
 
 
 
Search WWH ::




Custom Search