We provide virtual workshop in english about Oracle Database 23ai: administration. 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.
Learn to:
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.
Versions supported: 23ai, 21c, 19c
In this course you will learn to:
• Describe Oracle Database architecture
• 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
Course topics:
• Introduction to Oracle Database
• Accessing an Oracle Database
• Creating an Oracle Database by Using DBCA
• Creating an Oracle Database by Using SQL Command
• Starting Up and Shutting Down a Database
• Managing Database Instances
• Oracle Net Services: Overview
• Configuring Naming Methods
• Configuring and Administering the Listener
• Configuring a Shared Server Architecture
• Configuring Oracle Connection Manager
• Creating PDBS from Seed
• Using Other Techniques to Create PDBs
• Managing PDBs
• Database Storage Overview
• Creating and Managing Tablespaces
• Improving Space Usage
• Managind 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
• Database Processes
• Managing Memory
Target audience:
Database administrator
Prerequisites:
• A working knowledge of SQL is very helpful in the course. Suggested courses that will help you gain this knowledge: Introduction to SQL.
Language:
• English course material, english speaking instructor
Course material:
Digital course documentation and hands-on exercises