Oracle Database 23ai: Administration Workshop

Course code

D1106070GC10

Duration

5 Days, 40 Acad. Hours

Download pdf

Course Overview

Objectives

Prerequisites

Course Outline

Course Overview

This course is targeted at Database Administratorsand begins with explaining the architecture of an Oracle Database instance and the tools used to access it. The course includes creating and managing a database, configuring and managing Oracle Net Services along with creating and administering pluggable databases (PDBs). You learn how to create and manage database storage, users, backup, and implement database security. Additionally, the course covers protection of database against failures, loading, and transporting data.

Objectives

Configure Listener and Explain Oracle Database Naming Methods: Understand and implement Oracle Net services and listener configurations.
Create and Manage Tablespaces: Learn to handle tablespace creation, maintenance, and management.
Create and Manage PDBs: Understand the procedures for provisioning, cloning, and managing pluggable databases.
Create and Manage a Database and Optimize UNDO Tablespace: Establish a database setup and optimize the usage of the undo tablespace.
Determine Audit Requirements and Create Audit Policies: Implement comprehensive auditing strategies to ensure database security and compliance.
Configure and Manage Automated Maintenance Tasks: Automate routine maintenance with the Oracle Scheduler and Resource Manager.
Monitor Database and SQL Performance: Utilize performance views, metrics, and advisors to ensure optimal database performance.
Transport and Load Data Between Databases: Learn methods for Data Migration and integration using Data Pump and SQL*Loader.
Perform Database Start-Up and Shutdown: Master essential operations for controlling database availability

Prerequisites

Familiarity with Computers: Basic understanding of computer operations and software navigation.
Basic Understanding of Databases: General knowledge of database concepts, including the ability to comprehend database schemas and data structures.
SQL Proficiency: Basic skills in SQL query writing for interacting with databases.
Operating System Skills: Understanding of essential operating system commands and file management operations.
General IT Knowledge: Foundational awareness of IT practices and networking concepts.

Target Audience

Database Administrators
Database Architects
IT Managers
System Administrators
Database Engineers
Data Analysts
SQL Developers
IT Consultants
Solution Architects
Technical Support Engineers
Security Administrators
Cloud Database Administrators
Technical Project Managers
Data Warehouse Engineers

Course Outline

1 Introduction to Oracle Database

2 Accessing an Oracle Database

3 Creating an Oracle Database by Using DBCA

4 Creating an Oracle Database by Using a SQL Command

5 Starting Up and Shutting Down a Database Instance

6 Managing Database Instances

7 Oracle Net Services: Overview

8 Configuring Naming Methods

9 Configuring and Administering the Listener

10 Configuring a Shared Server Architecture

11 Creating PDBs from Seed

12 Using Other Techniques to Create PDBs

13 Managing PDBs

14 Database Storage Overview

15 Creating and Managing Tablespaces

16 Improving Space Usage

17 Managing Undo Data

18 Creating and Managing User Accounts

19 Configuring Privilege and Role Authorization

20 Configuring User Resource Limits

21 Implementing Oracle Database Auditing

22 Introduction to Loading and Transporting Data

23 Loading Data

24 Transporting Data

25 Using External Tables to Load and Transport Data

26 Automated Maintenance Tasks: Overview

27 Automated Maintenance Tasks: Managing Tasks and Windows

28 Database Monitoring and Tuning Performance Overview

29 Monitoring Database Performance

30 Analyzing SQL and Optimizing Access Paths

Back to trainings (Oracle)

Request the training

Oracle Database 23ai: Administration Workshop

Course code:

D1106070GC10

Duration:

5 Days, 40 Acad. Hours

24.03.25

Kyiv

Delivery format

Dates

24.03.25

Location

Kyiv

Apply

Download pdf