Data base administrator DBA course Expert level by STAR IT TECHNOLOGIES

Course Outline:
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 SEC