Temario
Objetivos:
Adquirir la capacidad y destreza para administrar la Base de Datos Oracle 11g.
Dirigido a:
Ingenieros de Sistemas, Administradores de Bases de Datos, estudiantes de últimos semestres de Ingeniería de Sistemas y todas las personas que deseen certificarse en bases de datos Oracle.
Estructura general del programa
Explain the Memory Structures
Describe the Process Structures
Overview of Storage Structures
Identify the tools for Administering an Oracle Database
Plan an Oracle Database installation
Install the Oracle software by using Oracle Universal Installer (OUI)
Create a database by using the Database Configuration Assistant (DBCA)
Setting database initialization parameters
Describe the stages of database startup and shutdown
Using alert log and trace files
Using data dictionary and dynamic performance views
Configure and Manage the Oracle Network
Using the Oracle Shared Server architecture
Overview of tablespace and datafiles
Create and manage tablespaces
Space management in tablespaces
Create and manage database user accounts
Grant and revoke privileges
Create and manage roles
Create and manage profiles
Monitor and resolve locking conflicts
