Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

Oracle Databases Training









Preferred method of contact?

Oracle Database 12c Administration

COURSE TYPE

Practitioner

Course Number

2227

Duration

5 Days

Enroll

About This Course: Databases represent the core of an organization’s informational infrastructure. It is imperative for administrators to be well trained. In this hands-on course, you gain the knowledge and skills to create and configure Oracle 12c databases, manage memory and storage effectively, and deploy essential procedures to maintain your organization’s database and ensure its availability.

You Will Learn How To

  • Create, configure and maintain Oracle 12c databases
  • Automate database administration using OEM Cloud Control 12c
  • Ensure database security by managing user privileges and roles
  • Manage storage to optimize space and performance
  • Implement Oracle partitions to manage large tables and indexes
  • Deploy appropriate backup, recovery and flashback procedures

Course Outline

  • Overview of Oracle Database 12

Configuring the instance and database

  • Balancing user requirements and resources
  • Ensuring database availability

Conceptualizing the Oracle 12c architecture

  • Processing transactions with the Oracle 12c server
  • Identifying types of processes, memory structures and files
  • Constructing an Oracle 12

Creating the database

  • Automating memory allocation with memory targets
  • Establishing network connectivity
  • Setting up control files and online redo log files

Starting and stopping the database

  • Mounting and opening the database
  • Authenticating connections having SYSDBA privilege
  • Automating administration with Oracle Enterprise Manager (OEM) Cloud Control 12

Evaluating the OEM architecture

  • Navigating the graphical interface
  • Comparing command-line and graphical techniques

Maintaining the database with OEM Cloud Control 12c

  • Setting thresholds and generating alerts
  • Managing privileges and roles
  • Evaluating container and pluggable databases
  • Flashing Back Oracle 12

Configuring UNDO tablespaces

  • Setting UNDO retention targets
  • Switching to an alternative UNDO tablespace

Monitoring and reversing changes to data

  • Tracking changes to data values with row history
  • Backing out user errors with Flashback Table
  • Retrieving dropped tables from the recycle bin
  • Implementing the Valid Time support feature
  • Managing Users and Resources

Establishing user accounts

  • Authenticating users with Oracle 12c password validation
  • Allocating space quotas and limiting resource usage

Enforcing security

  • Granting and revoking system and object privileges
  • Simplifying privilege management with roles
  • Capturing the use of privileges with dbms_privilege_capture
  • Performing Space Management

Building the storage hierarchy

  • Configuring tablespaces and datafiles
  • Handling sort data with temporary tablespaces
  • Creating Oracle Managed Files

Structuring data and index segments

  • Managing extents, blocks and large objects (LOB) storage
  • Eliminating row migration with PCTFREE and Data Pump
  • Conserving storage by compressing table data
  • Regaining space by shrinking tables and indexes online
  • Partitioning for Performance and Administration

Creating partitioned and subpartitioned tables

  • Evaluating range, list and hash partitioning methods
  • Administering partitions with merge, split, add and drop
  • Deploying partitioned tables based on virtual columns and referenced tables

Maintaining index partitions

  • Comparing the performance and maintenance of local and global indexes
  • Monitoring index partitions and rebuilding unusable indexes
  • Limiting indexing of partitions with partial indexing
  • Building a Fault-Tolerant Database

Safeguarding the database

  • Role of the redo log and control file
  • Ensuring recovery using archiving
  • Protecting and tracing the control file

Backing up the database and performing recovery

  • Implementing user-managed hot and cold backups
  • Restoring and recovering the entire database
  • Recovering corrupted tablespaces
  • Managing logical errors with flashback transaction back out
Show complete outline
Show Less

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Oct 24 - 28 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Dec 12 - 16 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 23 - 27 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Feb 27 - Mar 3 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Mar 20 - 24 AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware

May 15 - 19 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jun 5 - 9 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jul 10 - 14 AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware

Aug 28 - Sep 1 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Sep 25 - 29 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Guaranteed to Run

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here

Tuition

Standard

$3190

Government

$2833

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Questions

Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm


FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results.
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)
  • Make progress toward one or more Learning Tree Specialist & Expert Certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

Earn 29 Credits from NASBA

This course qualifies for 29 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

- ,

Prev
Next