Call us Today ! 9590800200 | training@gitsacademy.com
learn-apply-succeed

Introduction

The +Oracle Database, Administration corporate training course is designed to provide you with a firm foundation in administration of an Oracle database. Through this training course participants will get a clear understanding of Oracle Database architecture and learn managing of an Oracle database in an efficient and effective manner. This training course includes both Database as a Cloud Service and the on-premises Oracle Database.

You will benefit from this course as participants will learn detailed understanding on the architecture of an Oracle Database instance and database, allowing you to manage the database resources effectively. Learn how to create database storage structures suitable for the business applications supported by your database. Along this you will learn how to create users and administer database security to meet your business requirements. Even the basic information on backup and recovery techniques is available in this course.

To provide a satisfactory response time to users and take care of resources effectively, participants learn how to monitor the database and manage performance.

What The Participants will learn in this training

  • Learn to manage an Oracle Database instance and configure the Oracle Network environment.
  • Learn to create and manage storage structures, manage and move data, create and manage users, monitor the database and manage performance.
  • Learn how to create and manage Database as Cloud Service database deployments and manage tablespaces.
  • Manage storage space
  • Understand basic Implement backup and recovery procedures.
  • How to monitor and tune database performance, Tune SQL to improve performance and manage resources with Oracle Database Resource Manager.
  • Learn how to register databases and manage performance with Enterprise Manager Cloud Control.
  • Learn how tb Back up, restore, and patch DBCS database deployments
  • Describe the DBaaS and on-premises Oracle Database architectures
  • Learn to Manage database instances, create pluggable databases (PDBs) and configure the Oracle network environment

Why to choose Gits Academy for Oracle SQL Corporate Training?

Gits Academy conveyed a huge number of corporate trainings and we are considered as one of the best corporate training partner for Oracle DBA training. Gits Academy Faculty is best in preparing the training needs relating to Oracle DBA training. We have a pool of trainers who are very much experienced, confirmed, qualified for delivering training and are found to be the best in the business. Gits Academy delivers trainings on Oracle DBA over the globe. Our trainers have extensive experience in end-to-end Oracle DBA.

Who should attend this course?

Employees who are working Database Administrators, Database Designers, Support Engineer, Technical Administrator, Data Warehouse Administrator.

Oracle Database 12c Release 2 Course Content

  • 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
GITS Academy. All rights reserved.