Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
---|---|---|---|---|---|---|---|
Oct 21, 2024 | 09:00 | 05:00 | EDT | Live Virtual Class | 5 | $4,000 USD | Purchase |
Dec 2, 2024 | 09:00 | 05:00 | EST | Live Virtual Class | 5 | $4,000 USD | Purchase |
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