Discover Classes. Earn Rewards.

Oracle Database 12c: Administration Workshop is unfortunately unavailable

Thankfully we have 374 other Tech Classes for you to choose from. Check our top choices below or see all classes for more options.

Adobe InDesign Bootcamp

Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online

Master the art of page layout and design with Adobe InDesign at Noble Desktop. Create stunning books, magazines, and advertisements while learning essential techniques for professional typesetting. Elevate your design skills and unleash your creativity with this comprehensive InDesign course.

(372) All levels 18 and older
$975

3 sessions

Gift it!

Python for Data Science Bootcamp

Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online

Uncover the power of Python for analyzing real-world data sets in this hands-on course at Noble Desktop. Explore Python fundamentals and learn how to create programs, work with data, visualize insights, and develop machine learning models. Elevate your data science skills with the Python for Data Science Bootcamp.

(372) All levels 18 and older
$1,495

5 sessions

Gift it!

Adobe Photoshop Bootcamp

Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online

Enhance your photos and create stunning graphics with this comprehensive Photoshop course. From removing unwanted elements to making precise selections, you'll master essential techniques to transform your images. Unleash your creativity and learn from industry experts at Noble Desktop.

(372) All levels 18 and older
$975

3 sessions

Gift it!

Excel Specialist Certification Program

NYIM Training @ 185 Madison Ave, New York, NY & Virtually Online

Enhance your Excel skills and become a certified specialist through NYIM Training's comprehensive program, offering hands-on training, private sessions, and an exam with a free retake.

(742) All levels 18 and older
$899

3 sessions

Gift it!

Graphic Design Certificate

Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online

Learn the Adobe Creative Cloud apps used by professionals and master graphic design concepts to create stunning modern designs and build an impressive portfolio that showcases your skills to prospective clients or employers.

(372) All levels 18 and older
$2,995

14 sessions

Gift it!
See all Tech classes NYC

Oracle Database 12c: Administration Workshop

  • Advanced
  • 18 and older
  • $2,995
  • 33 Wood Avenue S, Iselin, NJ
  • over 5 sessions

Start Dates (0)

  • $2,995
  • ONLC Iselin @ 33 Wood Avenue S 6th Fl, Iselin, NJ 08830
  • over 5 sessions
  • All classes are live, hands-on training via remote instructor.
Showing 10 of 0

Class Description

Description

What you'll learn in this oracle database training:

The overall objective of this class 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 course modules that assist in preparation for certification as an Oracle Certified Associated (OCA) database administrator. Finally, it introduces 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.

Target Audience
The target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are:
 Database administrators
 Application designers and developers
 Web server administrators
 System administrators
 Implementation specialists
 Data center support engineers
 Chief Information Officers (CIO) and other information technology (IT) 2management professionals

Prerequisites
These are mandatory prerequisite courses (or equivalent knowledge) for this course:
 Oracle Database 12c: SQL Fundamentals
 Oracle Database 12c: Install & Upgrade Workshop
 Oracle Database 12c: Architecture & Internals

Certification
This course considers subjects applicable to certification as an Oracle Database 12c Administrator Certified Associate (OCA) for "Exam: 1Z0-062: Oracle Database 12c: Installation And Administration".
Oracle Database 12c: Administration Workshop

Contents

INTRODUCTION: MANAGING THE DATABASE INSTANCE
 THE DATABASE MANAGEMENT TOOLS
 EM DATABASE EXPRESS
 EM CLOUD CONTROL
 SQL DEVELOPER
 DATABASE ADMINISTRATION DUTIES

INTRODUCTION: DATABASE ARCHITECTURE REVIEW
 DATABASE INSTANCE CONFIGURATIONS
 MEMORY STRUCTURES
 PROCESS STRUCTURES
 STORAGE ARCHITECTURE

INTRODUCTION: STARTING & STOPPING DATABASE
SERVICES
 START & STOP THE DATABASE LISTENER
 ABOUT DATABASE STARTUP/SHUTDOWN
 SYSOPER
 SYSDBA
 DATABASE STATE & STAGES
 STARTUP WITH EM CLOUD CONTROL
 STARTUP WITH SQL*PLUS
 SHUTDOWN WITH EM CLOUD CONTROL
 SHUTDOWN WITH SQL*PLUS
 USING MS WINDOWS SERVICES

INTRODUCTION: ORACLE NETWORK ENVIRONMENT
 ORACLE NET SERVICES ARCHITECTURE
 ORACLE NET CONFIGURATION ASSISTANT
 ORACLE NET MANAGER
 USING EM CLOUD CONTROL
 ADVANCED NETWORK COMPRESSION
 TROUBLESHOOTING NETWORK PROBLEMS

INTRODUCTION: DIAGNOSTICS & ORACLE SUPPORT
 ABOUT DATABASE DIAGNOSTICS
 FAULT DIAGNOSABILITY INFRASTRUCTURE
 DATABASE INSTANCE HEALTH SNAPSHOT
 THE SUPPORT WORKBENCH
 PROACTIVE DATABASE HEALTH CHECKS
 PACKAGE DIAGNOSTIC DATA
 WORKING WITH THE KNOWLEDGE BASE

STORAGE: TABLESPACE MANAGEMENT
 STARTER TABLESPACES
 CREATE TABLESPACE WITH EM CC
 CREATE TABLESPACE WITH SQL
 MANAGE TABLESPACES WITH EM CC
 MANAGE TABLESPACES WITH EM DE
 MANAGE TABLESPACES WITH SQL
 DROP TABLESPACE
 ALTER TABLESPACE

STORAGE: ADVANCED TABLESPACE MANAGEMENT
 MANAGING TEMPORARY TABLESPACES
 TEMP TABLESPACE GROUPS WITH EM
 TEMP TABLESPACE GROUPS WITH SQL
 DEFAULT PERMANENT TABLESPACES
 BIGFILE TABLESPACES
 MANAGING THE SYSAUX TABLESPACE

STORAGE: DATA FILES & TEMP FILES MANAGEMENT
 MANAGE DATA FILES WITH EM
 ACCESS METADATA WITH SQL
 MANAGE DATA FILES WITH SQL
 MANAGE TEMP FILES
 ORACLE-MANAGED FILES (OMF)

STORAGE: UNDO DATA & UNDO TABLESPACES
 ABOUT UNDO SPACE MANAGEMENT
 CONFIGURE UNDO MANAGEMENT
 GUARANTEE UNDO RETENTION
 MONITOR UNDO SPACE WITH SQL
 USE THE EM UNDO ADVISOR

SECURITY & SCHEMAS: SECURITY OVERVIEW & DATABASE PRIVILEGES
 DATABASE SECURITY PRINCIPLES
 DATABASE SYSTEM PRIVILEGES
 DATABASE OBJECT PRIVILEGES
 SUPER ADMINISTRATOR ROLES
 PRIVILEGE ANALYSIS

SECURITY & SCHEMAS: USER SECURITY
 CREATE & MANAGE USER ACCOUNTS
 MANAGE USERS WITH EM
 MANAGE USERS WITH SQL
 CREATE USER
 ALTER USER
 DROP USER
 GRANT & REVOKE PRIVILEGES
 RESOURCE LIMITS VIA PROFILES
 ALTER PROFILE
 DROP PROFILE
 PASSWORD MANAGEMENT VIA PROFILES
 ROLE-BASED SECURITY MANAGEMENT
 ALTER USER...DEFAULT ROLE
 SET ROLE
 DELEGATING PRIVILEGE AUTHORIZATION
 WITH ADMIN OPTION & System Privileges
 WITH GRANT OPTION & Object Privileges
 PRINCIPLE OF LEAST PRIVILEGE CHECKLIST

SECURITY & SCHEMAS: DATABASE AUDITING
 AUDITING DATABASE ACTIVITY
 TRADITIONAL AUDITING
 UNIFIED AUDITING
 CREATE AUDIT POLICY

SECURITY & SCHEMAS: SQL LOADER
 LOADER CONCEPTS
 LOADER FROM THE COMMAND LINE
 CONTROL FILE OPTIONS
 LOAD METHODS
 LOADER EXPRESS MODE
 LOADER FROM EM

SECURITY & SCHEMAS: EXPORT & IMPORT
 MANAGE DIRECTORY OBJECTS
 THE DATA PUMP ARCHITECTURE
 DATA PUMP EXPORT
 DATA PUMP IMPORT
 DATA PUMP DICTIONARY VIEWS
 USING THE EM CC INTERFACE

PERFORMANCE & AVAILABILITY: MANAGING PERFORMANCE & SQL TUNING
 MANAGEMENT ADVISORY FRAMEWORK
 PERFORMANCE MONITORING & AWR
 THE SQL TUNING ADVISOR
 MONITORING EXCEPTIONS WITH METRICS

PERFORMANCE & AVAILABILITY: DATA CONCURRENCY
 ABOUT SYSTEM & USER LOCKS
 MONITOR & MANAGE USER LOCKS
 MONITOR LOCKS WITH DATA DICTIONARY
 MANAGE LOCKS WITH EM

PERFORMANCE & AVAILABILITY: BACKUP & RECOVERY CONCEPTS
 BACKUP & RECOVERY STRUCTURES
 MANAGING REDO DATA
 CONFIGURING FOR RECOVERABILITY
 INSTANCE RECOVERY
 RECOVERABILITY CHECKLIST

Refund Policy

Cancellation / Reschedule by Student

Because we must schedule rooms, ship course materials, assign instructors and provision computer resources well in advance, it is important students alert us ASAP with any cancel/reschedule requests.

Please note the following policies:

  • If requested 16 or more calendar days before the class
    • Cancellation requests made in this timeframe are eligible for refund less 5% cancellation fee.
    • Reschedule requests made in this timeframe will be accommodated if availability exists and will be processed at no additional charge.
  • If requested 15 calendar days or less before the class
    • Cancellation or Reschedule requests made by the student 15 calendar days or less before the class starts will be charged 100% the course fee and are not entitled to a refund.

Substitutions

  • If you are unable to attend your class, a substitute who meets the course prerequisites may attend in your place at no additional charge for the original class title, date and location. If you cannot find a substitute, you will be subject to the class cancellation policy.

Make-up Policy

Students are permitted one (1) Make-Up opportunity to attend an instructor-led class that was paid for but not previously attended for no additional charge.

  • Make-Up class registrations are subject to availability and are not entitled to refund.
  • Students may not reschedule a Make-up class registration.
  • Any no shows or cancellations forfeit their one Make-up opportunity.

Additionally, ONLC reserves the right to retire courses due to lack of demand. Retired classes are not available for Make-Up.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at ONLC Training Centers (7)

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 29950 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

ONLC Training Centers

ONLC Training Centers

All classes at this location

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...