Oracle Database 12c: Administration Workshop

Duration

5 days

Overview and Course Objectives

The overall objective of this course is threefold. First, this course instructs one in many of the day-to-day administration tasks required of an Oracle database administrator. Second, it is one of the courses modules that assist in preparation for certification as an Oracle Certified Associated (OCA) database administrator. Finally, it introduces one to many of the administration sub-specialties that one might next pursue. It is increasingly rare for a single database administrator to fulfill all the required responsibilities necessary for management of an enterprise-scale Oracle database installation. Therefore, one may eventually specialize into backup and recovery strategies, database performance tuning, security administration and the like.

Whenever appropriate this course demonstrates how an Oracle database installation integrates with its host environment, most commonly a Linux, Unix or MS Windows operating system platform. Extensive examples, workshop exercises and solutions are provided using the SQL command-line, the Enterprise Manager Database Express and the Enterprise Manager Cloud Control interfaces.

Prerequisites

Participants should have knowledge of relational concepts and knowledge of SQL is mandatory. Oracle Database 12c: SQL I - Introduction and Oracle Database 12c: SQL II - Intermediate are recommended prerequisites for this course.

Course Content

  • Introduction: Managing The Database Instance

  • Introduction: Database Architecture Review

  • Introduction: Starting & Stopping Database Services

  • Introduction: Oracle Network Environment

  • Introduction: Diagnostics & Oracle Support

  • Storage: Tablespace Management

  • Storage: Advanced Tablespace Management

  • Storage: Data Files & Temp Files Management

  • Storage: Undo Data & Undo Tablespaces

  • Security & Schemas: Security Overview & Database Privileges

  • Security & Schemas: User Security

  • Security & Schemas: Database Auditing

  • Security & Schemas: SQL Loader

  • Security & Schemas: Export & Import

  • Performance & Availability: Managing Performance & SQL Tuning

  • Performance & Availability: Data Concurrency

  • Performance & Availability: Backup & Recovery Concepts

Certification

This course considers is one of several in the Sideris series applicable to certification training as an Oracle Database 12c Administrator Certified Associate (OCA) for "Exam: 1Z0-062: Oracle Database 12c: Installation And Administration".

Get in touch with the Test Center in Kontich or Hasselt.

What’s next?

If  Oracle PL/SQL is still a mystery to you, you could follow Oracle Database 12c: PL/SQL I – Introduction.

 
 

Next training dates

  • 1 to 5 April 2019

Training cost

3.750 EUR (VAT excluded) per person

Practical details

5 days
Classroom
From 9 AM to 5 PM

Language

English

Location

De Villermontstraat 9
2550 Kontich
Belgium

This training in-company?

Upon your request we can organize this training for you.