È richiesta la conoscenza del linguaggio SQL e di un sistema operativo. È auspicabile la conoscenza di base dell'architettura Oracle.

Obiettivi

L'obiettivo del corso è il raggiungimento di una comprensione concettuale dell'architettura di Oracle Database 10g e di come i suoi diversi componenti lavorano ed interagiscono tra di loro. I partecipanti apprenderanno inoltre come creare database operazionali e gestire le varie strutture in modo efficace ed efficiente. Il corso prepara all'esame di certificazione OCA - Oracle Certified Associate.

Partecipanti

Il corso è rivolto a amministratori di database, consulenti tecnici e analisti di sistema

Programma del corso

Introduction

Explain the course objectives

Identify the Oracle product line

Describe the basic concepts of a relational database

Know core database administrator tasks

Installing Oracle Database 10g Software

Identify system requirements

Use optimal flexible architecture

Install software with the Oracle Universal Installer

Create an Oracle Database

Describe Oracle Database Architecture

Understand the instance architecture

Use the management framework

Use the Database Creation Assistant

Database interfaces

Use structured query language (SQL)

Use Procedural Language/Structured Query Language (PL/SQL)

Use Java

Use the Oracle C++ Call Interface (OCCI)

Controlling the database

Start and stop the agent

Start and stop the enterprise manager database console

Start and stop the listener

Startup and shutdown the database

Storage Structures

Define the purpose of tablespaces and data files

Create tablespaces

Manage tablespaces

Obtain tablespace information

Create and manage tablespaces using Oracle Managed Files (OMF)

Administering users

Create and manage database user accounts

Create and manage roles

Grant and revoke privileges

Control resource usage by users

Managing Schema Objects

Create and modify tables

Define constraints

View the attributes of a table

View the contents of a table

Create indexes and views

Managing Data

Manipulating data through SQL

Using Import

Using Export

Using SQL Loader

PL/SQL

Identify PL/SQL objects

Understand triggers and triggering events

Identify configuration options that affect PL/SQL performance

Oracle Database Security

Apply the principal of least privilege

Manage default user accounts

Implement standard password security features

Audit database activity

Oracle Net Services

Understand Oracle Net concepts

Use Oracle Net Manager to create and configure listeners

Use the listener control utility to control the Oracle Net Listener

Use the Oracle Net Manager to configure client and middle-tier connection

Use TNSPING to test Oracle Net connectivity

Oracle Shared Server

Understand when to use Oracle Shared Servers

Configure Oracle Shared Servers

Monitoring Shared Servers

Performance Monitoring

Troubleshoot invalid and unusable objects

Gather optimizer statistics

View performance metrics

React to performance issues

Proactive Maintenance: Objectives

Set warning and critical alert thresholds

Collect and use baseline metrics

Use tuning and diagnostic advisors

Use the Automatic Database Diagnostic Monitor (ADDM)

Manage the Automatic Workload Repository

Undo Management

Monitor and administer undo

Configure undo retention

Guarantee undo retention

Use the undo advisor

Monitoring and Resolving Lock Conflicts

Detect and resolve lock conflicts

Manage deadlocks

Backup and Recovery Concepts

Describe the basics of database backup, restore and recovery

List the types of failure that may occur in an Oracle Database

Describe ways to tune instance recovery

Identify the importance of checkpoints, redo log files, and archived log file

Configure ARCHIVELOG mode

Database backups

Create consistent database backups

Back your database up without shutting it down

Create incremental backups

Automate database backups

Monitor the flash recovery area

Database Recovery

Recover from loss of a control file

Recover from loss of a redo log file

Recover from loss of a data file