Oracle Database 12C Administration
Course
Online
Description
-
Type
Course
-
Methodology
Online
Databases represent the core of an organisation's informational infrastructure. It is imperative for administrators to be well trained. In this hands-on course, you gain the fundamental knowledge and skills to configure Oracle Database 12c (Oracle 12c), manage memory and storage effectively as well as deploy essential procedures to maintain your organisation's data, user accounts and privileges. You also learn to ensure availability of data by deploying backup, recovery and flashback operations. During this course, you gain experience with a variety of Oracle tools including Oracle Enterprise Manager (OEM) Cloud Control 12c, Data Pump and SQL*Plus. Who Should AttendThis course is designed for professionals whose work involves the administration of an Oracle 12c database, as well as anyone involved in working with databases who may be tasked with administering Oracle databases. Learning Objectives Create, configure and maintain Oracle 12c databasesAutomate database administration using OEM Cloud Control 12cEnsure database security by managing user privileges and rolesManage storage to optimise space and performanceImplement Oracle partitions to manage large tables and indexesDeploy appropriate backup, recovery and flashback proceduresHands-On Experience:Building, starting up and shutting down the databaseCreating and maintaining tablespacesAdministering partitioned objectsRetrieving lost data from hardware and software failuresManaging user resources and privilegesFlashing back data to recent points in time with flashback operations
About this course
Delegates who wish to attend the Oracle Database 12c Administration course should have an understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended.
Reviews
Subjects
- Database training
- Database
Course programme
Configuring the instance and database
- Balancing user requirements and resources
- Ensuring database availability
- Processing transactions with the Oracle 12c server
- Identifying types of processes, memory structures and files
- Automating memory allocation with memory targets
- Establishing network connectivity
- Setting up control files and online redo log files
- Mounting and opening the database
- Authenticating connections having SYSDBA privilege
- Navigating the graphical interface
- Comparing command-line and graphical techniques
- Setting thresholds and generating alerts
- Managing privileges and roles
- Evaluating container and pluggable databases
- Setting UNDO retention targets
- Switching to an alternative UNDO tablespace
- 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
- Authenticating users with Oracle 12c password validation
- Allocating space quotas and limiting resource usage
- Granting and revoking system and object privileges
- Simplifying privilege management with roles
- Capturing the use of privileges with dbms_privilege_capture
- Configuring tablespaces and datafiles
- Handling sort data with temporary tablespaces
- Creating Oracle Managed Files
- 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
- 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
- Comparing the performance and maintenance of local and global indexes
- Monitoring index partitions and rebuilding unusable indexes
- Limiting indexing of partitions with partial indexing
- Role of the redo log and control file
- Ensuring recovery using archiving
- Protecting and tracing the control file
- Implementing user-managed hot and cold backups
- Restoring and recovering the entire database
- Recovering corrupted tablespaces
- Managing logical errors with flashback transaction back out
Oracle Database 12C Administration