oracle 200x118 wht
8117  Reviews star_rate star_rate star_rate star_rate star_half

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...

Read More
Course Code DB23ai-ADMIN-WKSHP
Duration 5 days
Available Formats Classroom

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.

Skills Gained

  • 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

Who Can Benefit

  • Database Administrators
  • Database Architects
  • Developers

Prerequisites

  • Basic understanding of databases

Course Details

Outline

  • 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