Introduction to database management systems and databases

• What is a database?
• Popular database management system (DBMS) software and why Oracle DBMS
• History and Current trends of DBMS and Database Administration
• Tasks of a Database Administrator

Relational Database Model and Installing Oracle database software

• Entity Relational (ER) Model Overview
• Installation of Oracle database software (Oracle DBMS)

Oracle Database Architecture

• Creation of the first Oracle database.
• Startup and Shutdown of a database
• Components of an Oracle database and detailed architecture
• Advance Startup and Shutdown Scenarios

Database storage

• Tablespaces and allocation types
• Create tablespaces
• Create datafiles with fixed size and autoextend option
• Control files
• How to rename datafiles in a controlfile
• Redolog groups and members
• Archivelog mode for a database

Oracle Networking

• Introduction
• Oracle listener configuration
• Oracle database connections from other computers
• Oracle listener administration and TNS_ADMIN environment variable
• Database Links

Used Managed (Manual) Backup and Recovery

• Introduction
• Cold Backup (offline backup)
• Database in ArchiveLog mode
• Hot Backup (online backup)
• How to clone a database using Cold Backup
• How to clone a database using Hot Backup
• How to recreate source database from backups (failure scenario)

RMAN Backup and Recovery

• Differences between RMAN method and manual method
• Database backup using RMAN
• Database backup using RMAN compression mode
• RMAN catalog
• Database backup using RMAN catalog
• Querying the RMAN metadata
• How to clone a database using RMAN duplicate
• Introduction and overview to Backups to Tape
• Flashback Database and Flash Recovery Area for better management of backups

Database Objects

• Introduction
• Tables and Columns
• Indexes
• Packages, Stored procedures and Functions
• Database links
• Views and Synonyms
• Oracle Data Dictionary
• Popular Data Dictionary views and accessing them

Oracle database upgrades

• Introduction to Oracle versions and how to understand a version
• How to upgrade from one version to another version
• How to upgrade from one patchset to another patchset within a release
• What are one-off patches
• What is OPatch utility

Oracle Utilities

• Introduction
• SQL*Plus
• Data Pump Export
• Data Pump Import
• Introduction to Oracle SQL* Loader

User Management, Roles and Privileges

• Introduction
• Create databases users
• User roles and privileges
• User profiles and tablespace quotas
• OS authentication vs database authentication

Performance Tuning

• Introduction
• How to handle performance issues in the real world
• V$ views for performance monitoring and analysis
• How to size the Oracle database and memory for optimal performance
• Oracle database wait events
• Explain Oracle UNDO management internals and sizing.
• Explain Oracle TEMP space internals and sizing.
• SQL Query tracing using TKPROF
• Database wide tracing for Oracle Errors (Event Tracing)
• Index Monitoring and internals of index maintenance by Oracle
• Gather optimizer statistics using DBMS_STATS

Real world life of an Oracle DBA

• Type of Oracle errors. Valid errors and internal exceptions
• Monitoring Oracle databases.
• How to work with Oracle Support to create Service Requests
• Jargon and terminology used by Oracle DBAs
• Working with Oracle Forums for issues.
• Documentation of work and Communication with peers and managers.
• Customer Satisfaction and working with database users.
• Obtain Oracle database documentation.
• Scheduling JOBS and scripts through UNIX/LINUX crontab utility

Oracle ASM (Automatic Storage Management)

• Introduction and benefits of ASM
• ASM Setup and Configuration
• Partitioning Disks in LINUX
• ASM Parameter file, ASM Instance and working with DISKGROUPS
• Querying ASM Information
• Creating Database Files using ASM
• How to drop a database using drop database command.

Oracle Database High Availability (RAC, DataGaurd)

• Oracle Real Application Clusters (RAC)
• Oracle DataGaurd (Physical Standby) Overview