Database Reference
In-Depth Information
Managing Databases with SQL
Server 2012, Oracle Database
●
To install the DBMS software
●
To use the DBMS database administration and database
development graphical utilities
●
To create a database in the DBMS
●
To submit both SQL DDL and DML via the
DBMS utilities
●
To understand the implementation and use of SQL/
Persistent Stored Modules (SQL/PSM) in the DBMS
●
To understand the purpose and role of user-defined
functions and to create simple user-defined functions
●
To understand the purpose and role of stored procedures
and to create simple stored procedures
●
To understand the purpose and role of triggers and to
create simple triggers
●
To understand how SQL Server implements concurrency
control
●
To understand how the DBMS implements server and
database security
●
To understand the fundamental features of the DBMS
backup and recovery facilities
This chapter
is an overview of the material
that is covered in depth for three enterprise-
class DBMS products in three separate online
chapters:
●
Microsoft SQL Server 2012
in online Chapter 10A
●
Oracle Database 11
g
Release 2
in online Chapter 10B
●
MySQL 5.6
in online Chapter 10C
These chapters have been placed online to allow us to include more mate-
rial relevant to each separate DBMS product than the length of this topic
would otherwise allow. The online chapters are available at the
Database
Search WWH ::
Custom Search