• LOGIN
  • No products in the cart.

COURSE SYLLABUS

Enterprise Edition Installation
Identify System Requirements
The Optimal Flexible Architecture (OFA)
Oracle_base
Oracle_home
Configure the Installation Environment
Enterprise Edition Installation
DBCA
The Administrator Interface
Enterprise Manager Tour
Using EM SQL Worksheet
Duties of a Database Administrator
Exploring the Oracle Database Architecture: General

THE ORACLE ENTERPRISE ARCHITECTURE

Exploring the Oracle Database Architecture: Instance Memory
What is an Oracle Database Instance?
More about the System Global Area (SGA)
About the PGA
Managing Memory
Exploring the Oracle Database Architecture: Instance Processes
Instance Background Processes
SQL Execution Processes
Creating an Oracle Database
Create a new Database
Configure an existing Database
Drop a Database
Manage DBCA Templates
Manually create a Database
Managing the Database Instance
Configuring a Linux Environment
Starting & Stopping Database Control
Starting & Stopping the Database Listener
Starting & Stopping the Database Instance
More about the Database Files
Manage Database Storage Structures: Tablespaces
About Tablespaces
Tablespace Management
Drop Tablespace
Alter Tablespace
Manage Database Storage Structures: Advanced Tablespaces
More about temporary tablespaces
About temporary tablespace groups
More about permanent tablespaces
More about bigfile tablespaces
More about the sysaux tablespace
Manage Database Storage Structures
Data files & temp files
Managing Data Files
Managing Temp Files
Enable oracle-managed files (omf)
Managing undo data
About undo space management
Configure automatic undo management
undo_management
undo_tablespace
undo_retention
Guarantee undo retention
Monitor undo space
Use the undo advisor
Network environment: oracle shared servers
Shared servers architecture
Configure shared servers
Monitor shared servers
v$shared_server
v$shared_server_monitor
v$session
v$circuit
v$dispatcher & v$dispatcher_config
v$queue
Security: implementing database security
Database system privileges
Database object privileges
Administrator auditing of database activity
Enhanced default security settings
Security: administering user security
Create & manage database accounts
Grant & revoke database privileges
Resource limits via profiles
Alter profile
Drop profile
Password management via profiles
About role-based security
With admin option
Alter user…default role
Set Role
Enhanced default security settings
Moving data: sql loader
Loader concepts
Control file options
Load methods
Using the em interface
Moving data: export & import
Manage directory objects
About the data pump architecture
Data pump export
Data pump import
Data pump data dictionary views
Using the em interface
Database maintenance & performance management
The management & advisory framework
Manage the automatic workload repository
Automatic database diagnostic monitor
Use metrics & alert thresholds
Automatic maintenance tasks
Managing concurrency & locks
About latches & locks
Manage & monitor latches
Manage & monitor locks
v$lock
v$locked_object
v$session
v$session_wait
dba_blockers & dba_waiters
dba_dml_locks & dba_ddl_locks
dml_locks
Backup & recovery concepts & configuration
About database backup & recovery structures
Managing redo data
Managing archival data
Automatic crash recovery
Creating a basic backup strategy

Interested in learning Oracle?

0 responses on "Oracle"

Leave a Message

Your email address will not be published. Required fields are marked *

Course Reviews

4

4
1 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

© 2018 Schoolfortraining.Powered By Embtelsolutions.com
Note: School for Training is a vocational school. We promise quality education. We do not promise a job.
WhatsApp