Save PDFPrint

Oracle Database 12c Admin Training Course

Benefits To You

COURSE DETAILS:

Module1:Getting Started

• Course Objectives
•  Exploring Oracle Database Architecture
• 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

Module2:Managing Database Instances

• 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

Module3:Creating PDBs

• 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

Module4:Configuring the Oracle Network Environment

• 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

Module5:Administering User Security

• 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

Module6:Creating and Managing Tablespaces

• 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

Module7:Managing Storage Space

• 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

Module8:Managing UNDO Data

• 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

Module9:Moving Data

• 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

Module10:Backup and Recovery Concepts

• DBA Responsibilities
• Categories of Failure
• Understanding Instance Recovery
• Understanding Types of Backups
• Comparing Complete and Incomplete Recovery
• Oracle Data Protection Solutions
• Flashback Technology

Module11:Monitoring and Tuning Database Performance

• 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

Module12:SQL Tuning

• SQL Tuning Process
• Oracle Optimizer
• Optimizer Statistics
• SQL Plan Directives
• Adaptive Execution Plans
• SQL Tuning Advisor
• SQL Access Advisor
• SQL Performance Analyzer

Module13:Oracle Database Resource Manager

• 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

Module14:Enterprise Manager Cloud Control

• Controlling the Enterprise Manager Cloud Control Framework
• Starting the Enterprise Manager Cloud Control Framework
• Stopping the Enterprise Manager Cloud Control Framework

Module15:Introduction to Oracle Database Cloud Service

• Oracle Cloud: Overview
• Database Cloud Service Offerings
• DBCS Architecture
• Features and Tooling
• Additional Database Configuration Options

Module16:Creating DBCS Database Deployments

• Automated Database Provisioning
• Creating a Database Deployment
• How SSH Key Pairs are Used
• Creating an SSH Key Pair
• Storage Used for Database Files

Module17:Managing DBCS Database Deployments

• 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

Module18:Backing Up and Restoring DBCS Database Deployments

• 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

Module19:Patching DBCS Database Deployments

• Patching DBCS
• Using the DBCS Console to Manage Patches
• Using the dbaascli Utility to Manage Patches

Creating Master Encryption Keys for PDBs

• 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

Module20:Tablespace Encryption by Default

• 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

Oracle Fusion Cloud Job Interview Preparation

• Oracle DBA Interview Questions and Answers
• Oracle Fusion Cloud Technical Interview Questions
• Oracle Fusion Cloud Techno Functional Interview Questions
• Oracle Fusion Financials Cloud Interview Questions

📖 Oracle SOA Suite 12c Essentials Free Exam Practise Test

International Students Fee : 930 USD |

Job Interview Preparation  (Soft Skills Questions & Answers)

• Tough Open-Ended Job Interview Questions
• What to Wear for Best Job Interview Attire
• Job Interview Question- What are You Passionate About?
• How to Prepare for a Job Promotion Interview

 Your FREE eLEARNING Courses (Click Here)

Internships, Freelance and Full-Time Work opportunities

• Join Internships and Referral Program (click for details)
• Work as Freelancer or Full-Time Employee (click for details)

Flexible Class Options

• Week End Classes For Professionals  SAT | SUN
• Corporate Group Trainings Available
• Online Classes – Live Virtual Class (L.V.C), Online Training

Related Courses 

Oracle Database 11g Admin-I DBA Training Course
Oracle Database 11g Admin-II DBA Training Course
Oracle Fusion Sales and Service – Engagement Cloud Training
Oracle Fusion Financials Cloud Training

Oracle Techno Functional Consultant – Oracle Apps R12

Oracle ERP Implantation & Support Services 

Need Oracle ERP E-Business Suite | Fusion Cloud Implementation Services
Need Oracle ERP Healthcheck or Database Support Services

[/vc_column_text]