Oracle Database 23ai: Administration Workshop Live Class

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Dec 2, 202409:0005:00ESTLive Virtual Class5$4,000 USDPurchase
Jan 27, 202509:0005:00ESTLive Virtual Class5$4,000 USDPurchase
Mar 10, 202509:0005:00EDTLive Virtual Class5$4,000 USDPurchase
May 12, 202511:0007:00EDTLive Virtual Class5$4,000 USDPurchase
Jul 7, 202509:0005:00EDTLive Virtual Class5$4,000 USDPurchase
Sep 15, 202509:0005:00EDTLive Virtual Class5$4,000 USDPurchase
Nov 17, 202509:0005:00ESTLive Virtual Class5$4,000 USDPurchase


O23AI:DBALVC

Oracle Database 23ai: Administration Workshop Live Class

This course is targeted at Database Administrators and 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.

Duration: 5 Days

Prerequisites

  • Basic understanding of databases

Audience

  • Database Administrators
  • Database Architects
  • Developers

Learning Objectives

  • Explain Oracle Database memory and processes
  • Configure listener and naming methods to establish connections to database
  • Create and manage a database
  • Create and manage tablespaces and optimize UNDO tablespace
  • Create and manage PDBs
  • Create and manage users and roles
  • Determine audit requirements, create audit policies and review audit results
  • Configure and manage automated maintenance tasks
  • Transport and load data between databases
  • Monitor database and SQL performance and tune database performance

Topics

  • Introduction to Oracle Database
  • Accessing an Oracle Database
  • Creating an Oracle Database by Using DBCA
  • Creating an Oracle Database by Using a SQL Command
  • Starting Up and Shutting Down a Database Instance
  • Managing Database Instances
  • Oracle Net Services: Overview
  • Configuring Naming Methods
  • Configuring and Administering the Listener
  • Configuring a Shared Server Architecture
  • Creating PDBs from Seed
  • Using Other Techniques to Create PDBs
  • Managing PDBs
  • Database Storage Overview
  • Creating and Managing Tablespaces
  • Improving Space Usage
  • Managing Undo Data
  • Creating and Managing User Accounts
  • Configuring Privilege and Role Authorization
  • Configuring User Resource Limits
  • Implementing Oracle Database Auditing
  • Introduction to Loading and Transporting Data
  • Loading Data
  • Transporting Data
  • Using External Tables to Load and Transport Data
  • Automated Maintenance Tasks: Overview
  • Automated Maintenance Tasks: Managing Tasks and Windows
  • Database Monitoring and Tuning Performance Overview
  • Monitoring Database Performance
  • Analyzing SQL and Optimizing Access Paths
Right Menu IconMENU