Oracle Database 12c Administration
COURSE TYPE
Practitioner
Course Number
2227
Duration
5 Days
Databases represent the core of an organization’s informational infrastructure. In this Oracle administration training course, you learn the fundamental knowledge and skills to configure and support Oracle 12c databases, maintain your organization’s data, and ensure the availability of your data by deploying backup, recovery, and flashback operations.
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
Important Course Information
Requirements:
- Some background and experience working with a SQL-based relational database management system (RDBMS)
- Experience at the level of:
- Course 925, SQL Programming Language Introduction, or
- Course 2226, Oracle Database 12c Introduction
Recommended Experience:
- Knowledge at the level of:
- Course 493, Oracle PL/SQL Programming
Software:
- This course is currently running on Oracle 12c, on the Windows Server 2008, R2 platform
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
Convenient Ways to Attend This Instructor-Led Course
Hassle-Free Enrollment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.
In the Classroom
Live, Online
Private Team Training
In the Classroom — OR — Live, Online
Tuition — Standard: $3190 Government: $2833
Aug 14 - 18
(5 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare)
Reserve Your Seat
Sep 25 - 29
(5 Days)
9:00 AM - 4:30 PM EDT
Rockville, MD / Online (AnyWare)
Reserve Your Seat
Oct 23 - 27
(5 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare)
Reserve Your Seat
Dec 4 - 8
(5 Days)
9:00 AM - 4:30 PM EST
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Feb 12 - 16
(5 Days)
9:00 AM - 4:30 PM EST
New York / Online (AnyWare)
Reserve Your Seat
Mar 5 - 9
(5 Days)
9:00 AM - 4:30 PM EST
Ottawa / Online (AnyWare)
Reserve Your Seat
Apr 9 - 13
(5 Days)
9:00 AM - 4:30 PM EDT
Rockville, MD / Online (AnyWare)
Reserve Your Seat
Jun 4 - 8
(5 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Guaranteed to Run
Private Team Training
Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.
For details, call 1-888-843-8733 or Click Here »
Tuition
Standard
Government
In Classroom or
Online
Standard
$3190
Government
$2833
Private Team Training
Course Tuition Includes:
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)
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 ...