Oracle Learning Program

 

 

Oracle Learning Program

 

 

1. Oracle database architecture

 

Overview of database application architecture

Client/Server Architecture

Multi-layer architecture: Application Server

Physical database structure Overview

Data Files

Control File

Redo log files

Archive log files

Parameter file

Alarm and tracking debugging log files

Backup File

Logical database structure Overview

Tablespace

Data Block

Data Scaling

Segment

Overview of solutions and common solution objects

Table

Index

View

Cluster

Synonym

Oracle Data Dictionary Overview

Oracle instance Overview

Real Application Clusters: Multi-instance system

Instance Memory Structure

System global Zone

Database cache in SGA

Redo log buffer in SGA

Share pool in SGA

Statement handle/cursor

Program global Zone

Oracle background process

Process Architecture

User (customer) Process

Oracle service process

Database Access Overview

Network Connection

Start Database

How Oracle works

Oracle tool Overview

 

 

2. Oracle database features

 

Performance and scalability Overview

Concurrency

Read consistency

Read integrity, withdrawal record, transaction

Read-only transactions

Various lock mechanisms

Automatic lock

Manual lock

Silent Database

Real Application Clusters

Portability

Manageability Overview

Self-managed database

Oracle Enterprise Manager

SQL * Plus

Automatic Storage Management

Scheduler

Database Resource Manager

Database backup and recovery features

Fault Types

User errors

Statement Error

Process Error

Instance error

Medium (Disk) Failure

Data structure used for database recovery

Redo log

Withdrawal record

Control File

Database Backup

High availability overview

Overview of business intelligence features

Data Warehouse

Extract, transform, and load (ETL)

Materialized View

Bitmap index in data warehouse

Table Compression

Parallel Execution

Analyticdb SQL

Online analysis and processing capabilities

Data Mining

Partition

Content management features

XML in Oracle

Lob

Oracle document management (Oracle Text)

Oracle Ultra Search

Oracle intermedia

Oracle Spatial

Security Features

Security Mechanism

Overview of data integrity and triggers

Integrity constraints

Key

Trigger

Overview of information integration features

Distributed SQL

Location transparency

SQL and transaction transparency

Distributed Query Optimization

Oracle Data Flow

Capture

Transit

Use

Message Queue

Data Replication

Oracle transparent gateway and universal connection

 

 

3. Oracle Database Application Development

 

Oracle SQL Overview

SQL statement

Data Definition Statement

Data operation statement

Transaction control statement

Session control statement

System control statement

Embedded SQL statements

PL/SQL Overview

PL/SQL program structure

Java Overview

API Overview

Transaction Overview

Commit and cancel a transaction

Save point

Data Type Overview

Overview of international support