Oracle Database 12c: Administration Workshop Ed 2 Course Overview

Oracle Database 12c: Administration course, we study how to achieve administrator and organization responsibilities for Oracle Database 12c. Skilled trainers will teach on how to rise configure, monitor and manage performance.

Course Objectives:

  • Study about the Oracle Database Architecture.
  • Make and achieve an Oracle Database Instance.
  • Make and accomplish Storage Structures.
  • Construct the Oracle Network Environment.
  • Make and manage users.
  • Monitor the database and manage performance.
  • Learn basic information on backup and recovery techniques.
  • To use the Oracle Support Workbench and My Oracle Provision to keep posted Oracle Database software.
  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Getting Started
  • Course Objectives
  • Introducing Oracle Database
  • Relation Database Models
  • Oracle SQL and PL/SQL
  • Oracle Database Server Architecture
  • Connecting to Oracle Databases
  • Oracle Database Tools
  • Oracle-Supplied User Accounts
  • Querying the Oracle Data Dictionary
  • Initialization Parameter Files
  • Starting Up Oracle Databases
  • Shutting Down Oracle Databases
  • Opening and Closing PDBs
  • Working with the Automatic Diagnostic Repository (ADR)
  • Querying Dynamic Performance Views
  • Methods and Tools to Create PDBs
  • Creating PDBs from Seed with SQL*Plus
  • Cloning PDBs with SQL*Plus
  • Unplugging and Pluggin In PDBs with SQL*Plus
  • Dropping PDBs with SQL*Plus
  • Oracle Net Services
  • How Listeners Work
  • Configuring Listeners for Dynamic Service Registration
  • Configuring Listeners for Static Service Registration
  • Configuring Local Naming for Connections
  • Testing Oracle Net Connectivity with tnsping
  • Configuring Communidation Between Databases
  • Dedicated Versus Shared Server Configurations
  • Creating Users
  • Granting Privileges
  • Creating and Granting Roles
  • Revoking Privileges and Roles
  • Creating and Assigning Profiles
  • Authenticating Users
  • Assigning Quotas to Users
  • Applying the Principal of Least Privilege
  • How Table Data is Stored
  • Creating Tablespaces in SQL*Plus
  • Altering and Dropping Tablespaces in SQL*Plus
  • Viewing Tablespace Information in SQL*Plus
  • Implementing Oracle Managed Files
  • Moving and Renaming Online Data Files in SQL*Plus
  • Oracle Database Space Management Features
  • Block Space Management
  • Row Chaining and Migration
  • Free Space Management Within Segments
  • Types of Segments
  • Allocating Extents
  • Understanding Deferred Segment Creation
  • Space-Saving Features
  • Undo Data: Overview
  • Transactions and Undo Data
  • Storing Undo Information
  • Comparing Undo Data and Redo Data
  • Managing Undo
  • Local Undo Mode Versus Shared Undo Mode
  • Configuring Undo Retension
  • Categories of Undo
  • Moving Data: General Architecture
  • Oracle Data Pump: Overview
  • Oracle Data Pump: Benefits
  • Data Pump Export and Import Clients
  • Data Pump Utility: Interfaces and Modes
  • Data Pump Import: Transformations
  • SQL*Loader Overview
  • Loading Methods
  • DBA Responsibilities
  • Categories of Failure
  • Understanding Instance Recovery
  • Understanding Types of Backups
  • Comparing Complete and Incomplete Recovery
  • Oracle Data Protection Solutions
  • Flashback Technology
  • Managing Performance Activities
  • Performance Planning Considerations
  • Database Maintenance
  • Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor
  • Performance Monitoring
  • Performance Tuning Methodology
  • Database Server Statistics and Metrics
  • SQL Tuning Process
  • Oracle Optimizer
  • Optimizer Statistics
  • SQL Plan Directives
  • Adaptive Execution Plans
  • SQL Tuning Advisor
  • SQL Access Advisor
  • SQL Performance Analyzer
  • Oracle Database Resource Manager: Overview
  • Resource Manager Elements
  • Using Resource Manager to Allocate Resources
  • Creating a Simple Resource Plan
  • Creating a Complex Resource Plan
  • Using the Active Session Pool Feature
  • Limiting CPU Utilization at the Database Level
  • Limiting CPU Utilization at the Server Level
  • Controlling the Enterprise Manager Cloud Control Framework
  • Starting the Enterprise Manager Cloud Control Framework
  • Stopping the Enterprise Manager Cloud Control Framework
  • Oracle Cloud: Overview
  • Database Cloud Service Offerings
  • DBCS Architecture
  • Features and Tooling
  • Additional Database Configuration Options
  • Automated Database Provisioning
  • Creating a Database Deployment
  • How SSH Key Pairs are Used
  • Creating an SSH Key Pair
  • Storage Used for Database Files
  • Cloud Tooling
  • Accessing Tools and Features from the DBCS Console
  • Managing the Compute Node Associated With a Database Deployment
  • Managing Network Access to DBCS
  • Enabling Access to a Compute Node Port
  • Scaling a Database Deployment
  • Backing Up and Recovering Databases on DBCS
  • Backup Destination Choices
  • Backup Configuration
  • Creating an On-Demand Backup
  • Customizing the Backup Configuration
  • Performing Recovery by Using the Console
  • Performing Recovery by Using the dbaascli Utility
  • Patching DBCS
  • Using the DBCS Console to Manage Patches
  • Using the dbaascli Utility to Manage Patches
  • CDB and PDB Master Encryption Keys
  • Determining Whether You Need to Create and Activate and Encryption Key for a PDB
  • Creating and Activating an Encryption Key
  • Tablespace Encryption by Default in DBCS
  • Transparent Data Encryption (TDE) Overview
  • Components of TDE
  • Using TDE
  • Defining the Keystore Location
  • Controlling Tablespace Encryption by Default
  • Managing the Software Keystore and Master Encryption Key
  • Managing the Keystore in CDBs and PDBs
Live Online Training (Duration : 40 Hours)
Group Training 3100 Per Participant Incl. Official Courseware
30 May - 03 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
06 - 10 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 08 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 6200 3600 + If you accept merging of other students. Incl. Official Courseware
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 40 hours. We can offer you an Ultra-Fast Track for 20 hours for only USD 2,880

Course Prerequisites

knowledge of SQL and PL/SQL packages is very helpful in the course.

As a DBA you will need to ensure fast, reliable, secure and easy to manage performance of the database, which is done by effectively managing an Oracle instance, configuring the network environment properly, and performing database maintenance on a regular basis. This curriculum will help to prepare for the 1Z0-062: Oracle Database 12c: Installation and Administration certification exam, which is part of the Oracle Certified Associate (OCA) path.

Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle Database 12c R2: Administration Workshop Ed 3 Training Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Student Feedback  (Check Koenig Feedback on Trustpilot)

Q1 Say something about the Trainer? Q2 How is Koenig different from other training Companies? Q3 Will you come back to Koenig for training ?

Student Name Country Month Feedback Rating
Anonymous United States Feb-2019 https://www.youtube.com/watch?v=9nADjdo2Tl8

Request More Information

Add Name and Email Address of participant (If different from you)

FAQ's