Öppna kurser

Oracle Database: Administration Workshop

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.

Kursmå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:

Kursinnehå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
Your complete competence partner | Glasspaper