Training Dates - please open the booking form by clicking the listed date.

Oracle 12c - Administration

Duration: 5 Days
Delivery Type: Classroom
Target Audience: DBAs
Course Number: 2020250
Method: Lecture with examples and exercises.
  • Topics
  • Summary
  • Trainer
  • Download
  • Conditions

Tab 1

Topicsss

A. Installation and Set-Up

Installation Requirements - Software Installation with Oracle Universal Installer - Understanding the Oracle Architecture - Database Interfaces and their Use: SQL, PL/SQL, Java, OCCI - Start and Stop the Agent and Listener - Enterprise Manager Database Console - Database Shut Down

B. Schema Objects and Data Administration

Create, Change and Examine Tables - Define Constraints - Define Indexes and Views - Using SQL for Data Manipulation

C. User Management

Manage and Remove Database Users and Roles - Rights Management with Roles and Privileges - Resources and Access

D. Backup and Recovery

Fundamentals of Database Backup, Restore and Recovery - Techniques for Instance Recovery - Purpose of Checkpoints, Redo Log Files, Archived Log Files and ARCHIVELOG Mode - Offline and Online Backup of the Database - Incremental Backups - Automate Database Backups - Monitoring the Flash Recovery Area - Recover Lost Control Files, Redo Log Files and Data Files

E. Oracle Net Services

Representation of Oracle Net - Configuring the Listener with Oracle Net Manager - Control the Oracle Net Listener using the Listener Control Utility - Configuring the client and Middle-Tier Connection to Oracle Net Manager - Testing the Connection via Oracle Net with TNSPING

F. Storage Models

Creating and Managing Tablespaces and Data Files - Retrieving Information from Tablespaces - Configuration of Tablespaces with Oracle Managed Files (OMF)

Tab 3

Tab 4

Tab 5

Tab 6

Description
For trainings with hands-on labs you are kindly requested to bring your own laptop with the required software. Alternatively, you can use our virtual machines (VMWare) for the MS Windows OS.
Description
These course dates don´t fit in your calendar?
We also offer individual appointments or on-site trainings for your team and charge a per-day fee depending on the size of the group.
Description
In order to enroll for a training or for general inquiries regarding our training and consulting services please use the contact form, send us an email or phone. Kontaktformular oder die folgenden Möglichkeiten:
  • Phone : +1.305.395.7962
  • Fax : +1.305.395.7964