Oracle Database Administration (ORA1)

Databases, Oracle

This course provides a practical, hands-on introduction to Oracle database administration, focusing on architecture, step-by-step installation and storage management. You will learn to create databases, configure tablespaces, datafiles and use ASM for storage control.

The training covers core administration tasks: user and role management, access control, monitoring and performance tuning, and backup and recovery using RMAN. You will also learn to diagnose issues, optimize queries and apply security measures for reliable operation.

Location, current course term

Praha + online (volitelně)	11/10/2025 - 11/12/2025 CZECH Order 2/16/2026 - 2/18/2026 CZECH Order
Custom	Customized Training (date, location, content, duration)

The course:

Hide detail

• Overview and Oracle architecture
1. History and evolution of Oracle Database
2. Key components and overall architecture
3. Logical versus physical database structures
4. New features in the latest release

• Oracle database installation
1. Pre-installation requirements
2. Step-by-step installation guide
3. Environment configuration

• Initial database administration
1. Connecting with SQL*Plus and other tools
2. Introduction to management tools (e.g., Enterprise Manager)

• Creating a database and data dictionaries
1. Creating a new Oracle database instance
2. Understanding system catalogs and data dictionary views

• Logical and physical database structure
1. Space organization: tablespaces, segments and extents
2. Data storage and recovery: datafiles and redo logs
3. Introduction to Oracle ASM (Automatic Storage Management)

• Listener architecture
1. Oracle Net Services basics and listener configuration
2. Configuring tnsnames.ora and listener.ora

• Control files, redo logs and data management
1. Role of control files in recovery
2. Managing redo logs to ensure transaction consistency
3. Data storage management and space allocation in segments

• User, profile and role management
1. Creating users and assigning roles
2. Managing profiles and limits

• Database object management
1. Creating and managing tables, views, procedures
2. Schema design best practices

• Database security
1. Overview of Oracle security features
2. Implementing authentication and authorization
3. Data encryption techniques

• Oracle Net - client-server communication
1. Client-server architecture in Oracle databases
2. Network configuration and troubleshooting

• Performance monitoring
1. Detecting performance problems
2. Using AWR and ADDM for diagnostics

• Database transactions
1. Transaction fundamentals in Oracle
2. Transaction lifecycle: begin, commit, rollback
3. ACID properties and their importance
4. Multiversion concurrency control (MVCC) in Oracle

• Index and statistics management
1. Indexing strategies and index types overview
2. Creating, maintaining and tuning indexes
3. Gathering and using statistics for query optimization

• Undo area management
1. Role of undo in transaction management
2. Configuring undo retention and sizing policies

• Backup and recovery concepts
1. Importance of backup and recovery planning
2. Backup types: full, incremental and differential

• Backup and recovery with RMAN
1. Introduction to RMAN (Recovery Manager)
2. Backing up databases with RMAN commands
3. Restoring and recovering databases using RMAN

Assumed knowledge:

Basic knowledge of SQL and general OS concepts.

Recommended previous course:

Oracle Database - SQL Fundamentals (ORA0)

Recommended subsequent course:

Oracle Database Workshop: Advanced Database Administration (ORA2)

Schedule:

3 days (9:00 AM - 5:00 PM )

Course price:

716.00 € ( 866.36 € incl. 21% VAT)

Language: