This course is designed to provide you with a firm foundation in administration of an Oracle database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner.

Utbildningsmål

• Describe Oracle Database architecture
• Describe Oracle Database Cloud Service (DBCS) architecture and features
• Create and manage DBCS database deployments
• 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

Målgrupp

Database Administrator, Data Warehouse Administrator, Database Designer, Support Engineer, Technical Administrator

Förkunskaper

A working knowledge of SQL is very helpful in the course. Suggested courses that will help you gain this knowledge:

Innehåll

• Introduction
• Oracle Database Architecture
• Introduction to Oracle Database Cloud Service
• Creating DBCS Database Deployments
• Accessing an Oracle Database
• Managing DBCS Database Deployments
• Managing Database Instances
• Understanding Oracle Net Services
• Administering User Security
• Creating PDBs
• Creating Master Encryption Keys for PDBs
• Creating and Managing Tablespaces
• Managing Storage Space
• Managing Undo Data
• Moving Data
• Backup and Recovery Concepts and Configuration
• Creating Database Backups
• Performing Database Recovery
• Monitoring and Tuning Database Performance
• SQL Tuning
• Miscellaneous

I samarbete med utbildningspartner Glasspaper