Oracle9i Server-Architettura e Amministrazione Fundamentals

Livello - durata - Modalità di erogazione - Prezzo

Intermedio - 5 giorni - Aula - (Euro) 1400

Destinatari

Amministratore di database

Amministratori di Sistema

Personale Tecnico di supporto

Prerequisiti

Conoscenza della sintassi SQL

Obiettivi

Questo corso è progettato per fornire le competenze necessarie a svolgere le attività  amministrative per semplici databse

Gli allievi acquisiranno i concetti di base circa le architetture e strutture del databse Orcale 9i. Impareranno latresì a creare database operativi e a gestirne le strutture in una modalità  efficace e performante

Contenuti

Oracle Architectural Components Understanding the physical structure ; Understanding the memory structure ; Understanding the process structure ; Understanding the logical structure ; Outlining the stages of an SQL statement ; Defining an Oracle Database, the Oracle server, and the Oracle Instance

Getting Started with the Oracle Server Identifying database administrative tools ; Identifying the features of the Universal Installer

Managing an Oracle InstanceCreating, managing, and using initialization files: PFILE and SPFILE ; Identifying the various states of starting an instance ; Identifying the various options available to shutdown an instance ; Monitoring Alert and Trace files

Creating a Database Using the Database Configuration Assistant to create a database ; Creating a database manually ;

Using the Data Dictionary Identifying the uses and contents of the data dictionary ; Using the data dictionary to obtain information about the database

Maintaining the Control File Explaining the uses of the control file ; Listing the contents of the control file

Maintaining Redo Log Files Explaining the use of online redo log files ; Explaining the structure of online redo log files

Managing Tablespaces and Data Files Outlining the database storage hierarchy ; Identifying the types of tablespaces ;

Storage Structure and Relationships Outlining the various segment types and their uses ; Outlining the storage clause precedence

Managing Undo Data Understanding the purpose of undo data ; Managing undo data ;

Managing Tables Outlining the various Oracle data types ; Explaining the two types of ROWID formats

Managing Indexes Classification of types and uses indexes ; Creating b-tree and bitmap indexes ;

Maintaining Data Integrity Identifying the various types and states of constraints ; Implementing data integrity constraints ;

Managing Password Security and Resources Managing passwords using profiles ; Administering profiles ;

Managing Users Defining database schema and objects ; Creating new database users

Managing Privileges and Roles Identifying system and object privileges ; Granting and revoking privileges

Using Globalization Support Choosing character set and national character set for a database ; Specifying the language-dependent behavior ;