Data, Analytics & AI Category Banner Image

Oracle Database Administration (OCDA)

Length 5 days
Price NZD 4500 exc GST

Course overview

View dates &
book now

Why study this course

Oracle Database Administration is a comprehensive, hands-on course providing concrete information on the design of an Oracle® Database instance and database, allowing you to manage your database investment.

In this course, you'll learn how to create database storage structures that align with your requirements and business models. You'll also learn how to create users and administer databases, as well as harden the databases to meet your business requirements.

This is the foundational course for learning about Oracle Database Administration, and it does not assume prior knowledge of Oracle technologies.

Request Course Information

What you’ll learn

After completing this course, students should be able to:

Describe Oracle Database architecture
Create and manage an Oracle database
Configure the database to support your applications
Manage database security and implement auditing
Implement basic backup and recovery procedures
Move data between databases and files
Employ basic monitoring procedures and manage performance

Oracle at Lumify Work

Oracle offers a complete enterprise cloud designed to modernise your business, including cloud applications and cloud infrastructure services. Lumify Work offers courses in Oracle Database and web app development so you can utilise the world's leading converged, multimodel database management system in the cloud.

View all Oracle at Lumify Work courses

Who is the course for?

Anyone seeking to learn the fundamentals of administering an Oracle Database, to meet their business requirements.

Course subjects

Understanding Oracle Database Architecture
- Overview of the Oracle Database Architecture
- The Oracle Database Instance
- Oracle Database Memory Structures
- Process Architecture and Structures
- Server and Client Processes
- Oracle Database Storage Architecture
- Connect to the Oracle Database Instance
Managing Database Instances
- Oracle Database Management tools
- Use SQL*Plus in Oracle to Manage a Database Instance
- Use SQL Developer to Manage a Database Instance
- Enterprise Manager Database Express
- Initialisation Parameter Files
- Starting up and shutting down a database instance
Managing Users, Roles, and Privileges
- Predefined database user accounts
- Administrative privileges
- Authentication options
- Manage User Sessions
- Privileges and roles
- Profiles and users
Managing Tablespaces and Datafiles
- Exploring the storage structure
- Creating a new tablespace
- Altering a tablespace
- Dropping tablespaces
- Oracle Managed Files
- Moving or renaming an Online Data File
Moving Data
- Moving Data: General Architecture
- Directory Objects
- Oracle Data Pump
- Data Pump import transformations
- SQL*Loader
- External Tables
Configuring Oracle Net Services
- Oracle Net Services overview
- Oracle Net Listener
- Name Resolution
- User sessions and naming methods
- Oracle Net Manager
- Listener Control Utility
Managing Space
- Block Space Management
- Row Chaining and Migration
- Segments
- Extents
- Table Compression
- Shrinking segments
- Segment Advisor
- Resumable space allocation
Managing Undo
- Transactions and Undo data
- Storing undo information
- Managing undo retention
- Temporary undo
- Viewing undo activity and using the Undo Advisor
Creating CDBs and Regular PDBs
- Multitenant overview
- Creating CDBs
- Creating PDBs
- Moving PDBs
- Migration from a non-CDB environment
Backup and Duplicate
- Configuration for Recoverability
- Fast Recovery Area
- Redo Log files
- Archiver Process and ARCHIVELOG mode
- Performing backups using Recovery Manager (RMAN)
Recovery and Flashback
- Opening a database
- Keeping a database open
- Data Recovery Advisor
- Recovering from a loss of a System-Critical Data File
- Recovering from a loss of a Noncritical Data File

Prerequisites

Basic understanding of Oracle Database principles
Linux skills, including familiarity with command-line basics such as ls, cd, cp, and su
Beginner to intermediate proficiency with SQL

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.