Oracle

Oracle Database: Administration Workshop

Oracle Database: Administration Workshop

Share This Learning Path

Need more info? Contact us

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance. Versions Supported: 19c, 18c, 12c.

Audience Profile

This course is intended for administrators, designers, engineers who are interested in using Oracle Database.

Prerequisites

  • Oracle Database: Introduction to SQL.
  • A working knowledge of SQL and PL/SQL packages is very helpful in the course.
  • Basic knowledge of Linux operating system.

Course outline

Module 1: Introduction

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Oracle Database Editions, Options, and Management Packs
Oracle Cloud Overview
Sample HR Schema

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Describe Oracle Database editions.
Describe options.
Describe management packs.
Describe HR schema.

Module 2: Oracle Database Architecture

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Oracle Database Server Architecture
Oracle Database Instance Configurations
Connecting to the Database Instance
Oracle Database Memory and Process Structures
Logical and Physical Database Structures
Multitenant Architecture
Automatic Storage Management (ASM) Overview

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Describe Oracle Database architecture.

Module 3: Introduction to Oracle Database Cloud Service

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Oracle Database Cloud Service Architecture
Features and Tooling
Automated Database Provisioning

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Describe Oracle Database Cloud Service (DBCS) architecture and features.

Module 4: Creating DBCS Database Deployments

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Input to the Creation Wizard
SSH Key Pairs
Database File Storage

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Create DBCS database deployments.

Module 5: Accessing an Oracle Database

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

SQL*Plus
SQL Developer
Database Configuration Assistant (DBCA)
Oracle enterprise Manager Database Express
Oracle Enterprise Manager Cloud Control
Oracle Database Cloud Service Tools

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

How to acces an Oracle Databse.

Module 6: Managing DBCS Database Deployments

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Managing the Compute Node
Managing Network Access to DBCS
Scaling a Database Deployment
Patching a Database Deployment

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

How to managing DBCS Database deployments.

Module 7: Managing Database Instances

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Initialization Parameter Files
Starting Up Oracle Database Instances
Shutting Down Oracle Database Instances
Automatic Diagnostic Repository (ADR)
Alert Log and Trace Files
Dynamic Performance Views
Data Dictionary Views

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

How to managing Database instances.

Module 8: Understanding Oracle Net Services

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Oracle Net Listener Overview
Connecting to an Oracle Database Instance
Naming Methods
Oracle Net Services Administration Tools
Configuring Communication Between Database Instances
Comparing Dedicated and Shared Server Configurations

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Describe Oracle Net Services.

Module 9: Administering User Security

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Managing Oracle Cloud Users, Privileges, and Roles
Managing Oracle Database Users, Privileges, and Roles
User Authentication
Creating and Assigning Profiles
Assigning Quotas to Users
Applying the Principal of Least Privilege

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

How to administering user security.

Module 10: Creating PDBs

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Methods and Tools to Create PDBs
Creating PDBs from Seed
Cloning PDBs
Unplugging and Plugging in PDBs
Dropping PDBs

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

How to creating PDBs.

Module 11: Creating Master Encryption Keys for PDBs

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Encryption in Oracle Database Cloud Service
Overview of Transparent Data Encryption (TDE)
CDB and PDB Master Encryption Keys
Creating and Activating an Encryption Key

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

How to creating Master Encryption Keys for PDBs.

Module 12: Creating and Managing Tablespaces

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Table Data Storage
Creating, Altering and Dropping Tablespaces
Viewing Tablespace Information
Implementing Oracle Managed Files
Moving and Renaming Online Data Files
Tablespace Encryption by Default in DBCS

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

How to creating and managing Tablespaces.

Module 13: Managing Storage Space

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Oracle Database Space Management Features
Block Space Management
Types of Segments
Deferred Segment Creation
Space-Saving Features
Table and Row Compression
Shrinkable Segments
Resumable Space Allocation

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

How to managing Storage Space.

Module 14: Managing Undo Data

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Transactions and Undo Data
Storing Undo Information
Comparing Undo Data and Redo Data
Comparing Local Undo Mode and Shared Undo Mode
Configuring Undo Rentention
Temporary Undo

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

How to undo data between databases and files.

Module 15: Moving Data

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Oracle Data Pump
SQL*Loader
External Tables
Migrating to Oracle Database Cloud Service

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

How to move data between databases and files.

Module 16: Backup and Recovery Concepts

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Categories of Failure
Instance Recovery
Complete Recovery
Point-in-time Recovery
Flashback Technology

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Implement basic backup and recovery procedures.

Module 17: Backup and Recovery Configuration

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Configuring and Monitoring the Fast Recovery Area
Multiplexing Control Files
Multiplexing Redo Log Files
Archive Redo Log Files
Configuring ARCHIVELOG Mode

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Implement backup and recovery configuration.

Module 18: Creating Database Backups

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Backup Terminology
Using Recovery Manager (RMAN)
RMAN Backup Types
Automatic Backups on Database Cloud Service (DBCS)
On-Demand Backups on DBCS

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

How to create database backup.

Module 19: Performing Database Recovery

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Database Recovery Advisor
Recovering Data Files in NOARCHELOG Mode
Recovering Data Files in ARCHIVELOG Mode
Recovery Options in Database Cloud Service (DBCS)

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

How to performing database recovery.

Module 20: Monitoring and Tuning Database Performance

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

Performance Planning Considerations
Automatic Workload Repository (AWR)
Automatic Database Diagnostic Monitor (ADDM)
Advisory Framework
Managing Metric Thresholds and Alerts
Monitoring Wait Events, Sessions, and Services
Performance Tuning Methodology
Managing Memory Components

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

How to employ basic monitoring procedures and manage performance.

Module 21: SQL Tuning

Module Overview

This module is designed to provide you with a firm foundation in administration of an Oracle database. In this module you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner, also this module provides basic information on backup and recovery techniques.

Lessons

SQL Tuning Process
Oracle Optimizer
Optimizer Statistics
SQL Tuning Advisor
SQL Access Advisor
SQL Performance Analyzer

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Describe SQL Tuning.

Book Your Seat​

Find Learning Paths​

  • Search Paths

  • Vendors

Latest Learning Paths​

Join our community of certified professionals

Sign Up to our newsletter, and stay always up to date with latest IT certifications

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Facebook Linkedin

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Explore

Contact Us

International Computer Training Center

Copyright reserved to ICTC. Proudly Crafted by GTP Works

Choose how to get more info...

Give as a call

211 500 2 900

Let us, call you

Send us an email