Oracle Database: Administration Workshop

Oracle Database: Administration Workshop

Course overview

The Oracle Database: Administration Workshop provides detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

Database versions supported in this course are: 19c, 18c, 12c

Learn To:

  • Create and manage an Oracle Database Instance.
  • Create and manage Storage Structures.
  • Configure the Oracle Network Environment.
  • Create and manage users.
  • Monitor the database and manage performance.
  • Learn basic information on backup and recovery techniques.
  • Use the Oracle Support Workbench and My Oracle Support to update your Oracle Database software.

Benefits to You

  • Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
  • Participate in Hands-On Practices and Demonstrations
  • Expert instruction and hands-on demonstrations will provide you with real world experience. By engaging in hands-on exercises to reinforce your learning, you'll develop in demand skills to effectively manage an Oracle Database.

Target audience

  • Administrator
  • Architect
  • Database Administrator

Objectives

  • 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

Pre-requisites

  • Linux experience
  • Oracle Database 12c: Introduction to SQL

Certification info

Exam: Oracle Database Administration I (1Z0-082)

Certification: Oracle Database Administration 2019 Certified Professional

additional exam to reach Certification: Oracle Database Administration II (1Z0-083)