Oracle Database 12c R2: Administration Workshop Ed 3 NEW

Duration : 5 Days

What you will learn

The Oracle Database 12c R2: Administration Workshop Ed 3 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. This course covers both Database as a Cloud Service and the on-premises Oracle Database.

Learn To

  • Manage an Oracle Database instance.
  • Configure the Oracle Network environment.
  • Create and manage storage structures.
  • Manage and move data.
  • Create and manage users.
  • Monitor the database and manage performance.
  • Create and manage Database as a Cloud Service database deployments

Benefits to You

You will benefit from this course as you learn 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.

Audience

  • Data Warehouse Administrator
  • Database Administrators
  • Database Designers
  • Support Engineer
  • Technical Administrator

Related Training

Required Prerequisites

  • A working knowledge of SQL and PL/SQL packages is very helpful in the course.
  • Oracle Database 12c R1: New Features for Administrators Ed 2
  • Oracle Database 12c R2: Administration Workshop Ed 3 NEW

Suggested Prerequisites

Basic knowledge of Linux operating system

Course Objectives

  • Create and manage tablespaces
  • Manage storage space
  • Manage UNDO data
  • Move data between databases
  • Implement basic backup and recovery procedures
  • Implement basic backup and recovery procedures
  • Tune SQL to improve performance
  • Manage resources with Oracle Database Resource Manager
  • Register databases and manage performance with Enterprise Manager Cloud Control
  • Create and manage Database as a Cloud Service (DBCS) database deployments
  • Back up, restore, and patch DBCS database deployments
  • Describe the DBaaS and on-premises
  • Oracle Database architectures
  • Manage database instances
  • Create pluggable databases (PDBs)
  • Configure the Oracle network environment
  • Administer user security and implement auditing

Course Outline :

Popular Courses

Related Courses

Testimonials

Thank you EZY Intellect and Trainer for your support to become an Oracle Certified Professional

thumb Mr. Tint Aung Shwe
Assistant Manager (IT Department)-AYA Bank,August 29, 2017

This training helped me identify clear and do-able next steps toward my goal. Thank you EZY Intellect and Mr.Kushantha ( EC-Council Certified Trainer) for very valuable training.

thumb Mr. Kyaw Htet
CEH V10,21,22,23,29,30 Sep 2018